project QadFinancials > class BDivision > business logic query DivisionBySSOthers
Description
DivisionBySSOthers; query on main-table with from/to filter-values on Code , matching filter-value on Code, Equal filter-value on code, filter-value for BudgetGroupID and a filter-value for the SaherdSet.
Parameters
| iiCompanyId | integer | Company id |
| iiDivisionSharedSetID | integer | DivisionSharedSetID |
| icFromDivisionCode | character | FromDivisionCode |
| icToDivisionCode | character | ToDivisionCode |
| icMatchingDivisionCode | character | MatchingDivisionCode |
| icDivisionCode | character | Sub-Account Code |
| iiBudgetGroupID | integer | BudgetGroupID |
query condition
each Division where
Division.SharedSet_ID = iiDivisionSharedSetID AND
Division.DivisionCode >= icFromDivisionCode AND
Division.DivisionCode <= icToDivisionCode AND
Division.DivisionCode = icDivisionCode AND
Division.DivisionCode matches icMatchingDivisionCode AND
Division.BudgetGroup_ID = iiBudgetGroupID
query resultset tqDivisionBySSOthers
| field name | data type | db field | description |
|---|
| tiBudgetGroup_ID | integer | Division.BudgetGroup_ID | Link to BudgetGroup |
| tiDivision_ID | integer | Division.Division_ID | Record ID |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tcDivisionDescription | character | Division.DivisionDescription | Description |
| tiSharedSet_ID | integer | Division.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials