|
|
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
|
|
|
|
Division_ID
|
Link to Division
|
|
9999999999
|
|
|
|
FRWCube_ID
|
Link to FRWCube
|
|
9999999999
|
|
|
|
GL_ID
|
Link to GL
|
|
9999999999
|
|
|
|
IntercoBusinessRelation_ID
|
Link to BusinessRelation
|
|
9999999999
|
|
|
|
Journal_ID
|
Link to Journal
|
|
9999999999
|
|
|
|
JournalTypeCode
|
Daybook Type
|
|
x(30)
|
|
|
|
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
|
|
|
|
Period_ID
|
Link to Period
|
|
9999999999
|
|
|
|
PeriodYearPeriod
|
Year / GL Period
|
|
999999
|
|
|
|
PostingHist_ID
|
Link to PostingHist
|
|
9999999999
|
|
|
|
Project_ID
|
Link to Project
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QFRWCube_ID
|
Record ID
|
|
9999999999
|
|
|
|
QFRWCubeCreditCC
|
SC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeCreditLC
|
BC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeCreditTC
|
TC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitCC
|
SC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitLC
|
BC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitTC
|
TC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeETime
|
Time (s)
|
|
->>>,>>>,>>>,>>9.9999
|
4
|
|
|
QFRWCubeInfo
|
Info
|
|
x(40)
|
|
|
|
QFRWCubePHLastModifiedDate
|
Last Modified Date PH
|
Mod Date PH
|
99/99/9999
|
|
|
|
QFRWCubePHLastModifiedTime
|
Last Modified Time PH
|
Mod Time PH
|
99999
|
|
|
|
QFRWCubePostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
QFRWCubeQTY
|
Quantity
|
Qty
|
->>>,>>>,>>9.99999
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
FRWCubeIdx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
ICBusRel
|
no
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
PeriodYrPd
|
no
|
PeriodYearPeriod
|
yes
|
no
|
|
|
PostingHist
|
no
|
PostingHist_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
QFRWCube_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|