dataset BCOACrossRef

class dataset

object identification

primary key
COACrossRef_ID
object identity
COACrossRef_ID

table tCOACrossRef

field name	data type	mnd.	description
COACrossRef_ID	integer	yes	COA Cross Reference
SourceDomain_ID	integer	yes	Source Domain
TargetDomain_ID	integer	yes	Target Domain
AltCOAStruct_ID	integer	no	Alternate COA Structure
COACrossRefCode	character(20)	yes	Code
COACrossRefDescription	character(40)	no	Description
COACrossRefIsActive	logical	yes	Active
COACrossRefType	character(20)	yes	Type
	value list:		{&COACROSSREFTYPES}
tcSourceDomainCode	character(8)	yes
tcTargetDomainCode	character(8)	yes
tcAltCOAStructCode	character(20)	no
LastModifiedDate	date	no	Last Mod Date
LastModifiedTime	integer	no	Last Mod Time
LastModifiedUser	character(20)	no	Last Mod User
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 tCOACrossRefDet

field name	data type	mnd.	description
COACrossRefDet_ID	integer	yes	Cross Reference Detail
COACrossRef_ID	integer	yes	Cross Reference
TargetGL_ID	integer	no	Target GL Account
TargetDivision_ID	integer	no	Target Sub-Account
TargetCostCentre_ID	integer	no	Target Cost Center
TargetProject_ID	integer	no	Target Project
TargetAltCOAStructDet_ID	integer	no	Target Alternate COA
COACrossRefDetSrcGLFrom	character(20)	no	Source GL Account From
COACrossRefDetSrcGLTo	character(20)	no	Source GL Account To
COACrossRefDetSrcDivFrom	character(20)	no	Source Sub-Account From
COACrossRefDetSrcDivTo	character(20)	no	Source Sub-Account To
COACrossRefDetSrcCCFrom	character(20)	no	Source Cost Center From
COACrossRefDetSrcCCTo	character(20)	no	Source Cost Center To
COACrossRefDetSrcProjFrom	character(20)	no	Source Project From
COACrossRefDetSrcProjTo	character(20)	no	Source Project To
tcTargetGLCode	character(8)	no
tcTargetDivisionCode	character(8)	no
tcTargetCostCentreCode	character(4)	no
tcTargetProjectCode	character(8)	no
tcTargetAltCOAStructDetCode	character(20)	no
LastModifiedDate	date	no	Last Mod Date
LastModifiedTime	integer	no	Last Mod Time
LastModifiedUser	character(20)	no	Last Mod User
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	= tCOACrossRef.tc_Rowid
tc_Status	character	no	update 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 name	data type	description
tiParentObject_ID	integer
tcLngCode	character
tcTranslationStringText	character
tc_ParentRowid	character
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_Status	character

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