dataset BQCrossCyPosting

class dataset

object identification

primary key
QCrossCyPosting_ID
object identity
QCrossCyPosting_ID

table tQCrossCyPosting

field name	data type	mnd.	description
QCrossCyPosting_ID	integer	yes	Record ID
DDocumentInvoiceXref_ID	integer	no	Link to DDocumentInvoiceXref
CDocumentInvoiceXref_ID	integer	no	Link to CDocumentInvoiceXref
CInvoice_ID	integer	no	Link to CInvoice
Company_ID	integer	yes	Link to Company
CrossCompanyGL_ID	integer	yes	Link to CrossCompany
Currency_ID	integer	yes	Link to Currency
DInvoice_ID	integer	no	Link to DInvoice
OriginatorCompany_ID	integer	yes	Link to OriginatorCompany
OriginatorPosting_ID	integer	yes	Link to OriginatorPosting
OriginatorPostingLine_ID	integer	yes	Link to OriginatorPostingLine
OriginatorJournal_ID	integer	no	Link to OriginatorJournal
APMatchingGL_ID	integer	no	Link to APMatchingGL
APMatchingDivision_ID	integer	no	Link to APMatchingDivision
APMatchingProject_ID	integer	no	Link to APMatchingProject
APMatchingCostCentre_ID	integer	no	Link to APMatchingCostCentre
ComplPostingRevPosting_ID	integer	no	Complete Reversal Posting
CrossCompanyGLIsCredit	logical	yes	Cross-Comp GL is Credit
QCrossCyPostingIsWHT	logical	yes	WHT
QCrossCyPostingAmountTC	decimal(4)	yes	TC Amount
QCrossCyPostingAmountLC	decimal(4)	no	TC Amount
QCrossCyPostingAmountCC	decimal(4)	no	SC Amount
QCrossCyPostingQTY	decimal(10)	no	Quantity
QCrossCyPostingDiscAmountTC	decimal(4)	no	TC Disc Amount
QCrossCyPostingCreateDate	date	yes	Creation Date
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
QCrossCyPostingCreateTime	integer	yes	Creation Time
QCrossCyPostingPaymentDate	date	no	Payment Date
QCrossCyPostingInfo	character(70)	no	Originator Info
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
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