project QadFinancials > class BDivision > business logic query DivisionByMatchingDivisionCode
Description
GLByMatchingGLCode; query that returns the Code and ID of Divisions and that has a condition on Code with the matching operator.
Parameters
| iiCompanyId | integer | Company id |
| icDivisionCode | character | DivisionCode that is in the condition with the matches-operator |
query condition
each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.DivisionCode matches icDivisionCode
query resultset tqDivisionByMatchingDivisionCode
| field name | data type | db field | description |
|---|
| tiDivision_ID | integer | Division.Division_ID | Record ID |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
Internal usage
QadFinancials