business logic query ConsolidPeriodXrefByPeriod

Parameters

iiCompanyId	integer	Company id
iiConsolidCompanyID	integer
icConsolidCompanyCode	character
iiSourceYear	integer
iiSourcePeriod	integer
iiTargetYear	integer
iiTargetPeriod	integer

query condition

each ConsolidPeriodXref where

ConsolidPeriodXref.Company_Id = iiCompanyId AND
ConsolidPeriodXref.ConsolidationCompany_ID = iiConsolidCompanyID

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = ConsolidPeriodXref.ConsolidationCompany_ID AND
Company.CompanyCode = icConsolidCompanyCode

each Period1 (inner-join) where

Period1.Company_Id = iiCompanyId AND
Period1.Company_ID = Company.Company_ID AND
Period1.Period_ID = ConsolidPeriodXref1.ConsolidationPeriod_ID AND
Period1.PeriodYear = iiTargetYear AND
Period1.PeriodPeriod = iiTargetPeriod

first Period2 (inner-join) where

Period2.Company_Id = iiCompanyId AND
Period2.Period_ID = ConsolidPeriodXref.Period_ID AND
Period2.PeriodYear = iiSourceYear AND
Period2.PeriodPeriod = iiSourcePeriod

query sort order

Company.ConsolidCompanyCode (ascending)
Period2.PeriodYear (ascending)
Period2.PeriodPeriod (ascending)

query resultset tqConsolidPeriodXrefByPeriod

field name	data type	db field	description
tiConsolidationCompany_ID	integer	ConsolidPeriodXref.ConsolidationCompany_ID	Consolidation Entity
tiConsolidationPeriod_ID	integer	ConsolidPeriodXref.ConsolidationPeriod_ID	Consolidation Period
ttConsolidPeriodEndDate	date	Period1.PeriodEndDate	End Date
ttConsolidPeriodStartDate	date	Period1.PeriodStartDate	Start Date
tiConsolidPeriodXref_ID	integer	ConsolidPeriodXref.ConsolidPeriodXref_ID	Record ID
tiPeriod_ID	integer	Period1.Period_ID	Record ID
tlPeriodIsPostingGLAllowed	logical	Period2.PeriodIsPostingGLAllowed	GL
tcConsolidCompanyCode	character	Company.CompanyCode	Entity Code
tiPeriodYear	integer	Period2.PeriodYear	GL Calendar Year
tiPeriodPeriod	integer	Period2.PeriodPeriod	GL Period
tiConsolidPeriodYear	integer	Period1.PeriodYear	GL Calendar Year
tiConsolidPeriodPeriod	integer	Period1.PeriodPeriod	GL Period
tiCompany_ID	integer	ConsolidPeriodXref.Company_ID	Link to Company
tiSourcePeriod_ID	integer	ConsolidPeriodXref.Period_ID	Source GL Period
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(ConsolidPeriodXref),rowid(Company),rowid(Period1),rowid(Period2)

Internal usage

QadFinancials

method BConsolid.AdditionalUpdatesConsolidationBlock
method BConsolid.CheckPreviousPeriod
method BConsolid.ValidateComponentPost
method BConsolid.ValidateComponentPostSub1
method BConsolidPeriodXref.ApiGetConsolidPeriods
method BConsolidPeriodXref.ApiSetConsolidPeriods