business logic query BudgetFDSByBudgetIDPropAlloc

Description

This query retrieves BudgetFDS record for the budget, which can be used for proportional allocation.

iiBudgetID

integer

each BudgetFDS where

BudgetFDS.Budget_ID = iiBudgetID AND
BudgetFDS.BudgetFDSIsAllocationTotal = true

field name	data type	db field	description
tiBudget_ID	integer	BudgetFDS.Budget_ID	Link to Budget
tiBudgetFDS_ID	integer	BudgetFDS.BudgetFDS_ID	Record ID
tlBudgetFDSIsAllocationTotal	logical	BudgetFDS.BudgetFDSIsAllocationTotal	Used for Proportional Allocation
tiBudgetFDSSeq	integer	BudgetFDS.BudgetFDSSeq	WBS Level
tcBudgetFDSType	character	BudgetFDS.BudgetFDSType	COA Element
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BudgetFDS)

QadFinancials