dataset BDebtorBalance

class dataset

object identification

primary key
DBalance_ID
object identity
DBalance_ID

table tDBalance

field name	data type	mnd.	description
DBalance_ID	integer	yes	Record ID
DBalanceLC	decimal(4)	no	BC Balance
DBalanceTC	decimal(4)	no	TC Balance
DBalanceCC	decimal(4)	no	SC Balance
Debtor_ID	integer	yes	Link to Debtor
Currency_ID	integer	yes	Link to Currency
Company_ID	integer	yes	Link to Company
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tDHist

field name	data type	mnd.	description
DHist_ID	integer	yes	Record ID
Debtor_ID	integer	yes	Link to Debtor
Currency_ID	integer	yes	Link to Currency
Company_ID	integer	yes	Link to Company
DBalance_ID	integer	yes	Link to DBalance
GL_ID	integer	yes	Link to GL
Project_ID	integer	no	Link to Project
CostCentre_ID	integer	no	Link to CostCentre
Journal_ID	integer	yes	Link to Journal
Division_ID	integer	no	Link to Division
DHistNettoCredNoteLC	decimal(4)	no	BC Net to Credit Note
DHistNettoCredNoteTC	decimal(4)	no	TC Net Credit Note
DHistNettoCredNoteCC	decimal(4)	no	SC Net Credit Note
DHistNettoInvoiceLC	decimal(4)	no	BC Net to Invoice
DHistNettoInvoiceTC	decimal(4)	no	TC Net Invoice
DHistNettoInvoiceCC	decimal(4)	no	SC Net Invoice
DHistGrossCredNoteLC	decimal(4)	no	BC Gross Credit Note
DHistGrossCredNoteTC	decimal(4)	no	TC Gross Credit Note
DHistGrossCredNoteCC	decimal(4)	no	SC Gross Credit Note
DHistGrossInvoiceLC	decimal(4)	no	BC Gross Invoice
DHistGrossInvoiceTC	decimal(4)	no	TC Gross Invoice
DHistGrossInvoiceCC	decimal(4)	no	SC Gross Invoice
DHistMovementCreditLC	decimal(4)	no	BC Activity Credit
DHistMovementCreditTC	decimal(4)	no	TC Activity Credit
DHistMovementCreditCC	decimal(4)	no	SC Activity Credit
DHistMovementDebitLC	decimal(4)	no	BC Activity Debit
DHistMovementDebitTC	decimal(4)	no	TC Activity Debit
DHistMovementDebitCC	decimal(4)	no	SC Activity Debit
DHistYearPeriodFrom	integer	yes	From Year GL Period
DHistYearPeriodTill	integer	yes	To Year GL Period
DHistBalanceLC	decimal(4)	no	BC Balance
DHistBalanceTC	decimal(4)	no	TC Balance
DHistBalanceCC	decimal(4)	no	SC Balance
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tDBalance.tc_Rowid
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character