project QadFinancials > class BPeriod > business logic query PeriodPrim
Description
query that can be used find period based on the prim-key or based on the logical, unique key
Parameters
| iiCompanyId | integer | Company id |
| iiPeriodId | integer | |
| iiPeriodYear | integer | Year of the period |
| iiPeriodPeriod | integer | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod
query resultset tqPeriodPrim
| 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 |
Internal usage
QadFinancials