project QadFinancials > class BPeriod > business logic query PeriodByCyYearTypeStatus
Description
PeriodByCyYearTypeStatus
Parameters
| iiCompanyId | integer | Company id |
| iiPeriodYear | integer | Period Year |
| icPeriodTypeCode | character | PeriodTypeCode |
| icPeriodStatus | character | Period Status |
| icPeriodStatusNot | character | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodTypeCode = icPeriodTypeCode AND
Period.PeriodStatus = icPeriodStatus AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodStatus <> icPeriodStatusNot
query sort order
Period.Company_ID (ascending)
Period.PeriodYear (ascending)
Period.PeriodPeriod (ascending)
query resultset tqPeriodByCyYearTypeStatus
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Period) |
Internal usage
QadFinancials