project QadFinancials > class BPosting > business logic query PostingByPostingLineId

Description

PostingByPostingLineId


Parameters


iiCompanyIdintegerCompany id
iiPostingLineIdintegerPosting Line ID


query condition


  each PostingLine where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = iiPostingLineId

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

          first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND


query resultset tqPostingByPostingLineId


field namedata typedb fielddescription
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period
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.
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
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.
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tiProject_IDintegerPostingLine.Project_IDDescription
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
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.
tiPostingVoucherintegerPosting.PostingVoucherVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiCompany_IDintegerPosting.Company_IDLink to Company
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
ttPostingSystemDatedatePosting.PostingSystemDateThe system date of the posting corresponding to "PostingDate".
api annotation:In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system.
ttPostingValueDatedatePosting.PostingValueDateThe value date (used for banking entries).
tiPosting_IDintegerPosting.Posting_IDRecord ID


Internal usage


QadFinancials
method BCDocument.CalculateAll
method BCInvoice.AdditionalUpdatesAllAssignments
method BCInvoice.AdditionalUpdatesAllQCInvoiceMovement
method BCInvoice.CreateCInvoiceMovements
method BCInvoice.LoadCIAndMFPosting
method BDDocument.Calculate
method BDInvoice.AdditionalUpdatesAllAssignments
method BDInvoice.AdditionalUpdatesAllQDInvoiceMovement
method BFixedAssetCapital.ValidateComponent