project QadFinancials > class BDebtorReport > business logic query PeriodFromTo

Description

PeriodFromTo


Parameters


iiCompanyIdintegerCompany id
iiFromPeriodYearintegerFromPeriodYear
iiToPeriodYearintegerToPeriodYear


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod >= iiFromPeriodYear AND
Period.PeriodYearPeriod <= iiToPeriodYear


query resultset tqPeriodFromTo


field namedata typedb fielddescription
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period


Internal usage


QadFinancials
method BDebtorReport.ValidateDateFilter