business logic query JournalGroupByCodeByID

Description

Query to lookup up journal groups based on either the journal code or the journal id value.

Parameters

icJournalGroupCode	character	The Code of the JournalGroup that you want to retrieve. Specify '?' if you are specifying an id in the iiJournalGroup parameter.
iiJournalGroupId	integer	The idof the JournalGroup that you want to retrieve. Specify '?' if you are specifying a code in the icJournalGroupCode parameter.
ilJournalGroupIsActive	logical	Specify if you want to retrieve journal groups that are active (true) or inactive (false) Specify '?' to retrieve all.
iiCompanyId	integer	Company id

query condition

each JournalGroup where

JournalGroup.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
JournalGroup.JournalGroupCode = icJournalGroupCode AND
JournalGroup.JournalGroup_ID = iiJournalGroupId AND
JournalGroup.JournalGroupIsActive = ilJournalGroupIsActive

query resultset tqJournalGroupByCodeByID

field name	data type	db field	description
tiJournalGroup_ID	integer	JournalGroup.JournalGroup_ID	Record ID
tcJournalGroupCode	character	JournalGroup.JournalGroupCode	Daybook Group Code
tlJournalGroupIsActive	logical	JournalGroup.JournalGroupIsActive	Active

Internal usage

QadFinancials

method BJournal.Calculate
method BJournal.InitialValues
method BJournal.PreValidateComponent
method BJournalGroup.ValidateComponent