|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AbsRetTaxDivision_ID
|
Absorbed Tax Sub-Account
|
Abs Tax Sub-Acct
|
9999999999
|
|
|
|
AbsRetTaxGL_ID
|
Absorbed Tax Account
|
Abs Tax Account
|
9999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
9999999999
|
|
|
|
DInvoiceVat_ID
|
Record ID
|
|
9999999999
|
|
|
|
DInvoiceVatIsAbsRet
|
Absorbed
|
|
yes/no
|
|
|
|
DInvoiceVatIsAccrRcpUs
|
Accrue at Receipt/Usage
|
|
yes/no
|
|
|
|
DInvoiceVatIsRevCharge
|
Reverse Charge
|
Rev Charge
|
yes/no
|
|
|
|
DInvoiceVatIsSuspDel
|
Suspended Tax
|
Susp Tax
|
yes/no
|
|
|
|
DInvoiceVatIsTaxable
|
Taxable
|
|
yes/no
|
|
|
|
DInvoiceVatIsUpdAllow
|
Upd Allow
|
|
yes/no
|
|
|
|
DInvoiceVatNTBaseCreditTC
|
Non-taxable Credit (TC)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatNTBaseDebitTC
|
Non-taxable Debit (TC)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatSequence
|
Sequence
|
|
9999999999
|
|
|
|
DInvoiceVatSuspDelTaxAmtTC
|
Tax Amount on Suspended Account (TC)
|
Tax Amount on Susp Acct (TC)
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatTaxTrType
|
Tax Transaction Type
|
Tax Tr Type
|
x(2)
|
|
|
|
DInvoiceVatUILinkedRowID
|
Linked Row
|
|
x(30)
|
|
|
|
DInvoiceVatVatBaseCreditCC
|
SC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseCreditLC
|
BC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseCreditTC
|
TC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitCC
|
SC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitLC
|
BC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitTC
|
TC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditCC
|
SC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditLC
|
BC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditTC
|
TC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitCC
|
SC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitLC
|
BC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitTC
|
TC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>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)
|
|
|
|
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
|
Suspended Tax Sub-Account
|
Susp Tax Sub-Acct
|
9999999999
|
|
|
|
SuspDelTaxGL_ID
|
Suspended Tax Account
|
Susp Tax Acct
|
9999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxenvTaxEnv
|
Tax Environment
|
Tax Env
|
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
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
NormDivIdx
|
no
|
NormalTaxDivision_ID
|
yes
|
no
|
|
|
NormGLIdx
|
no
|
NormalTaxGL_ID
|
yes
|
no
|
|
|
PostingVatIdx
|
no
|
PostingVat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DInvoiceVat_ID
|
yes
|
no
|
|
|
SuspDelDivIdx
|
no
|
SuspDelTaxDivision_ID
|
yes
|
no
|
|
|
SuspDelGLIdx
|
no
|
SuspDelTaxGL_ID
|
yes
|
no
|
|
|
UniqueTax
|
yes
|
DInvoice_ID
|
yes
|
no
|
|
|
|
|
TxuTaxUsage
|
yes
|
no
|
|
|
|
|
TxclTaxCls
|
yes
|
no
|
|
|
|
|
TxenvTaxEnv
|
yes
|
no
|
|
|
|
|
Vat_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|