project QadFinancials > class BPosting > business logic query PostingVatByPostingLineId

Description

Give all posting lines with vat lines


Parameters


iiPostingIDinteger
iiCompanyIdintegerCompany id


query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = iiPostingID

      each PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND

          first Division (outer-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = PostingLine.Division_ID AND

          first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingLine.GL_ID AND

          each PostingVat (inner-join) where
PostingVat.PostingLine_ID = PostingLine.PostingLine_ID AND

              first Vat (inner-join) where
Vat.Vat_ID = PostingVat.Vat_ID AND

                  first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND

                      each tx2_mstr (inner-join) where
tx2_mstr.tx2_domain = Domains.DomainCode AND
tx2_mstr.tx2_tax_code = Vat1.VatCode


query resultset tqPostingVatByPostingLineId


field namedata typedb fielddescription
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcDomainCodecharacterDomains.DomainCodeDomain
tcFromTxzTaxZonecharacterPostingVat.FromTxzTaxZoneFrom Tax Zone.
api annotation:?
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tiPosting_IDintegerPosting.Posting_IDRecord ID
tdPostingLineCreditLCdecimalPostingLine.PostingLineCreditLCBC Credit
api annotation:Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field.
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitLCdecimalPostingLine.PostingLineDebitLCBC Debit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tiPostingVat_IDintegerPostingVat.PostingVat_IDRecord ID
tdPostingVatBaseCreditCCdecimalPostingVat.PostingVatBaseCreditCCSC (Statutory Currency) Base Credit amount.
tdPostingVatBaseCreditLCdecimalPostingVat.PostingVatBaseCreditLCBC (Base/Local Currency) Base Credit amount.
tdPostingVatBaseCreditTCdecimalPostingVat.PostingVatBaseCreditTCTC (Transaction Currency) Base Credit amount.
tdPostingVatBaseDebitCCdecimalPostingVat.PostingVatBaseDebitCCSC (Statutory Currency) Base Debit amount.
tdPostingVatBaseDebitLCdecimalPostingVat.PostingVatBaseDebitLCBC (Base/Local Currency) Base Debit amount.
tdPostingVatBaseDebitTCdecimalPostingVat.PostingVatBaseDebitTCTC (Transaction Currency) Base Debit amount.
tdPostingVatExchangeRatedecimalPostingVat.PostingVatExchangeRateTC/BC Exchange Rate.
api annotation:?
tcPostingVatInOutcharacterPostingVat.PostingVatInOutIn/Out?
api annotation:Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales.
tlPostingVatIsAbsRetlogicalPostingVat.PostingVatIsAbsRetAbsorbed Retained
tlPostingVatIsReverseChargelogicalPostingVat.PostingVatIsReverseChargeReverse Charge
tlPostingVatIsSuspDellogicalPostingVat.PostingVatIsSuspDelSuspended/Delayed Tax
tiPostingVatOwnTaxDeclaratintegerPostingVat.PostingVatOwnTaxDeclaratOwn Declaration Tax
tcPostingVatOwnTaxIDFedercharacterPostingVat.PostingVatOwnTaxIDFederOwn Federal Tax?
api annotation:?
tcPostingVatOwnTaxIDMisc1characterPostingVat.PostingVatOwnTaxIDMisc1Own Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful.
api annotation:?
tcPostingVatOwnTaxIDMisc2characterPostingVat.PostingVatOwnTaxIDMisc2Own Miscellaneous Tax 2
tcPostingVatOwnTaxIDMisc3characterPostingVat.PostingVatOwnTaxIDMisc3Own Miscellaneous Tax 3
tcPostingVatOwnTaxIDStatecharacterPostingVat.PostingVatOwnTaxIDStateOwn State Tax?
api annotation:?
tdPostingVatRateScaledecimalPostingVat.PostingVatRateScaleScale Factor (TC/BC).
api annotation:?
tdPostingVatTaxCreditCCdecimalPostingVat.PostingVatTaxCreditCCSC (Statutory Currency) Tax Credit amount.
api annotation:?
tdPostingVatTaxCreditLCdecimalPostingVat.PostingVatTaxCreditLCBC (Base/Local) Tax Credit amount.
api annotation:?
tdPostingVatTaxCreditTCdecimalPostingVat.PostingVatTaxCreditTCTC (Transaction Currency) Tax Credit amount.
api annotation:?
tdPostingVatTaxDebitCCdecimalPostingVat.PostingVatTaxDebitCCSC (Statutory Currency) Tax Debit amount.
api annotation:?
tdPostingVatTaxDebitLCdecimalPostingVat.PostingVatTaxDebitLCBC (Base Currency) Tax Debit amount.
api annotation:?
tdPostingVatTaxDebitTCdecimalPostingVat.PostingVatTaxDebitTCTC (Transaction Currency) Tax Debit amount.
api annotation:?
tcPostingVatTaxIDFedercharacterPostingVat.PostingVatTaxIDFederFederal Tax?
api annotation:?
tcPostingVatTaxIDMisc1characterPostingVat.PostingVatTaxIDMisc1Miscellaneous Tax 1. For reference and documentation
purposes, enter any other tax identification numbers that are useful.
api annotation:?
tcPostingVatTaxIDMisc2characterPostingVat.PostingVatTaxIDMisc2Miscellaneous Tax 2
tcPostingVatTaxIDMisc3characterPostingVat.PostingVatTaxIDMisc3Miscellaneous Tax 3
tcPostingVatTaxIDStatecharacterPostingVat.PostingVatTaxIDStateState Tax?
api annotation:?
ttPostingVatTaxPointDatedatePostingVat.PostingVatTaxPointDateThe date when this posting is taken into account in the Tax sub-adminstration.
api annotation:?
tcPostingVatTaxTransTypecharacterPostingVat.PostingVatTaxTransTypeTax 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"
tcPostingVatTransTypecharacterPostingVat.PostingVatTransTypeTransaction 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".
tcToTxzTaxZonecharacterPostingVat.ToTxzTaxZoneTo Tax Zone
api annotation:?
tctx2_domaincharactertx2_mstr.tx2_domainDomain
tltx2_pmt_disclogicaltx2_mstr.tx2_pmt_discDiscount Tax at Payment
tctx2_tax_codecharactertx2_mstr.tx2_tax_codeTax Code
tcTxclTaxClscharacterPostingVat.TxclTaxClsTax 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
tcTxenvTaxEnvcharacterPostingVat.TxenvTaxEnvTax 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:?
tcTxtyTaxTypecharacterPostingVat.TxtyTaxTypeTax Type
tcTxuTaxUsagecharacterPostingVat.TxuTaxUsageTax 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.
tiVat_IDintegerPostingVat.Vat_IDTax Code
tcVatCodecharacterVat.VatCodeTax Code
tiVatGroup_IDintegerPostingVat.VatGroup_IDTax Group Code
tiVatPeriod_IDintegerPostingVat.VatPeriod_IDLink to VatPeriod
tiVatRule_IDintegerPostingVat.VatRule_IDLink to VatRule


Internal usage


QadFinancials
method BBankEntry.AdditionalUpdatesInvDiscountCurrDiff
method BBankEntry.AdditionalUpdatesInvDiscountCurrDiffTax
method BCDocument.AdditionalUpdatesPostingXrefCIDiscTax
method BCDocument.AdditionalUpdatesPostingXrefDI
method BDDocument.AdditionalUpdatesPostingXrefDIDisc
method BDDocument.StopAllQueries