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
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 tqPeriodNextPeriodByYearPeriod
field name | data type | db field | description |
tiCompany_ID | integer | Period.Company_ID | Link to Company |
tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
tiPeriod_ID | integer | Period.Period_ID | Record ID |
ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
Internal usage
QadFinancials