business logic query PeriodPrevPeriodByYearPeriod

Description

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

Parameters

iiCompanyId	integer	Company id
iiPeriodYear	integer	Pass the year
iiPeriodPeriod	integer	Pass 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 tqPeriodPrevPeriodByYearPeriod

field name	data type	db field	description
tiCompany_ID	integer	Period.Company_ID	Link to Company
tiPeriod_ID	integer	Period.Period_ID	Record ID
ttPeriodEndDate	date	Period.PeriodEndDate	End Date
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
ttPeriodStartDate	date	Period.PeriodStartDate	Start Date
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
tiPeriodYearPeriod	integer	Period.PeriodYearPeriod	GL Calendar Year/GL Period

Internal usage

QadFinancials