About This Guide > PostingHist
  
PostingHist
Posting History
 
 
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