project QadFinancials > class BBudget > 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


iiBudgetIDintegerBudget ID
iiBudgetWBSIDintegerBudgetWBSID
icBudgetWBSCodecharacterBudgetWBSCode
iiParentBudgetWBSIDintegerParentBudgetWBSID
icBudgetFDSTypecharacterBudgetFDSType
iiSafStructureIDintegerSafStructureID
iiSafConceptIDintegerSafConceptId
iiBudgetFDSIDintegerBudgetFDSID


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 namedata typedb fielddescription
tiBudget_IDintegerBudgetWBS.Budget_IDLink to Budget
tiBudgetFDS_IDintegerBudgetWBS.BudgetFDS_IDLink to BudgetFDS
tiBudgetFDSSeqintegerBudgetWBS.BudgetFDSSeqCOA Sequence
tcBudgetFDSTypecharacterBudgetWBS.BudgetFDSTypeCOA Type
tiBudgetGroup_IDintegerBudgetWBS.BudgetGroup_IDBudget Group
tiBudgetWBS_IDintegerBudgetWBS.BudgetWBS_IDRecord ID
tcBudgetWBSCodecharacterBudgetWBS.BudgetWBSCodeWBS Code
tcBudgetWBSCostRevenuecharacterBudgetWBS.BudgetWBSCostRevenueCost/Revenue
tcBudgetWBSCostTypecharacterBudgetWBS.BudgetWBSCostTypeCost Type
tcBudgetWBSFDSCodecharacterBudgetWBS.BudgetWBSFDSCodeCOA Code
tcBudgetWBSFDSDefaultcharacterBudgetWBS.BudgetWBSFDSDefaultCOA Default
tcBudgetWBSFDSFromCodecharacterBudgetWBS.BudgetWBSFDSFromCodeFrom COA
tcBudgetWBSFDSListcharacterBudgetWBS.BudgetWBSFDSListCOA List
tcBudgetWBSFDSToCodecharacterBudgetWBS.BudgetWBSFDSToCodeTo COA
tcBudgetWBSOverrunPeriodcharacterBudgetWBS.BudgetWBSOverrunPeriodGL Period Overrun
tcBudgetWBSOverrunTotalcharacterBudgetWBS.BudgetWBSOverrunTotalTotal Overrun
tcBudgetWBSOverrunYTDcharacterBudgetWBS.BudgetWBSOverrunYTDOverrun (YTD)
tdBudgetWBSPercOfCompdecimalBudgetWBS.BudgetWBSPercOfCompPercentage (ETC)
tdBudgetWBSSeqdecimalBudgetWBS.BudgetWBSSeqWBS Seq
tcBudgetWBSStatuscharacterBudgetWBS.BudgetWBSStatusStatus
tiParentBudgetWBS_IDintegerBudgetWBS.ParentBudgetWBS_IDLink to BudgetWBS
tiSafConcept_IDintegerBudgetWBS.SafConcept_IDSAF Concept Code
tiSafStructure_IDintegerBudgetWBS.SafStructure_IDSAF Structure
tiUnit_IDintegerBudgetWBS.Unit_IDGL Account Unit of Measure
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BudgetWBS)


Internal usage


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