dataset BFRWChart

class dataset

object identification

primary key
FRWChart_ID
alternate key
FRWChartCode
object identity
FRWChart_ID

table tFRWChart

Annotation

<QUERYTYPE=Application Table - Master Data>

Description

FRW Chart Table

field name	data type	mnd.	description
FRWChart_ID	integer	yes	Record ID
GLSharedSet_ID	integer	no	Link To GLSharedSet
DivisionSharedSet_ID	integer	no	Link To DivisionSharedSet
CostCentreSharedSet_ID	integer	no	Link To CostCentreSharedSet
ProjectSharedSet_ID	integer	no	Link To ProjectSharedSet
FRWChartCode	character(20)	yes	Chart
FRWChartDescription	character(40)	no	Description
FRWChartDefaultGLCode	character(8)	no	GL Account
FRWChartDefaultDivCode	character(8)	no	Sub-Account
FRWChartDefaultCCCode	character(8)	no	Cost Center
FRWChartDefaultPrjCode	character(8)	no	Project
FRWChartCurrTransAdjGLCode	character(8)	no	CTA Account
FRWChartSafConcept01	character(20)	no	SAF Concept 1
FRWChartSafConcept02	character(20)	no	SAF Concept 2
FRWChartSafConcept03	character(20)	no	SAF Concept 3
FRWChartSafConcept04	character(20)	no	SAF Concept 4
FRWChartSafConcept05	character(20)	no	SAF Concept 5
FRWChartSafConcept06	character(20)	no	SAF Concept 6
FRWChartSafConcept07	character(20)	no	SAF Concept 7
FRWChartSafConcept08	character(20)	no	SAF Concept 8
FRWChartSafConcept09	character(20)	no	SAF Concept 9
FRWChartSafConcept10	character(20)	no	SAF Concept 10
tcGLSharedSetCode	character(20)	no
tcDivisionSharedSetCode	character(20)	no
tcCostCentreSharedSetCode	character(20)	no
tcFRWChartSafConcept01Desc	character(40)	no
tcFRWChartSafConcept02Desc	character(40)	no
tcFRWChartSafConcept03Desc	character(40)	no
tcFRWChartSafConcept04Desc	character(40)	no
tcFRWChartSafConcept05Desc	character(40)	no
tcFRWChartSafConcept06Desc	character(40)	no
tcFRWChartSafConcept07Desc	character(40)	no
tcFRWChartSafConcept08Desc	character(40)	no
tcFRWChartSafConcept09Desc	character(40)	no
tcFRWChartSafConcept10Desc	character(40)	no
tcGLSharedSetDescription	character(40)	no
tcDivisionSharedSetDescription	character(40)	no
tcCostCentreSharedSetDescription	character(40)	no
tcProjectSharedSetDescription	character(40)	no
tcFRWChartDefaultGLCodeDesc	character(40)	no
tcFRWChartDefaultDivCodeDesc	character(40)	no
tcFRWChartDefaultCCCodeDesc	character(40)	no
tcFRWChartDefaultPrjCodeDesc	character(40)	no
tcFRWChartCurrTransAdjGLCodeDesc	character(40)	no
tcProjectSharedSetCode	character(20)	no
CustomShort0	character(20)	no	Custom Short Field
CustomShort1	character(20)	no	Custom Short Field
CustomShort2	character(20)	no	Custom Short Field
CustomShort3	character(20)	no	Custom Short Field
CustomShort4	character(20)	no	Custom Short Field
CustomShort5	character(20)	no	Custom Short Field
CustomShort6	character(20)	no	Custom Short Field
CustomShort7	character(20)	no	Custom Short Field
CustomShort8	character(20)	no	Custom Short Field
CustomShort9	character(20)	no	Custom Short Field
CustomCombo0	character(20)	no	Custom Combo Field
CustomCombo1	character(20)	no	Custom Combo Field
CustomCombo2	character(20)	no	Custom Combo Field
CustomCombo3	character(20)	no	Custom Combo Field
CustomCombo4	character(20)	no	Custom Combo Field
CustomCombo5	character(20)	no	Custom Combo Field
CustomCombo6	character(20)	no	Custom Combo Field
CustomCombo7	character(20)	no	Custom Combo Field
CustomCombo8	character(20)	no	Custom Combo Field
CustomCombo9	character(20)	no	Custom Combo Field
CustomLong0	character(255)	no	Custom Long Field
CustomLong1	character(255)	no	Custom Long Field
CustomNote	character(2000)	no	Custom Note Field
CustomDate0	date	no	Custom Date Field
CustomDate1	date	no	Custom Date Field
CustomDate2	date	no	Custom Date Field
CustomDate3	date	no	Custom Date Field
CustomDate4	date	no	Custom Date Field
CustomInteger0	integer	no	Custom Integer Field
CustomInteger1	integer	no	Custom Integer Field
CustomInteger2	integer	no	Custom Integer Field
CustomInteger3	integer	no	Custom Integer Field
CustomInteger4	integer	no	Custom Integer Field
CustomDecimal0	decimal(4)	no	Custom Decimal Field
CustomDecimal1	decimal(4)	no	Custom Decimal Field
CustomDecimal2	decimal(4)	no	Custom Decimal Field
CustomDecimal3	decimal(4)	no	Custom Decimal Field
CustomDecimal4	decimal(4)	no	Custom Decimal Field
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 tFRWCompany

