|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link To Company
|
|
9999999999
|
|
|
|
CostCentre_ID
|
Link To CostCentre
|
|
9999999999
|
|
|
|
Currency_ID
|
Link To Currency
|
|
9999999999
|
|
|
|
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
|
|
9999999999
|
|
|
|
Dim02Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim03Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim04Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim05Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim06Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim07Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim08Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim09Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Dim10Saf_ID
|
Link To SAF
|
|
9999999999
|
|
|
|
Division_ID
|
Link To Division
|
|
9999999999
|
|
|
|
Domain_ID
|
Link To Domain
|
|
9999999999
|
|
|
|
FRWCube_ID
|
Link To FRWCube
|
|
9999999999
|
|
|
|
FRWCubeDim_ID
|
Record ID
|
|
9999999999
|
|
|
|
FRWCubeDimBSISGL
|
BS/IS GL
|
|
yes/no
|
|
|
|
FRWCubeDimCombinedKey
|
Key
|
|
x(360)
|
|
|
|
FRWCubeDimCompanyCode
|
Entity
|
|
x(20)
|
|
|
|
FRWCubeDimCostCentreCode
|
Cost Center
|
|
x(8)
|
|
|
|
FRWCubeDimCostCentreDescr
|
Cost Center Descr
|
|
x(40)
|
|
|
|
FRWCubeDimCurrencyCode
|
Currency
|
|
x(3)
|
|
|
|
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)
|
|
|
|
FRWCubeDimIsBudget
|
Is Budget Dimmension
|
|
yes/no
|
|
|
|
FRWCubeDimJournalCode
|
Daybook
|
|
x(8)
|
|
|
|
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
|
|
|
|
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
|
|
9999999999
|
|
|
|
ICBusinessRelation_ID
|
Link To Interco-BusinessRelation
|
|
9999999999
|
|
|
|
ICCompany_ID
|
Link To Interco-Company
|
|
9999999999
|
|
|
|
Journal_ID
|
Link To Journal
|
|
9999999999
|
|
|
|
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
|
|
9999999999
|
|
|
|
Project_ID
|
Link To Project
|
|
9999999999
|
|
|
|
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
|