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