project QadFinancials > class BJournal > business logic query JournalByJournalGroupIsActive

Parameters

iiCompanyId	integer	Company id
iiJournalGroupId	integer
iiJournalId	integer
ilJournalIsActive	logical

query condition

each Journal where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = iiJournalId AND
Journal.JournalIsActive = ilJournalIsActive AND
Journal.JournalGroup_ID = iiJournalGroupId

query resultset tqJournalByJournalGroupIsActive

field name	data type	db field	description
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalDescription	character	Journal.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.
tiJournalGroup_ID	integer	Journal.JournalGroup_ID	Link to Journal Group
tlJournalIsActive	logical	Journal.JournalIsActive	Indicate if this is an active daybook.
	api annotation:		Value for this field defaults to false.

Internal usage

QadFinancials

method BCMask.ValidateComponentPostCMaskJournalGroup