project QadFinancials > class BJournal > business logic query JournalByJournalCode

Description

This query returns some journal information based on journal code


Parameters


iiCompanyIdintegerPlease enter a good description for this parameter.
icJournalCodecharacterDaybook Code


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode = icJournalCode


query sort order


Journal.JournalCode (ascending)


query resultset tqJournalByJournalCode


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.
tcJournalDescriptioncharacterJournal.JournalDescriptionA brief description of the daybook.
api annotation:Value for this field defaults to null.
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".
tcJournalTypeCodeTrcharactercalculated
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BDeductionCat.ValidateComponent
method BDInvoice.GetJournalControl
method BDInvoice.ValidateComponentDInvoiceDIText
method BPosting.ApiStdMaintainTTSub1
method BPosting.StdMaintainTTSub1
method BMfgDaybookSetReport.DaybookSetReport
method BPeriod.ValidateComponentPre