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