business logic query WHTPrim

Description

this query can be used by other components that have the ID of a Withholding tax record but that needs to know the logical identification of the withholding tax record or vice-versa

Parameters

iiCompanyId	integer	Company id
iiCInvoiceWHTId	integer	CInvoiceWHT_ID
iiBankStateAllocId	integer	BankStateAlloc_ID
iiCDocumentInvoiceXRefId	integer	CDocumentInvoiceXRef_ID
iiWHTId	integer	WHT_ID
icWHTChargeType	character	WHTChargeType - see preprocessors
iiOIAdjustLnID	integer	OI Adjust Line ID
iiCACInvoiceID	integer	Reference to the supplier-adjustment

query condition

each WHT where

WHT.CInvoiceWHT_ID = iiCInvoiceWHTId AND
WHT.BankStateAlloc_ID = iiBankStateAllocId AND
WHT.CDocumentInvoiceXref_ID = iiCDocumentInvoiceXRefId AND
WHT.Company_ID = iiCompanyId AND
WHT.WHT_ID = iiWHTId AND
WHT.WHTChargeType = icWHTChargeType AND
WHT.OIAdjustLn_ID = iiOIAdjustLnID AND
WHT.CACInvoice_ID = iiCACInvoiceID

query resultset tqWHTPrim

field name	data type	db field	description
tiBankStateAlloc_ID	integer	WHT.BankStateAlloc_ID	Link to BankStateAlloc
tiCACInvoice_ID	integer	WHT.CACInvoice_ID	Link to CA-CInvoice
tiCDocumentInvoiceXref_ID	integer	WHT.CDocumentInvoiceXref_ID	Link to CDocumentInvoiceXref
tiCInvoiceWHT_ID	integer	WHT.CInvoiceWHT_ID	Link to CInvoiceWHT
tiCompany_ID	integer	WHT.Company_ID	Link to Company
tiOIAdjustLn_ID	integer	WHT.OIAdjustLn_ID	Link to OIAdjustLn
tiWHT_ID	integer	WHT.WHT_ID	Record ID
tcWHTChargeType	character	WHT.WHTChargeType	Charge Type
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(WHT)

Internal usage

QadFinancials

method BWithholdingTax.CreateAndOrUpdateWHT