Annotation

<QUERYTYPE=Application Table - Master Data>

Description

FRW Company table

field name	data type	mnd.	description
FRWCompany_ID	integer	yes	Record ID
FRWShSetComb_ID	integer	no	Link To FRWShSetComb
FRWChart_ID	integer	yes	Link To FRWChart
Company_ID	integer	no	Link To Company
FRWCompanyCode	character(20)	yes	Entity Code
FRWCompanyFRWChartCode	character(20)	no	Chart
CustomShort0	character(20)	no	Custom Short Field
CustomShort1	character(20)	no	Custom Short Field
CustomShort2	character(20)	no	Custom Short Field
CustomShort3	character(20)	no	Custom Short Field
CustomShort4	character(20)	no	Custom Short Field
CustomShort5	character(20)	no	Custom Short Field
CustomShort6	character(20)	no	Custom Short Field
CustomShort7	character(20)	no	Custom Short Field
CustomShort8	character(20)	no	Custom Short Field
CustomShort9	character(20)	no	Custom Short Field
CustomCombo0	character(20)	no	Custom Combo Field
CustomCombo1	character(20)	no	Custom Combo Field
CustomCombo2	character(20)	no	Custom Combo Field
CustomCombo3	character(20)	no	Custom Combo Field
CustomCombo4	character(20)	no	Custom Combo Field
CustomCombo5	character(20)	no	Custom Combo Field
CustomCombo6	character(20)	no	Custom Combo Field
CustomCombo7	character(20)	no	Custom Combo Field
CustomCombo8	character(20)	no	Custom Combo Field
CustomCombo9	character(20)	no	Custom Combo Field
CustomLong0	character(255)	no	Custom Long Field
CustomLong1	character(255)	no	Custom Long Field
CustomNote	character(2000)	no	Custom Note Field
CustomDate0	date	no	Custom Date Field
CustomDate1	date	no	Custom Date Field
CustomDate2	date	no	Custom Date Field
CustomDate3	date	no	Custom Date Field
CustomDate4	date	no	Custom Date Field
CustomInteger0	integer	no	Custom Integer Field
CustomInteger1	integer	no	Custom Integer Field
CustomInteger2	integer	no	Custom Integer Field
CustomInteger3	integer	no	Custom Integer Field
CustomInteger4	integer	no	Custom Integer Field
CustomDecimal0	decimal(4)	no	Custom Decimal Field
CustomDecimal1	decimal(4)	no	Custom Decimal Field
CustomDecimal2	decimal(4)	no	Custom Decimal Field
CustomDecimal3	decimal(4)	no	Custom Decimal Field
CustomDecimal4	decimal(4)	no	Custom Decimal Field
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	yes	= tFRWChart.tc_Rowid
tc_Status	character	no	update status

table tFRWShSetComb

