project QadFinancials > class BPeriod > business logic query PeriodForOldestOpenPeriod
Parameters
query condition
each Period where
Period.Company_ID = iiCompanyID AND
Period.PeriodStatus = {&PERIODSTATUS-OPEN}
query sort order
Period.PeriodYear (ascending)
Period.PeriodPeriod (ascending)
query resultset tqPeriodForOldestOpenPeriod
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
Internal usage
QadFinancials