project QadFinancials > class BConsolidPeriodXref > business logic query ConsolidPeriodXrefByPeriod


Parameters


iiCompanyIdintegerCompany id
iiConsolidCompanyIDinteger
icConsolidCompanyCodecharacter
iiSourceYearinteger
iiSourcePeriodinteger
iiTargetYearinteger
iiTargetPeriodinteger


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 namedata typedb fielddescription
tiConsolidationCompany_IDintegerConsolidPeriodXref.ConsolidationCompany_IDConsolidation Entity
tiConsolidationPeriod_IDintegerConsolidPeriodXref.ConsolidationPeriod_IDConsolidation Period
ttConsolidPeriodEndDatedatePeriod1.PeriodEndDateEnd Date
ttConsolidPeriodStartDatedatePeriod1.PeriodStartDateStart Date
tiConsolidPeriodXref_IDintegerConsolidPeriodXref.ConsolidPeriodXref_IDRecord ID
tiPeriod_IDintegerPeriod1.Period_IDRecord ID
tlPeriodIsPostingGLAllowedlogicalPeriod2.PeriodIsPostingGLAllowedGL
tcConsolidCompanyCodecharacterCompany.CompanyCodeEntity Code
tiPeriodYearintegerPeriod2.PeriodYearGL Calendar Year
tiPeriodPeriodintegerPeriod2.PeriodPeriodGL Period
tiConsolidPeriodYearintegerPeriod1.PeriodYearGL Calendar Year
tiConsolidPeriodPeriodintegerPeriod1.PeriodPeriodGL Period
tiCompany_IDintegerConsolidPeriodXref.Company_IDLink to Company
tiSourcePeriod_IDintegerConsolidPeriodXref.Period_IDSource GL Period
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = 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