|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CostCentre_ID
|
Cost Center Code
|
|
9999999999
|
|
|
|
CrossCompany_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CrossCompanyPosting_ID
|
Posting (Cross-Cy)
|
|
9999999999
|
|
|
|
CrossCompanyPostingLine_ID
|
Posting line (Cross-Cy)
|
Posting-line (Cross-Cy)
|
9999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Trans Curr
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
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
|
|
|
|
CustomDate5
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate6
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate7
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate8
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate9
|
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
|
|
|
CustomDecimal5
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal6
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal7
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal8
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal9
|
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)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
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)
|
|
|
|
Division_ID
|
Sub-Account Code
|
|
9999999999
|
|
|
|
GL_ID
|
GL Description
|
|
9999999999
|
|
|
|
IntercoBusinessRelation_ID
|
Intercompany Code
|
|
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)
|
|
|
|
Period_ID
|
Link to Period
|
|
9999999999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
9999999999
|
|
|
|
PostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
PostingLine_ID
|
Record ID
|
|
9999999999
|
|
|
|
PostingLineAddGLNbr
|
Additional Sequence Number
|
|
99999999999
|
|
|
|
PostingLineAddGLNbrDate
|
Additional Sequence Date
|
|
99/99/9999
|
|
|
|
PostingLineCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingLineCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingLineCostCentreText
|
Cost Center
|
|
x(40)
|
|
|
|
PostingLineCreditCC
|
SC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineCreditLC
|
BC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineCreditPC
|
PC Credit
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingLineCreditTC
|
TC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineCrossExternRef
|
Ext Reference (Cross-Cy)
|
|
x(40)
|
|
|
|
PostingLineDebitCC
|
SC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineDebitLC
|
BC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineDebitPC
|
PC Debit
|
|
->,>>>,>>9.99
|
4
|
|
|
PostingLineDebitTC
|
TC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingLineExchangeRate
|
Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingLineGrossIncAccRef
|
Gross Income Accounting Reference
|
|
x(40)
|
|
|
|
PostingLineIsProjPosting
|
Project Posting
|
Proj
|
yes/no
|
|
|
|
PostingLineLegalDocNbr
|
Legal Document Nbr
|
|
x(255)
|
|
|
|
PostingLineMaster_ID
|
Link to Master
|
|
9999999999
|
|
|
|
PostingLineMirrorRef
|
Mirroring Reference
|
|
x(20)
|
|
|
|
PostingLineMirrorType
|
Mirroring Type
|
|
x(20)
|
|
|
|
PostingLineOriginLineNbr
|
Origin Line Number
|
Origin Line No
|
>>>9
|
|
|
|
PostingLineProjectText
|
Project
|
Prj
|
x(40)
|
|
|
|
PostingLineQTY
|
Quantity
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
PostingLineRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingLineSafText
|
SAF
|
|
x(40)
|
|
|
|
PostingLineSequence
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
PostingLineText
|
Description
|
|
x(40)
|
|
|
|
PostingLineTransaction_ID
|
Link to Transaction
|
|
9999999999
|
|
|
|
PostingYearPeriod
|
Year/GL Period
|
GL Cal Yr/GL Pd
|
999999
|
|
|
|
Project_ID
|
Description
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AddGLIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingLineAddGLNbr
|
no
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CompanyGLYearPd
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
PostingYearPeriod
|
yes
|
no
|
|
|
CompanyYearPeirod
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingYearPeriod
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
CrossCompany
|
no
|
CrossCompany_ID
|
yes
|
no
|
|
|
CrossCompanyPost
|
no
|
CrossCompanyPosting_ID
|
yes
|
no
|
|
|
CrossCompanyPostL
|
no
|
CrossCompanyPostingLine_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingDate
|
yes
|
no
|
|
|
CyGLDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
PostingDate
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
ExtCrossIdx
|
no
|
PostingLineCrossExternRef
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
Interco
|
no
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
Master
|
no
|
PostingLineMaster_ID
|
yes
|
no
|
|
|
MirrorRef
|
no
|
PostingLineMirrorRef
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
|
PostingIDLineSeq
|
no
|
Posting_ID
|
yes
|
no
|
|
|
|
|
PostingLineSequence
|
yes
|
no
|
|
|
PostingYearPeriod
|
no
|
PostingYearPeriod
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingLine_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|
|
|
ProjectPosting
|
no
|
PostingLineIsProjPosting
|
yes
|
no
|
|
|
TransactionId
|
no
|
PostingLineTransaction_ID
|
yes
|
no
|