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