project QadFinancials > class BJournal > business logic query JournalByJournalIDCodeType

Description

This query returns some journal information based on journal code, ID and type.


Parameters


iiCompanyIdintegerPlease enter a good description for this parameter.
iiJournalIDintegerJournalId
icJournalCodecharacterDaybook Code
icJournalTypeCodecharacterDaybook Type Code


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode = icJournalCode AND
Journal.Journal_ID = iiJournalID AND
Journal.JournalTypeCode = icJournalTypeCode


query sort order


Journal.JournalCode (ascending)


query resultset tqJournalByJournalIDCodeType


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.
tcJournalSecondDescriptioncharacterJournal.JournalSecondDescriptionSecond Description
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tiRole_IDintegerJournal.Role_IDLink to Role
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BAllocation.ValJournal
method BBankEntry.ValidateComponent
method BCInvoice.CreateCInvoiceMovementsCrossCyJrnl
method BCInvoice.ValidateComponentPostCAJournal
method BCInvoice.ValidateComponentPostJournal
method BCInvoiceJournalEntry.ApiStdMaintainTTSub
method BDInvoice.CreateDInvoiceMovementsCrossCyJrnl
method BDInvoice.ValidateComponentAll
method BDInvoice.ValidateComponentAllJournal
method BDInvoice.ValidateComponentAllLinkedInvoices
method BDInvoice.ValidateComponentAllPostDAJournalCode
method BExpenseNoteReport.ExpenseNote
method BFixedAssetBookType.ValidateComponent
method BFRWAnalysisCode.GetCOAElementDescription
method BGLOpenItemProcessor.GLOpenItemInitializationValidate
method BJournal.ApiValidateJournal
method BPosting.AdditionalUpdatesFACapital
method BPosting.ValidateComponentPostStopQueries
method BJournalEntry.GetPostingInfoByPostingLineID
method BJournalEntry.GetPostingInfoByPostingLineIDTT
method BMfgNRM.ApiReplicateFromFinancials
method BMfgNRM.UpdateMfgData
method BReportingJournal.ApiUpdateReportingJournal
method TJournalRole.CheckJournalRole