project QadFinancials > class BJournal > business logic query JournalForJEDefault


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacter
icJournalControlcharacter
icJournalTypeCodecharacter


query condition


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

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


query resultset tqJournalForJEDefault


field namedata typedb fielddescription
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".
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type


Internal usage


QadFinancials
method BCInvoice.CreateMFPosting