project QadFinancials > class BDivision > business logic query DivisionForSharedSetMerge
Description
Get content of passed RedundantSharedSet and equivalent element by DivisionCode in passed MasterSharedSet.
Parameters
| iiCompanyId | integer | Company id |
| iiRedundantSharedSetId | integer | |
| iiMasterSharedSetId | integer | |
query condition
each Division where
Division.SharedSet_Id = iiRedundantSharedSetId
first Division2 (inner-join) where
Division2.DivisionCode = Division.DivisionCode AND
Division2.SharedSet_ID = iiMasterSharedSetId
query resultset tqDivisionForSharedSetMerge
| field name | data type | db field | description |
|---|
| tcDivisionCode | character | Division.DivisionCode | Sub-Account |
| tiMasterDivision_ID | integer | Division2.Division_ID | Record ID |
| tiMasterSharedSet_ID | integer | Division2.SharedSet_ID | Link to SharedSet |
| tiRedundantDivision_ID | integer | Division.Division_ID | Record ID |
| tiRedundantSharedSet_ID | integer | Division.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials