project QadFinancials > class BDebtorReport > business logic query PeriodFromTo
Description
PeriodFromTo
Parameters
| iiCompanyId | integer | Company id |
| iiFromPeriodYear | integer | FromPeriodYear |
| iiToPeriodYear | integer | ToPeriodYear |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod >= iiFromPeriodYear AND
Period.PeriodYearPeriod <= iiToPeriodYear
query resultset tqPeriodFromTo
| field name | data type | db field | description |
|---|
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
Internal usage
QadFinancials