| field name | data type | description |
|---|---|---|
| CInvoiceVat_ID | integer | |
| CInvoice_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 | |
| CInvoiceVatVatBaseDebitLC | 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. |
| CInvoiceVatVatBaseCreditLC | 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. |
| CInvoiceVatVatBaseDebitTC | 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. |
| CInvoiceVatVatBaseCreditTC | 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. |
| CInvoiceVatVatBaseDebitCC | 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. |
| CInvoiceVatVatBaseCreditCC | 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. |
| CInvoiceVatVatDebitLC | 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. |
| CInvoiceVatVatCreditLC | 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. |
| CInvoiceVatVatDebitTC | 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. |
| CInvoiceVatVatCreditTC | 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. |
| CInvoiceVatVatDebitCC | 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. |
| CInvoiceVatVatCreditCC | 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. |
| CInvoiceVatIsTaxable | logical | Taxable. This field indicates if the invoice is taxable. This field defaults to true if the supplier is taxable. |
| CInvoiceVatNonRecTaxAmtTC | decimal(4) | Non-Rev Tax Amount. This field displays the percentage of tax that is not recoverable. Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe. |
| CInvoiceVatIsUpdAllow | 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. |
| CInvoiceVatIsAbsRet | logical | Retained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government. |
| CInvoiceVatIsAccrRcpUs | logical | CInvoiceVatIsAccrRcpUS Tax is accrued at receipt. This is a parameter of the tax rate code in GTM. |
| CInvoiceVatTaxTrType | character | CInvoiceVatTaxTrType Tax transaction type. This is a parameter of the tax rate code in GTM. |
| CInvoiceVatIsRevCharge | logical | CInvoiceIsRevCharge.This field indicates if the invoice tax is of type Reverse Charge. |
| CInvoiceVatUILinkedRowID | character | |
| CInvoiceVatSequence | integer | CInvoceVatSequence.The sequentiel number of the tax line on the invoice. |
| CInvoiceVatNTBaseDebitTC | 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. |
| CInvoiceVatNTBaseCreditTC | 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. |
| CInvoiceVatIsSuspDel | logical | CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM. |
| CInvoiceVatSuspDelTaxAmtTC | 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. These fields default from the supplier, and can be modified. |
| TxenvTaxEnv | character | Tax Environment. This field is automatically calculated based on the supplier and ship-to address details, and can be modified. |
| TxclTaxCls | character | Tax Class. This field default from the supplier, and can be modified. |
| TxtyTaxType | character | Tax Type. This field displays the tax type, which defaults from the tax environment. |
| tdCInvoiceVatVatBaseDebitVC | decimal(4) | Obsolete field. |
| tdCInvoiceVatVatBaseCreditVC | decimal(4) | Obsolete field. |
| tdCInvoiceVatVatDebitVC | decimal(4) | Obsolete field. |
| tdCInvoiceVatVatCreditVC | decimal(4) | Obsolete field. |
| 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 | tcVatInOut Indication if the tax in Input (tax on purchases) or Output (tax on sales). |
| tcVatCode | character | Tax Code. This field displays the code of the tax rate, based on the tax environment for the combination of supplier 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 supplier 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. |
| tlTx2InvDisc | logical | Discount invoice at Invoice? |
| tdCInvoiceVatExchangeRateCC | decimal(10) | SC Exchange Rate |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| 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