business logic query CInvoiceForWHTDefaulting

Description

CInvoiceForWHTDefaulting: This query lists all CInvoice records and underlaying CInvoiceWHT and related Vat and tx2_mstr records based on creditor invoice id.

Result-set is indexed on CInvoice_ID

Note the result-set can hold mutliple entries for every VAT-record as each VAT-record can have multiple Tx2_mstr-records as the join is only on VatCode (and not on Domain as well)

Parameters

iiCompanyId	integer	Company id
iiCInvoiceID	integer	CInvoice ID
ilCInvoiceIsWHT	logical	Does the invoice holds WHT
icDomainCode	character	DomainCode: This is used to make sure we get the correct record from tx2_mstr joined from table Vat. Therefore we have a condition on tx2_mstr.tx2_domain

query condition

each CInvoice where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoiceID AND
CInvoice.CInvoiceIsWHT = ilCInvoiceIsWHT

each CInvoiceWHT (inner-join) where

CInvoiceWHT.CInvoice_ID = CInvoice.CInvoice_ID AND

first Vat (outer-join) where

Vat.Vat_ID = CInvoiceWHT.Vat_ID AND

first tx2_mstr (conditional-join) where

tx2_mstr.tx2_tax_code = Vat.VatCode AND
tx2_mstr.tx2_domain = icDomainCode

query resultset tqCInvoiceForWHTDefaulting

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tiCInvoiceCurrency_ID	integer	CInvoice.CInvoiceCurrency_ID	Currency Code
tlCInvoiceIsWHT	logical	CInvoice.CInvoiceIsWHT	Withholding Tax
tcCInvoiceType	character	CInvoice.CInvoiceType	Invoice Type. This field identifies the invoice type. The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.
tiCInvoiceWHT_ID	integer	CInvoiceWHT.CInvoiceWHT_ID	Record ID
tdCInvoiceWHTBaseAmtCreditTC	decimal	CInvoice.CInvoiceWHTBaseAmtCreditTC	TC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtDebitTC	decimal	CInvoice.CInvoiceWHTBaseAmtDebitTC	TC WHT Base Amount (DR)
tdCInvoiceWHTTotAmtCreditCC	decimal	CInvoice.CInvoiceWHTTotAmtCreditCC	SC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtCreditLC	decimal	CInvoice.CInvoiceWHTTotAmtCreditLC	BC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtCreditTC	decimal	CInvoice.CInvoiceWHTTotAmtCreditTC	TC WHT Total Amount (CR)
tdCInvoiceWHTTotAmtDebitCC	decimal	CInvoice.CInvoiceWHTTotAmtDebitCC	SC WHT Total Amount (DR)
tdCInvoiceWHTTotAmtDebitLC	decimal	CInvoice.CInvoiceWHTTotAmtDebitLC	BC WHT Total Amount (DR)
tdCInvoiceWHTTotAmtDebitTC	decimal	CInvoice.CInvoiceWHTTotAmtDebitTC	TC WHT Total Amount (DR)
tiCompany_ID	integer	CInvoice.Company_ID	Link to Company
tctx2_domain	character	tx2_mstr.tx2_domain	Domain
tltx2_update_tax	logical	tx2_mstr.tx2_update_tax	Update Tax Allowed
tiVat_ID	integer	CInvoiceWHT.Vat_ID	Link to Vat
tcVatCode	character	Vat.VatCode	Tax Code

Internal usage

QadFinancials

method BCInvoice.DefaultWHTDataBasedOnCInvoice