project QadFinancials > class BBudget > business logic query BudgetWBSByWBSIDSAF
Description
BudgetWBSByWBSIDSAF; returns all saf-information based on the WBSID
Parameters
| iiBudgetWBSID | integer | BudgetWBSID |
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 name | data type | db field | description |
|---|
| tiBudgetFDSSeq | integer | BudgetWBS.BudgetFDSSeq | COA Sequence |
| tcBudgetFDSType | character | BudgetWBS.BudgetFDSType | COA Type |
| tiBudgetFDS_ID | integer | BudgetWBS.BudgetFDS_ID | Link to BudgetFDS |
| tcBudgetWBSCode | character | BudgetWBS.BudgetWBSCode | WBS Code |
| tcBudgetWBSFDSDefault | character | BudgetWBS.BudgetWBSFDSDefault | COA Default |
| tiBudgetWBS_ID | integer | BudgetWBS.BudgetWBS_ID | Record ID |
| tiBudget_ID | integer | BudgetWBS.Budget_ID | Link to Budget |
| 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 |
| tcSafStructureCode | character | SafStructure.SafStructureCode | Structure Code |
| tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
Internal usage
QadFinancials