project QadFinancials > class BJournal > business logic query JournalByJournalCodeWithLayer


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacterJournalCode


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode = icJournalCode

      first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND


query resultset tqJournalByJournalCodeWithLayer


field namedata typedb fielddescription
tiJournal_IDintegerJournal.Journal_IDRecord ID
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalControlcharacterJournal.JournalControlA type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source.
tlJournalIsActivelogicalJournal.JournalIsActiveIndicate if this is an active daybook.
api annotation:Value for this field defaults to false.
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tcLayerCodecharacterLayer.LayerCodeLayer Code
tlLayerIsActivelogicalLayer.LayerIsActiveActive
tlLayerIsAddGLNbrlogicalLayer.LayerIsAddGLNbrUse Additional GL Numbering
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BPosting.AdditionalUpdatesPreAddGLNumberDet
method BPosting.ApiMassDeletePeriodicCostingPostings
method BPosting.ApiMassDeletePeriodicCostingPostingsByDomain
method BPosting.ApiMassReversePeriodicCostingPostings
method BPosting.ApiMassReversePeriodicCostingPostingsByDomain