|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
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
|
|
|
|
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
|
|
|
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)
|
|
|
|
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)
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
9999999999
|
|
|
|
InvMovementPostingLine_ID
|
Link to PostingLine
|
|
9999999999
|
|
|
|
JournalEntryPostingLine_ID
|
Link to PostingLine
|
|
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)
|
|
|
|
OIAdjust_ID
|
Link to OIAdjust
|
|
9999999999
|
|
|
|
OIAdjustLn_ID
|
Record ID
|
|
9999999999
|
|
|
|
OIAdjustLnBaseCurrencyCode
|
Base Currency
|
BC
|
x(3)
|
|
|
|
OIAdjustLnCurrencyCode
|
Transactional Currency
|
TC
|
x(3)
|
|
|
|
OIAdjustLnGLCode
|
GL Account
|
|
x(8)
|
|
|
|
OIAdjustLnInvCompanyCode
|
Entity
|
|
x(20)
|
|
|
|
OIAdjustLnInvCredDebCode
|
Supplier/Customer
|
|
x(8)
|
|
|
|
OIAdjustLnInvDate
|
Invoice Date
|
|
99/99/9999
|
|
|
|
OIAdjustLnInvIdentifier
|
Invoice Number
|
|
x(40)
|
|
|
|
OIAdjustLnInvJournalCode
|
Daybook
|
|
x(8)
|
|
|
|
OIAdjustLnInvReference
|
Reference
|
|
x(40)
|
|
|
|
OIAdjustLnInvType
|
Invoice Type
|
|
x(20)
|
|
|
|
OIAdjustLnInvVoucher
|
Voucher
|
|
999999999
|
|
|
|
OIAdjustLnInvYear
|
Year
|
|
9999
|
|
|
|
OIAdjustLnMovementAmtLC
|
BC Movement
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnMovementAmtTC
|
TC Movement
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnNewBalanceAmtLC
|
BC New Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnNewBalanceAmtTC
|
TC New Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnOrigBalanceAmtLC
|
BC Orig Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnOrigBalanceAmtTC
|
TC Orig Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaidAmtTC
|
TC Paid Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaymentDiscLC
|
BC Payment Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnPaymentDiscTC
|
TC Payment Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnTaxDiscLC
|
BC Tax Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnTaxDiscTC
|
TC Tax Disc
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnType
|
Type
|
|
x(20)
|
|
|
|
OIAdjustLnWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
OIAdjustLnWHTCCRate
|
WHT SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTCCScale
|
WHT SC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTLCRate
|
WHT BC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTLCScale
|
WHT BC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
OIAdjustLnWHTPerc
|
WHT Percentage
|
|
->>9.99
|
2
|
|
|
OIAdjustLnWHTTxFeeTC
|
TC WHT Taxable Fee
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
InvMovement
|
no
|
InvMovementPostingLine_ID
|
yes
|
no
|
|
|
JournalEntry
|
no
|
JournalEntryPostingLine_ID
|
yes
|
no
|
|
|
OIAdjust
|
no
|
OIAdjust_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
OIAdjustLn_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
OIAdjust_ID
|
yes
|
no
|
|
|
|
|
CInvoice_ID
|
yes
|
no
|
|
|
|
|
DInvoice_ID
|
yes
|
no
|
|
|
|
|
JournalEntryPostingLine_ID
|
yes
|
no
|