project QadFinancials > class BJournal > business logic query JournalByMfgDaybookSet
Parameters
| iiCompanyId | integer | Company id |
| icLayerType | character | |
| icdomainCode | character | |
query condition
each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
each dybs_mstr (inner-join) where
dybs_mstr.dybs_interco_dybk = Journal.JournalCode AND
dybs_mstr.dybs_domain = icdomainCode
first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerType
query resultset tqJournalByMfgDaybookSet
| field name | data type | db field | description |
|---|
| tcdybs_domain | character | dybs_mstr.dybs_domain | Domain |
| tcdybs_interco_dybk | character | dybs_mstr.dybs_interco_dybk | Intercompany Daybook |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
Internal usage
QadFinancials