dataset BMirroringGL

class dataset

object identification

primary key
MirroringGL_ID
object identity
MirroringGL_ID

table tMirroringGL

field name	data type	mnd.	description
MirroringGL_ID	integer	yes	Record ID
Domain_ID	integer	yes	Domain
Company_ID	integer	no	Entity
Source1GL_ID	integer	yes	Source 1 Account Type
Source1Division_ID	integer	no	Source 1 Sub-Account
Source1CostCentre_ID	integer	no	Source 1 Cost Center
Source1Project_ID	integer	no	Source 1 Project
Mirror1GL_ID	integer	yes	Mirror 1 Account
Mirror1Division_ID	integer	no	Mirror 1 Sub-Account
Mirror1CostCentre_ID	integer	no	Mirror 1 Cost Center
Mirror1Project_ID	integer	no	Mirror 1 Project
Source2GL_ID	integer	yes	Source 2 Account Type
Source2Division_ID	integer	no	Source 2 Sub-Account
Source2CostCentre_ID	integer	no	Source 2 Cost Center
Source2Project_ID	integer	no	Source 2 Project
Mirror2GL_ID	integer	yes	Mirror 2 Account
Mirror2Division_ID	integer	no	Mirror 2 Sub-Account
Mirror2CostCentre_ID	integer	no	Mirror 2 Cost Center
Mirror2Project_ID	integer	no	Mirror 2 Project
MirroringGLSplitGLType	character(20)	yes	Account Split Type
	value list:		{&MIRRORINGGLSPLITGLTYPES}
MirroringGLTrans1Journal	character(20)	yes	Transaction 1 Daybook
	value list:		{&MIRRORINGGLTRANS1JOURNALS}
MirroringGLTrans2Journal	character(20)	yes	Transaction 2 Daybook
	value list:		{&MIRRORINGGLTRANS2JOURNALS}
tcDomainCode	character(8)	yes	Domain
tcCompanyCode	character(20)	no	Entity
tcSource1GLCode	character(8)	yes	Source 1 Account
tcSource1GLTypeCode	character(20)	yes	Soruce 1 Account Type
	value list:		{&GLTYPECODES}
tcSource1GLSystemType	character(20)	yes	Source 1 System Type
	value list:		{&GLSYSTEMTYPES}
tcSource1CostCentreCode	character(4)	no	Source 1 Cost Center
tcSource1DivisionCode	character(8)	no	Source 1 Sub-Account
tcSource1ProjectCode	character(8)	no	Source 1 Project
tcSource2GLCode	character(8)	yes	Soruce 2 Account
tcSource2GLTypeCode	character(20)	yes	Source 2 Account Type
	value list:		{&GLTYPECODES}
tcSource2GLSystemType	character(20)	yes	Source 2 System Type
	value list:		{&GLSYSTEMTYPES}
tcSource2CostCentreCode	character(4)	no	Source 2 Cost Center
tcSource2DivisionCode	character(8)	no	Source 2 Sub-Account
tcSource2ProjectCode	character(8)	no	Source 2 Project
tcMirror1GLCode	character(8)	yes	Mirror 1 Account
tcMirror1GLTypeCode	character(20)	yes	Mirror 1 Account Type
tcMirror1CostCentreCode	character(4)	no	Mirror 1 Cost Center
tcMirror1ProjectCode	character(8)	no	Mirror 1 Project
tcMirror1DivisionCode	character(8)	no	Mirror 1 Sub-Account
tcMirror2GLCode	character(8)	yes	Mirror 2 Account
tcMirror2GLTypeCode	character(20)	yes	Mirror 2 Account Type
tcMirror2CostCentreCode	character(4)	no	Mirror 2 Cost Center
tcMirror2DivisionCode	character(8)	no	Mirror 2 Sub-Account
tcMirror2ProjectCode	character(8)	no	Mirror 2 Project
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified 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 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