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