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