project QadFinancials > class BPosting > business logic query PostingVatByPostingID

Description

PostingVatByPostingID: All fields of tables postingline and posting vat will be in the result-set


Parameters


iiCompanyIdintegerCompany id
iiPostingIDinteger


query condition


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

      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


query resultset tqPostingVatByPostingID


field namedata typedb fielddescription
tiCompany_IDintegerPostingLine.Company_IDLink to Company
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiCrossCompany_IDintegerPostingLine.CrossCompany_IDLink to Company
tiCrossCompanyPosting_IDintegerPostingLine.CrossCompanyPosting_IDPosting (Cross-Cy)
tiCrossCompanyPostingLine_IDintegerPostingLine.CrossCompanyPostingLine_IDPosting line (Cross-Cy)
tiCurrency_IDintegerPostingLine.Currency_IDCurrency Code
tiCurrency_ID2integerPostingVat.Currency_IDCurrency Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcFromTxzTaxZonecharacterPostingVat.FromTxzTaxZoneFrom Tax Zone.
api annotation:?
tiGL_IDintegerPostingLine.GL_IDGL Description
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tiIntercoBusinessRelation_IDintegerPostingLine.IntercoBusinessRelation_IDIntercompany Code
tiPeriod_IDintegerPostingLine.Period_IDLink to Period
tiPeriodMark_IDintegerPostingVat.PeriodMark_IDLink to PeriodMark
tiPosting_IDintegerPostingLine.Posting_IDLink to Posting
tiPosting_ID2integerPostingVat.Posting_IDLink to Posting
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tcPostingLineCostCentreTextcharacterPostingLine.PostingLineCostCentreTextCost Center
api annotation:Value for this field defaults to blank.
tdPostingLineCreditCCdecimalPostingLine.PostingLineCreditCCSC Credit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field
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.
tdPostingLineCreditPCdecimalPostingLine.PostingLineCreditPCPC Credit
api annotation:This field is obsolete and can be left blank.
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tcPostingLineCrossExternRefcharacterPostingLine.PostingLineCrossExternRefExt Reference (Cross-Cy) - must be filled when create a cross-company posting.
api annotation:Value for this field defaults to blank.
tdPostingLineDebitCCdecimalPostingLine.PostingLineDebitCCSC Debit
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field.
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.
tdPostingLineDebitPCdecimalPostingLine.PostingLineDebitPCPC Debit
api annotation:This field is obsolete.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tdPostingLineExchangeRatedecimalPostingLine.PostingLineExchangeRateExchange Rate
api annotation:Default value for this field depends on the exchang erate shared set specified for the current domain.
tlPostingLineIsProjPostinglogicalPostingLine.PostingLineIsProjPostingProject Posting
tiPostingLineMaster_IDintegerPostingLine.PostingLineMaster_IDLink to Master
tcPostingLineMirrorRefcharacterPostingLine.PostingLineMirrorRefThis holds a reference number to link the source and mirror postinglines together.
--> Source account 1 and mirror account 1 will have the same reference.
--> Source account 2 and mirror account 2 will also have the same reference (but different from source and mirror account 1).
api annotation:Value for this field defaults to blank.
tcPostingLineMirrorTypecharacterPostingLine.PostingLineMirrorTypeSOURCE or MIRROR (Depending if the posting line uses the source account or the mirror account).
api annotation:Value for this field defaults to blank.
tiPostingLineOriginLineNbrintegerPostingLine.PostingLineOriginLineNbrEquivalent to PostingLineSequence, however there is a difference in format and the value may differ in a number of specific cases.
MfgPro Equivalent: glt_line
api annotation:Value for this field defaults to 0.
tcPostingLineProjectTextcharacterPostingLine.PostingLineProjectTextProject
api annotation:Value for this field defaults to blank.
tdPostingLineQTYdecimalPostingLine.PostingLineQTYQuantity
api annotation:Value for this field defaults to 0.0000.
tdPostingLineRateScaledecimalPostingLine.PostingLineRateScaleScale Factor
api annotation:The default value is 1.
tcPostingLineSafTextcharacterPostingLine.PostingLineSafTextSAF
api annotation:Value for this field defaults to blank.
tiPostingLineSequenceintegerPostingLine.PostingLineSequenceSequence
tcPostingLineTextcharacterPostingLine.PostingLineTextDescription
api annotation:Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting.
tiPostingLineTransaction_IDintegerPostingLine.PostingLineTransaction_IDLink to Transaction
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".
tiPostingYearPeriodintegerPostingLine.PostingYearPeriodThe GL calendar year/period for the journal entry.
api annotation:In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting.
tiProject_IDintegerPostingLine.Project_IDDescription
tcToTxzTaxZonecharacterPostingVat.ToTxzTaxZoneTo Tax Zone
api annotation:?
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
tiVatGroup_IDintegerPostingVat.VatGroup_IDTax Group Code
tiVatPeriod_IDintegerPostingVat.VatPeriod_IDLink to VatPeriod
tiVatRule_IDintegerPostingVat.VatRule_IDLink to VatRule


Internal usage


QadFinancials
method BOpenItemAdjustment.OIAdjCommitSubCInvoiceDiscount
method BOpenItemAdjustment.OIAdjCommitSubDInvoiceDiscount