business logic query BudgetPeriodByBudgetIDDate

Description

BudgetPeriodByBudgetIDDate; query on tabole BudgetPeriod
Sorted by BudgetPeriodSeq

Parameters

iiBudgetID	integer	Budget ID
iiBudgetPeriodID	integer	BudgetPeriodID
itEnclosedDate	date	FromDate <= <parameter> <= ToDate

query condition

each BudgetPeriod where

BudgetPeriod.Budget_ID = iiBudgetID AND
BudgetPeriod.BudgetPeriod_ID = iiBudgetPeriodID AND
BudgetPeriod.BudgetPeriodFromDate <= itEnclosedDate AND
BudgetPeriod.BudgetPeriodTillDate >= itEnclosedDate

query sort order

BudgetPeriod.BudgetPeriodSeq (ascending)

query resultset tqBudgetPeriodByBudgetIDDate

field name	data type	db field	description
tiBudget_ID	integer	BudgetPeriod.Budget_ID	Link to Budget
tiBudgetPeriod_ID	integer	BudgetPeriod.BudgetPeriod_ID	Record ID
tcBudgetPeriodCode	character	BudgetPeriod.BudgetPeriodCode	Period Code
tiBudgetPeriodSeq	integer	BudgetPeriod.BudgetPeriodSeq	GL Period Seq
ttBudgetPeriodFromDate	date	BudgetPeriod.BudgetPeriodFromDate	Start Date
ttBudgetPeriodTillDate	date	BudgetPeriod.BudgetPeriodTillDate	End Date

Internal usage

QadFinancials

method BBudget.ApiCheckBudget
method BBudget.BudgetCheckInfoResolve
method BBudget.BudgetCheckInfoResolveQueryStart
method BBudget.BudgetCheckInfoResolveQueryStop
method BBudgetRebuild.ApiRebuildBudgetPartTwo