| field name | data type | description |
|---|
| tiCInvoice_ID | integer | |
| tdCInvoiceCCRate | decimal(10) | |
| tdCInvoiceCCScale | decimal(10) | |
| tiCInvoiceCurrency_ID | integer | |
| tdCInvoiceExchangeRate | decimal(10) | |
| tlCInvoiceIsWHT | logical | |
| tdCInvoiceNonDiscAmtTC | decimal(4) | |
| tdCInvoiceOriginalCreditTC | decimal(4) | |
| tdCInvoiceOriginalDebitTC | decimal(4) | |
| ttCInvoicePostingDate | date | |
| tiCInvoicePostingYear | integer | |
| tdCInvoiceRateScale | decimal(10) | |
| tcCInvoiceReference | character | |
| tcCInvoiceType | character | |
| tdCInvoiceVatBaseCreditTC | decimal(4) | |
| tdCInvoiceVatBaseDebitTC | decimal(4) | |
| tdCInvoiceVatCreditTC | decimal(4) | |
| tdCInvoiceVatDebitTC | decimal(4) | |
| tiCInvoiceVoucher | integer | |
| tiCInvoiceWHT_ID | integer | |
| tdCInvoiceWHTAmtCreditTC | decimal(4) | |
| tdCInvoiceWHTAmtDebitTC | decimal(4) | |
| tdCInvoiceWHTBaseAmtCreditTC | decimal(4) | |
| tdCInvoiceWHTBaseAmtDebitTC | decimal(4) | |
| tdCInvoiceWHTExpenseCreditTC | decimal(4) | |
| tdCInvoiceWHTExpenseDebitTC | decimal(4) | |
| tdCInvoiceWHTFeeCreditTC | decimal(4) | |
| tdCInvoiceWHTFeeDebitTC | decimal(4) | |
| tdCInvoiceWHTTaxFeeCreditTC | decimal(4) | |
| tdCInvoiceWHTTaxFeeDebitTC | decimal(4) | |
| tdCInvoiceWHTTotAmtCreditTC | decimal(4) | |
| tdCInvoiceWHTTotAmtDebitTC | decimal(4) | |
| tiCompany_ID | integer | |
| tcCompanyCode | character | |
| tcCostCentreCode | character | |
| tiCreditor_ID | integer | |
| tcCreditorCode | character | |
| tiDivision_ID | integer | |
| tcDivisionCode | character | |
| tiGL_ID | integer | |
| tcGLCode | character | |
| tiJournal_ID | integer | |
| tcJournalCode | character | |
| tiLocalCurrencyCurrency_ID | integer | |
| tcLocalCurrencyCurrencyCode | character | |
| tcProjectCode | character | |
| tiSharedSet_ID | integer | |
| tcSharedSetCode | character | |
| tdtx2_tax_pct | decimal(10) | |
| tctx2_tax_type | character | |
| tltx2_update_tax | logical | |
| tiVat_ID | integer | |
| tcVatCode | character | |
| tiWHTCertFormat_ID | integer | |
| tcWHTCertFormatCode | character | |
QadFinancials