| field name | data type | description |
|---|---|---|
| DInvoiceVat_ID | integer | |
| DInvoice_ID | integer | |
| Vat_ID | integer | |
| NormalTaxGL_ID | integer | |
| NormalTaxDivision_ID | integer | |
| AbsRetTaxGL_ID | integer | |
| AbsRetTaxDivision_ID | integer | |
| SuspDelTaxGL_ID | integer | |
| SuspDelTaxDivision_ID | integer | |
| PostingVat_ID | integer | |
| DInvoiceVatVatBaseDebitLC | decimal(4) | BC Base Amount DR. This field displays the debit base amount in the base currency. This field is calculated by the system using the TC Base Amount DR and the Exchange rate. |
| DInvoiceVatVatBaseCreditLC | decimal(4) | BC Base Amount CR. This field displays the credit base amount in the base currency. This field is calculated by the system using the TC Base Amount CR and the Exchange rate. |
| DInvoiceVatVatBaseDebitTC | decimal(4) | TC Base Amount DR. This field displays the debit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatVatBaseCreditTC | decimal(4) | TC Base Amount CR. This field displays the credit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatVatBaseDebitCC | decimal(4) | SC Base Amount DR. This field displays the debit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount DR and the SC rate. |
| DInvoiceVatVatBaseCreditCC | decimal(4) | SC Base Amount CR. This field displays the credit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount CR and the SC rate. |
| DInvoiceVatVatDebitLC | decimal(4) | BC Tax Amount DR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount DR and the Exchange rate. |
| DInvoiceVatVatCreditLC | decimal(4) | BC Tax Amount CR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount CR and the Exchange rate. |
| DInvoiceVatVatDebitTC | decimal(4) | TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatVatCreditTC | decimal(4) | TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatVatDebitCC | decimal(4) | SC Tax Amount DR. This field displays the debit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount DR and the SC rate. |
| DInvoiceVatVatCreditCC | decimal(4) | SC Tax Amount CR. This field displays the credit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount CR and the SC rate. |
| DInvoiceVatIsTaxable | logical | Taxable. This field indicates if the invoice is taxable. |
| api annotation: | This field defaults to true if the customer is taxable. | |
| DInvoiceVatIsUpdAllow | logical | Update Tax Allowed. When this is field is true, you can modify the base and tax credit and debit amounts during transaction entry. This field is useful for overriding the system if there is a need to match amounts on manually issued documents. In some environments, tax authorities require that you cannot modify the calculated tax amounts. |
| DInvoiceVatIsAbsRet | logical | Retained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government. |
| DInvoiceVatIsAccrRcpUs | logical | Accrue at Receipt/Usage. Tax is accrued at receipt. This is a parameter of the tax rate code in GTM. |
| DInvoiceVatTaxTrType | character | Tax transaction type. This is a parameter of the tax rate code in GTM. |
| DInvoiceVatIsRevCharge | logical | Reverse Charge.This field indicates if the invoice tax is of type Reverse Charge. |
| DInvoiceVatUILinkedRowID | character | |
| DInvoiceVatSequence | integer | Sequence.The sequentiel number of the tax line on the invoice. |
| api annotation: | PartialUpdate = yes - defaults to 1 | |
| DInvoiceVatNTBaseDebitTC | decimal(4) | TC Base Debit Non-taxable. This field displays the Non-taxable debit base amount in the transaction currency. This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatNTBaseCreditTC | decimal(4) | TC Base Credit Non-taxable. This field displays the Non-taxable credit base amount in the transaction currency. This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code. |
| DInvoiceVatIsSuspDel | logical | CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM. |
| api annotation: | PartialUpdate = yes - defaults to false | |
| DInvoiceVatSuspDelTaxAmtTC | decimal(4) | Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency. |
| TxuTaxUsage | character | Tax Usage. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax usage being applied, if any. Select a different tax class if necessary. |
| api annotation: | This field defaults from the customer,and can be modified. | |
| TxenvTaxEnv | character | Tax Environment. This field is automatically calculated based on the customer and ship-to address details, and can be modified. |
| TxclTaxCls | character | Tax Class. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax class being applied, if any. |
| api annotation: | This field default from the customer, and can be modified. | |
| TxtyTaxType | character | Tax Type. This field displays the tax type, which defaults from the tax environment. |
| tdDInvoiceVatVatBaseDebitVC | decimal(4) | This field is obsoleted. |
| tdDInvoiceVatVatBaseCreditVC | decimal(4) | This field is obsoleted. |
| tdDInvoiceVatVatDebitVC | decimal(4) | This field is obsoleted. |
| tdDInvoiceVatVatCreditVC | decimal(4) | This field is obsoleted. |
| tlIsRecalculateTax | logical | Recalc. When you change the tax class, tax usage, tax environment, or the Taxable fields or modify one of the base amounts, this field is automatically set to true,and the system recalculates the amounts when you have completed the line in the grid. You can also manually set this field to true or false. |
| tcDomainCode | character | Domain. This field displays the doamin of the invoice (the current domain). |
| tcVatInOut | character | Tax In/Out. Indication if the tax in Input (tax on purchases) or Output (tax on sales). |
| api annotation: | PartialUpdate = yes - defaults to output | |
| tcVatCode | character | Tax Code. This field displays the code of the tax rate, based on the tax environment for the combination of customer and ship-to address. |
| tcNormalTaxGLCode | character | Normal Tax Account. This field indicates the Gl account for tax use. The Tax accounts are defined for the current domain in Domain/Account Control. |
| tcNormalTaxDivisionCode | character | Normal Tax Sub-Account. This field indicates the sub-account if the customer control account is defined with sub-account analysis. |
| tcAbsRetTaxGLCode | character | Retained Tax Account. This field indicates the GL account used to retain the tax. When you have selected the Retained/Absorbed options. This field is defined in Tax Rate Maintenance. |
| tcAbsRetTaxDivisionCode | character | Retained Tax Sub-Account.This field indicates the sub- Account used to retain the tax. When you have selected the Retained/Absorbed options. This field is defined in Tax Rate Maintenance. |
| tcSuspDelTaxGLCode | character | Delayed Tax Account. This field indicates the GL account used to handle the delayed tax. |
| tcSuspDelTaxDivisionCode | character | Delayed Tax Sub-Account. This field indicates the sub-account used to handle the delayed tax. |
| tlIsAvataxTaxLine | logical | Is the tax line a Avatax tax line i.e. using tax method 40 |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials