project QadFinancials > class BDivision > business logic query DivisionForCOAMaskSelect

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
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 (outer-join) where
ProfileLink.Profile_ID = Division.COAMaskDivProfile_ID AND
ProfileLink.SharedSet_ID = iiCOAMaskDivSharedSetId


query resultset tqDivisionForCOAMaskSelect


field namedata typedb fielddescription
tcBudgetGroupCodecharacterBudgetGroup.BudgetGroupCodeBudget Group
tiCOAMaskDivProfile_IDintegerDivision.COAMaskDivProfile_IDCOA Mask Profile
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcDivisionDescriptioncharacterDivision.DivisionDescriptionDescription
tlDivisionIsActivelogicalDivision.DivisionIsActiveActive
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