Annotation

<QUERYTYPE=Application Table - Master Data>

field name	data type	mnd.	description
FRWShSetComb_ID	integer	yes	Record ID
FRWChart_ID	integer	yes	Link To FRWChart
Domain_ID	integer	no	Link To Domain
GLSharedSet_ID	integer	no	Link To GLSharedSet
DivisionSharedSet_ID	integer	no	Link To DivisionSharedSet
CostCentreSharedSet_ID	integer	no	Link To CostCentreSharedSet
ProjectSharedSet_ID	integer	no	Link To ProjectSharedSet
GLCOACrossRef_ID	integer	no	Link To GL COACrossRef
DivCOACOACrossRef_ID	integer	no	Link To Div COACrossRef
CCCOACOACrossRef_ID	integer	no	Link To CC COACrossRef
PrjCOACOACrossRef_ID	integer	no	Link To Prj COACrossRef
CombCOACOACrossRef_ID	integer	no	Link To Combined COACrossRef
FRWShSetCombFRWChartCode	character(20)	no	Chart
FRWShSetCombAllSets	character(70)	no	Sets
FRWShSetCombGLSSCode	character(20)	no	GL Shared Set
FRWShSetCombDivSSCode	character(20)	no	Sub-Account Shared Set
FRWShSetCombCCSSCode	character(20)	no	Cost Center Shared Set
FRWShSetCombPrjSSCode	character(20)	no	Project Shared Set
FRWShSetCombGLCOACRCode	character(20)	no	GL Cross Ref
FRWShSetCombDivCOACRCode	character(20)	no	Sub-Account Cross Ref
FRWShSetCombCCCOACRCode	character(20)	no	Cost Center Cross Ref
FRWShSetCombPrjCOACRCode	character(20)	no	Project Cross Ref
FRWShSetCombCombCOACRCode	character(20)	no	Combined Cross Ref
CustomShort0	character(20)	no	Custom Short Field
CustomShort1	character(20)	no	Custom Short Field
CustomShort2	character(20)	no	Custom Short Field
CustomShort3	character(20)	no	Custom Short Field
CustomShort4	character(20)	no	Custom Short Field
CustomShort5	character(20)	no	Custom Short Field
CustomShort6	character(20)	no	Custom Short Field
CustomShort7	character(20)	no	Custom Short Field
CustomShort8	character(20)	no	Custom Short Field
CustomShort9	character(20)	no	Custom Short Field
CustomCombo0	character(20)	no	Custom Combo Field
CustomCombo1	character(20)	no	Custom Combo Field
CustomCombo2	character(20)	no	Custom Combo Field
CustomCombo3	character(20)	no	Custom Combo Field
CustomCombo4	character(20)	no	Custom Combo Field
CustomCombo5	character(20)	no	Custom Combo Field
CustomCombo6	character(20)	no	Custom Combo Field
CustomCombo7	character(20)	no	Custom Combo Field
CustomCombo8	character(20)	no	Custom Combo Field
CustomCombo9	character(20)	no	Custom Combo Field
CustomLong0	character(255)	no	Custom Long Field
CustomLong1	character(255)	no	Custom Long Field
CustomNote	character(2000)	no	Custom Note Field
CustomDate0	date	no	Custom Date Field
CustomDate1	date	no	Custom Date Field
CustomDate2	date	no	Custom Date Field
CustomDate3	date	no	Custom Date Field
CustomDate4	date	no	Custom Date Field
CustomInteger0	integer	no	Custom Integer Field
CustomInteger1	integer	no	Custom Integer Field
CustomInteger2	integer	no	Custom Integer Field
CustomInteger3	integer	no	Custom Integer Field
CustomInteger4	integer	no	Custom Integer Field
CustomDecimal0	decimal(4)	no	Custom Decimal Field
CustomDecimal1	decimal(4)	no	Custom Decimal Field
CustomDecimal2	decimal(4)	no	Custom Decimal Field
CustomDecimal3	decimal(4)	no	Custom Decimal Field
CustomDecimal4	decimal(4)	no	Custom Decimal Field
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	yes	= tFRWChart.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