|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AutoReversalPosting_ID
|
Automatic Reversal Posting
|
Automatic Reversal Posting
|
9999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CreatorUsr_ID
|
Login
|
|
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)
|
|
|
|
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)
|
|
|
|
Journal_ID
|
Daybook Code
|
|
9999999999
|
|
|
|
LastApprovedUsr_ID
|
Link to Usr
|
|
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)
|
|
|
|
LastVerifiedUsr_ID
|
Link to Usr
|
|
9999999999
|
|
|
|
ObsoleteClosing_ID
|
Link to Closing
|
|
9999999999
|
|
|
|
Period_ID
|
Link to Period
|
|
9999999999
|
|
|
|
PeriodMark_ID
|
Link to PeriodMark
|
|
9999999999
|
|
|
|
Posting_ID
|
Record ID
|
|
9999999999
|
|
|
|
PostingAddGLNbr
|
Sequence Number
|
|
999999999
|
|
|
|
PostingAddGLNbrDate
|
Additional GL Numbering Date
|
|
99/99/9999
|
|
|
|
PostingAddGLNbrRevDate
|
Additional GL Numbering Reversal Date
|
|
99/99/9999
|
|
|
|
PostingApproveComments
|
Approve Comments
|
|
x(40)
|
|
|
|
PostingApprovedDate
|
Last Approved Date
|
|
99/99/9999
|
|
|
|
PostingApprovedTime
|
Last Approved Time
|
|
->,>>>,>>9
|
|
|
|
PostingApproveStatus
|
Approve Status
|
|
x(40)
|
|
|
|
PostingAutoReversalDate
|
Automatic Reversal Date
|
Automatic Reversal Date
|
99/99/9999
|
|
|
|
PostingAutoReversalType
|
Automatic Reversal Type
|
Automatic Reversal Type
|
x(20)
|
|
|
|
PostingBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
PostingBatchNumber
|
Batch Number
|
|
x(8)
|
|
|
|
PostingBusinessRelationTxt
|
Bus Rel (IC Posting)
|
Business Relation (IC Posting)
|
x(40)
|
|
|
|
PostingCreationDate
|
Creation Date
|
|
99/99/9999
|
|
|
|
PostingCreationTimeString
|
Creation Time
|
|
x(10)
|
|
|
|
PostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
PostingInvoiceReferenceTxt
|
External Inv Ref
|
External Invoice Reference
|
x(50)
|
|
|
|
PostingIsAutoReversal
|
Automatic Reversal
|
Automatic Reversal
|
yes/no
|
|
|
|
PostingIsCorrection
|
Correction
|
Correction
|
yes/no
|
|
|
|
PostingIsReplacement
|
Replacement
|
Is Replacement
|
yes/no
|
|
|
|
PostingIsReversing
|
Reversal
|
Is Reversal
|
yes/no
|
|
|
|
PostingIsReversingBySign
|
Correction
|
|
yes/no
|
|
|
|
PostingIsSkipAutoAssignLC
|
Skip Auto Assign BC
|
|
yes/no
|
|
|
|
PostingIsZeroValueAllowed
|
Zero Value Allowed
|
|
yes/no
|
|
|
|
PostingMirrorRef
|
Mirroring Reference
|
|
x(20)
|
|
|
|
PostingOriginAddressCode
|
Address Code
|
|
x(20)
|
|
|
|
PostingOriginatorReference
|
Original Posting Reference
|
|
x(40)
|
|
|
|
PostingOriginDaybookCode
|
Origin Daybook Code
|
|
x(8)
|
|
|
|
PostingOriginDaybookNumber
|
Origin Daybook Number
|
|
x(40)
|
|
|
|
PostingOriginDocument
|
Origin Document
|
Origin Doc
|
x(22)
|
|
|
|
PostingOriginDocumentType
|
Origin Payment Type
|
Origin Pay Type
|
x(2)
|
|
|
|
PostingOriginIsExternal
|
External Origin
|
|
yes/no
|
|
|
|
PostingOriginReference
|
Origin Reference
|
Origin Ref
|
x(22)
|
|
|
|
PostingOriginTransType
|
Origin Transaction Type
|
Origin Trans Type
|
x(2)
|
|
|
|
PostingParentText
|
Parent Text
|
|
x(40)
|
|
|
|
PostingPeriod
|
GL Period
|
|
99
|
|
|
|
PostingSecondText
|
Second Description
|
|
x(40)
|
|
|
|
PostingSystemDate
|
System Date
|
Sys Date
|
99/99/9999
|
|
|
|
PostingText
|
Description
|
|
x(40)
|
|
|
|
PostingValueDate
|
Value Date
|
|
99/99/9999
|
|
|
|
PostingVerifiedDate
|
Last Verified Date
|
|
99/99/9999
|
|
|
|
PostingVerifiedTime
|
Last Verified Time
|
|
->,>>>,>>9
|
|
|
|
PostingVerifyComments
|
Verify Comments
|
|
x(40)
|
|
|
|
PostingVerifyStatus
|
Verify Status
|
|
x(40)
|
|
|
|
PostingVoucher
|
Voucher
|
|
999999999
|
|
|
|
PostingYear
|
Year
|
|
9999
|
|
|
|
PostingYearPeriod
|
Year/GL Period
|
GL Cal Yr/GL Pd
|
999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
ReportingJournal_ID
|
Reporting Daybook
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AddGLNbr
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingAddGLNbr
|
no
|
no
|
|
|
|
|
PostingAddGLNbrDate
|
no
|
no
|
|
|
ApproveIdx
|
no
|
PostingApproveStatus
|
yes
|
no
|
|
|
AutoReversal
|
no
|
PostingIsAutoReversal
|
yes
|
no
|
|
|
|
|
PostingAutoReversalType
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CreateUsrIdx
|
no
|
CreatorUsr_ID
|
yes
|
no
|
|
|
CyJrnlDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
PostingDate
|
yes
|
no
|
|
|
CyOrig
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingOriginTransType
|
yes
|
no
|
|
|
|
|
PostingOriginReference
|
yes
|
no
|
|
|
CyPeriodYearPeriodIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingYearPeriod
|
yes
|
no
|
|
|
CyPostingDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingDate
|
yes
|
no
|
|
|
CySysDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingSystemDate
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
LastApprUsrIdx
|
no
|
LastApprovedUsr_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LastVerUsrIdx
|
no
|
LastVerifiedUsr_ID
|
yes
|
no
|
|
|
MirrorRef
|
no
|
PostingMirrorRef
|
yes
|
no
|
|
|
OriginatorRef
|
no
|
PostingOriginatorReference
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
PeriodMarkIdx
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
|
PostingDate
|
no
|
PostingDate
|
yes
|
no
|
|
|
PostingOriginIsExt
|
no
|
PostingOriginIsExternal
|
yes
|
no
|
|
|
PostingOriginRef
|
no
|
PostingOriginReference
|
yes
|
no
|
|
|
PostingYear
|
no
|
PostingYear
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Posting_ID
|
yes
|
no
|
|
|
ReportingJrnlIdx
|
no
|
ReportingJournal_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingYear
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
PostingVoucher
|
yes
|
no
|
|
|
VerifyIdx
|
no
|
PostingVerifyStatus
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingYear
|
yes
|
no
|
|
|
|
|
PostingPeriod
|
yes
|
no
|
|
|
|
|
Journal_ID
|
yes
|
no
|
|
|
|
|
PostingVoucher
|
yes
|
no
|
|
|
Voucher
|
no
|
PostingVoucher
|
yes
|
no
|