project QadFinancials > class BJournal > business logic query JournalForSharedSetMerge
Description
Get content of passed RedundantSharedSet and equivalent element by JournalCode in passed MasterSharedSet.
Parameters
| iiCompanyId | integer | Company id |
| iiRedundantSharedSetId | integer | |
| iiMasterSharedSetId | integer | |
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 name | data type | db field | description |
|---|
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiMasterJournal_ID | integer | Journal2.Journal_ID | Record ID |
| tiMasterSharedSet_ID | integer | Journal2.SharedSet_ID | Link to SharedSet |
| tiRedundantJournal_ID | integer | Journal.Journal_ID | Record ID |
| tiRedundantSharedSet_ID | integer | Journal.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials