project QadFinancials > class BDivision > business logic query DivisionForSharedSetMerge

Description

Get content of passed RedundantSharedSet and equivalent element by DivisionCode in passed MasterSharedSet.


Parameters


iiCompanyIdintegerCompany id
iiRedundantSharedSetIdinteger
iiMasterSharedSetIdinteger


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 namedata typedb fielddescription
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tiMasterDivision_IDintegerDivision2.Division_IDRecord ID
tiMasterSharedSet_IDintegerDivision2.SharedSet_IDLink to SharedSet
tiRedundantDivision_IDintegerDivision.Division_IDRecord ID
tiRedundantSharedSet_IDintegerDivision.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeInitLoadSharedSetData