|
|
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
|
|
|
|
GL_ID
|
Link to GL
|
|
9999999999
|
|
|
|
IntercoBusinessRelation_ID
|
Link to BusinessRelation
|
|
9999999999
|
|
|
|
Journal_ID
|
Link to Journal
|
|
9999999999
|
|
|
|
JournalTypeCode
|
Daybook Type
|
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
|
|
|
|
PostingHist_ID
|
Record ID
|
|
9999999999
|
|
|
|
PostingHistBalanceCreditCC
|
SC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceCreditLC
|
BC Balance Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceCreditPC
|
PC Credit Balance
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceCreditTC
|
TC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceDebitCC
|
SC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceDebitLC
|
BC Balance Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceDebitPC
|
PC Debit Balance
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceDebitTC
|
TC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistBalanceQTY
|
Quantity Balance
|
Qty Balance
|
->>>,>>>,>>9.99999
|
10
|
|
|
PostingHistFRWCubeTimeStamp
|
Timestamp
|
|
x(32)
|
|
|
|
PostingHistMovemntCreditCC
|
SC Credit Activity
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntCreditLC
|
BC Movement Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntCreditPC
|
PC Credit Activity
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntCreditTC
|
TC Credit Activity
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntDebitCC
|
SC Debit Activity
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntDebitLC
|
BC Movement Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntDebitPC
|
PC Debit Activity
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntDebitTC
|
TC Debit Activity
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistMovemntQTY
|
Qty Activity
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
PostingHistYearPeriodFrom
|
From Year/GL Period
|
|
->,>>>,>>9
|
|
|
|
PostingHistYearPeriodTill
|
To Year/GL Period
|
|
->,>>>,>>9
|
|
|
|
PostingHistYTDCreditCC
|
SC Credit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDCreditLC
|
BC YTD Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDCreditPC
|
PC Credit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDCreditTC
|
TC Credit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDDebitCC
|
SC Debit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDDebitLC
|
BC YTD Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDDebitPC
|
PC Debit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDDebitTC
|
TC Debit (YTD)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingHistYTDQTY
|
Quantity (YTD)
|
Qty (YTD)
|
->>>,>>>,>>9.99999
|
10
|
|
|
PostingSafCombined_ID
|
Link to PostingSafCombined
|
|
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
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CompanyYPFrom
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyCCTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyDivTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyGLFrom
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
CyGLLayPd1Till
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyGLLayPd2From
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
CyGLTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyJrnlPdFrom
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
CyJrnlTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyLayPd1Till
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
CyLayPd2From
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
CyProjTill
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
GLCostCentre
|
no
|
GL_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
GLDivision
|
no
|
GL_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|
|
|
GLPostSafComb
|
no
|
GL_ID
|
yes
|
no
|
|
|
|
|
PostingSafCombined_ID
|
yes
|
no
|
|
|
GLProject
|
no
|
GL_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
IDsPeriod1Till
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
|
|
PostingSafCombined_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
IDsPeriod2From
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
|
|
PostingSafCombined_ID
|
yes
|
no
|
|
|
|
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
Interco
|
no
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
|
Period1Till
|
no
|
PostingHistYearPeriodTill
|
yes
|
no
|
|
|
Period2From
|
no
|
PostingHistYearPeriodFrom
|
yes
|
no
|
|
|
PostingSafComb
|
no
|
PostingSafCombined_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingHist_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|