project QadFinancials > class BPeriod > business logic query PeriodNextPeriodByYearPeriod

Description

Return the next periods.
A period is considered as 'next' when it is not a YC period and when the YearPeriod is greater then the input YearPeriod.


Parameters


iiCompanyIdintegerCompany id
iiPeriodYearintegerPass the year
iiPeriodPeriodintegerPass the Period


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodTypeCode <> {&PERIODTYPECODE-YEARCLOSING} AND
Period.PeriodYearPeriod > iiPeriodYear * 100 + iiPeriodPeriod


query sort order


Period.Company_ID (ascending)
Period.PeriodYear (ascending)
Period.PeriodPeriod (ascending)


query resultset tqPeriodNextPeriodByYearPeriod


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriod_IDintegerPeriod.Period_IDRecord ID
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date


Internal usage


QadFinancials
method BConsolidDump.InitialValues
method BGLReport.CalculateMeasureDateforIS
method BGLReport.FindWholePeriodRange
method BGLReport.GetCorrectMeasureDateForIS
method BJournalEntry.DefaultValuesPostingAutoReversalDate
method BRecurringEntry.GetNextPeriod
method BRevaluation.AdditionalUpdatesPostingCreate