project QadFinancials > class BJournal > business logic query JournalByRoleID


Parameters


iiCompanyIdintegerCompany id
iiRoleIDinteger


query condition


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


query resultset tqJournalByRoleID


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.
tiJournalGroup_IDintegerJournal.JournalGroup_IDLink to Journal Group
tlJournalIsActivelogicalJournal.JournalIsActiveIndicate if this is an active daybook.
api annotation:Value for this field defaults to false.
tlJournalIsProjectProvisionlogicalJournal.JournalIsProjectProvisionProject Provision
tcJournalTypeCodecharacterJournal.JournalTypeCodeA daybook type code.
api annotation:Value for this field defaults to "Journal Entries".
ttLastModifiedDatedateJournal.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerJournal.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterJournal.LastModifiedUserLast Modified User
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tiRole_IDintegerJournal.Role_IDLink to Role
tiSharedSet_IDintegerJournal.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BRole.ValidateComponent