|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ApprovePosting_ID
|
Link to ApprovePosting
|
|
9999999999
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
DeductionCatLine_ID
|
Link to DeductionCatLine
|
|
9999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
9999999999
|
|
|
|
DInvoiceDeduction_ID
|
Record ID
|
|
9999999999
|
|
|
|
DInvoiceDeductionApRejCom
|
Approve/Reject Comment
|
|
x(80)
|
|
|
|
DInvoiceDeductionApRejDate
|
Approve/Reject Date
|
Mod Date
|
99/99/9999
|
|
|
|
DInvoiceDeductionCC
|
Deduction SC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceDeductionComment
|
Comment
|
|
x(2000)
|
|
|
|
DInvoiceDeductionCreateDate
|
Create Date
|
Mod Date
|
99/99/9999
|
|
|
|
DInvoiceDeductionCustRef
|
Customer Reference
|
|
x(20)
|
|
|
|
DInvoiceDeductionLC
|
Deduction BC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceDeductionPromotionCode
|
Promotion Code
|
|
x(20)
|
|
|
|
DInvoiceDeductionSequence
|
Sequence
|
|
9999999999
|
|
|
|
DInvoiceDeductionStatus
|
Deduction Status
|
|
x(40)
|
|
|
|
DInvoiceDeductionTC
|
Deduction TC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PaidDInvoice_ID
|
Link to PaidDInvoice
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RejectPosting_ID
|
Link to RejectPosting
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ApPost
|
no
|
ApprovePosting_ID
|
yes
|
no
|
|
|
Deduct
|
no
|
DeductionCatLine_ID
|
yes
|
no
|
|
|
DI
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
PaidDI
|
no
|
PaidDInvoice_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DInvoiceDeduction_ID
|
yes
|
no
|
|
|
RePost
|
no
|
RejectPosting_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
DInvoice_ID
|
yes
|
no
|
|
|
|
|
DeductionCatLine_ID
|
yes
|
no
|
|
|
|
|
PaidDInvoice_ID
|
yes
|
no
|
|
|
|
|
DInvoiceDeductionSequence
|
yes
|
no
|