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