project QadFinancials > class BWithholdingTax > dataset BWithholdingTax

class dataset

object identification

primary key
WHT_ID
object identity
WHT_ID

table tWHT

Description

Withholding Tax

field namedata typemnd.description
WHT_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
CInvoiceWHT_IDintegeryesLink to CInvoiceWHT
BankStateAlloc_IDintegernoLink to BankStateAlloc
CDocumentInvoiceXref_IDintegernoLink to CDocumentInvoiceXref
OIAdjustLn_IDintegernoLink to OIAdjustLn
CACInvoice_IDintegernoLink to CA-CInvoice
Currency_IDintegeryesLink to Currency
WHTCertFormat_IDintegernoLink to WHTCertFormat
Vat_IDintegernoLink to Vat
CInvoice_IDintegeryesLink to CInvoice
GL_IDintegeryesLink to GL
Division_IDintegernoLink to Division
Project_IDintegernoLink to Project
CostCentre_IDintegernoLink to CostCentre
Creditor_IDintegeryesLink to Creditor
WHTNumberintegernoWHT Number
WHTAdditionalNumberintegernoAdditional WHT Additional WHT Number
WHTChargeTypecharacter(20)noCharge Type
value list:{&WHTCHARGETYPES}
WHTCInvoiceReferencecharacter(50)noInvoice Reference
WHTPaymentReferencecharacter(40)noPayment Reference
WHTStatuscharacter(20)noWHT Status
value list:{&WHTSTATUSES}
WHTPercentagedecimal(2)noWHT Tax Rate Perc
WHTCInvoicePostingDatedatenoInvoice Posting Date
WHTPaymentDatedatenoPayment Date
WHTSettlementDatedatenoSettlement Date
WHTIsPrintedlogicalyesPrinted
WHTChargeAmtDebitTCdecimal(4)noCharge Amount Dr TC
WHTChargeAmtCreditTCdecimal(4)noCharge Amount Cr TC
WHTChargeAmtCreditLCdecimal(4)noCharge Amount Cr BC
WHTChargeAmtDebitLCdecimal(4)noCharge Amount Dr LC
WHTChargeAmtCreditCCdecimal(4)noCharge Amount Cr SC
WHTChargeAmtDebitCCdecimal(4)noCharge Amount Dr SC
WHTRetainedAmtDebitTCdecimal(4)noRetained Amount Dr TC
WHTRetainedAmtCreditTCdecimal(4)noRetained Amount Cr TC
WHTRetainedAmtDebitLCdecimal(4)noRetained Amount Dr LC
WHTRetainedAmtCreditLCdecimal(4)noRetained Amount Cr BC
WHTRetainedAmtDebitCCdecimal(4)noRetained Amount Dr SC
WHTRetainedAmtCreditCCdecimal(4)noRetained Amount Cr SC
WHTTaxableFeesDebitTCdecimal(4)noTaxable Fee Amount Dr TC
WHTTaxableFeesCreditTCdecimal(4)noTaxable Fee Amount Cr TC
WHTTaxableFeesDebitLCdecimal(4)noTaxable Fee Amount Dr LC
WHTTaxableFeesCreditLCdecimal(4)noTaxable Fee Amount Cr BC
WHTTaxableFeesDebitCCdecimal(4)noTaxable Fee Amount Dr SC
WHTTaxableFeesCreditCCdecimal(4)noTaxable Fee Amount Cr SC
WHTAmtDebitTCdecimal(4)noWHT Amount Dr TC
WHTAmtCreditTCdecimal(4)noWHT Amount Cr TC
WHTAmtDebitLCdecimal(4)noWHT Amount Dr LC
WHTAmtCreditLCdecimal(4)noWHT Amount Cr BC
WHTAmtDebitCCdecimal(4)noWHT Amount Dr SC
WHTAmtCreditCCdecimal(4)noWHT Amount Cr SC
WHTVATAmtDebitTCdecimal(4)noTax Amount Dr TC
WHTVATAmtCreditTCdecimal(4)noTax Amount Cr TC
WHTVATAmtDebitLCdecimal(4)noTax Amount Dr LC
WHTVATAmtCreditLCdecimal(4)noTax Amount Cr BC
WHTVATAmtDebitCCdecimal(4)noTax Amount Dr SC
WHTVATAmtCreditCCdecimal(4)noTax Amount Cr SC
WHTPaidAmtDebitTCdecimal(4)noPaid Amount Dr TC
WHTPaidAmtCreditTCdecimal(4)noPaid Amount Cr TC
WHTPaidAmtDebitLCdecimal(4)noPaid Amount Dr LC
WHTPaidAmtCreditLCdecimal(4)noPaid Amount Cr BC
WHTPaidAmtDebitCCdecimal(4)noPaid Amount Dr SC
WHTPaidAmtCreditCCdecimal(4)noPaid Amount Cr SC
WHTTotAmtDebitTCdecimal(4)noTotal Amount Dr TC
WHTTotAmtCreditTCdecimal(4)noTotal Amount Cr TC
WHTTotAmtDebitLCdecimal(4)noTotal Amount Dr LC
WHTTotAmtCreditLCdecimal(4)noTotal Amount Cr BC
WHTTotAmtDebitCCdecimal(4)noTotal Amount Dr SC
WHTTotAmtCreditCCdecimal(4)noTotal Amount Cr SC
WHTCompanyCodecharacter(20)noEntity Code
WHTCreditorCodecharacter(8)noSupplier Code
WHTCreditorSharedSetCodecharacter(20)noSupplier Shared Set Code
WHTCompanyLCCurrencyCodecharacter(3)noBase Currency
WHTPeriodYearintegernoGL Calendar Year
WHTPeriodPeriodintegernoGL Period
WHTTaxTypecharacter(16)noTax Type
tcWHTCertFormatCodecharacter(20)no
tcGLCodecharacter(8)yes
tcCreditorCodecharacter(8)yes
tcDivisionCodecharacter(8)no
tcCostCentreCodecharacter(4)no
tcProjectCodecharacter(8)no
tcCurrencyCodecharacteryes
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter