About This Guide > DHist
  
DHist
Customer Balance History
 
 
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