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