business logic query BasePostingHistoryCheck

Parameters

iiCompanyId	integer	Company id
iiPeriod	integer

query condition

each Period where

Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod = iiPeriod

each Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Period_ID = Period.Period_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

first Layer (outer-join) where

Layer.Layer_ID = Journal.Layer_ID AND

first PeriodMark (inner-join) where

PeriodMark.Company_Id = iiCompanyId AND
PeriodMark.PeriodMark_ID = Posting.PeriodMark_ID AND

each PostingLine (outer-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND

first BusinessRelation (conditional-join) where

BusinessRelation.BusinessRelation_ID = PostingLine.IntercoBusinessRelation_ID AND

first CostCentre (conditional-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = PostingLine.CostCentre_ID AND

first Currency (conditional-join) where

Currency.Currency_ID = PostingLine.Currency_ID AND

first Division (conditional-join) where

Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = PostingLine.Division_ID AND

first GL (outer-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingLine.GL_ID AND

each PostingSaf (conditional-join) where

PostingSaf.PostingLine_ID = PostingLine.PostingLine_ID AND

first Saf (conditional-join) where

Saf.Saf_ID = PostingSaf.Saf_ID AND

first SafStructure (conditional-join) where

SafStructure.SafStructure_ID = PostingSaf.SafStructure_ID AND

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = PostingLine.Project_ID AND

query sort order

PostingLine.PostingLine_ID (ascending)

query resultset tqBasePostingHistoryCheck

field name	data type	db field	description
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcLayerCode	character	Layer.LayerCode	Layer Code
tcPeriodMarkCode	character	PeriodMark.PeriodMarkCode	Mark
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditCC	decimal	PostingLine.PostingLineCreditCC	SC 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
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.
tdPostingLineCreditPC	decimal	PostingLine.PostingLineCreditPC	PC Credit
	api annotation:		This field is obsolete and can be left blank.
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitCC	decimal	PostingLine.PostingLineDebitCC	SC 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.
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.
tdPostingLineDebitPC	decimal	PostingLine.PostingLineDebitPC	PC Debit
	api annotation:		This field is obsolete.
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit
tdPostingLineQTY	decimal	PostingLine.PostingLineQTY	Quantity
	api annotation:		Value for this field defaults to 0.0000.
tiPostingSafInputSequence	integer	PostingSaf.PostingSafInputSequence	Sequence number of this SAF within all the SAF lines for the same posting line.
tcPostingSafParentType	character	PostingSaf.PostingSafParentType	Parent Type. Indicates the parent type of this SAF record.
tcProjectCode	character	Project.ProjectCode	Project
tiSaf_ID	integer	PostingSaf.Saf_ID	SAF Code
tcSafCode	character	Saf.SafCode	SAF Code
tiSafStructure_ID	integer	PostingSaf.SafStructure_ID	Structure Code
tcSafStructureCode	character	SafStructure.SafStructureCode	Structure Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Period),rowid(Posting),rowid(Journal),rowid(Layer),rowid(PeriodMark),rowid(PostingLine),rowid(BusinessRelation),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(PostingSaf),rowid(Saf),rowid(SafStructure),rowid(Project)

Internal usage

QadFinancials

method BClosingPostingsReport.HistoryPostingsCheck