project QadFinancials > class BBudget > business logic query BudgetWBSByWBSIDSAF

Description

BudgetWBSByWBSIDSAF; returns all saf-information based on the WBSID


Parameters


iiBudgetWBSIDintegerBudgetWBSID


query condition


  each BudgetWBS where
BudgetWBS.BudgetWBS_ID = iiBudgetWBSID

      first SafConcept (inner-join) where
SafConcept.SafConcept_ID = BudgetWBS.SafConcept_ID AND

      first SafStructure (inner-join) where
SafStructure.SafStructure_ID = BudgetWBS.SafStructure_ID AND


query resultset tqBudgetWBSByWBSIDSAF


field namedata typedb fielddescription
tiBudgetFDSSeqintegerBudgetWBS.BudgetFDSSeqCOA Sequence
tcBudgetFDSTypecharacterBudgetWBS.BudgetFDSTypeCOA Type
tiBudgetFDS_IDintegerBudgetWBS.BudgetFDS_IDLink to BudgetFDS
tcBudgetWBSCodecharacterBudgetWBS.BudgetWBSCodeWBS Code
tcBudgetWBSFDSDefaultcharacterBudgetWBS.BudgetWBSFDSDefaultCOA Default
tiBudgetWBS_IDintegerBudgetWBS.BudgetWBS_IDRecord ID
tiBudget_IDintegerBudgetWBS.Budget_IDLink to Budget
tiParentBudgetWBS_IDintegerBudgetWBS.ParentBudgetWBS_IDLink to BudgetWBS
tiSafConcept_IDintegerBudgetWBS.SafConcept_IDSAF Concept Code
tiSafStructure_IDintegerBudgetWBS.SafStructure_IDSAF Structure
tcSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code


Internal usage


QadFinancials
method BBudget.ApiGetBudgetWBSSafInfoDetails