business logic query DInvoicePostingForSuspTax

Description

retrieve the posting tax records with suspended taxes

Parameters

iiCompanyId	integer	Company id
iiDInvoiceId	integer
ilDInvoiceVatIsSuspDel	logical

query condition

each DInvoice where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoiceId

first CostCentre (conditional-join) where

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

first Currency (inner-join) where

Currency.Currency_ID = DInvoice.DInvoiceCurrency_ID AND

each DInvoiceVat (inner-join) where

DInvoiceVat.DInvoice_ID = DInvoice.DInvoice_ID AND
DInvoiceVat.DInvoiceVatIsSuspDel = ilDInvoiceVatIsSuspDel

first Division1 (conditional-join) where

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

first Division2 (conditional-join) where

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

first GL1 (conditional-join) where

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

first GL2 (conditional-join) where

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

first PostingVat (conditional-join) where

PostingVat.PostingVat_ID = DInvoiceVat.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 Division3 (conditional-join) where

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

first Project (conditional-join) where

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

query resultset tqDInvoicePostingForSuspTax

field name	data type	db field	description
tiCompany_ID	integer	DInvoice.Company_ID	Link to Company
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tdDInvoiceBalanceCreditTC	decimal	DInvoice.DInvoiceBalanceCreditTC	TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
tdDInvoiceBalanceDebitTC	decimal	DInvoice.DInvoiceBalanceDebitTC	TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
tcDInvoiceDIText	character	DInvoice.DInvoiceDIText	CIDescription. A brief description for the SI posting.
	api annotation:		This field defaults from the DInvoiceDescription.
tdDInvoiceExchangeRate	decimal	DInvoice.DInvoiceExchangeRate	Exchange Rate. The accounting 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.
tdDInvoiceOriginalCreditCC	decimal	DInvoice.DInvoiceOriginalCreditCC	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.
tdDInvoiceOriginalCreditLC	decimal	DInvoice.DInvoiceOriginalCreditLC	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.
tdDInvoiceOriginalCreditTC	decimal	DInvoice.DInvoiceOriginalCreditTC	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.
tdDInvoiceOriginalDebitCC	decimal	DInvoice.DInvoiceOriginalDebitCC	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.
tdDInvoiceOriginalDebitLC	decimal	DInvoice.DInvoiceOriginalDebitLC	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.
tdDInvoiceOriginalDebitTC	decimal	DInvoice.DInvoiceOriginalDebitTC	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.
ttDInvoicePostingDate	date	DInvoice.DInvoicePostingDate	Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved.
	api annotation:		This field defaults from the invoice creation date.
tdDInvoiceRateScale	decimal	DInvoice.DInvoiceRateScale	Scale Factor.This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. The exchange rate is multiplied by the scale factor to determine the actual exchange rate.
	api annotation:		The value for the scale factor defaults from the exchange rate definition, but it can be modified.
ttDInvoiceTaxPointDate	date	DInvoice.DInvoiceTaxPointDate	Tax Point Date. The date to be used in tax calculations. For sales-related invoices, this field displays the tax calculation date on the associated order.
	api annotation:		This field defaults to DInvoicePostingDate.
tcDInvoiceType	character	DInvoice.DInvoiceType	Invoice Type. This field displays the invoice type. Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
	api annotation:		PartialUpdate = yes - defaults to Invoice
tiDInvoiceVat_ID	integer	DInvoiceVat.DInvoiceVat_ID	Record ID
tdDInvoiceVatBaseCreditTC	decimal	DInvoice.DInvoiceVatBaseCreditTC	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.
tdDInvoiceVatBaseDebitLC	decimal	DInvoice.DInvoiceVatBaseDebitLC	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.
tdDInvoiceVatBaseDebitTC	decimal	DInvoice.DInvoiceVatBaseDebitTC	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.
tdDInvoiceVatCreditTC	decimal	DInvoice.DInvoiceVatCreditTC	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.
tdDInvoiceVatDebitTC	decimal	DInvoice.DInvoiceVatDebitTC	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.
tlDInvoiceVatIsSuspDel	logical	DInvoiceVat.DInvoiceVatIsSuspDel	CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
	api annotation:		PartialUpdate = yes - defaults to false
tlDInvoiceVatIsTaxable	logical	DInvoiceVat.DInvoiceVatIsTaxable	Taxable. This field indicates if the invoice is taxable.
	api annotation:		This field defaults to true if the customer is taxable.
tdDInvoiceVatSuspDelTaxAmtTC	decimal	DInvoiceVat.DInvoiceVatSuspDelTaxAmtTC	Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
tcDivisionCode	character	Division3.DivisionCode	Sub-Account
tcDomainCode	character	Domains.DomainCode	Domain
tcFromTxzTaxZone	character	PostingVat.FromTxzTaxZone	From Tax Zone.
	api annotation:		?
tcNormalTaxDivisionCode	character	Division1.DivisionCode	Sub-Account
tcNormalTaxGLCode	character	GL1.GLCode	A code identifying the GL account.
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.
tiPostingVat_ID	integer	PostingVat.PostingVat_ID	Record ID
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
tlPostingVatIsSuspDel	logical	PostingVat.PostingVatIsSuspDel	Suspended/Delayed Tax
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:		?
ttPostingVatTaxPointDate	date	PostingVat.PostingVatTaxPointDate	The date when this posting is taken into account in the Tax sub-adminstration.
	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
tcSuspTaxDivisionCode	character	Division2.DivisionCode	Sub-Account
tcSuspTaxGLCode	character	GL2.GLCode	A code identifying the GL 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 BDInvoice.MoveSuspendedTax