project QadFinancials > class BMirroringJournal > business logic query MirroringJournalPrim
Description
This query returns the key fields per domain for the mirroring daybook Id and Mirroring daybook code.
Parameters
| iiCompanyId | integer | Company id |
| icSourceJournalCode | character | |
| icMirrorJournalCode | character | |
| iiDomainID | integer | |
| iiMirroringJournalID | integer | |
query condition
each MirroringJournal where
MirroringJournal.Company_Id = iiCompanyId AND
MirroringJournal.Domain_ID = iiDomainID AND
MirroringJournal.MirroringJournal_ID = iiMirroringJournalID
first Journal1 (inner-join) where
Journal1.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal1.Journal_ID = MirroringJournal.SourceJournal_ID AND
Journal1.JournalCode = icSourceJournalCode
first Journal2 (inner-join) where
Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = MirroringJournal.MirrorJournal_ID AND
Journal2.JournalCode = icMirrorJournalCode
query resultset tqMirroringJournalPrim
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | MirroringJournal.Company_ID | Entity |
| tiDomain_ID | integer | MirroringJournal.Domain_ID | Domain |
| tiMirroringJournal_ID | integer | MirroringJournal.MirroringJournal_ID | Record ID |
| tcMirrorJournalCode | character | Journal2.JournalCode | A daybook code (maximum eight characters). |
| tcSourceJournalCode | character | Journal1.JournalCode | A daybook code (maximum eight characters). |
Internal usage
QadFinancials