project QadFinancials > class BJournal > business logic query JournalForExcel

Description

JournalByJournalTypeLayerType.


Parameters


iiCompanyIdintegerCompany id
iiRoleIDinteger


query condition


  each Journal where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Role_ID = iiRoleID

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

      first Role (inner-join) where
Role.Role_ID = Journal.Role_ID AND


query resultset tqJournalForExcel


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.
tcJournalSecondDescriptioncharacterJournal.JournalSecondDescriptionSecond Description
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tcRoleNamecharacterRole.RoleNameRole Name
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet
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".
tiLayer_IDintegerLayer.Layer_IDRecord ID
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcLayerDescriptioncharacterLayer.LayerDescriptionDescription
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Journal),rowid(Layer),rowid(Role)


Internal usage


QadFinancials
method BJournal.ApiLoadJournal