project QadFinancials > class BPeriod > business logic query PeriodByYearPeriodForPrevStat
Description
Return the previous periods
A period is considered as 'prev' when it is not a YC period, and when the YearPeriod is greater then the input YearPeriod.
Parameters
| iiCompanyId | integer | Company id |
| iiPeriodPeriod | integer | |
| iiPeriodYear | integer | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodTypeCode <> {&PERIODTYPECODE-YEARCLOSING} AND
Period.PeriodYearPeriod < iiPeriodYear * 100 + iiPeriodPeriod AND
(Period.PeriodStatus <> {&PERIODSTATUS-REPORTED} AND
Period.PeriodStatus <> {&PERIODSTATUS-FROZEN} )
query resultset tqPeriodByYearPeriodForPrevStat
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| tlPeriodIsReportChecked | logical | Period.PeriodIsReportChecked | Checked/Reported |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
Internal usage
QadFinancials