| field name | data type | mnd. | description |
|---|
| WHT_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| CInvoiceWHT_ID | integer | yes | Link to CInvoiceWHT |
| BankStateAlloc_ID | integer | no | Link to BankStateAlloc |
| CDocumentInvoiceXref_ID | integer | no | Link to CDocumentInvoiceXref |
| OIAdjustLn_ID | integer | no | Link to OIAdjustLn |
| CACInvoice_ID | integer | no | Link to CA-CInvoice |
| Currency_ID | integer | yes | Link to Currency |
| WHTCertFormat_ID | integer | no | Link to WHTCertFormat |
| Vat_ID | integer | no | Link to Vat |
| CInvoice_ID | integer | yes | Link to CInvoice |
| GL_ID | integer | yes | Link to GL |
| Division_ID | integer | no | Link to Division |
| Project_ID | integer | no | Link to Project |
| CostCentre_ID | integer | no | Link to CostCentre |
| Creditor_ID | integer | yes | Link to Creditor |
| WHTNumber | integer | no | WHT Number |
| WHTAdditionalNumber | integer | no | Additional WHT Additional WHT Number |
| WHTChargeType | character(20) | no | Charge Type |
| value list: | | {&WHTCHARGETYPES} |
| WHTCInvoiceReference | character(50) | no | Invoice Reference |
| WHTPaymentReference | character(40) | no | Payment Reference |
| WHTStatus | character(20) | no | WHT Status |
| value list: | | {&WHTSTATUSES} |
| WHTPercentage | decimal(2) | no | WHT Tax Rate Perc |
| WHTCInvoicePostingDate | date | no | Invoice Posting Date |
| WHTPaymentDate | date | no | Payment Date |
| WHTSettlementDate | date | no | Settlement Date |
| WHTIsPrinted | logical | yes | Printed |
| WHTChargeAmtDebitTC | decimal(4) | no | Charge Amount Dr TC |
| WHTChargeAmtCreditTC | decimal(4) | no | Charge Amount Cr TC |
| WHTChargeAmtCreditLC | decimal(4) | no | Charge Amount Cr BC |
| WHTChargeAmtDebitLC | decimal(4) | no | Charge Amount Dr LC |
| WHTChargeAmtCreditCC | decimal(4) | no | Charge Amount Cr SC |
| WHTChargeAmtDebitCC | decimal(4) | no | Charge Amount Dr SC |
| WHTRetainedAmtDebitTC | decimal(4) | no | Retained Amount Dr TC |
| WHTRetainedAmtCreditTC | decimal(4) | no | Retained Amount Cr TC |
| WHTRetainedAmtDebitLC | decimal(4) | no | Retained Amount Dr LC |
| WHTRetainedAmtCreditLC | decimal(4) | no | Retained Amount Cr BC |
| WHTRetainedAmtDebitCC | decimal(4) | no | Retained Amount Dr SC |
| WHTRetainedAmtCreditCC | decimal(4) | no | Retained Amount Cr SC |
| WHTTaxableFeesDebitTC | decimal(4) | no | Taxable Fee Amount Dr TC |
| WHTTaxableFeesCreditTC | decimal(4) | no | Taxable Fee Amount Cr TC |
| WHTTaxableFeesDebitLC | decimal(4) | no | Taxable Fee Amount Dr LC |
| WHTTaxableFeesCreditLC | decimal(4) | no | Taxable Fee Amount Cr BC |
| WHTTaxableFeesDebitCC | decimal(4) | no | Taxable Fee Amount Dr SC |
| WHTTaxableFeesCreditCC | decimal(4) | no | Taxable Fee Amount Cr SC |
| WHTAmtDebitTC | decimal(4) | no | WHT Amount Dr TC |
| WHTAmtCreditTC | decimal(4) | no | WHT Amount Cr TC |
| WHTAmtDebitLC | decimal(4) | no | WHT Amount Dr LC |
| WHTAmtCreditLC | decimal(4) | no | WHT Amount Cr BC |
| WHTAmtDebitCC | decimal(4) | no | WHT Amount Dr SC |
| WHTAmtCreditCC | decimal(4) | no | WHT Amount Cr SC |
| WHTVATAmtDebitTC | decimal(4) | no | Tax Amount Dr TC |
| WHTVATAmtCreditTC | decimal(4) | no | Tax Amount Cr TC |
| WHTVATAmtDebitLC | decimal(4) | no | Tax Amount Dr LC |
| WHTVATAmtCreditLC | decimal(4) | no | Tax Amount Cr BC |
| WHTVATAmtDebitCC | decimal(4) | no | Tax Amount Dr SC |
| WHTVATAmtCreditCC | decimal(4) | no | Tax Amount Cr SC |
| WHTPaidAmtDebitTC | decimal(4) | no | Paid Amount Dr TC |
| WHTPaidAmtCreditTC | decimal(4) | no | Paid Amount Cr TC |
| WHTPaidAmtDebitLC | decimal(4) | no | Paid Amount Dr LC |
| WHTPaidAmtCreditLC | decimal(4) | no | Paid Amount Cr BC |
| WHTPaidAmtDebitCC | decimal(4) | no | Paid Amount Dr SC |
| WHTPaidAmtCreditCC | decimal(4) | no | Paid Amount Cr SC |
| WHTTotAmtDebitTC | decimal(4) | no | Total Amount Dr TC |
| WHTTotAmtCreditTC | decimal(4) | no | Total Amount Cr TC |
| WHTTotAmtDebitLC | decimal(4) | no | Total Amount Dr LC |
| WHTTotAmtCreditLC | decimal(4) | no | Total Amount Cr BC |
| WHTTotAmtDebitCC | decimal(4) | no | Total Amount Dr SC |
| WHTTotAmtCreditCC | decimal(4) | no | Total Amount Cr SC |
| WHTCompanyCode | character(20) | no | Entity Code |
| WHTCreditorCode | character(8) | no | Supplier Code |
| WHTCreditorSharedSetCode | character(20) | no | Supplier Shared Set Code |
| WHTCompanyLCCurrencyCode | character(3) | no | Base Currency |
| WHTPeriodYear | integer | no | GL Calendar Year |
| WHTPeriodPeriod | integer | no | GL Period |
| WHTTaxType | character(16) | no | Tax Type |
| tcWHTCertFormatCode | character(20) | no | |
| tcGLCode | character(8) | yes | |
| tcCreditorCode | character(8) | yes | |
| tcDivisionCode | character(8) | no | |
| tcCostCentreCode | character(4) | no | |
| tcProjectCode | character(8) | no | |
| tcCurrencyCode | character | yes | |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |