project QadFinancials > class BCOACrossRef > dataset BCOACrossRef

class dataset

object identification

primary key
COACrossRef_ID
object identity
COACrossRef_ID

table tCOACrossRef


field namedata typemnd.description
COACrossRef_IDintegeryesCOA Cross Reference
SourceDomain_IDintegeryesSource Domain
TargetDomain_IDintegeryesTarget Domain
AltCOAStruct_IDintegernoAlternate COA Structure
COACrossRefCodecharacter(20)yesCode
COACrossRefDescriptioncharacter(40)noDescription
COACrossRefIsActivelogicalyesActive
COACrossRefTypecharacter(20)yesType
value list:{&COACROSSREFTYPES}
tcSourceDomainCodecharacter(8)yes
tcTargetDomainCodecharacter(8)yes
tcAltCOAStructCodecharacter(20)no
LastModifiedDatedatenoLast Mod Date
LastModifiedTimeintegernoLast Mod Time
LastModifiedUsercharacter(20)noLast Mod User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCOACrossRefDet


field namedata typemnd.description
COACrossRefDet_IDintegeryesCross Reference Detail
COACrossRef_IDintegeryesCross Reference
TargetGL_IDintegernoTarget GL Account
TargetDivision_IDintegernoTarget Sub-Account
TargetCostCentre_IDintegernoTarget Cost Center
TargetProject_IDintegernoTarget Project
TargetAltCOAStructDet_IDintegernoTarget Alternate COA
COACrossRefDetSrcGLFromcharacter(20)noSource GL Account From
COACrossRefDetSrcGLTocharacter(20)noSource GL Account To
COACrossRefDetSrcDivFromcharacter(20)noSource Sub-Account From
COACrossRefDetSrcDivTocharacter(20)noSource Sub-Account To
COACrossRefDetSrcCCFromcharacter(20)noSource Cost Center From
COACrossRefDetSrcCCTocharacter(20)noSource Cost Center To
COACrossRefDetSrcProjFromcharacter(20)noSource Project From
COACrossRefDetSrcProjTocharacter(20)noSource Project To
tcTargetGLCodecharacter(8)no
tcTargetDivisionCodecharacter(8)no
tcTargetCostCentreCodecharacter(4)no
tcTargetProjectCodecharacter(8)no
tcTargetAltCOAStructDetCodecharacter(20)no
LastModifiedDatedatenoLast Mod Date
LastModifiedTimeintegernoLast Mod Time
LastModifiedUsercharacter(20)noLast Mod User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCOACrossRef.tc_Rowid
tc_Statuscharacternoupdate status

table tTransString

Description

Table for keeping translations of end-user data.
The application defines what columns can be translated, and the end-user maintains the translations itself.

field namedata typedescription
tiParentObject_IDinteger
tcLngCodecharacter
tcTranslationStringTextcharacter
tc_ParentRowidcharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_Statuscharacter

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter