project QadFinancials > class BDivision > business logic query DivisionForCOAMaskRangeSelect
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 | |
| icGLCode | character | Code of GL account |
| iiGLSharedSetId | integer | |
| 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 (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 name | data type | db field | description |
|---|
| tcBudgetGroupCode | character | BudgetGroup.BudgetGroupCode | Budget Group |
| tcCOAMaskDivGLFrom | character | COAMaskDivGL.COAMaskDivGLFrom | From |
| tlCOAMaskDivGLIsNeg | logical | COAMaskDivGL.COAMaskDivGLIsNeg | Disallowed Range |
| tcCOAMaskDivGLTo | character | COAMaskDivGL.COAMaskDivGLTo | To |
| 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 |
| tiGLSharedSet_ID | integer | COAMaskDivGL.GLSharedSet_ID | Shared Set |
| 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