business logic query BudgetLinkAccByPeriodWBS

Description

BudgetLinkAccByPeriodWBS; query that returns information about the AccPeriod for a budget.

Parameters

iiBudget_ID	integer
iiPeriod_ID	integer
iiBudgetWBS_ID	integer
iiLayer_ID	integer	ID of layer for which values are calculated

query condition

each BudgetLinkAcc where

BudgetLinkAcc.Budget_ID = iiBudget_ID AND
BudgetLinkAcc.BudgetWBS_ID = iiBudgetWBS_ID AND
BudgetLinkAcc.Period_ID = iiPeriod_ID AND
BudgetLinkAcc.Layer_ID = iiLayer_ID

query resultset tqBudgetLinkAccByPeriodWBS

field name	data type	db field	description
tiBudget_ID	integer	BudgetLinkAcc.Budget_ID	Link to Budget
tiBudgetLinkAcc_ID	integer	BudgetLinkAcc.BudgetLinkAcc_ID	Record ID
tdBudgetLinkAccCreditLC	decimal	BudgetLinkAcc.BudgetLinkAccCreditLC	BC Credit
tdBudgetLinkAccDebitLC	decimal	BudgetLinkAcc.BudgetLinkAccDebitLC	BC Debit
tdBudgetLinkAccQTY	decimal	BudgetLinkAcc.BudgetLinkAccQTY	Qty
tiBudgetWBS_ID	integer	BudgetLinkAcc.BudgetWBS_ID	Link to BudgetWBS
tiLayer_ID	integer	BudgetLinkAcc.Layer_ID	Link to Layer
tiPeriod_ID	integer	BudgetLinkAcc.Period_ID	Link to Period
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BudgetLinkAcc)

Internal usage

QadFinancials

method BBudgetLinkAcc.ApiCreateOrUpdateBudgetLinkAcc