|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CostCentre_ID
|
Link to CostCentre
|
|
9999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
9999999999
|
|
|
|
DBalance_ID
|
Link to DBalance
|
|
9999999999
|
|
|
|
Debtor_ID
|
Link to Debtor
|
|
9999999999
|
|
|
|
DHist_ID
|
Record ID
|
|
9999999999
|
|
|
|
DHistBalanceCC
|
SC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistBalanceLC
|
BC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistBalanceTC
|
TC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossCredNoteCC
|
SC Gross Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossCredNoteLC
|
BC Gross Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossCredNoteTC
|
TC Gross Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossInvoiceCC
|
SC Gross Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossInvoiceLC
|
BC Gross Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistGrossInvoiceTC
|
TC Gross Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementCreditCC
|
SC Activity Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementCreditLC
|
BC Activity Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementCreditTC
|
TC Activity Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementDebitCC
|
SC Activity Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementDebitLC
|
BC Activity Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistMovementDebitTC
|
TC Activity Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoCredNoteCC
|
SC Net Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoCredNoteLC
|
BC Net to Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoCredNoteTC
|
TC Net Credit Note
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoInvoiceCC
|
SC Net Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoInvoiceLC
|
BC Net to Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistNettoInvoiceTC
|
TC Net Invoice
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DHistYearPeriodFrom
|
From Year GL Period
|
|
->,>>>,>>9
|
|
|
|
DHistYearPeriodTill
|
To Year GL Period
|
|
->,>>>,>>9
|
|
|
|
Division_ID
|
Link to Division
|
|
9999999999
|
|
|
|
GL_ID
|
Link to GL
|
|
9999999999
|
|
|
|
Journal_ID
|
Link to Journal
|
|
9999999999
|
|
|
|
Project_ID
|
Link to Project
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyDebtorYearPeriodFrom
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
DHistYearPeriodFrom
|
yes
|
no
|
|
|
CyDebtorYearPeriodTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
DHistYearPeriodTill
|
yes
|
no
|
|
|
CyYearPeriodFrom
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
DHistYearPeriodFrom
|
yes
|
no
|
|
|
CyYearPeriodTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
DHistYearPeriodTill
|
yes
|
no
|
|
|
DBalance
|
no
|
DBalance_ID
|
yes
|
no
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DHist_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
DHistYearPeriodFrom
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|