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 |