project QadFinancials > class BDivision > business logic query DivisionForCOAMaskSelect
Description
This query is used by query procedure for COA Mask intelligent lookup.
Parameters
iiCompanyId | integer | Company id |
icDivisionCodeEqual | character | |
icDivisionCodeNotEqual | character | |
icDivisionCodeTo | character | |
icDivisionCodeFrom | character | |
icDivisionCodeMatches | character | |
iiCOAMaskDivSharedSetId | integer | |
icDivisionDescEq | character | |
icDivisionDescNotEq | character | |
icDivisionDescFrom | character | |
icDivisionDescTo | character | |
icDivisionDescMatches | character | |
icBudgetGroupEq | character | |
icBudgetGroupNotEq | character | |
icBudgetGroupFrom | character | |
icBudgetGroupTo | character | |
icBudgetGroupMatches | character | |
ilDivisionIsActive | logical | |
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 name | data type | db field | description |
tcBudgetGroupCode | character | BudgetGroup.BudgetGroupCode | Budget Group |
tiCOAMaskDivProfile_ID | integer | Division.COAMaskDivProfile_ID | COA Mask Profile |
tiDivision_ID | integer | Division.Division_ID | Record ID |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tcDivisionDescription | character | Division.DivisionDescription | Description |
tlDivisionIsActive | logical | Division.DivisionIsActive | Active |
tiProfileLink_ID | integer | ProfileLink.ProfileLink_ID | Record ID |
tiProfileLinkSharedSet_ID | integer | ProfileLink.SharedSet_ID | Link to SharedSet |
tiSharedSet_ID | integer | Division.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials