business logic query CInvoiceWHTForWHTCreation

Description

CInvoiceWHTForWHTCreation: This query return the elements that are needed for creating the WHT records in class BWithholdingTax.

NOTE!!!!!!!!!!!!!!!!:
This query should nopt be extended in any way unless you also adapt the programcode in BCInvoice that fills a temp-table that is defined like the result-set of this query and unless you also adapt the program-code in class BWithholdingTax

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 Currency (inner-join) where

Currency.Currency_ID = CompanyProperty.Currency_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 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 tqCInvoiceWHTForWHTCreation

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
tdCInvoiceNonDiscAmtTC	decimal	CInvoice.CInvoiceNonDiscAmtTC	TC Non-discount Amount. This field display the invoice amount without discount in base currency.
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.
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.
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.
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.
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.
tiCInvoiceWHT_ID	integer	CInvoiceWHT.CInvoiceWHT_ID	Record ID
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)
tdCInvoiceWHTTotAmtCreditTC	decimal	CInvoice.CInvoiceWHTTotAmtCreditTC	TC WHT Total Amount (CR)
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
tiDivision_ID	integer	CInvoiceWHT.Division_ID	Link to Division
tcDivisionCode	character	Division.DivisionCode	Sub-Account
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	Currency.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 BWithholdingTax.CreateAndOrUpdateWHTSub
dataset BWithholdingTax.tInvoiceWHTPaymentCIWHT