project QadFinancials > class BJournalGroup > business logic query JournalGroupByCodeByID

Description

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


Parameters


icJournalGroupCodecharacterThe Code of the JournalGroup that you want to retrieve. Specify '?' if you are specifying an id in the iiJournalGroup parameter.
iiJournalGroupIdintegerThe idof the JournalGroup that you want to retrieve. Specify '?' if you are specifying a code in the icJournalGroupCode parameter.
ilJournalGroupIsActivelogicalSpecify if you want to retrieve journal groups that are active (true) or inactive (false) Specify '?' to retrieve all.
iiCompanyIdintegerCompany 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 namedata typedb fielddescription
tiJournalGroup_IDintegerJournalGroup.JournalGroup_IDRecord ID
tcJournalGroupCodecharacterJournalGroup.JournalGroupCodeDaybook Group Code
tlJournalGroupIsActivelogicalJournalGroup.JournalGroupIsActiveActive


Internal usage


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