business logic query GetAllWHTByInvoiceID

Parameters

iiCompanyId	integer	Company id
iiInvoiceID	integer
iiVatID	integer

query condition

each CInvoice where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoiceIsWHT = yes AND
CInvoice.CInvoice_ID = iiInvoiceID

each CDocumentInvoiceXref (inner-join) where

CDocumentInvoiceXref.CInvoice_ID = CInvoice.CInvoice_ID AND

each WHT (inner-join) where

WHT.Company_Id = iiCompanyId AND
WHT.CDocumentInvoiceXref_ID = CDocumentInvoiceXref.CDocumentInvoiceXref_ID AND
(WHT.WHTStatus = 'WHTINITIAL' OR
WHT.WHTStatus = 'WHTDUE' ) AND
WHT.Vat_ID = iiVatID

first CInvoiceWHT (inner-join) where

CInvoiceWHT.CInvoiceWHT_ID = WHT.CInvoiceWHT_ID AND

first Vat (inner-join) where

(vat.vat_id = wht.vat_id OR
0 = wht.vat_id )

first tx2_mstr (inner-join) where

tx2_mstr.tx2_tax_code = Vat.VatCode AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = CInvoice.Journal_ID AND

query resultset tqGetAllWHTByInvoiceID

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tdCInvoiceOriginalCreditTC	decimal	CInvoice.CInvoiceOriginalCreditTC	TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
tdCInvoiceOriginalDebitTC	decimal	CInvoice.CInvoiceOriginalDebitTC	TC AP Amount. This field displays the debit total invoice amount in the transaction currency. If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
tiCInvoicePostingYear	integer	CInvoice.CInvoicePostingYear	Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly.
	api annotation:		This field defaults to the accounting year associated with the posting date.
tdCInvoiceVatBaseCreditTC	decimal	CInvoice.CInvoiceVatBaseCreditTC	TC Base Amount CR. This field displays the credit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatBaseDebitTC	decimal	CInvoice.CInvoiceVatBaseDebitTC	TC Base Amount DR. This field displays the debit base amount in the transaction currency. This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatCreditTC	decimal	CInvoice.CInvoiceVatCreditTC	TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdCInvoiceVatDebitTC	decimal	CInvoice.CInvoiceVatDebitTC	TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tiCInvoiceVoucher	integer	CInvoice.CInvoiceVoucher	Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tdCInvoiceWHTAmtCreditTC	decimal	CInvoiceWHT.CInvoiceWHTAmtCreditTC	TC WHT Amount (CR)
tdCInvoiceWHTAmtDebitTC	decimal	CInvoiceWHT.CInvoiceWHTAmtDebitTC	TC WHT Amount (DR)
tdCInvoiceWHTBaseAmtCreditTC	decimal	CInvoice.CInvoiceWHTBaseAmtCreditTC	TC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtDebitTC	decimal	CInvoice.CInvoiceWHTBaseAmtDebitTC	TC WHT Base Amount (DR)
tdCInvoiceWHTExpenseCreditTC	decimal	CInvoiceWHT.CInvoiceWHTExpenseCreditTC	TC Expense (CR)
tdCInvoiceWHTExpenseDebitTC	decimal	CInvoiceWHT.CInvoiceWHTExpenseDebitTC	TC Expense (DR)
tdCInvoiceWHTFeeCreditTC	decimal	CInvoiceWHT.CInvoiceWHTFeeCreditTC	TC Fee (CR)
tdCInvoiceWHTFeeDebitTC	decimal	CInvoiceWHT.CInvoiceWHTFeeDebitTC	TC Fee (DR)
tdCInvoiceWHTTaxFeeCreditTC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeCreditTC	TC Taxable Fee (CR)
tdCInvoiceWHTTaxFeeDebitTC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeDebitTC	TC Taxable Fee (DR)
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tdtx2_pct_recv	decimal	tx2_mstr.tx2_pct_recv	Percent Recoverable
tdtx2_tax_pct	decimal	tx2_mstr.tx2_tax_pct	Tax Rate
tiVat_ID	integer	Vat.Vat_ID	Record ID
tcVatCode	character	Vat.VatCode	Tax Code
tcVatDescription	character	Vat.VatDescription	Description
tdWHTAmtCreditTC	decimal	WHT.WHTAmtCreditTC	WHT Amount Cr TC
tdWHTAmtDebitTC	decimal	WHT.WHTAmtDebitTC	WHT Amount Dr TC
tdWHTChargeAmtCreditTC	decimal	WHT.WHTChargeAmtCreditTC	Charge Amount Cr TC
tdWHTChargeAmtDebitTC	decimal	WHT.WHTChargeAmtDebitTC	Charge Amount Dr TC
tcWHTChargeType	character	WHT.WHTChargeType	Charge Type
tdWHTPaidAmtCreditTC	decimal	WHT.WHTPaidAmtCreditTC	Paid Amount Cr TC
tdWHTPaidAmtDebitTC	decimal	WHT.WHTPaidAmtDebitTC	Paid Amount Dr TC
tdWHTRetainedAmtCreditTC	decimal	WHT.WHTRetainedAmtCreditTC	Retained Amount Cr TC
tdWHTRetainedAmtDebitTC	decimal	WHT.WHTRetainedAmtDebitTC	Retained Amount Dr TC
tdWHTTaxableFeesCreditTC	decimal	WHT.WHTTaxableFeesCreditTC	Taxable Fee Amount Cr TC
tdWHTTaxableFeesDebitTC	decimal	WHT.WHTTaxableFeesDebitTC	Taxable Fee Amount Dr TC
tdWHTTotAmtCreditTC	decimal	WHT.WHTTotAmtCreditTC	Total Amount Cr TC
tdWHTTotAmtDebitTC	decimal	WHT.WHTTotAmtDebitTC	Total Amount Dr TC
tdWHTVATAmtCreditTC	decimal	WHT.WHTVATAmtCreditTC	Tax Amount Cr TC
tdWHTVATAmtDebitTC	decimal	WHT.WHTVATAmtDebitTC	Tax Amount Dr TC

Internal usage

QadFinancials

method BCreditorReport.CreditorWithholdingTax