project QadFinancials > class BJournal > business logic query JournalForProfileLinkDef

Description

Returns all possible journals for defaulting of a profile link record.


Parameters


iiCompanyIdintegerCompany id
iiSharedSetIdintegerSharedSetId
icJournalTypeCodecharacterDaybook Type Code
ilJournalIsActivelogicaltrue for active, false for inactice, unknown value for both
ilJournalTypeIsCorrectionlogicalJournalTypeIsCorrection
icJournalControlcharacterJournal Control : operational, financial, ...


query condition


  each Journal where
Journal.SharedSet_ID = iiSharedSetId AND
Journal.JournalTypeCode = icJournalTypeCode AND
Journal.JournalIsActive = ilJournalIsActive AND
Journal.JournalControl = icJournalControl

      first JournalType (inner-join) where
JournalType.JournalTypeCode = Journal.JournalTypeCode AND
JournalType.JournalTypeIsCorrection = ilJournalTypeIsCorrection

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


query resultset tqJournalForProfileLinkDef


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".
tlJournalTypeIsCorrectionlogicalJournalType.JournalTypeIsCorrectionCorrection Daybook
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BCInvoice.DefaultValuesInvoiceType
method BCInvoice.GetCAJournalCode
method BCInvoice.GetJournalCode
method BCInvoice.GetMFJournal
method BDInvoice.DefaultValuesInvoiceType
method BDInvoice.GetDAJournalCode
method BExpenseNote.GetAllocationJournal
method BJournalEntry.DefaultValuesPostingForUI
method BProfile.DefaultProfileLinkObject