project QadFinancials > class BCInvoiceJournalEntry > dataset tApiCInvoiceWHTCIJE

table tApiCInvoiceWHTCIJE

Description

Table contains withholding tax records.

field namedata typedescription
CInvoiceWHT_IDinteger
CInvoice_IDinteger
Vat_IDinteger
GL_IDinteger
Division_IDinteger
CInvoiceVat_IDinteger
CInvoiceWHTFeeDebitTCdecimal(4)
CInvoiceWHTFeeCreditTCdecimal(4)
CInvoiceWHTExpenseDebitTCdecimal(4)
CInvoiceWHTExpenseCreditTCdecimal(4)
CInvoiceWHTTaxFeeDebitTCdecimal(4)
CInvoiceWHTTaxFeeCreditTCdecimal(4)
CInvoiceWHTTaxFeeDebitCCdecimal(4)
CInvoiceWHTTaxFeeCreditCCdecimal(4)
CInvoiceWHTTaxFeeDebitLCdecimal(4)
CInvoiceWHTTaxFeeCreditLCdecimal(4)
CInvoiceWHTAmtDebitTCdecimal(4)
CInvoiceWHTAmtCreditTCdecimal(4)
CInvoiceWHTAmtDebitCCdecimal(4)
CInvoiceWHTAmtCreditCCdecimal(4)
CInvoiceWHTAmtDebitLCdecimal(4)
CInvoiceWHTAmtCreditLCdecimal(4)
CInvoiceWHTTaxPctdecimal(2)
CInvoiceWHTRecovTaxPctdecimal(2)
CInvoiceWHTTaxTypecharacter
CInvoiceWHTTaxTrTypecharacter
CInvoiceWHTIsUpdAllowlogical
CInvoiceWHTIsOrigFromAPMlogical
CInvoiceWHTBaseTaxPctdecimal(2)
tcVatCodecharacter
tcDomainCodecharacter
tcVatInOutcharacter
tcVatDescriptioncharacter
tctx2DesccharacterTax Rate Description
tdtx2TaxPctdecimal(2)
tdtx2PctRecvdecimal(2)Tax Percentage Recoverable
tctx2TaxTypecharacterTax Type
tcGLCodecharacter
tcDivisionCodecharacter
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BCInvoiceJournalEntry.ApiStdMaintainTTV01