|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
frcd__chr01
|
|
|
x(8)
|
|
|
|
frcd__chr02
|
|
|
x(8)
|
|
|
|
frcd__chr03
|
|
|
x(8)
|
|
|
|
frcd__chr04
|
|
|
x(8)
|
|
|
|
frcd__chr05
|
|
|
x(8)
|
|
|
|
frcd__chr06
|
|
|
x(8)
|
|
|
|
frcd__chr07
|
|
|
x(8)
|
|
|
|
frcd__chr08
|
|
|
x(8)
|
|
|
|
frcd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
frcd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
frcd__dte01
|
|
|
99/99/99
|
|
|
|
frcd__dte02
|
|
|
99/99/99
|
|
|
|
frcd__log01
|
|
|
yes/no
|
|
|
|
frcd__log02
|
|
|
yes/no
|
|
|
|
frcd_class
|
Freight Class
|
Class
|
x(8)
|
|
|
|
frcd_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
frcd_domain
|
Domain
|
|
x(8)
|
|
|
|
frcd_end
|
End
|
|
99/99/99
|
|
|
|
frcd_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
frcd_max_wt
|
Maximum Weight
|
Max Weight
|
->>,>>>,>>>
|
10
|
|
|
frcd_min_wt
|
> Minimum Weight
|
>Min Weight
|
->>,>>>,>>>
|
10
|
|
|
frcd_min_wtc
|
Freight Charge
|
Freight!Charge
|
->>,>>>,>>9.9<<<
|
10
|
|
|
frcd_site
|
Site
|
|
x(8)
|
|
|
|
frcd_start
|
Start
|
|
99/99/99
|
|
|
|
frcd_tot_wtc
|
Freight Charge Per Fr List UM
|
Charge Per!Fr List UM
|
->>,>>>,>>9.99
|
10
|
|
|
frcd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
frcd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
frcd_xtr_wtc
|
Freight Charge Per UM Over Min
|
Fr Chg Per!Unit Over Min
|
->>,>>>,>>9.99
|
10
|
|
|
frcd_zone
|
Zone
|
|
x(10)
|
|
|
|
oid_frcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
frcd_fr_list
|
yes
|
frcd_domain
|
yes
|
no
|
|
|
|
|
frcd_fr_list
|
yes
|
no
|
|
|
|
|
frcd_site
|
yes
|
no
|
|
|
|
|
frcd_curr
|
yes
|
no
|
|
|
|
|
frcd_zone
|
yes
|
no
|
|
|
|
|
frcd_class
|
yes
|
no
|
|
|
|
|
frcd_max_wt
|
yes
|
no
|
|
|
|
|
frcd_start
|
yes
|
no
|
|
|
oid_frcd_det
|
yes
|
oid_frcd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
frd__qadc01
|
|
|
x(8)
|
|
|
|
frd_code
|
Rate Code
|
Code
|
x(8)
|
|
|
|
frd_domain
|
Domain
|
|
x(8)
|
|
|
|
frd_rate
|
Rate
|
|
>,>>>,>>9.99<<<
|
10
|
|
|
frd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
frd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
frd_weight
|
Weight
|
|
>,>>>,>>9.9<<<<<<<
|
10
|
|
|
oid_frd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
frd_rate
|
yes
|
frd_domain
|
yes
|
no
|
|
|
|
|
frd_code
|
yes
|
no
|
|
|
|
|
frd_weight
|
yes
|
no
|
|
|
oid_frd_det
|
yes
|
oid_frd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
frm__qadc01
|
|
|
x(8)
|
|
|
|
frm_code
|
Rate Code
|
Code
|
x(8)
|
|
|
|
frm_curr
|
Currency
|
Curr
|
x(3)
|
|
|
|
frm_desc
|
Description
|
|
x(24)
|
|
|
|
frm_domain
|
Domain
|
|
x(8)
|
|
|
|
frm_rate_qty
|
Rate Qty
|
|
>,>>>,>>9.9<<<<<<<
|
10
|
|
|
frm_um
|
UM
|
|
x(2)
|
|
|
|
frm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
frm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_frm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
frm_code
|
yes
|
frm_domain
|
yes
|
no
|
|
|
|
|
frm_code
|
yes
|
no
|
|
|
oid_frm_mstr
|
yes
|
oid_frm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWAnCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWAnCodeAnalyseText
|
Analyse Text
|
|
x(255)
|
|
|
|
FRWAnCodeAnalyseType
|
Analyse Type
|
|
x(20)
|
|
|
|
FRWAnCodeCalcElement
|
Calculation Element
|
|
x(2000)
|
|
|
|
FRWAnCodeCalcType
|
Calculation Type
|
|
x(20)
|
|
|
|
FRWAnCodeCode
|
Code
|
|
x(255)
|
|
|
|
FRWAnCodeCtrlCOADim
|
Controlling Dimension
|
|
x(20)
|
|
|
|
FRWAnCodeDescription
|
Description
|
|
x(255)
|
|
|
|
FRWAnCodeELR
|
ELR
|
|
x(20)
|
|
|
|
FRWAnCodeFRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWAnCodeInfo
|
Summary Info
|
|
x(60)
|
|
|
|
FRWAnCodeTaxoName
|
Taxonomy Name
|
|
x(20)
|
|
|
|
FRWAnCodeVersion
|
Version
|
|
x(40)
|
|
|
|
FRWAnCodeXBRElement
|
XBR Element
|
|
x(255)
|
|
|
|
FRWChart_ID
|
Link to FRWChart
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Chart1dx
|
no
|
FRWAnCodeFRWChartCode
|
yes
|
no
|
|
|
Chart2Idx
|
no
|
FRWChart_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWAnCode_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWAnCodeCode
|
yes
|
no
|
|
|
|
|
FRWAnCodeFRWChartCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWAnCode_ID
|
Link to FRWAnCode
|
|
-99999999999
|
|
|
|
FRWAnCodeElem_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWAnCodeElemCOAType
|
COA Type
|
|
x(40)
|
|
|
|
FRWAnCodeElemIsDetRowExpl
|
Explode Detail-rows
|
|
yes/no
|
|
|
|
FRWAnCodeElemMask
|
Element Mask
|
|
x(32)
|
|
|
|
FRWAnCodeElemMaskRange1
|
Mask Range 1
|
|
x(40)
|
|
|
|
FRWAnCodeElemMaskRange2
|
Mask Range 2
|
|
x(40)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AnCodeIdx
|
no
|
FRWAnCode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWAnCodeElem_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWAnCode_ID
|
yes
|
no
|
|
|
|
|
FRWAnCodeElemCOAType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWAnCodeElem_ID
|
Link to FRWANCodeElem
|
|
-99999999999
|
|
|
|
FRWAnCodeElemDet_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWAnCodeElemDetBurstEmail
|
Burst Email
|
|
x(255)
|
|
|
|
FRWAnCodeElemDetCode
|
COA Element Code
|
|
x(20)
|
|
|
|
FRWAnCodeElemDetValue
|
COA Type
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ElemIdx
|
no
|
FRWAnCodeElem_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWAnCodeElemDet_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWAnCodeElem_ID
|
yes
|
no
|
|
|
|
|
FRWAnCodeElemDetValue
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWBuildLog_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWBuildLogComments
|
Comments
|
|
x(100)
|
|
|
|
FRWBuildLogCubeCode
|
Cube Name
|
|
x(20)
|
|
|
|
FRWBuildLogDate
|
Log Date
|
|
yes/no
|
|
|
|
FRWBuildLogErrorNumber
|
Error Number
|
|
x(10)
|
|
|
|
FRWBuildLogErrorText
|
Error Number
|
|
x(255)
|
|
|
|
FRWBuildLogErrorType
|
Error Type
|
|
x(20)
|
|
|
|
FRWBuildLogIsLastFailed
|
Last Failed
|
|
yes/no
|
|
|
|
FRWBuildLogIsLastGood
|
Last Good
|
|
yes/no
|
|
|
|
FRWBuildLogLogDate
|
Date of Logging
|
|
99/99/9999
|
|
|
|
FRWBuildLogProgram
|
Program
|
|
x(20)
|
|
|
|
FRWBuildLogTime
|
Log Time
|
|
x(25)
|
|
|
|
FRWBuildLogTimeChar
|
Time
|
|
x(25)
|
|
|
|
FRWBuildLogUser
|
User
|
|
x(8)
|
|
|
|
FRWCube_ID
|
Link TO FRWCube
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Cube2dx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWBuildLogCubeCode
|
yes
|
no
|
|
|
FailedIdx
|
no
|
FRWBuildLogIsLastFailed
|
yes
|
no
|
|
|
GoodIdx
|
no
|
FRWBuildLogIsLastGood
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWBuildLog_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWBuildLogCubeCode
|
yes
|
no
|
|
|
|
|
FRWBuildLogDate
|
yes
|
no
|
|
|
|
|
FRWBuildLogTime
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentreSharedSet_ID
|
Link To CostCentreSharedSet
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DivisionSharedSet_ID
|
Link To DivisionSharedSet
|
|
-99999999999
|
|
|
|
FRWChart_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWChartCurrTransAdjGLCode
|
CTA Account
|
|
x(8)
|
|
|
|
FRWChartDefaultCCCode
|
Cost Center
|
|
x(8)
|
|
|
|
FRWChartDefaultDivCode
|
Sub-Account
|
|
x(8)
|
|
|
|
FRWChartDefaultGLCode
|
GL Account
|
|
x(8)
|
|
|
|
FRWChartDefaultPrjCode
|
Project
|
|
x(8)
|
|
|
|
FRWChartDescription
|
Description
|
|
x(40)
|
|
|
|
FRWChartSafConcept01
|
SAF Concept 1
|
|
x(20)
|
|
|
|
FRWChartSafConcept02
|
SAF Concept 2
|
|
x(20)
|
|
|
|
FRWChartSafConcept03
|
SAF Concept 3
|
|
x(20)
|
|
|
|
FRWChartSafConcept04
|
SAF Concept 4
|
|
x(20)
|
|
|
|
FRWChartSafConcept05
|
SAF Concept 5
|
|
x(20)
|
|
|
|
FRWChartSafConcept06
|
SAF Concept 6
|
|
x(20)
|
|
|
|
FRWChartSafConcept07
|
SAF Concept 7
|
|
x(20)
|
|
|
|
FRWChartSafConcept08
|
SAF Concept 8
|
|
x(20)
|
|
|
|
FRWChartSafConcept09
|
SAF Concept 9
|
|
x(20)
|
|
|
|
FRWChartSafConcept10
|
SAF Concept 10
|
|
x(20)
|
|
|
|
GLSharedSet_ID
|
Link To GLSharedSet
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ProjectSharedSet_ID
|
Link To ProjectSharedSet
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCSS
|
no
|
CostCentreSharedSet_ID
|
yes
|
no
|
|
|
DivSS
|
no
|
DivisionSharedSet_ID
|
yes
|
no
|
|
|
GLSS
|
no
|
GLSharedSet_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWChart_ID
|
yes
|
no
|
|
|
PrjSS
|
no
|
ProjectSharedSet_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWChartCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWChart_ID
|
Link To FRWChart
|
|
-99999999999
|
|
|
|
FRWCol_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWColCode
|
Column Group Code
|
|
x(20)
|
|
|
|
FRWColDescription
|
Column Group Description
|
|
x(40)
|
|
|
|
FRWColIsInvertSign
|
Invert Sign
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ChartIdx
|
no
|
FRWChart_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCol_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWColCode
|
yes
|
no
|
|
|
|
|
FRWChart_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWAnCode_ID
|
Link to FRWAnCode
|
|
-99999999999
|
|
|
|
FRWCol_ID
|
Link to FRWCol
|
|
-99999999999
|
|
|
|
FRWColDet_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWColDetCalcFormula
|
Formula for Calcualted Column
|
|
x(60)
|
|
|
|
FRWColDetColumnType
|
Column Type
|
|
x(20)
|
|
|
|
FRWColDetCompareOffset
|
Number Periods Offset
|
|
99
|
|
|
|
FRWColDetCompareType
|
Period Compare Type
|
|
x(20)
|
|
|
|
FRWColDetFixedPeriodFrom
|
Fixed Period From
|
|
99
|
|
|
|
FRWColDetFixedPeriodTo
|
Fixed Period To
|
|
99
|
|
|
|
FRWColDetIsBracketNegative
|
Print negative amounts between brackets
|
Negative in Brackets
|
yes/no
|
|
|
|
FRWColDetIsFullAmount
|
Print Full Amount
|
Full Amount
|
yes/no
|
|
|
|
FRWColDetIsHiddenColumn
|
Hide On Report
|
|
yes/no
|
|
|
|
FRWColDetIsHideFuturePeriod
|
Hide Future Periods
|
|
yes/no
|
|
|
|
FRWColDetIsRedNegative
|
Print negative Amounts in Red
|
Negative in Red
|
yes/no
|
|
|
|
FRWColDetIsWithCurrSign
|
Print Currency Sign
|
|
yes/no
|
|
|
|
FRWColDetIsZeroSuppress
|
Zero Suppress
|
|
yes/no
|
|
|
|
FRWColDetLabel
|
Column Label
|
|
x(64)
|
|
|
|
FRWColDetLabelStyle
|
Label Style
|
|
x(20)
|
|
|
|
FRWColDetLeadTrailUnitLabel
|
Percentage Sign or Currency Sign Position
|
Sign Position
|
x(20)
|
|
|
|
FRWColDetMeasureStyle
|
Measure Style Tag
|
|
x(20)
|
|
|
|
FRWColDetMeasureType
|
Measure Type
|
|
x(20)
|
|
|
|
FRWColDetPeriodType
|
Period Type
|
|
x(20)
|
|
|
|
FRWColDetSeq
|
Column Sequence Number
|
|
9999
|
|
|
|
FRWColDetUnitLabel
|
Percentage or Currency Sign
|
Sign (%, $, ...)
|
x(20)
|
|
|
|
FRWColDetUnitType
|
Unit Type
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AnCodeIdx
|
no
|
FRWAnCode_ID
|
yes
|
no
|
|
|
ColIdx
|
no
|
FRWCol_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWColDet_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWColDetSeq
|
yes
|
no
|
|
|
|
|
FRWCol_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FromRangeFRWAnCode_ID
|
Link to FromRange-FRWAnCode
|
|
-99999999999
|
|
|
|
FRWCol_ID
|
Link to FRWCol
|
|
-99999999999
|
|
|
|
FRWColDet_ID
|
Link to FRWColDet
|
|
-99999999999
|
|
|
|
FRWColDetComp_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWColDetCompIsSameRowAmt
|
Use Amount From Same Row
|
|
yes/no
|
|
|
|
FRWColDetCompSeq
|
Line Number
|
|
999
|
|
|
|
FRWColDetCompSource
|
Use Amount From Column
|
|
x(3)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceFRWAnCode_ID
|
Link to Source-FRWAnCode
|
|
-99999999999
|
|
|
|
ToRangeFRWAnCode_ID
|
Link to ToRange-FRWAnCode
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ColDetIdx
|
no
|
FRWColDet_ID
|
yes
|
no
|
|
|
ColIdx
|
no
|
FRWCol_ID
|
yes
|
no
|
|
|
FRangeAnCodeIdx
|
no
|
FromRangeFRWAnCode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWColDetComp_ID
|
yes
|
no
|
|
|
SourceAnCodeIdx
|
no
|
SourceFRWAnCode_ID
|
yes
|
no
|
|
|
TRangeAnCodeIdx
|
no
|
ToRangeFRWAnCode_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWColDet_ID
|
yes
|
no
|
|
|
|
|
FRWColDetCompSeq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link To Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWChart_ID
|
Link To FRWChart
|
|
-99999999999
|
|
|
|
FRWCompany_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCompanyCode
|
Entity Code
|
|
x(20)
|
|
|
|
FRWCompanyFRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWShSetComb_ID
|
Link To FRWShSetComb
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ChartID
|
no
|
FRWChart_ID
|
yes
|
no
|
|
|
ChartIdx
|
no
|
FRWCompanyFRWChartCode
|
yes
|
no
|
|
|
CyIdx
|
no
|
FRWCompanyCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCompany_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWCompanyCode
|
yes
|
no
|
|
|
|
|
FRWCompanyFRWChartCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
COACrossRef_ID
|
Link to COACrossRef
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCrossRef_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCrossRefCOACode
|
COA Code
|
|
x(20)
|
|
|
|
FRWCrossRefCOAType
|
COA Type
|
|
x(20)
|
|
|
|
FRWCrossRefCode
|
Code
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceCCSharedSet_ID
|
Link to Source CC SharedSet
|
|
-99999999999
|
|
|
|
SourceDivSharedSet_ID
|
Link to Source Div SharedSet
|
|
-99999999999
|
|
|
|
SourceGLSharedSet_ID
|
Link to Source GL SharedSet
|
|
-99999999999
|
|
|
|
SourcePrjSharedSet_ID
|
Link to Source Prj SharedSet
|
|
-99999999999
|
|
|
|
TargetCCSharedSet_ID
|
Link to Target CC SharedSet
|
|
-99999999999
|
|
|
|
TargetDivSharedSet_ID
|
Link to Target Div SharedSet
|
|
-99999999999
|
|
|
|
TargetGLSharedSet_ID
|
Link to Target GL SharedSet
|
|
-99999999999
|
|
|
|
TargetPrjSharedSet_ID
|
Link to Target Prj SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
COA1Idx
|
no
|
COACrossRef_ID
|
yes
|
no
|
|
|
COA2Idx
|
no
|
FRWCrossRefCOAType
|
yes
|
no
|
|
|
|
|
FRWCrossRefCOACode
|
yes
|
no
|
|
|
COA3Idx
|
no
|
FRWCrossRefCOACode
|
yes
|
no
|
|
|
|
|
FRWCrossRefCOAType
|
yes
|
no
|
|
|
CodeIdx
|
no
|
FRWCrossRefCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCrossRef_ID
|
yes
|
no
|
|
|
SS1
|
no
|
SourceGLSharedSet_ID
|
yes
|
no
|
|
|
SS2
|
no
|
TargetGLSharedSet_ID
|
yes
|
no
|
|
|
SS3
|
no
|
SourceDivSharedSet_ID
|
yes
|
no
|
|
|
SS4
|
no
|
TargetDivSharedSet_ID
|
yes
|
no
|
|
|
SS5
|
no
|
SourceCCSharedSet_ID
|
yes
|
no
|
|
|
SS6
|
no
|
TargetCCSharedSet_ID
|
yes
|
no
|
|
|
SS7
|
no
|
SourcePrjSharedSet_ID
|
yes
|
no
|
|
|
SS8
|
no
|
TargetPrjSharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ChildFRWCube_ID
|
Link To Child FRWCube
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Domain_ID
|
Link to Domain
|
|
-99999999999
|
|
|
|
FRWChart_ID
|
Link to FRWChart
|
|
-99999999999
|
|
|
|
FRWCube_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeChildFRWCubeCode
|
Child Name
|
|
x(20)
|
|
|
|
FRWCubeCode
|
Name
|
|
x(20)
|
|
|
|
FRWCubeCurrencyCode
|
Presentation Currency
|
|
x(3)
|
|
|
|
FRWCubeDescription
|
Description
|
|
x(40)
|
|
|
|
FRWCubeFirstReportYear
|
First Report Year
|
|
9999
|
|
|
|
FRWCubeFromLCCC
|
Translate From BC/SC
|
|
x(20)
|
|
|
|
FRWCubeFRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWCubeGLPeriodFromDomain
|
GL Periods From Domain
|
|
x(8)
|
|
|
|
FRWCubeIsAllowedCreateQFRWCube
|
Allow Create Queue
|
|
yes/no
|
|
|
|
FRWCubeIsExcludeYearClosing
|
Exclude Year Closing
|
|
yes/no
|
|
|
|
FRWCubeIsIgnoreValRate
|
Ignore Valid Rates
|
|
yes/no
|
|
|
|
FRWCubeIsPeriodFromDomain
|
Periods From Domain
|
|
yes/no
|
|
|
|
FRWCubeISRateType
|
IS Exchange Rate Type
|
|
x(20)
|
|
|
|
FRWCubeIsReportPerYear
|
Report per Year
|
|
yes/no
|
|
|
|
FRWCubeISTransMethod
|
IS Translation Method
|
|
x(2)
|
|
|
|
FRWCubeIsWithCostCentre
|
Include Cost Center Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithCurrency
|
Include Trans Curr Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithDivision
|
Include Sub Account Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithElimination
|
With Elimination
|
|
yes/no
|
|
|
|
FRWCubeIsWithGL
|
Include GL Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithJournal
|
Include Daybook Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithPrj
|
Include Project Dimension
|
|
yes/no
|
|
|
|
FRWCubeIsWithSAF
|
Include SAF Dimension
|
|
yes/no
|
|
|
|
FRWCubeLastUpdate
|
Last Updated
|
|
99/99/9999
|
|
|
|
FRWCubePeriodsByRepPeriod
|
By Reporting Period
|
|
99
|
|
|
|
FRWCubePeriodsByRepYear
|
By Reporting Year
|
|
9999
|
|
|
|
FRWCubePeriodType
|
Period Type
|
|
x(20)
|
|
|
|
FRWCubeRateSharedSetCode
|
Exchange Rate Shared Set
|
|
x(20)
|
|
|
|
FRWCubeRateTypeBS
|
BS Exchange Rate Type
|
|
x(20)
|
|
|
|
FRWCubeRebuildFromYP
|
Rebuild From YP
|
|
999999
|
|
|
|
FRWCubeStatus
|
Status
|
|
x(20)
|
|
|
|
FRWCubeTransMethodBS
|
BS Translation Method
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link To Rate Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AllowQIdx
|
no
|
FRWCubeIsAllowedCreateQFRWCube
|
yes
|
no
|
|
|
ChartIdx
|
no
|
FRWChart_ID
|
yes
|
no
|
|
|
Chl21Idx
|
no
|
FRWCubeChildFRWCubeCode
|
yes
|
no
|
|
|
Chld1Idx
|
no
|
ChildFRWCube_ID
|
yes
|
no
|
|
|
CodeIdx
|
yes
|
FRWCubeCode
|
yes
|
no
|
|
|
CurrIdx
|
no
|
FRWCubeCurrencyCode
|
yes
|
no
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCube_ID
|
yes
|
no
|
|
|
SSIdx
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link To Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCube_ID
|
Link To FRW Cube
|
|
-99999999999
|
|
|
|
FRWCubeCy_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeCyCompanyCode
|
Entity Code
|
|
x(40)
|
|
|
|
FRWCubeCyFromLCCC
|
BC/SC
|
|
x(20)
|
|
|
|
FRWCubeCyFRWCubeCode
|
Cube
|
|
x(20)
|
|
|
|
FRWCubeCyISRateType
|
IS Rate Type
|
|
x(20)
|
|
|
|
FRWCubeCyIsRebuildNeed
|
Needs Rebuild
|
|
yes/no
|
|
|
|
FRWCubeCyISTransMethod
|
IS Translation
|
|
x(20)
|
|
|
|
FRWCubeCyParticipPerc
|
Participation Percentage
|
|
>>9.99
|
|
|
|
FRWCubeCyPartPercentage
|
Participation Percentage
|
|
->>9.99
|
2
|
|
|
FRWCubeCyRateSharedSetCode
|
Rate Shared Set Code
|
|
x(20)
|
|
|
|
FRWCubeCyRateTypeBS
|
BS Rate Type
|
|
99/99/9999
|
|
|
|
FRWCubeCyRateTypeIS
|
IS Rate Type
|
|
yes/no
|
|
|
|
FRWCubeCyTransMethodBS
|
BS Translation Method
|
|
99/99/9999
|
|
|
|
FRWCubeCyTransMethodIS
|
IS Translation Method
|
|
yes/no
|
|
|
|
FRWShSetComb_ID
|
Link To FRWShSetComb
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeCy
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
CubeID
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWCubeCyFRWCubeCode
|
yes
|
no
|
|
|
CyIdx
|
no
|
FRWCubeCyCompanyCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeCy_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWCubeCyFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeCyCompanyCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link To Company
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Link To CostCentre
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link To Currency
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Dim01Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim02Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim03Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim04Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim05Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim06Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim07Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim08Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim09Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Dim10Saf_ID
|
Link To SAF
|
|
-99999999999
|
|
|
|
Division_ID
|
Link To Division
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link To Domain
|
|
-99999999999
|
|
|
|
FRWCube_ID
|
Link To FRWCube
|
|
-99999999999
|
|
|
|
FRWCubeDim_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeDimBSISGL
|
BS/IS GL
|
|
yes/no
|
|
|
|
FRWCubeDimCombinedKey
|
Key
|
|
x(360)
|
|
|
|
FRWCubeDimCompanyCode
|
Entity
|
|
x(20)
|
|
|
|
FRWCubeDimCompanyDescr
|
Entity Description
|
|
x(40)
|
|
|
|
FRWCubeDimCostCentreCode
|
Cost Center
|
|
x(8)
|
|
|
|
FRWCubeDimCostCentreDescr
|
Cost Center Descr
|
|
x(40)
|
|
|
|
FRWCubeDimCurrencyCode
|
Currency
|
|
x(3)
|
|
|
|
FRWCubeDimCurrencyDescr
|
Currency Description
|
|
x(40)
|
|
|
|
FRWCubeDimDivisionCode
|
Sub-Account
|
|
x(8)
|
|
|
|
FRWCubeDimDivsionDescr
|
Sub-Account Descr
|
|
x(40)
|
|
|
|
FRWCubeDimDomainCode
|
Domain
|
|
x(8)
|
|
|
|
FRWCubeDimFRWCubeCode
|
Cube Name
|
|
x(20)
|
|
|
|
FRWCubeDimGLCategory
|
GL Account Category
|
|
x(20)
|
|
|
|
FRWCubeDimGLCode
|
GL
|
|
x(8)
|
|
|
|
FRWCubeDimGLDescr
|
GL Descr
|
|
x(40)
|
|
|
|
FRWCubeDimGLIsActive
|
GL account is Active
|
|
yes/no
|
|
|
|
FRWCubeDimGLIsBalAccount
|
GL Account is Balance Sheet
|
|
yes/no
|
|
|
|
FRWCubeDimGLISBS
|
BS/IS GL
|
|
x(2)
|
|
|
|
FRWCubeDimGLType
|
GL Account Type Code
|
|
x(20)
|
|
|
|
FRWCubeDimICCompanyCode
|
IC Entity
|
|
x(20)
|
|
|
|
FRWCubeDimICInterco
|
IC Interco
|
|
x(20)
|
|
|
|
FRWCubeDimIntercoDescr
|
Interco Descr
|
|
x(40)
|
|
|
|
FRWCubeDimIsBudget
|
Is Budget Dimmension
|
|
yes/no
|
|
|
|
FRWCubeDimJournalCode
|
Daybook
|
|
x(8)
|
|
|
|
FRWCubeDimJournalDescr
|
Daybook Description
|
|
x(40)
|
|
|
|
FRWCubeDimJournalTypeCode
|
Daybook Type
|
|
x(40)
|
|
|
|
FRWCubeDimLayerCode
|
Layer
|
|
x(20)
|
|
|
|
FRWCubeDimLayerTypeCode
|
Layer Type
|
|
x(40)
|
|
|
|
FRWCubeDimProjectCode
|
Project
|
|
x(8)
|
|
|
|
FRWCubeDimProjectDescr
|
Project Descr
|
|
x(40)
|
|
|
|
FRWCubeDimRateTypeCode
|
Rate Type
|
|
yes/no
|
|
|
|
FRWCubeDimSaf01Descr
|
SAF1 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf02Descr
|
SAF2 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf03Descr
|
SAF3 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf04Descr
|
SAF4 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf05Descr
|
SAF5 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf06Descr
|
SAF6 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf07Descr
|
SAF7 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf08Descr
|
SAF8 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf09Descr
|
SAF9 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSaf10Descr
|
SAF10 Descr
|
|
x(40)
|
|
|
|
FRWCubeDimSafCode01
|
Saf 1
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode02
|
Saf 2
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode03
|
Saf 3
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode04
|
Saf 4
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode05
|
Saf 5
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode06
|
Saf 6
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode07
|
Saf 7
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode08
|
Saf 8
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode09
|
Saf 9
|
|
x(20)
|
|
|
|
FRWCubeDimSafCode10
|
Saf 10
|
|
x(20)
|
|
|
|
FRWCubeDimTransMethod
|
Translation Method
|
|
yes/no
|
|
|
|
FRWCubeDimUsedRateType
|
Rate Type used for translation
|
|
x(20)
|
|
|
|
FRWCubeDimUsedTransMethod
|
Rate Translation Method Used
|
|
x(2)
|
|
|
|
GL_ID
|
Link To GL
|
|
-99999999999
|
|
|
|
ICBusinessRelation_ID
|
Link To Interco-BusinessRelation
|
|
-99999999999
|
|
|
|
ICCompany_ID
|
Link To Interco-Company
|
|
-99999999999
|
|
|
|
Journal_ID
|
Link To Journal
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Layer_ID
|
Link To Layer
|
|
-99999999999
|
|
|
|
Project_ID
|
Link To Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Budget
|
no
|
FRWCubeDimIsBudget
|
yes
|
no
|
|
|
CCidx
|
no
|
FRWCubeDimCostCentreCode
|
yes
|
no
|
|
|
CodeIdx
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
Combidx
|
no
|
FRWCubeDimCombinedKey
|
yes
|
no
|
|
|
Compidx
|
no
|
FRWCubeDimCompanyCode
|
yes
|
no
|
|
|
CubeCC
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimCostCentreCode
|
yes
|
no
|
|
|
CubeCurr
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimCurrencyCode
|
yes
|
no
|
|
|
CubeCy
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimCompanyCode
|
yes
|
no
|
|
|
CubeDiv
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimDivisionCode
|
yes
|
no
|
|
|
CubeGL
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimGLCode
|
yes
|
no
|
|
|
CubeIC
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimICInterco
|
yes
|
no
|
|
|
CubeID
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeJrnl
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimJournalCode
|
yes
|
no
|
|
|
CubeLayer
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimLayerCode
|
yes
|
no
|
|
|
CubePrj
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimProjectCode
|
yes
|
no
|
|
|
CubeSaf01
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode01
|
yes
|
no
|
|
|
CubeSaf02
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode02
|
yes
|
no
|
|
|
CubeSaf03
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode03
|
yes
|
no
|
|
|
CubeSaf04
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode04
|
yes
|
no
|
|
|
CubeSaf05
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode05
|
yes
|
no
|
|
|
CubeSaf06
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode06
|
yes
|
no
|
|
|
CubeSaf07
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode07
|
yes
|
no
|
|
|
CubeSaf08
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode08
|
yes
|
no
|
|
|
CubeSaf09
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode09
|
yes
|
no
|
|
|
CubeSaf10
|
no
|
FRWCubeDimFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeDimSafCode10
|
yes
|
no
|
|
|
CurrIdx
|
no
|
FRWCubeDimCurrencyCode
|
yes
|
no
|
|
|
Dividx
|
no
|
FRWCubeDimDivisionCode
|
yes
|
no
|
|
|
Domainidx
|
no
|
FRWCubeDimDomainCode
|
yes
|
no
|
|
|
GLidx
|
no
|
FRWCubeDimGLCode
|
yes
|
no
|
|
|
ICCompidx
|
no
|
FRWCubeDimICCompanyCode
|
yes
|
no
|
|
|
ICidx
|
no
|
FRWCubeDimICInterco
|
yes
|
no
|
|
|
Journalidx
|
no
|
FRWCubeDimJournalCode
|
yes
|
no
|
|
|
Layeridx
|
no
|
FRWCubeDimLayerTypeCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeDim_ID
|
yes
|
no
|
|
|
Prjidx
|
no
|
FRWCubeDimProjectCode
|
yes
|
no
|
|
|
Saf10Idx
|
no
|
FRWCubeDimSafCode10
|
yes
|
no
|
|
|
Saf1Idx
|
no
|
FRWCubeDimSafCode01
|
yes
|
no
|
|
|
Saf2Idx
|
no
|
FRWCubeDimSafCode02
|
yes
|
no
|
|
|
Saf3Idx
|
no
|
FRWCubeDimSafCode03
|
yes
|
no
|
|
|
Saf4Idx
|
no
|
FRWCubeDimSafCode04
|
yes
|
no
|
|
|
Saf5Idx
|
no
|
FRWCubeDimSafCode05
|
yes
|
no
|
|
|
Saf6Idx
|
no
|
FRWCubeDimSafCode06
|
yes
|
no
|
|
|
Saf7Idx
|
no
|
FRWCubeDimSafCode07
|
yes
|
no
|
|
|
Saf8Idx
|
no
|
FRWCubeDimSafCode08
|
yes
|
no
|
|
|
Saf9Idx
|
no
|
FRWCubeDimSafCode09
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCube_ID
|
Link To FRW Cube
|
|
-99999999999
|
|
|
|
FRWCubeGLPd_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeGLPdCompanyCode
|
Entity Code
|
|
x(20)
|
|
|
|
FRWCubeGLPdEndDate
|
GL Period End Date
|
|
99/99/9999
|
|
|
|
FRWCubeGLPdFRWCubeCode
|
Cube Name
|
|
x(20)
|
|
|
|
FRWCubeGLPdPeriodPeriod
|
GL Period
|
|
99
|
|
|
|
FRWCubeGLPdPeriodYearInt
|
GL Year
|
|
9999
|
|
|
|
FRWCubeGLPdReportPeriodInt
|
Report Period
|
|
99
|
|
|
|
FRWCubeGLPdReportYear
|
Report Year
|
|
9999
|
|
|
|
FRWCubeGLPdStartDate
|
GL Period Start Date
|
|
99/99/9999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeID
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWCubeGLPdFRWCubeCode
|
yes
|
no
|
|
|
CyIdx
|
no
|
FRWCubeGLPdCompanyCode
|
yes
|
no
|
|
|
EndIdx
|
no
|
FRWCubeGLPdEndDate
|
yes
|
no
|
|
|
PdID
|
no
|
FRWCubeGLPdPeriodYearInt
|
yes
|
no
|
|
|
|
|
FRWCubeGLPdPeriodPeriod
|
yes
|
no
|
|
|
PdIdx
|
no
|
FRWCubeGLPdPeriodPeriod
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeGLPd_ID
|
yes
|
no
|
|
|
RepPd
|
no
|
FRWCubeGLPdReportYear
|
yes
|
no
|
|
|
|
|
FRWCubeGLPdReportPeriodInt
|
yes
|
no
|
|
|
RepPdIdx
|
no
|
FRWCubeGLPdReportYear
|
yes
|
no
|
|
|
StartIdx
|
no
|
FRWCubeGLPdStartDate
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWCubeGLPdFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubeGLPdCompanyCode
|
yes
|
no
|
|
|
|
|
FRWCubeGLPdPeriodYearInt
|
yes
|
no
|
|
|
|
|
FRWCubeGLPdPeriodPeriod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCubeHistLink_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeMeas_ID
|
Link to FRWCubeMeas
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PostingHist_ID
|
Link to PostingHist
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Measure
|
no
|
FRWCubeMeas_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeHistLink_ID
|
yes
|
no
|
|
|
Uniq
|
yes
|
PostingHist_ID
|
yes
|
no
|
|
|
|
|
FRWCubeMeas_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCube_ID
|
Link to FRWCube
|
|
-99999999999
|
|
|
|
FRWCubeLayer_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Layer_ID
|
Link to Layer
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FRWCubeIdx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
LayerIdx
|
no
|
Layer_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeLayer_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWCube_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCube_ID
|
Link To FRWCube
|
|
-99999999999
|
|
|
|
FRWCubeDim_ID
|
Link To FRWCubeDim
|
|
-99999999999
|
|
|
|
FRWCubeMeas_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubeMeasAcitivtyQTY
|
Qty Activity
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
FRWCubeMeasActivityCRLC
|
BC/SC Activity CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityCRPC
|
PC Activity CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityCRTC
|
TC Activity CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityDifPC
|
PC ActivityTranslation Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityDRLC
|
BC/SC Activity DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityDRPC
|
PC Activity DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasActivityDRTC
|
TC Activity DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasAverageRate
|
BC/SC->PC Weighted Av. Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasCloseBalCRLC
|
BC/SC Closing Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalCRPC
|
PC Closing Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalCRTC
|
TC Closing Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalDRLC
|
BC/SC Closing Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalDRPC
|
PC Closing Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalDRTC
|
TC Closing Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalLC
|
BC/SC Closing Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalPC
|
PC Closing Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasCloseBalTC
|
TC Closing Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasClosingBalDifPC
|
PC Closing Translation Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasClosingBalQTY
|
Qty Closing Balance
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
FRWCubeMeasFRWCubeCode
|
Cube Name
|
|
x(20)
|
|
|
|
FRWCubeMeasHighRate
|
HI Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasLCCCCurCode
|
BC/SC Currency Code
|
|
x(3)
|
|
|
|
FRWCubeMeasOpenBalCRLC
|
BC/SC Opening Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalCRPC
|
PC Opening Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalCRTC
|
TC Opening Balance CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalDifPC
|
PC Opening Translation Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalDRLC
|
BC/SC Opening Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalDRPC
|
PC Opening Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalDRTC
|
TC Opening Balance DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalLC
|
BC/SC Opening Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalLTC
|
TC Opening Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalPC
|
PC Opening Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasOpenBalQTY
|
Qty Opening Balance
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
FRWCubeMeasOriOpenBalDifPC
|
PC Original Translation Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPCCurCode
|
PC Currency Code
|
|
x(3)
|
|
|
|
FRWCubeMeasPeriodEndRate
|
BC/SC->PC Period End Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasPeriodOpenRate
|
Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasPrevOpenBalCRLC
|
BC/SC Previous Years CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPrevOpenBalCRPC
|
PC Previous Years CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPrevOpenBalCRTC
|
TC Previous Years CR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPrevOpenBalDRLC
|
BC/SC Previous Years DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPrevOpenBalDRPC
|
PC Previous Years DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasPrevOpenBalDRTC
|
TC Previous Years DR
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
FRWCubeMeasReportPeriod
|
Period
|
|
99
|
|
|
|
FRWCubeMeasReportYear
|
Year
|
|
9999
|
|
|
|
FRWCubeMeasSimpAverageRate
|
BC/SC->PC Simple Av. Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasTCCurCode
|
TC Currency Code
|
|
x(3)
|
|
|
|
FRWCubeMeasYCRate
|
Year Closing Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubeMeasYORate
|
Year Opening Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
FRWCubePeriod_ID
|
Link To FRWCubePeriod
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeID
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWCubeMeasFRWCubeCode
|
yes
|
no
|
|
|
DimIdx
|
no
|
FRWCubeDim_ID
|
yes
|
no
|
|
|
DimYrPd
|
no
|
FRWCubeDim_ID
|
yes
|
no
|
|
|
|
|
FRWCubeMeasReportYear
|
yes
|
no
|
|
|
|
|
FRWCubeMeasReportPeriod
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubeMeas_ID
|
yes
|
no
|
|
|
YrPdIdx
|
no
|
FRWCubeMeasReportYear
|
yes
|
no
|
|
|
|
|
FRWCubeMeasReportPeriod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWCube_ID
|
Link To FRW Cube
|
|
-99999999999
|
|
|
|
FRWCubePeriod_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWCubePeriodEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
FRWCubePeriodFRWCubeCode
|
Cube Name
|
|
x(20)
|
|
|
|
FRWCubePeriodIsRebuildNeed
|
Rebuild Needed
|
|
yes/no
|
|
|
|
FRWCubePeriodReportPerInt
|
Report Period
|
|
99
|
|
|
|
FRWCubePeriodReportYear
|
Report Year
|
|
9999
|
|
|
|
FRWCubePeriodStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeID
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWCubePeriodFRWCubeCode
|
yes
|
no
|
|
|
EndIdx
|
no
|
FRWCubePeriodEndDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWCubePeriod_ID
|
yes
|
no
|
|
|
RepPd
|
no
|
FRWCubePeriodReportYear
|
yes
|
no
|
|
|
|
|
FRWCubePeriodReportPerInt
|
yes
|
no
|
|
|
StartIdx
|
no
|
FRWCubePeriodStartDate
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWCubePeriodFRWCubeCode
|
yes
|
no
|
|
|
|
|
FRWCubePeriodReportYear
|
yes
|
no
|
|
|
|
|
FRWCubePeriodReportPerInt
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FRWAnCode_ID
|
Link to FRWAnCode
|
|
-99999999999
|
|
|
|
FRWChart_ID
|
Link to FRWChart
|
|
-99999999999
|
|
|
|
FRWCol_ID
|
Link to FRWCol
|
|
-99999999999
|
|
|
|
FRWCube_ID
|
Link to FRWCube
|
|
-99999999999
|
|
|
|
FRWRepMstr_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWRepMstrCOADetDef
|
COA Details Default
|
|
x(20)
|
|
|
|
FRWRepMstrCode
|
Report Master Code
|
|
x(20)
|
|
|
|
FRWRepMstrCodeDescOption
|
Code, Description or Both
|
|
x(20)
|
|
|
|
FRWRepMstrDescription
|
Report MasterDescription
|
|
x(40)
|
|
|
|
FRWRepMstrIndentPixels
|
Number of Pixels for Indent
|
|
->,>>>,>>9
|
|
|
|
FRWRepMstrIsNegAmntBracket
|
Print negative with brackets
|
|
yes/no
|
|
|
|
FRWRepMstrIsZeroSuppres
|
Suppress zero amounts on report
|
|
yes/no
|
|
|
|
FRWRepMstrLabelForCode
|
Label for Code and Description
|
|
x(40)
|
|
|
|
FRWRepMstrLevelsToPrint
|
Levels To Print
|
|
>9
|
|
|
|
FRWRepMstrMaxPostingline
|
Max Posting Lines
|
|
>,>>>,>>>,>>9
|
|
|
|
FRWRepMstrNumberOfDecimals
|
Number of Decimals
|
|
9
|
|
|
|
FRWRepMstrPrintTransactions
|
Print GL Transactions
|
|
x(20)
|
|
|
|
FRWRepMstrSubTitle
|
Subtitle
|
|
x(2000)
|
|
|
|
FRWRepMstrThousandMillion
|
Report Amount Scale
|
|
x(20)
|
|
|
|
FRWRepMstrTitle
|
ReportTitle
|
|
x(255)
|
|
|
|
FRWRepMstrTitleStyle
|
Report Title Style Tag
|
|
x(20)
|
|
|
|
FRWRepMstrXBRLFileBase
|
XBRL output file base name
|
|
x(20)
|
|
|
|
FRWRepMstrXBRLLocalNS
|
XBRL Local Name Space
|
|
x(255)
|
|
|
|
FRWRepMstrXBRLNameSpace
|
XBRL Name Space
|
|
x(255)
|
|
|
|
FRWRepMstrXBRLNSPrefix
|
XBRL Name Space Prefix
|
|
x(40)
|
|
|
|
FRWRepMstrXBRLReportType
|
XBRL Report Type BS/IS
|
|
x(20)
|
|
|
|
FRWRepMstrZeroSuppressType
|
Zero Suppress Type
|
|
x(20)
|
|
|
|
FRWTreeNode_ID
|
Link to FRWTree
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AnCodeIdx
|
no
|
FRWAnCode_ID
|
yes
|
no
|
|
|
ChartIdx
|
no
|
FRWChart_ID
|
yes
|
no
|
|
|
ColIdx
|
no
|
FRWCol_ID
|
yes
|
no
|
|
|
CubeIdx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWRepMstr_ID
|
yes
|
no
|
|
|
TreeNodeIdx
|
no
|
FRWTreeNode_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWRepMstrCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
FRWRepMstr_ID
|
Link to FRWRepMstr
|
|
-99999999999
|
|
|
|
FRWRepMstrRole_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Role_ID
|
Link to Role
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
FRWRepMstrRole_ID
|
yes
|
no
|
|
|
RepMstrIdx
|
no
|
FRWRepMstr_ID
|
yes
|
no
|
|
|
RoleIdx
|
no
|
Role_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWRepMstr_ID
|
yes
|
no
|
|
|
|
|
Role_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CCCOACOACrossRef_ID
|
Link To CC COACrossRef
|
|
-99999999999
|
|
|
|
CombCOACOACrossRef_ID
|
Link To Combined COACrossRef
|
|
-99999999999
|
|
|
|
CostCentreSharedSet_ID
|
Link To CostCentreSharedSet
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DivCOACOACrossRef_ID
|
Link To Div COACrossRef
|
|
-99999999999
|
|
|
|
DivisionSharedSet_ID
|
Link To DivisionSharedSet
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link To Domain
|
|
-99999999999
|
|
|
|
FRWChart_ID
|
Link To FRWChart
|
|
-99999999999
|
|
|
|
FRWShSetComb_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWShSetCombAllSets
|
Sets
|
|
x(70)
|
|
|
|
FRWShSetCombCCCOACRCode
|
Cost Center Cross Ref
|
|
x(20)
|
|
|
|
FRWShSetCombCCSSCode
|
Cost Center Shared Set
|
|
x(20)
|
|
|
|
FRWShSetCombCombCOACRCode
|
Combined Cross Ref
|
|
x(20)
|
|
|
|
FRWShSetCombDivCOACRCode
|
Sub-Account Cross Ref
|
|
x(20)
|
|
|
|
FRWShSetCombDivSSCode
|
Sub-Account Shared Set
|
|
x(20)
|
|
|
|
FRWShSetCombFRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWShSetCombGLCOACRCode
|
GL Cross Ref
|
|
x(20)
|
|
|
|
FRWShSetCombGLSSCode
|
GL Shared Set
|
|
x(20)
|
|
|
|
FRWShSetCombPrjCOACRCode
|
Project Cross Ref
|
|
x(20)
|
|
|
|
FRWShSetCombPrjSSCode
|
Project Shared Set
|
|
x(20)
|
|
|
|
GLCOACrossRef_ID
|
Link To GL COACrossRef
|
|
-99999999999
|
|
|
|
GLSharedSet_ID
|
Link To GLSharedSet
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PrjCOACOACrossRef_ID
|
Link To Prj COACrossRef
|
|
-99999999999
|
|
|
|
ProjectSharedSet_ID
|
Link To ProjectSharedSet
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ChartID
|
no
|
FRWChart_ID
|
yes
|
no
|
|
|
ChartIdx
|
no
|
FRWShSetCombFRWChartCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWShSetComb_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
FRWShSetCombAllSets
|
yes
|
no
|
|
|
|
|
FRWShSetCombFRWChartCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Domain_ID
|
Link To Domain
|
|
-99999999999
|
|
|
|
FRWAnCode_ID
|
Link To FRWAnCode
|
|
-99999999999
|
|
|
|
FRWChart_ID
|
Link To FRWChart
|
|
-99999999999
|
|
|
|
FRWTreeNode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
FRWTreeNodeBalancePrintType
|
Balances Print Type
|
|
x(20)
|
|
|
|
FRWTreeNodeCode
|
Name
|
|
x(255)
|
|
|
|
FRWTreeNodeDescription
|
Description
|
|
x(255)
|
|
|
|
FRWTreeNodeDRCROnly
|
DR/CR
|
|
x(20)
|
|
|
|
FRWTreeNodeFRWChartCode
|
Chart
|
|
x(20)
|
|
|
|
FRWTreeNodeIsBlankRowAfter
|
Insert Blank Row After
|
|
yes/no
|
|
|
|
FRWTreeNodeIsBlankRowBefore
|
Insert Blank Row Before
|
|
yes/no
|
|
|
|
FRWTreeNodeIsExplode
|
Explode
|
|
yes/no
|
|
|
|
FRWTreeNodeIsFullAmount
|
Print the Full Amount
|
|
yes/no
|
|
|
|
FRWTreeNodeIsHiddenRow
|
Hide Row on Report
|
|
yes/no
|
|
|
|
FRWTreeNodeIsInvertActSign
|
Invert Activity Columns Sign
|
|
yes/no
|
|
|
|
FRWTreeNodeIsInvertBalSign
|
Invert Balans Columns Sign
|
|
yes/no
|
|
|
|
FRWTreeNodeIsPageSkipAfter
|
Skip Page After
|
|
yes/no
|
|
|
|
FRWTreeNodeIsTextOnly
|
Print Text Only
|
|
yes/no
|
|
|
|
FRWTreeNodeIsTotalAfter
|
Print Total After Detail
|
|
yes/no
|
|
|
|
FRWTreeNodeIsUsed
|
Used
|
|
yes/no
|
|
|
|
FRWTreeNodeParentCode
|
Parent Name
|
|
x(255)
|
|
|
|
FRWTreeNodeRowStyle
|
Row Style
|
|
x(40)
|
|
|
|
FRWTreeNodeSequence
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ParentFRWTreeNode_ID
|
Link To Parent FRWTreeNode
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AnCode
|
no
|
FRWAnCode_ID
|
yes
|
no
|
|
|
ChartCode
|
no
|
FRWTreeNodeFRWChartCode
|
yes
|
no
|
|
|
ChartID
|
no
|
FRWChart_ID
|
yes
|
no
|
|
|
CodeIdx
|
no
|
FRWTreeNodeCode
|
yes
|
no
|
|
|
DomIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
ParCode
|
no
|
FRWTreeNodeParentCode
|
yes
|
no
|
|
|
ParID
|
no
|
ParentFRWTreeNode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
FRWTreeNode_ID
|
yes
|
no
|