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