project QadFinancials > class BJournal > business logic query JournalByJournalTypeLayerType

Description

JournalByJournalTypeLayerType.


Parameters


iiCompanyIdinteger
icJournalTypeCodecharacterJournalTypeCode
icLayerCodecharacterLayer Code
ilJournalIsActivelogical


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalTypeCode = icJournalTypeCode AND
Journal.JournalIsActive = ilJournalIsActive

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


query resultset tqJournalByJournalTypeLayerType


field namedata typedb fielddescription
tlJournalIsActivelogicalJournal.JournalIsActiveIndicate if this is an active daybook.
api annotation:Value for this field defaults to false.
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet
tiJournal_IDintegerJournal.Journal_IDRecord ID
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalDescriptioncharacterJournal.JournalDescriptionA brief description of the daybook.
api annotation:Value for this field defaults to null.
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tiLayer_IDintegerLayer.Layer_IDRecord ID
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerDescriptioncharacterLayer.LayerDescriptionDescription


Internal usage


QadFinancials
method BJournal.PreValidateComponent
method BYearClosing.DefaultValuesLayer