WHT


Field Name	Label	Col-Label	Format	Dec
BankStateAlloc_ID	Link to BankStateAlloc		9999999999
CACInvoice_ID	Link to CA-CInvoice		9999999999
CDocumentInvoiceXref_ID	Link to CDocumentInvoiceXref		9999999999
CInvoice_ID	Link to CInvoice		9999999999
CInvoiceWHT_ID	Link to CInvoiceWHT		9999999999
Company_ID	Link to Company		9999999999
CostCentre_ID	Link to CostCentre		9999999999
Creditor_ID	Link to Creditor		9999999999
Currency_ID	Link to Currency		9999999999
CustomCombo0	Custom Combo Field		x(20)
CustomCombo1	Custom Combo Field		x(20)
CustomCombo2	Custom Combo Field		x(20)
CustomCombo3	Custom Combo Field		x(20)
CustomCombo4	Custom Combo Field		x(20)
CustomCombo5	Custom Combo Field		x(20)
CustomCombo6	Custom Combo Field		x(20)
CustomCombo7	Custom Combo Field		x(20)
CustomCombo8	Custom Combo Field		x(20)
CustomCombo9	Custom Combo Field		x(20)
CustomDate0	Custom Date Field		99/99/9999
CustomDate1	Custom Date Field		99/99/9999
CustomDate2	Custom Date Field		99/99/9999
CustomDate3	Custom Date Field		99/99/9999
CustomDate4	Custom Date Field		99/99/9999
CustomDecimal0	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal1	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal2	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal3	Custom Decimal Field		->,>>>,>>9.99	4
CustomDecimal4	Custom Decimal Field		->,>>>,>>9.99	4
CustomInteger0	Custom Integer Field		->,>>>,>>9
CustomInteger1	Custom Integer Field		->,>>>,>>9
CustomInteger2	Custom Integer Field		->,>>>,>>9
CustomInteger3	Custom Integer Field		->,>>>,>>9
CustomInteger4	Custom Integer Field		->,>>>,>>9
CustomLong0	Custom Long Field		x(255)
CustomLong1	Custom Long Field		x(255)
CustomNote	Custom Note Field		x(2000)
CustomShort0	Custom Short Field		x(20)
CustomShort1	Custom Short Field		x(20)
CustomShort2	Custom Short Field		x(20)
CustomShort3	Custom Short Field		x(20)
CustomShort4	Custom Short Field		x(20)
CustomShort5	Custom Short Field		x(20)
CustomShort6	Custom Short Field		x(20)
CustomShort7	Custom Short Field		x(20)
CustomShort8	Custom Short Field		x(20)
CustomShort9	Custom Short Field		x(20)
Division_ID	Link to Division		9999999999
GL_ID	Link to GL		9999999999
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
OIAdjustLn_ID	Link to OIAdjustLn		9999999999
Project_ID	Link to Project		9999999999
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
Vat_ID	Link to Vat		9999999999
WHT_ID	Record ID		9999999999
WHTAdditionalNumber	Additional WHT		999999999
WHTAmtCreditCC	WHT Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTAmtCreditLC	WHT Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTAmtCreditTC	WHT Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTAmtDebitCC	WHT Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTAmtDebitLC	WHT Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTAmtDebitTC	WHT Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTCertFormat_ID	Link to WHTCertFormat		9999999999
WHTChargeAmtCreditCC	Charge Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTChargeAmtCreditLC	Charge Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTChargeAmtCreditTC	Charge Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTChargeAmtDebitCC	Charge Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTChargeAmtDebitLC	Charge Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTChargeAmtDebitTC	Charge Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTChargeType	Charge Type		x(20)
WHTCInvoicePostingDate	Invoice Posting Date		99/99/9999
WHTCInvoiceReference	Invoice Reference		x(50)
WHTCompanyCode	Entity Code		x(20)
WHTCompanyLCCurrencyCode	Base Currency		x(3)
WHTCreditorCode	Supplier Code		x(8)
WHTCreditorSharedSetCode	Supplier Shared Set Code		x(20)
WHTIsPrinted	Printed		yes/no
WHTNumber	WHT Number		999999999
WHTPaidAmtCreditCC	Paid Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTPaidAmtCreditLC	Paid Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTPaidAmtCreditTC	Paid Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTPaidAmtDebitCC	Paid Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTPaidAmtDebitLC	Paid Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTPaidAmtDebitTC	Paid Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTPaymentDate	Payment Date		99/99/9999
WHTPaymentReference	Payment Reference		x(40)
WHTPercentage	WHT Tax Rate Perc		->>9.99	2
WHTPeriodPeriod	GL Period	GL Pd	99
WHTPeriodYear	GL Calendar Year	GL Cal Year	9999
WHTRetainedAmtCreditCC	Retained Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTRetainedAmtCreditLC	Retained Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTRetainedAmtCreditTC	Retained Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTRetainedAmtDebitCC	Retained Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTRetainedAmtDebitLC	Retained Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTRetainedAmtDebitTC	Retained Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTSettlementDate	Settlement Date		99/99/9999
WHTStatus	WHT Status		x(20)
WHTTaxableFeesCreditCC	Taxable Fee Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTTaxableFeesCreditLC	Taxable Fee Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTTaxableFeesCreditTC	Taxable Fee Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTTaxableFeesDebitCC	Taxable Fee Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTTaxableFeesDebitLC	Taxable Fee Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTTaxableFeesDebitTC	Taxable Fee Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTTaxType	Tax Type		x(16)
WHTTotAmtCreditCC	Total Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTTotAmtCreditLC	Total Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTTotAmtCreditTC	Total Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTTotAmtDebitCC	Total Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTTotAmtDebitLC	Total Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTTotAmtDebitTC	Total Amount Dr TC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtCreditCC	Tax Amount Cr SC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtCreditLC	Tax Amount Cr BC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtCreditTC	Tax Amount Cr TC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtDebitCC	Tax Amount Dr SC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtDebitLC	Tax Amount Dr LC		->>>,>>>,>>>,>>9.99	4
WHTVATAmtDebitTC	Tax Amount Dr TC		->>>,>>>,>>>,>>9.99	4


	Index-Name	Uni	Field-Name	Asc	Abbr
	BankStateAlloc	no	BankStateAlloc_ID	yes	no
	CACInvoice	no	CACInvoice_ID	yes	no
	CDoxInvXRef	no	CDocumentInvoiceXref_ID	yes	no
	CInvoice	no	CInvoice_ID	yes	no
	CInvoiceWHT	no	CInvoiceWHT_ID	yes	no
	Company	no	Company_ID	yes	no
	CostCentre	no	CostCentre_ID	yes	no
	Creditor	no	Creditor_ID	yes	no
	CreditorIdx	no	WHTCreditorCode	yes	no
	Currency	no	Currency_ID	yes	no
	CyIdx	no	WHTCompanyCode	yes	no
	Division	no	Division_ID	yes	no
	GL	no	GL_ID	yes	no
	OIAdj	no	OIAdjustLn_ID	yes	no
	PaymentDate	no	Company_ID	yes	no
			WHTPaymentDate	yes	no
	PeriodIdx	no	WHTPeriodYear	yes	no
			WHTPeriodPeriod	yes	no
	PostingDate	no	Company_ID	yes	no
			WHTCInvoicePostingDate	yes	no
∗	Prim	yes	WHT_ID	yes	no
	PrjIdx	no	Project_ID	yes	no
	SSCurrIdx	no	WHTCreditorSharedSetCode	yes	no
			WHTCompanyLCCurrencyCode	yes	no
	TaxTypeIdx	no	WHTTaxType	yes	no
	UniqueIdx	yes	Company_ID	yes	no
			CInvoiceWHT_ID	yes	no
			BankStateAlloc_ID	yes	no
			CDocumentInvoiceXref_ID	yes	no
			OIAdjustLn_ID	yes	no
			CACInvoice_ID	yes	no
			WHTChargeType	yes	no
	Vat	no	Vat_ID	yes	no
	WHTCertFormat	no	WHTCertFormat_ID	yes	no
	WHTNumber	no	WHTNumber	yes	no