project QadFinancials > class BReportPeriod > business logic query ReportPeriodByDate

Description

ReportPeriodByDate; query that returns the record is contained by the input-paramater (itDate)


Parameters


itDatedateDate that is >= start-date and <= the end-dat of the returned period.


query condition


  each ReportPeriod where
ReportPeriod.ReportPeriodStartDate <= itDate AND
ReportPeriod.ReportPeriodEndDate >= itDate


query sort order


ReportPeriod.ReportPeriodStartDate (ascending)


query resultset tqReportPeriodByDate


field namedata typedb fielddescription
tiReportPeriod_IDintegerReportPeriod.ReportPeriod_IDRecord ID
ttReportPeriodStartDatedateReportPeriod.ReportPeriodStartDateStart Date
ttReportPeriodEndDatedateReportPeriod.ReportPeriodEndDateEnd Date
tiReportPeriodYearintegerReportPeriod.ReportPeriodYearYear
tiReportPeriodPeriodintegerReportPeriod.ReportPeriodPeriodGL Period
tlReportPeriodIsReportedlogicalReportPeriod.ReportPeriodIsReportedReported


Internal usage


QadFinancials
method BBudget.InitialValues