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