business logic query PostingForPostingHist

Parameters

iiCompanyId	integer	Company id
iiPeriodID	integer
iiGLId	integer
icLayerType	character
iiDivisionId	integer
icBusinessRelationICCode	character

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 name	data type	db field	description
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany 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_ID	integer	Posting.Company_ID	Link to Company
tiCostCentre_ID	integer	PostingLine.CostCentre_ID	Cost Center Code
tiCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
tiDivision_ID	integer	PostingLine.Division_ID	Sub-Account Code
tiGL_ID	integer	PostingLine.GL_ID	GL Description
tiIntercoBusinessRelation_ID	integer	PostingLine.IntercoBusinessRelation_ID	Intercompany Code
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiLayer_ID	integer	Journal.Layer_ID	Link to Layer
tcLayerCode	character	Layer.LayerCode	Layer Code
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
tiPeriodMark_ID	integer	Posting.PeriodMark_ID	Link to PeriodMark
tiPosting_ID	integer	Posting.Posting_ID	Record ID
ttPostingDate	date	Posting.PostingDate	The 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_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditLC	decimal	PostingLine.PostingLineCreditLC	BC 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.
tdPostingLineDebitLC	decimal	PostingLine.PostingLineDebitLC	BC 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.
tdPostingLineQTY	decimal	PostingLine.PostingLineQTY	Quantity
	api annotation:		Value for this field defaults to 0.0000.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tiPostingYearPeriod	integer	Posting.PostingYearPeriod	The 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_ID	integer	PostingLine.Project_ID	Description

Internal usage

QadFinancials

method BConsolid.AdditionalUpdatesConsolidationBlock