project QadFinancials > class BBudget > business logic query BudgetWBSBusComponentByIDs
Description
BudgetWBSBusComponentByIDs; query on BudgetWBS and its sub-table BudgetWBSBusComponent based on ID's
!!!! INNER-JOIN between BudgetWBS and BudgetWBSBusComponent
Parameters
| iiBudgetID | integer | Budget ID |
| iiBudgetWBSID | integer | BudgetWBSID |
| iiBusComponentID | integer | BusComponentID |
query condition
each BudgetWBS where
BudgetWBS.Budget_ID = iiBudgetID AND
BudgetWBS.BudgetWBS_ID = iiBudgetWBSID
each BudgetWBSBusComponent (inner-join) where
BudgetWBSBusComponent.BudgetWBS_ID = BudgetWBS.BudgetWBS_ID AND
BudgetWBSBusComponent.BusComponent_ID = iiBusComponentID
query resultset tqBudgetWBSBusComponentByIDs
| field name | data type | db field | description |
|---|
| tiBudget_ID | integer | BudgetWBS.Budget_ID | Link to Budget |
| tiBudgetWBS_ID | integer | BudgetWBS.BudgetWBS_ID | Record ID |
| tiBusComponent_ID | integer | BudgetWBSBusComponent.BusComponent_ID | Component |
| tiBudgetWBSBusComponent_ID | integer | BudgetWBSBusComponent.BudgetWBSBusComponent_ID | Record ID |
| tcBudgetWBSCode | character | BudgetWBS.BudgetWBSCode | WBS Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(BudgetWBS),rowid(BudgetWBSBusComponent) |
Internal usage
QadFinancials