business logic query ReportPeriodByAllInfo

Description

ReportPeriodByAllInfo; query with parameters for every field and with all equal-operators

Parameters

iiReportPeriodID	integer	ReportPeriod
iiReportPeriodYear	integer	ReportPeriodYear
iiReportPeriodPeriod	integer	ReportPeriodPeriod
itReportPeriodStartDate	date	ReportPeriodStartDate
itReportPeriodEndDate	date	ReportPeriodEndDate
ilReportPeriodIsReported	logical	ReportPeriodIsReported

query condition

each ReportPeriod where

ReportPeriod.ReportPeriod_ID = iiReportPeriodID AND
ReportPeriod.ReportPeriodYear = iiReportPeriodYear AND
ReportPeriod.ReportPeriodPeriod = iiReportPeriodPeriod AND
ReportPeriod.ReportPeriodStartDate = itReportPeriodStartDate AND
ReportPeriod.ReportPeriodEndDate = itReportPeriodEndDate AND
ReportPeriod.ReportPeriodIsReported = ilReportPeriodIsReported

query sort order

ReportPeriod.ReportPeriodYear (ascending)
ReportPeriod.ReportPeriodPeriod (ascending)

query resultset tqReportPeriodByAllInfo

field name	data type	db field	description
tiReportPeriod_ID	integer	ReportPeriod.ReportPeriod_ID	Record ID
tiReportPeriodYear	integer	ReportPeriod.ReportPeriodYear	Year
tiReportPeriodPeriod	integer	ReportPeriod.ReportPeriodPeriod	GL Period
ttReportPeriodStartDate	date	ReportPeriod.ReportPeriodStartDate	Start Date
ttReportPeriodEndDate	date	ReportPeriod.ReportPeriodEndDate	End Date
tlReportPeriodIsReported	logical	ReportPeriod.ReportPeriodIsReported	Reported
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(ReportPeriod)

Internal usage

QadFinancials

method BBudget.CalculateBudgetWBS
method BReportPeriod.AdditionalUpdates
method BReportPeriod.APIGetStartAndEndDate
method BReportPeriod.DataLoadMultiple
method BReportPeriod.DataNewMultipleCopyPeriodYear
method BReportPeriod.DefaultValues