project QadFinancials > class BJournal > business logic query JournalBeginsForJEDefault

Description

This query returns some journal information based on the beginning of a journal code, journal control and journal type.


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacter
icJournalControlcharacter
icJournalTypeCodecharacter


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode begins icJournalCode AND
Journal.JournalControl = icJournalControl AND
Journal.JournalTypeCode = icJournalTypeCode

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


query resultset tqJournalBeginsForJEDefault


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.
tcJournalSecondDescriptioncharacterJournal.JournalSecondDescriptionSecond Description
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type


Internal usage


QadFinancials
method BCInvoice.DefaultValuesCAJournal
method BCInvoice.DefaultValuesJournal
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport
method BDInvoice.CreateDInvoices
method BDInvoice.CreateFinChgInvoices
method BDInvoice.DefaultValuesDAJournal
method BDInvoice.DefaultValuesInvoiceType
method BDInvoice.DefaultValuesJournal
method BDInvoice.DefaultValuesLinkedInvoice
method BDInvoice.DefaultValuesVoucher
method BDInvoice.ExitInstance
method BDInvoice.PreSave
method BGLOpenItemProcessor.DefaultValuesJournal
method BJournalEntry.DefaultValuesYearJournal