project QadFinancials > class BPosting > business logic query PostingForPostingHist


Parameters


iiCompanyIdintegerCompany id
iiPeriodIDinteger
iiGLIdinteger
icLayerTypecharacter
iiDivisionIdinteger
icBusinessRelationICCodecharacter


query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Period_ID = iiPeriodID

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

          first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerType

      each PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND
PostingLine.Division_ID = iiDivisionId AND
PostingLine.GL_ID = iiGLId

          first BusinessRelation (conditional-join) where
BusinessRelation.BusinessRelation_ID = PostingLine.IntercoBusinessRelation_ID AND
BusinessRelation.BusinessRelationICCode = icBusinessRelationICCode


query resultset tqPostingForPostingHist


field namedata typedb fielddescription
tcBusinessRelationICCodecharacterBusinessRelation.BusinessRelationICCodeIntercompany Code. When Intercompany is true, this field is mandatory.
The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports.
The intercompany code must be unique for this business relation.
tiCompany_IDintegerPosting.Company_IDLink to Company
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiCurrency_IDintegerPostingLine.Currency_IDCurrency Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tiIntercoBusinessRelation_IDintegerPostingLine.IntercoBusinessRelation_IDIntercompany Code
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPeriodMark_IDintegerPosting.PeriodMark_IDLink to PeriodMark
tiPosting_IDintegerPosting.Posting_IDRecord ID
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).
tiPostingLine_IDintegerPostingLine.PostingLine_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.
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.
tdPostingLineQTYdecimalPostingLine.PostingLineQTYQuantity
api annotation:Value for this field defaults to 0.0000.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
tiPostingYearPeriodintegerPosting.PostingYearPeriodThe GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
api annotation:If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
tiProject_IDintegerPostingLine.Project_IDDescription


Internal usage


QadFinancials
method BConsolid.AdditionalUpdatesConsolidationBlock