dataset tInvoiceWHTPayment

table tInvoiceWHTPayment

Description

tInvoiceWHTPayment: temp-table used as interface for methods to create or update WHT-record.
Fields:
tiCInvoiceID: Mandatory identifier of the invoice
tdAllocatedAmountTC: Allocated amount of the payment for this invoice - Mandatory
tdDiscountAmountTC: Discount amount of the payment for this invoice
tdWHTTaxableFeeTC: Taxable fee of the payment for this invoice (only for WHT of type 'Fee')
tdWHTAmtTC: wht amount of the payment for this invoice
tlCreateWHT: True in case we need to create a WHT-record, false in case we need to update an existing WHT-record
tiWHTNumber: wht number, mandatory
tcPaymentReference: payment reference, mandatory
tcCurrencyCode: currency code of the payment, mandatory
tiCDocumentInvoiceXref_ID: unique identifier of the payment record - either this, tiOIAdjustLnID or tiBankStateAlloc_ID must be filled
tiBankStateAlloc_ID : unique identifier of the bank state alloc record - either this, tiOIAdjustLnID or tiCDocumentInvoiceXref_ID must be filled
tiOIAdjustLnID : unique identifier of open item adjustment - either this, tiCDocumentInvoiceXrefID or tiBankStateAllocID must be filled.
ttPostingDate: posting date of the payment - mandatory
tiPaymentAccountingYear: Accounting year that embraces the posting date of the payment - optional
tiPaymentAccountingPeriod: Accounting period that embraces the posting date of the payment - optional
ttSettlementDate: SettlementDate - optional
tcWHTStatus: Status the WHT record should get - mandatory
tlUpdateAllAmounts: Only applicable in case tlCreateWHT is false. When this is true then all amount will be recalculated. Normally this field will only be true in case the AllocatedAmt, DiscountAmt or the PaymentStatus are changed
tdPaymentAccRateTCLC: Accounting tax rate TC-LC on PaymentDate - mandatory
tdPaymentAccScaleTCLC: Accounting tax scale factor TC-LC on PaymentDate - mandatory
tdPaymentAccRateTCCC: Accounting tax rate TC-CC on PaymentDate - mandatory
tdPaymentAccScaleTCCC: Accounting tax scale factor TC-CC on PaymentDate - mandatory
tdPaymentWHTRateTCLC: withholding tax rate TC-LC on PaymentDate - mandatory
tdPaymentWHTScaleTCLC: withholding tax scale factor TC-LC on PaymentDate - mandatory
tdPaymentWHTRateTCCC: withholding tax rate TC-CC on PaymentDate - mandatory
tdPaymentWHTScaleTCCC: withholding tax scale factor TC-CC on PaymentDate - mandatory

field name	data type	description
tiCInvoiceID	integer
tdAllocatedAmountTC	decimal
tdDiscountAmountTC	decimal
tdWHTTaxableFeeTC	decimal
tdWHTAmountTC	decimal
tlCreateWHT	logical
tiWHTNumber	integer
tcPaymentReference	character
tcCurrencyCode	character
tiCDocumentInvoiceXrefID	integer
tiBankStateAllocID	integer
tiOIAjustLnID	integer
tiCACInvoiceID	integer
ttPostingDate	date
tiPaymentAccountingYear	integer
tiPaymentAccountingPeriod	integer
ttSettlementDate	date
tcWHTStatus	character
tlUpdateAllAmounts	logical
tdPaymentAccRateTCLC	decimal
tdPaymentAccScaleTCLC	decimal
tdPaymentAccRateTCCC	decimal
tdPaymentAccScaleTCCC	decimal
tdPaymentWHTRateTCLC	decimal
tdPaymentWHTScaleTCLC	decimal
tdPaymentWHTRateTCCC	decimal
tdPaymentWHTScaleTCCC	decimal

Internal usage

QadFinancials

method BWithholdingTax.CreateAndOrUpdateWHT