project QadFinancials > class BJournal > business logic query JournalByJournalLayer

Description

JournalByJournalAndLayer


Parameters


iiCompanyIdinteger
icJournalCodecharacterDaybook Code
icCandoJournalTypeCodecharacterCandoJournalTypeCode
icLayerCodecharacterLayer Code
icCandoLayerTypeCodecharacterCandoLayerTypeCode
iiJournalIDinteger
ilJournalIsActivelogical


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode = icJournalCode AND
Journal.JournalTypeCode can-do icCandoJournalTypeCode AND
Journal.Journal_ID = iiJournalID AND
Journal.JournalIsActive = ilJournalIsActive

      first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerCode = icLayerCode AND
Layer.LayerTypeCode can-do icCandoLayerTypeCode


query resultset tqJournalByJournalAndLayer


field namedata typedb fielddescription
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.
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 BAPMatching.InitialValues
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport
method BERSProcessor.ERSProcessInit
method BJournalEntry.CreateRecEntryPostingReverse
method BJournalEntry.CreateReplaceEntry
method BJournalEntry.CreateReverseEntry
method BMirroringJournal.GetJournalInfo
method BMirroringJournal.ValidateComponentPre
method BOpenItemAdjustment.OIAdjCommitValidateOne
method BOpenItemAdjustment.OIAdjCreatePosting
method BRevaluation.AdditionalUpdatesPostingCreate
method BRevaluation.AdditionalUpdatesPostingCreateLines
method BYearClosing.ValidateComponentAllJournal
read related business field(s) on tMirroringJournal.SourceJournal_ID
read related business field(s) on tMirroringJournal.MirrorJournal_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tMirroringJournal.SourceJournal_ID
validate related business field(s) on tMirroringJournal.MirrorJournal_ID