project QadFinancials > class BCMask > business logic query CMaskJournalByCmaskByJrnlCtrl
Parameters
| iiCMaskId | integer | Daybook mask id. |
| icJournalControl | character | Daybook control |
| iiCompanyId | integer | Company id |
query condition
each CMaskJournal where
CMaskJournal.CMask_ID = iiCMaskID
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = CMaskJournal.Journal_ID AND
Journal.JournalControl = icJournalControl
query resultset tqCMaskJournalByCmaskByJrnlCtrl
| field name | data type | db field | description |
|---|
| tiCMask_ID | integer | CMaskJournal.CMask_ID | Link to CMask |
| tiCMaskJournal_ID | integer | CMaskJournal.CMaskJournal_ID | Record ID |
| tiJournal_ID | integer | CMaskJournal.Journal_ID | Link to Journal |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcJournalControl | character | Journal.JournalControl | A type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source. |
| tcJournalTypeCode | character | Journal.JournalTypeCode | A daybook type code. |
| api annotation: | | Value for this field defaults to "Journal Entries". |
Internal usage
QadFinancials