business logic query CInvoiceWHTByCInvoice

Description

lists all the WHT records for a certain supplier invoice records

Parameters

iiCompanyId	integer	Company id
iiCInvoiceId	integer	CInvoice ID
ilUpdateTax	logical	Update Tax

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

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CInvoice.Company_ID AND

each CompanyProperty (inner-join) where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

first Currency1 (inner-join) where

Currency1.Currency_ID = CompanyProperty.Currency_ID AND

first Domains (inner-join) where

Domains.Domain_ID = Company.Domain_ID AND

first CostCentre (conditional-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = CInvoice.CostCentre_ID AND

first Creditor (inner-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND

first SharedSet (inner-join) where

SharedSet.SharedSet_ID = Creditor.SharedSet_ID AND

first WHTCertFormat (conditional-join) where

WHTCertFormat.WHTCertFormat_ID = Creditor.WHTCertFormat_ID AND

first Currency2 (inner-join) where

Currency2.Currency_ID = CInvoice.CInvoiceCurrency_ID AND

first Journal (inner-join) where

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

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = CInvoice.Project_ID AND

first Division (conditional-join) where

Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = CInvoiceWHT.Division_ID AND

first GL (conditional-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = CInvoiceWHT.GL_ID AND

first Vat (conditional-join) where

Vat.Vat_ID = CInvoiceWHT.Vat_ID AND

first tx2_mstr (outer-join) where

tx2_mstr.tx2_tax_code = Vat.VatCode AND
tx2_mstr.tx2_update_tax = ilUpdateTax

query resultset tqCInvoiceWHTByCInvoice

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoiceWHT.CInvoice_ID	Link to CInvoice
tdCInvoiceCCRate	decimal	CInvoice.CInvoiceCCRate	SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate.
tdCInvoiceCCScale	decimal	CInvoice.CInvoiceCCScale	Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments.
tiCInvoiceCurrency_ID	integer	CInvoice.CInvoiceCurrency_ID	Currency Code
tdCInvoiceExchangeRate	decimal	CInvoice.CInvoiceExchangeRate	Exchange Rate. The exchange rate used by the invoice. The BC Invoice Amount is calculated based on the exchange rate. If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
tlCInvoiceIsWHT	logical	CInvoice.CInvoiceIsWHT	Withholding Tax
tdCInvoiceOriginalCreditCC	decimal	CInvoice.CInvoiceOriginalCreditCC	SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tdCInvoiceOriginalCreditLC	decimal	CInvoice.CInvoiceOriginalCreditLC	BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate.
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.
tdCInvoiceOriginalDebitCC	decimal	CInvoice.CInvoiceOriginalDebitCC	SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency. This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
tdCInvoiceOriginalDebitLC	decimal	CInvoice.CInvoiceOriginalDebitLC	BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency. This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate.
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.
ttCInvoicePostingDate	date	CInvoice.CInvoicePostingDate	Posting Date. This filed indicates the date on which the invoice is to be posted.
	api annotation:		This field defaults from the invoice creation date.
tiCInvoicePostingPeriod	integer	CInvoice.CInvoicePostingPeriod	GL Period.This field indicates the period when the invoice to be posted. If this field is modified, the posting and tax dates are changed correspondingly.
	api annotation:		This field defaults to the period associated with the posting date.
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.
tiCInvoicePostingYearPeriod	integer	CInvoice.CInvoicePostingYearPeriod	Year/Period. This field indicates the accounting year and period 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 and period associated with the posting date.
tdCInvoiceRateScale	decimal	CInvoice.CInvoiceRateScale	Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
tcCInvoiceReference	character	CInvoice.CInvoiceReference	Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the supplier.
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.
tdCInvoiceVatBaseCreditCC	decimal	CInvoice.CInvoiceVatBaseCreditCC	SC Base Amount CR. This field displays the credit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount CR and the SC rate.
tdCInvoiceVatBaseCreditLC	decimal	CInvoice.CInvoiceVatBaseCreditLC	BC Base Amount CR. This field displays the credit base amount in the base currency. This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
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.
tdCInvoiceVatBaseDebitCC	decimal	CInvoice.CInvoiceVatBaseDebitCC	SC Base Amount DR. This field displays the debit base amount in the statutory currency. This field is calculated by the system using the TC Base Amount DR and the SC rate.
tdCInvoiceVatBaseDebitLC	decimal	CInvoice.CInvoiceVatBaseDebitLC	BC Base Amount DR. This field displays the debit base amount in the base currency. This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
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.
tdCInvoiceVatCreditCC	decimal	CInvoice.CInvoiceVatCreditCC	SC Tax Amount CR. This field displays the credit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount CR and the SC rate.
tdCInvoiceVatCreditLC	decimal	CInvoice.CInvoiceVatCreditLC	BC Tax Amount CR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
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.
tdCInvoiceVatDebitCC	decimal	CInvoice.CInvoiceVatDebitCC	BC Tax Amount DR. This field displays the debit tax amount in the statutory currency. This field is calculated by the system using the TC Tax Amount DR and the SC rate.
tdCInvoiceVatDebitLC	decimal	CInvoice.CInvoiceVatDebitLC	BC Tax Amount DR. This field displays the debit tax amount in the base currency. This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
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.
tiCInvoiceWHT_ID	integer	CInvoiceWHT.CInvoiceWHT_ID	Record ID
tdCInvoiceWHTAmtCreditCC	decimal	CInvoiceWHT.CInvoiceWHTAmtCreditCC	SC WHT Amount (CR)
tdCInvoiceWHTAmtCreditLC	decimal	CInvoiceWHT.CInvoiceWHTAmtCreditLC	BC WHT Amount (CR)
tdCInvoiceWHTAmtCreditTC	decimal	CInvoiceWHT.CInvoiceWHTAmtCreditTC	TC WHT Amount (CR)
tdCInvoiceWHTAmtDebitCC	decimal	CInvoiceWHT.CInvoiceWHTAmtDebitCC	SC WHT Amount (DR)
tdCInvoiceWHTAmtDebitLC	decimal	CInvoiceWHT.CInvoiceWHTAmtDebitLC	BC WHT Amount (DR)
tdCInvoiceWHTAmtDebitTC	decimal	CInvoiceWHT.CInvoiceWHTAmtDebitTC	TC WHT Amount (DR)
tdCInvoiceWHTBaseAmtCreditCC	decimal	CInvoice.CInvoiceWHTBaseAmtCreditCC	SC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtCreditLC	decimal	CInvoice.CInvoiceWHTBaseAmtCreditLC	BC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtCreditTC	decimal	CInvoice.CInvoiceWHTBaseAmtCreditTC	TC WHT Base Amount (CR)
tdCInvoiceWHTBaseAmtDebitCC	decimal	CInvoice.CInvoiceWHTBaseAmtDebitCC	SC WHT Base Amount (DR)
tdCInvoiceWHTBaseAmtDebitLC	decimal	CInvoice.CInvoiceWHTBaseAmtDebitLC	BC WHT Base Amount (DR)
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)
tdCInvoiceWHTTaxFeeCreditCC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeCreditCC	SC Taxable Fee (CR)
tdCInvoiceWHTTaxFeeCreditLC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeCreditLC	BC Taxable Fee (CR)
tdCInvoiceWHTTaxFeeCreditTC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeCreditTC	TC Taxable Fee (CR)
tdCInvoiceWHTTaxFeeDebitCC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeDebitCC	SC Taxable Fee (DR)
tdCInvoiceWHTTaxFeeDebitLC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeDebitLC	BC Taxable Fee (DR)
tdCInvoiceWHTTaxFeeDebitTC	decimal	CInvoiceWHT.CInvoiceWHTTaxFeeDebitTC	TC Taxable Fee (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	Company.Company_ID	Record ID
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tiCreditor_ID	integer	CInvoice.Creditor_ID	Link to Creditor
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tcCurrencyCode	character	Currency2.CurrencyCode	Currency Code
tiDivision_ID	integer	CInvoiceWHT.Division_ID	Link to Division
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcDomainCode	character	Domains.DomainCode	Domain
tiGL_ID	integer	CInvoiceWHT.GL_ID	Link to GL
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tiJournal_ID	integer	CInvoice.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiLocalCurrencyCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tcLocalCurrencyCurrencyCode	character	Currency1.CurrencyCode	Currency Code
tcProjectCode	character	Project.ProjectCode	Project
tiSharedSet_ID	integer	Creditor.SharedSet_ID	Link to SharedSet
tcSharedSetCode	character	SharedSet.SharedSetCode	Shared Set Code
tdtx2_tax_pct	decimal	tx2_mstr.tx2_tax_pct	Tax Rate
tctx2_tax_type	character	tx2_mstr.tx2_tax_type	Tax Type
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
tiWHTCertFormat_ID	integer	Creditor.WHTCertFormat_ID	Link to Withholding Tax Certificate Format
tcWHTCertFormatCode	character	WHTCertFormat.WHTCertFormatCode	Format Code

Internal usage

QadFinancials

method BBankEntry.AdditionalUpdatesInvCIMovements
method BCDocument.AdditionalUpdatesPostingXRefWHT