project QadFinancials > class BDivision > business logic query DivisionForCOAMask
Description
Get Sub-account COA Mask for Sub-account
Parameters
| iiCompanyId | integer | Company id |
| iiDivisionId | integer | ID of the division ofr which COA Mask should be retrieved |
| icDivisionCode | character | Code of Sub-account for which COA Mask should be retreived |
| ilCOAMaskDivActive | logical | Active COA Mask |
query condition
each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = iiDivisionId AND
Division.DivisionCode = icDivisionCode
each ProfileLink (inner-join) where
ProfileLink.Profile_ID = Division.COAMaskDivProfile_ID AND
first COAMaskDiv (inner-join) where
COAMaskDiv.SharedSet_Id = vi_SUBACCOUNTCOAMASK_sharedset(iiCompanyId) AND
COAMaskDiv.COAMaskDiv_ID = ProfileLink.ProfileLinkObject_ID AND
COAMaskDiv.COAMaskDivIsActive = ilCOAMaskDivActive
query resultset tqDivisionForCOAMask
| field name | data type | db field | description |
|---|
| tiCOAMaskDiv_ID | integer | COAMaskDiv.COAMaskDiv_ID | COA Mask Sub-Account |
| tcCOAMaskDivCode | character | COAMaskDiv.COAMaskDivCode | Sub-Account COA Mask Code |
| tlCOAMaskDivIsActive | logical | COAMaskDiv.COAMaskDivIsActive | Active |
| tiCOAMaskDivProfile_ID | integer | Division.COAMaskDivProfile_ID | COA Mask Profile |
| tiDivision_ID | integer | Division.Division_ID | Record ID |
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tiSharedSet_ID | integer | COAMaskDiv.SharedSet_ID | Shared Set |
Internal usage
QadFinancials