project QadFinancials > class BJournal > business logic query JournalByMfgDaybook
Parameters
| iiCompanyId | integer | Company id |
| icDomainCode | character | |
| icLayerType | character | |
query condition
each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
each dyd_mstr (inner-join) where
dyd_mstr.dyd_domain = icDomainCode AND
dyd_mstr.dyd_dy_code = Journal.JournalCode
first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerType
query resultset tqJournalByMfgDaybook
| field name | data type | db field | description |
|---|
| tcdyd_domain | character | dyd_mstr.dyd_domain | Domain |
| tcdyd_dy_code | character | dyd_mstr.dyd_dy_code | Daybook |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
Internal usage
QadFinancials