business logic query CInvoiceWHTForIDOnly

Description

CInvoiceWHTForIDOnly: very simple query that just list the CInvoiceWHT- records for a certain invoice - without much joins.
Please keep this query as simple as can be and create another new one rather than extending this one

Parameters

iiCInvoiceID	integer
iiCompanyId	integer	Company id

query condition

each CInvoiceWHT where

CInvoiceWHT.CInvoice_ID = iiCInvoiceID

first CInvoice (inner-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = CInvoiceWHT.CInvoice_ID AND

query resultset tqCInvoiceWHTForIDOnly

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoiceWHT.CInvoice_ID	Link to CInvoice
tiCInvoiceWHT_ID	integer	CInvoiceWHT.CInvoiceWHT_ID	Record ID
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)
tiCompany_ID	integer	CInvoice.Company_ID	Link to Company

Internal usage

QadFinancials

method BWithholdingTax.CreateAndOrUpdateWHT