project QadFinancials > class BJournal > business logic query JournalByJournalTypeOIA

Description

JournalByJournalTypeLayerType.


Parameters


iiCompanyIdinteger
icJournalTypeCodecharacterJournalTypeCode
ilJournalIsActivelogical


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalTypeCode = icJournalTypeCode AND
Journal.JournalIsActive = ilJournalIsActive AND
Journal.JournalControl = {&JOURNALCONTROL-FINANCIAL}

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


query resultset tqJournalByJournalTypeOIA


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.
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcLayerCodecharacterLayer.LayerCodeLayer Code


Internal usage


QadFinancials
method BOpenItemAdjustment.GetDebtorAdjJournal