project QadFinancials > class BJournal > business logic query JournalForSharedSetMerge

Description

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


Parameters


iiCompanyIdintegerCompany id
iiRedundantSharedSetIdinteger
iiMasterSharedSetIdinteger


query condition


  each Journal where
Journal.SharedSet_Id = iiRedundantSharedSetId

      first Journal2 (inner-join) where
Journal2.JournalCode = Journal.JournalCode AND
Journal2.SharedSet_ID = iiMasterSharedSetId


query resultset tqJournalForSharedSetMerge


field namedata typedb fielddescription
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiMasterJournal_IDintegerJournal2.Journal_IDRecord ID
tiMasterSharedSet_IDintegerJournal2.SharedSet_IDLink to SharedSet
tiRedundantJournal_IDintegerJournal.Journal_IDRecord ID
tiRedundantSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BSharedSetMerge.MergeInitLoadSharedSetData