business logic query CInvoicePostingForDelTax

Description

retrieve the posting tax records with delayed taxes

Parameters

iiCompanyId	integer	Company id
iiCInvoiceId	integer	ID of the supplier invoice
ilCInvoiceVatIsSuspDel	logical	Delayed flag

query condition

each CInvoice where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoiceId

each CInvoiceVat (inner-join) where

CInvoiceVat.CInvoice_ID = CInvoice.CInvoice_ID AND
CInvoiceVat.CInvoiceVatIsSuspDel = ilCInvoiceVatIsSuspDel

first Division1 (conditional-join) where

Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = CInvoiceVat.NormalTaxDivision_ID AND

first Division2 (conditional-join) where

Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = CInvoiceVat.SuspDelTaxDivision_ID AND

first GL1 (conditional-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = CInvoiceVat.NormalTaxGL_ID AND

first GL2 (conditional-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = CInvoiceVat.SuspDelTaxGL_ID AND

first PostingVat (conditional-join) where

PostingVat.PostingVat_ID = CInvoiceVat.PostingVat_ID AND

first PostingLine (outer-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = PostingVat.PostingLine_ID AND

first Vat (outer-join) where

Vat.Vat_ID = PostingVat.Vat_ID AND

first Domains (outer-join) where

Domains.Domain_ID = Vat.Domain_ID AND

first CostCentre (conditional-join) where

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

first Currency (inner-join) where

Currency.Currency_ID = CInvoice.CInvoiceCurrency_ID AND

first Division3 (conditional-join) where

Division3.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division3.Division_ID = CInvoice.Division_ID AND

first Project (conditional-join) where

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

query resultset tqCInvoicePostingForDelTax

field name	data type	db field	description
tiCInvoice_ID	integer	CInvoice.CInvoice_ID	Record ID
tdCInvoiceBalanceCreditTC	decimal	CInvoice.CInvoiceBalanceCreditTC	TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
tdCInvoiceBalanceDebitTC	decimal	CInvoice.CInvoiceBalanceDebitTC	TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
tcCInvoiceCIText	character	CInvoice.CInvoiceCIText	CIDescription. A brief description for the SI posting.
	api annotation:		This field defaults from the CInvoiceDescription.
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.
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.
tdCInvoiceRateScale	decimal	CInvoice.CInvoiceRateScale	Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
ttCInvoiceTaxPointDate	date	CInvoice.CInvoiceTaxPointDate	Tax Point Date.This field indicates the date to be used in tax calculations.
	api annotation:		This field defaults from the posting date.
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.
tiCInvoiceVat_ID	integer	CInvoiceVat.CInvoiceVat_ID	Record ID
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.
tlCInvoiceVatIsSuspDel	logical	CInvoiceVat.CInvoiceVatIsSuspDel	CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
tlCInvoiceVatIsTaxable	logical	CInvoiceVat.CInvoiceVatIsTaxable	Taxable. This field indicates if the invoice is taxable. This field defaults to true if the supplier is taxable.
tdCInvoiceVatSuspDelTaxAmtTC	decimal	CInvoiceVat.CInvoiceVatSuspDelTaxAmtTC	Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
tiCompany_ID	integer	CInvoice.Company_ID	Link to Company
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcDelTaxDivisionCode	character	Division2.DivisionCode	Sub-Account
tcDelTaxGLCode	character	GL2.GLCode	A code identifying the GL account.
tcDivisionCode	character	Division3.DivisionCode	Sub-Account
tcDomainCode	character	Domains.DomainCode	Domain
tcFromTxzTaxZone	character	PostingVat.FromTxzTaxZone	From Tax Zone.
	api annotation:		?
tiNormalTaxDivision_ID	integer	CInvoiceVat.NormalTaxDivision_ID	Normal Tax Sub-Account
tcNormalTaxDivisionCode	character	Division1.DivisionCode	Sub-Account
tiNormalTaxGL_ID	integer	CInvoiceVat.NormalTaxGL_ID	Normal Tax Account
tcNormalTaxGLCode	character	GL1.GLCode	A code identifying the GL account.
tdPostingLineCCRate	decimal	PostingLine.PostingLineCCRate	The exchange rate used to convert between transaction (TC) and statutory(SC) amounts.
	api annotation:		Default value for this field depends on the exchangerate shared set specified for the current domain.
tdPostingLineCCScale	decimal	PostingLine.PostingLineCCScale	A decimal number that must be multiplied by the exchange rate to get the real exchange rate. Its format is 9999999.9999999 and it was introduced to extend the accuracy of the exchange rate.
	api annotation:		The default value is 1.
tdPostingLineExchangeRate	decimal	PostingLine.PostingLineExchangeRate	Exchange Rate
	api annotation:		Default value for this field depends on the exchang erate shared set specified for the current domain.
tdPostingLineRateScale	decimal	PostingLine.PostingLineRateScale	Scale Factor
	api annotation:		The default value is 1.
tdPostingVatBaseCreditCC	decimal	PostingVat.PostingVatBaseCreditCC	SC (Statutory Currency) Base Credit amount.
tdPostingVatBaseCreditLC	decimal	PostingVat.PostingVatBaseCreditLC	BC (Base/Local Currency) Base Credit amount.
tdPostingVatBaseCreditTC	decimal	PostingVat.PostingVatBaseCreditTC	TC (Transaction Currency) Base Credit amount.
tdPostingVatBaseDebitCC	decimal	PostingVat.PostingVatBaseDebitCC	SC (Statutory Currency) Base Debit amount.
tdPostingVatBaseDebitLC	decimal	PostingVat.PostingVatBaseDebitLC	BC (Base/Local Currency) Base Debit amount.
tdPostingVatBaseDebitTC	decimal	PostingVat.PostingVatBaseDebitTC	TC (Transaction Currency) Base Debit amount.
tdPostingVatExchangeRate	decimal	PostingVat.PostingVatExchangeRate	TC/BC Exchange Rate.
	api annotation:		?
tcPostingVatInOut	character	PostingVat.PostingVatInOut	In/Out?
	api annotation:		Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales.
tlPostingVatIsReverseCharge	logical	PostingVat.PostingVatIsReverseCharge	Reverse Charge
tiPostingVatOwnTaxDeclarat	integer	PostingVat.PostingVatOwnTaxDeclarat	Own Declaration Tax
tcPostingVatOwnTaxIDFeder	character	PostingVat.PostingVatOwnTaxIDFeder	Own Federal Tax?
	api annotation:		?
tcPostingVatOwnTaxIDMisc1	character	PostingVat.PostingVatOwnTaxIDMisc1	Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful.
	api annotation:		?
tcPostingVatOwnTaxIDMisc2	character	PostingVat.PostingVatOwnTaxIDMisc2	Own Miscellaneous Tax 2
tcPostingVatOwnTaxIDMisc3	character	PostingVat.PostingVatOwnTaxIDMisc3	Own Miscellaneous Tax 3
tcPostingVatOwnTaxIDState	character	PostingVat.PostingVatOwnTaxIDState	Own State Tax?
	api annotation:		?
tdPostingVatRateScale	decimal	PostingVat.PostingVatRateScale	Scale Factor (TC/BC).
	api annotation:		?
tdPostingVatTaxCreditCC	decimal	PostingVat.PostingVatTaxCreditCC	SC (Statutory Currency) Tax Credit amount.
	api annotation:		?
tdPostingVatTaxCreditLC	decimal	PostingVat.PostingVatTaxCreditLC	BC (Base/Local) Tax Credit amount.
	api annotation:		?
tdPostingVatTaxCreditTC	decimal	PostingVat.PostingVatTaxCreditTC	TC (Transaction Currency) Tax Credit amount.
	api annotation:		?
tdPostingVatTaxDebitCC	decimal	PostingVat.PostingVatTaxDebitCC	SC (Statutory Currency) Tax Debit amount.
	api annotation:		?
tdPostingVatTaxDebitLC	decimal	PostingVat.PostingVatTaxDebitLC	BC (Base Currency) Tax Debit amount.
	api annotation:		?
tdPostingVatTaxDebitTC	decimal	PostingVat.PostingVatTaxDebitTC	TC (Transaction Currency) Tax Debit amount.
	api annotation:		?
tcPostingVatTaxIDFeder	character	PostingVat.PostingVatTaxIDFeder	Federal Tax?
	api annotation:		?
tcPostingVatTaxIDMisc1	character	PostingVat.PostingVatTaxIDMisc1	Miscellaneous Tax 1. For reference and documentation purposes, enter any other tax identification numbers that are useful.
	api annotation:		?
tcPostingVatTaxIDMisc2	character	PostingVat.PostingVatTaxIDMisc2	Miscellaneous Tax 2
tcPostingVatTaxIDMisc3	character	PostingVat.PostingVatTaxIDMisc3	Miscellaneous Tax 3
tcPostingVatTaxIDState	character	PostingVat.PostingVatTaxIDState	State Tax?
	api annotation:		?
tcPostingVatTaxTransType	character	PostingVat.PostingVatTaxTransType	Tax Transaction Type?
	api annotation:		Available value for this field: 29 represents "AP Payment Check (Discount at Payment)", 55 represents "AP Transactions", 22 represents "AP Invoice", 18 represents "AR Invoice", 16 represents "AR Operational Invoice", 19 represents "AR Payment (Discount at Payment)", 56 represents "AR Transactions", 45 represents "Logistic Accounting - DO Shipment", 27 represents "Logistic Accounting - PO Receipt", 43 represents "Logistic Accounting - SO Shipment", 20 represents "Purchase Order", 21 represents "Purchase Order Receipt", 25 represents "Purchase Order Return"
tcPostingVatTransType	character	PostingVat.PostingVatTransType	Transaction Type?
	api annotation:		Available value for this field is: ACQUISITION represents "IC Acquisition", BOTH represents "Both", EXPORT represents "Export", IN represents "IN", OUT represents "OUT", IMPORT represents "Import", INLAND-PURCHASE represents "INLAND-PURCHASE", INLAND-SALES represents "INLAND-SALES", PURCHASE represents "Inland Purchase", SALES represents "Inland Sales", SUPPLY represents "IC Supply", TRIANGULARPURCHASE represents "Triangular Purchase", TRIANGULARSALES represents "Triangular Sales".
tcProjectCode	character	Project.ProjectCode	Project
tiSuspDelTaxDivision_ID	integer	CInvoiceVat.SuspDelTaxDivision_ID	Delayed Tax Sub-Account
tiSuspDelTaxGL_ID	integer	CInvoiceVat.SuspDelTaxGL_ID	Delayed Tax Account
tcToTxzTaxZone	character	PostingVat.ToTxzTaxZone	To Tax Zone
	api annotation:		?
tcTxclTaxCls	character	PostingVat.TxclTaxCls	Tax Class. A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions.
	api annotation:		The value of Tax Class defaults to the header of transactions created for this address
tcTxenvTaxEnv	character	PostingVat.TxenvTaxEnv	Tax Environment. A code (maximum 16 characters) that identifies a set of tax types for a tax zone/tax class combination. On transactions, this code identifies the transaction or line-item tax environment.
	api annotation:		?
tcTxtyTaxType	character	PostingVat.TxtyTaxType	Tax Type
tcTxuTaxUsage	character	PostingVat.TxuTaxUsage	Tax Usage. A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address. Common tax usages are retail, manufacturing, and industrialization.
	api annotation:		The value of Tax Usage defaults to the header of transactions created for this address.
tcVatCode	character	Vat.VatCode	Tax Code
tcVatInOut	character	Vat.VatInOut	Tax In/Out

Internal usage

QadFinancials

method BCInvoice.UpdateCInvoiceVatDelay