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