business logic query BudgetLinkByBudgetPerWBS

Description

BudgetLinkByBudgetPerWBS; query that returns information about the actuals and commitments for a budget.

Parameters

iiBudgetLinkID	integer	BudgetLinkID
iiBudgetID	integer	Budget ID
iiBudgetWBSID	integer	BudgetWBSID
iiFromBudgetPeriodID	integer	FromBudgetPeriodID
iiToBudgetPeriodID	integer	ToBudgetPeriodID

query condition

each BudgetLink where

BudgetLink.BudgetLink_ID = iiBudgetLinkID AND
BudgetLink.Budget_ID = iiBudgetID AND
BudgetLink.BudgetPeriod_ID >= iiFromBudgetPeriodID AND
BudgetLink.BudgetPeriod_ID <= iiToBudgetPeriodID AND
BudgetLink.BudgetWBS_ID = iiBudgetWBSID

query sort order

BudgetLink.BudgetLink_ID (ascending)

query resultset tqBudgetLinkByBudgetPerWBS

field name	data type	db field	description
tdBudgetLinkActualSalesQTY	decimal	BudgetLink.BudgetLinkActualSalesQTY	Sales Quantity
tdBudgetLinkActualSalesTC	decimal	BudgetLink.BudgetLinkActualSalesTC	Sales Amount
tiBudgetLink_ID	integer	BudgetLink.BudgetLink_ID	Record ID
tiBudget_ID	integer	BudgetLink.Budget_ID	Link to Budget
tiBudgetWBS_ID	integer	BudgetLink.BudgetWBS_ID	Link to BudgetWBS
tiBudgetPeriod_ID	integer	BudgetLink.BudgetPeriod_ID	Link to BudgetPeriod
tdBudgetLinkActualTC	decimal	BudgetLink.BudgetLinkActualTC	Amount
tdBudgetLinkActualQTY	decimal	BudgetLink.BudgetLinkActualQTY	Quantity
tdBudgetLinkCommitTC	decimal	BudgetLink.BudgetLinkCommitTC	Commitment Amount
tdBudgetLinkCommitQTY	decimal	BudgetLink.BudgetLinkCommitQTY	Commitment Quantity

Internal usage

QadFinancials

method BBudget.ApiCheckBudgetGetFigures
method BBudget.ApiGetBudgetWBSWithFiguresActualFig
method BBudget.CalculateBudgetWBS
method BBudget.ValidateComponentBudgetLinkFigure
method BBudgetLink.ApiCreateOrUpdateBudgetLink
method BBudgetLink.DeleteBudgetLinkByBudgetID