project QadFinancials > class BJournal > business logic query SelectJournalForLayer


Parameters


iiCompanyIdintegerCompany id
iiJournalIdinteger
icJournalCodecharacter


query condition


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

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


query resultset tqSelectJournalForLayer


field namedata typedb fielddescription
tiJournal_IDintegerJournal.Journal_IDRecord ID
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcJournalDescriptioncharacterJournal.JournalDescriptionA brief description of the daybook.
api annotation:Value for this field defaults to null.
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
tcJournalTypeCodeTrcharactercalculated
tiLayer_IDintegerLayer.Layer_IDRecord ID
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerDescriptioncharacterLayer.LayerDescriptionDescription
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type


Internal usage


QadFinancials
read related business field(s) on tCMaskJournal.Journal_ID
ApiGetAlternateKeyValues
validate related business field(s) on tCMaskJournal.Journal_ID