project QadFinancials > class BCreditorReport > business logic query PeriodByYearPeriodRange


Parameters


iiCompanyIdintegerCompany id
iiPeriodYearPeriodFrominteger
iiPeriodYearPeriodTointeger


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod >= iiPeriodYearPeriodFrom AND
Period.PeriodYearPeriod <= iiPeriodYearPeriodTo


query resultset tqPeriodByYearPeriodRange


field namedata typedb fielddescription
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period


Internal usage


QadFinancials
method BCreditorReport.CreditorAgeingABackwards