business logic query BudgetWBSByAll

Description

BudgetWBSByAll;

DO NOT MAKE ANY CHANGE TO THIS QUERY; THIS SHOULD BE AS SIMPLE AS POSSIBLE BECAUSE IT IS USED BY THE BUDGET-RESOLVE (first contact KriLae/WouAnt in case you need a change)

Whenever a field gets added to the result-set of this query, the same shoudl be done for the temp-table data-item tBudgetWBSByAll (and it should be assigned/used accordingly in the program-code of course).

Parameters

iiBudgetID	integer	Budget ID
iiBudgetWBSID	integer	BudgetWBSID
icBudgetWBSCode	character	BudgetWBSCode
iiParentBudgetWBSID	integer	ParentBudgetWBSID
icBudgetFDSType	character	BudgetFDSType
iiSafStructureID	integer	SafStructureID
iiSafConceptID	integer	SafConceptId
iiBudgetFDSID	integer	BudgetFDSID

query condition

each BudgetWBS where

BudgetWBS.Budget_ID = iiBudgetID AND
BudgetWBS.BudgetWBS_ID = iiBudgetWBSID AND
BudgetWBS.BudgetWBSCode = icBudgetWBSCode AND
BudgetWBS.ParentBudgetWBS_ID = iiParentBudgetWBSID AND
BudgetWBS.BudgetFDSType = icBudgetFDSType AND
BudgetWBS.SafStructure_ID = iiSafStructureID AND
BudgetWBS.SafConcept_ID = iiSafConceptID and
BudgetWBS.BudgetFDS_ID = iiBudgetFDSID

query resultset tqBudgetWBSByAll

field name	data type	db field	description
tiBudget_ID	integer	BudgetWBS.Budget_ID	Link to Budget
tiBudgetFDS_ID	integer	BudgetWBS.BudgetFDS_ID	Link to BudgetFDS
tiBudgetFDSSeq	integer	BudgetWBS.BudgetFDSSeq	COA Sequence
tcBudgetFDSType	character	BudgetWBS.BudgetFDSType	COA Type
tiBudgetGroup_ID	integer	BudgetWBS.BudgetGroup_ID	Budget Group
tiBudgetWBS_ID	integer	BudgetWBS.BudgetWBS_ID	Record ID
tcBudgetWBSCode	character	BudgetWBS.BudgetWBSCode	WBS Code
tcBudgetWBSCostRevenue	character	BudgetWBS.BudgetWBSCostRevenue	Cost/Revenue
tcBudgetWBSCostType	character	BudgetWBS.BudgetWBSCostType	Cost Type
tcBudgetWBSFDSCode	character	BudgetWBS.BudgetWBSFDSCode	COA Code
tcBudgetWBSFDSDefault	character	BudgetWBS.BudgetWBSFDSDefault	COA Default
tcBudgetWBSFDSFromCode	character	BudgetWBS.BudgetWBSFDSFromCode	From COA
tcBudgetWBSFDSList	character	BudgetWBS.BudgetWBSFDSList	COA List
tcBudgetWBSFDSToCode	character	BudgetWBS.BudgetWBSFDSToCode	To COA
tcBudgetWBSOverrunPeriod	character	BudgetWBS.BudgetWBSOverrunPeriod	GL Period Overrun
tcBudgetWBSOverrunTotal	character	BudgetWBS.BudgetWBSOverrunTotal	Total Overrun
tcBudgetWBSOverrunYTD	character	BudgetWBS.BudgetWBSOverrunYTD	Overrun (YTD)
tdBudgetWBSPercOfComp	decimal	BudgetWBS.BudgetWBSPercOfComp	Percentage (ETC)
tdBudgetWBSSeq	decimal	BudgetWBS.BudgetWBSSeq	WBS Seq
tcBudgetWBSStatus	character	BudgetWBS.BudgetWBSStatus	Status
tiParentBudgetWBS_ID	integer	BudgetWBS.ParentBudgetWBS_ID	Link to BudgetWBS
tiSafConcept_ID	integer	BudgetWBS.SafConcept_ID	SAF Concept Code
tiSafStructure_ID	integer	BudgetWBS.SafStructure_ID	SAF Structure
tiUnit_ID	integer	BudgetWBS.Unit_ID	GL Account Unit of Measure
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BudgetWBS)

Internal usage

QadFinancials

method BBudget.BudgetCheckInfoResolve
method BBudget.BudgetCheckInfoResolveQueryStart
method BBudget.BudgetCheckInfoResolveQueryStop
method BBudget.CheckBudgetFDSWBS
method BBudget.CheckBudgetFDSwithWBSID
method BSafStructure.GetSafStructureIsReferenced