|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AbsRetTaxDivision_ID
|
Retained Tax Sub-Account
|
Retained Tax Sub-Acct
|
9999999999
|
|
|
|
AbsRetTaxGL_ID
|
Retained Tax Account
|
|
9999999999
|
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
9999999999
|
|
|
|
CInvoiceVat_ID
|
Record ID
|
|
9999999999
|
|
|
|
CInvoiceVatIsAbsRet
|
Retained
|
|
yes/no
|
|
|
|
CInvoiceVatIsAccrRcpUs
|
Accrue at Receipt/Usage
|
|
yes/no
|
|
|
|
CInvoiceVatIsRevCharge
|
Reverse Charge
|
Rev Charge
|
yes/no
|
|
|
|
CInvoiceVatIsSuspDel
|
Delayed Tax
|
Delay Tax
|
yes/no
|
|
|
|
CInvoiceVatIsTaxable
|
Taxable
|
|
yes/no
|
|
|
|
CInvoiceVatIsUpdAllow
|
Update Allow
|
Upd Allow
|
yes/no
|
|
|
|
CInvoiceVatNonRecTaxAmtTC
|
Non-Recoverable Tax Amount
|
Non-Rev Tax Amt
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatNTBaseCreditTC
|
TC Base Credit Non-taxable
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatNTBaseDebitTC
|
TC Base Debit Non-taxable
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatSequence
|
Sequence
|
|
9999999999
|
|
|
|
CInvoiceVatSuspDelTaxAmtTC
|
Tax Amount on Delayed Account (TC)
|
Tax Amount on Delay Acct (TC)
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatTaxTrType
|
Tax Transaction Type
|
|
x(2)
|
|
|
|
CInvoiceVatUILinkedRowID
|
Linked Row
|
|
x(30)
|
|
|
|
CInvoiceVatVatBaseCreditCC
|
SC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatBaseCreditLC
|
BC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatBaseCreditTC
|
TC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatBaseDebitCC
|
SC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatBaseDebitLC
|
BC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatBaseDebitTC
|
TC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatCreditCC
|
SC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatCreditLC
|
BC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatCreditTC
|
TC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatDebitCC
|
SC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatDebitLC
|
BC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CInvoiceVatVatDebitTC
|
TC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
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)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
NormalTaxDivision_ID
|
Normal Tax Sub-Account
|
Normal Tax Sub-Acct
|
9999999999
|
|
|
|
NormalTaxGL_ID
|
Normal Tax Account
|
|
9999999999
|
|
|
|
PostingVat_ID
|
Link to PostingVat
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SuspDelTaxDivision_ID
|
Delayed Tax Sub-Account
|
Delay Tax Sub-Acct
|
9999999999
|
|
|
|
SuspDelTaxGL_ID
|
Delayed Tax Account
|
Delay Tax Acct
|
9999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxenvTaxEnv
|
Tax Environment
|
|
x(16)
|
|
|
|
TxtyTaxType
|
Tax Type
|
|
x(16)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
Vat_ID
|
Domain
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AbsRetDivIdx
|
no
|
AbsRetTaxDivision_ID
|
yes
|
no
|
|
|
AbsRetGLIdx
|
no
|
AbsRetTaxGL_ID
|
yes
|
no
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
NormalDivIdx
|
no
|
NormalTaxDivision_ID
|
yes
|
no
|
|
|
NormalGLIdx
|
no
|
NormalTaxGL_ID
|
yes
|
no
|
|
|
PostingVatIdx
|
no
|
PostingVat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CInvoiceVat_ID
|
yes
|
no
|
|
|
SuspDelDivIdx
|
no
|
SuspDelTaxDivision_ID
|
yes
|
no
|
|
|
SuspDelGLIdx
|
no
|
SuspDelTaxGL_ID
|
yes
|
no
|
|
|
UniqueTax
|
yes
|
CInvoice_ID
|
yes
|
no
|
|
|
|
|
TxuTaxUsage
|
yes
|
no
|
|
|
|
|
TxclTaxCls
|
yes
|
no
|
|
|
|
|
TxenvTaxEnv
|
yes
|
no
|
|
|
|
|
Vat_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|