project QadFinancials > class BDivision > business logic query DivisionForCOAMaskRangeSelect

Description

This query is used by query procedure for COA Mask intelligent lookup.


Parameters


iiCompanyIdintegerCompany id
icDivisionCodeEqualcharacter
icDivisionCodeNotEqualcharacter
icDivisionCodeTocharacter
icDivisionCodeFromcharacter
icDivisionCodeMatchescharacter
iiCOAMaskDivSharedSetIdinteger
icDivisionDescEqcharacter
icDivisionDescNotEqcharacter
icDivisionDescFromcharacter
icDivisionDescTocharacter
icDivisionDescMatchescharacter
icBudgetGroupEqcharacter
icBudgetGroupNotEqcharacter
icBudgetGroupFromcharacter
icBudgetGroupTocharacter
icBudgetGroupMatchescharacter
icGLCodecharacterCode of GL account
iiGLSharedSetIdinteger
ilDivisionIsActivelogical


query condition


  each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.DivisionCode = icDivisionCodeEqual AND
Division.DivisionCode <> icDivisionCodeNotEqual AND
Division.DivisionCode matches icDivisionCodeMatches AND
Division.DivisionCode <= icDivisionCodeTo AND
Division.DivisionCode >= icDivisionCodeFrom AND
Division.DivisionDescription = icDivisionDescEq AND
Division.DivisionDescription <> icDivisionDescNotEq AND
Division.DivisionDescription matches icDivisionDescMatches AND
Division.DivisionDescription <= icDivisionDescTo AND
Division.DivisionDescription >= icDivisionDescFrom AND
Division.DivisionIsActive = ilDivisionIsActive

      first BudgetGroup (conditional-join) where
BudgetGroup.BudgetGroup_ID = Division.BudgetGroup_ID AND
BudgetGroup.BudgetGroupCode = icBudgetGroupEq AND
BudgetGroup.BudgetGroupCode <> icBudgetGroupNotEq AND
BudgetGroup.BudgetGroupCode <= icBudgetGroupTo AND
BudgetGroup.BudgetGroupCode >= icBudgetGroupFrom AND
BudgetGroup.BudgetGroupCode matches icBudgetGroupMatches

      each ProfileLink (inner-join) where
ProfileLink.Profile_ID = Division.COAMaskDivProfile_ID AND
ProfileLink.SharedSet_ID = iiCOAMaskDivSharedSetId

          first COAMaskDiv (inner-join) where
COAMaskDiv.SharedSet_Id = vi_SUBACCOUNTCOAMASK_sharedset(iiCompanyId) AND
COAMaskDiv.COAMaskDiv_ID = ProfileLink.ProfileLinkObject_ID AND

              each COAMaskDivGL (inner-join) where
COAMaskDivGL.COAMaskDiv_ID = COAMaskDiv.COAMaskDiv_ID AND
((COAMaskDivGL.COAMaskDivGLFrom = ? AND
COAMaskDivGL.COAMaskDivGLTo = ? ) OR
(COAMaskDivGL.COAMaskDivGLFrom <= icGLCode AND
COAMaskDivGL.COAMaskDivGLTo >= icGLCode ) OR
(COAMaskDivGL.COAMaskDivGLFrom = ? AND
COAMaskDivGL.COAMaskDivGLTo >= icGLCode ) OR
(COAMaskDivGL.COAMaskDivGLFrom <= icGLCode AND
COAMaskDivGL.COAMaskDivGLTo = ? )) AND
COAMaskDivGL.GLSharedSet_ID = iiGLSharedSetId


query resultset tqDivisionForCOAMaskRangeSelect


field namedata typedb fielddescription
tcBudgetGroupCodecharacterBudgetGroup.BudgetGroupCodeBudget Group
tcCOAMaskDivGLFromcharacterCOAMaskDivGL.COAMaskDivGLFromFrom
tlCOAMaskDivGLIsNeglogicalCOAMaskDivGL.COAMaskDivGLIsNegDisallowed Range
tcCOAMaskDivGLTocharacterCOAMaskDivGL.COAMaskDivGLToTo
tiCOAMaskDivProfile_IDintegerDivision.COAMaskDivProfile_IDCOA Mask Profile
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcDivisionDescriptioncharacterDivision.DivisionDescriptionDescription
tlDivisionIsActivelogicalDivision.DivisionIsActiveActive
tiGLSharedSet_IDintegerCOAMaskDivGL.GLSharedSet_IDShared Set
tiProfileLink_IDintegerProfileLink.ProfileLink_IDRecord ID
tiProfileLinkSharedSet_IDintegerProfileLink.SharedSet_IDLink to SharedSet
tiSharedSet_IDintegerDivision.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BDivision.ApiSelectDivisionCOAMask
method BDivision.ApiSelectDivisionCOAMaskEnt