project QadFinancials > class BCreditorReport > business logic query PeriodByYearPeriodRange
Parameters
| iiCompanyId | integer | Company id |
| iiPeriodYearPeriodFrom | integer | |
| iiPeriodYearPeriodTo | integer | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod >= iiPeriodYearPeriodFrom AND
Period.PeriodYearPeriod <= iiPeriodYearPeriodTo
query resultset tqPeriodByYearPeriodRange
| field name | data type | db field | description |
|---|
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
Internal usage
QadFinancials