|
|
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
|
|
9999999999
|
|
|
|
FRWCubeDim_ID
|
Link To FRWCubeDim
|
|
9999999999
|
|
|
|
FRWCubeMeas_ID
|
Record ID
|
|
9999999999
|
|
|
|
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
|
|
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)
|
|
|
|
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
|