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