project QadFinancials > class BDivision > business logic query DivisionByCodeIsActive
Parameters
| iiCompanyId | integer | Company id |
| icDivisionCode | character | |
| ilIsActive | logical | |
query condition
each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.DivisionCode = icDivisionCode AND
Division.DivisionIsActive = ilIsActive
query resultset tqDivisionByCodeIsActive
| field name | data type | db field | description |
|---|
| tiDivision_ID | integer | Division.Division_ID | Record ID |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tlDivisionIsActive | logical | Division.DivisionIsActive | Active |
Internal usage
QadFinancials