project QadFinancials > class BDivision > business logic query DivisionForCOAMask

Description

Get Sub-account COA Mask for Sub-account


Parameters


iiCompanyIdintegerCompany id
iiDivisionIdintegerID of the division ofr which COA Mask should be retrieved
icDivisionCodecharacterCode of Sub-account for which COA Mask should be retreived
ilCOAMaskDivActivelogicalActive 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 namedata typedb fielddescription
tiCOAMaskDiv_IDintegerCOAMaskDiv.COAMaskDiv_IDCOA Mask Sub-Account
tcCOAMaskDivCodecharacterCOAMaskDiv.COAMaskDivCodeSub-Account COA Mask Code
tlCOAMaskDivIsActivelogicalCOAMaskDiv.COAMaskDivIsActiveActive
tiCOAMaskDivProfile_IDintegerDivision.COAMaskDivProfile_IDCOA Mask Profile
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tiSharedSet_IDintegerCOAMaskDiv.SharedSet_IDShared Set


Internal usage


QadFinancials
method BDivision.Calculate