business logic query JournalGroupPrim

Description

Query is used to covert between the journalgroup_id the journalgroupcode.

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 ID of the JournalGroup that you want to retrieve. Specify '?' if you are specifying a code in the icJournalGroupCode parameter
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

query resultset tqJournalGroupPrim

field name	data type	db field	description
tiJournalGroup_ID	integer	JournalGroup.JournalGroup_ID	Record ID
tcJournalGroupCode	character	JournalGroup.JournalGroupCode	Daybook Group Code
tcJournalGroupDescription	character	JournalGroup.JournalGroupDescription	Description

Internal usage

QadFinancials

method BCMask.DataLoadByInputCMaskJrnlGrp
read related business field(s) on tCMaskJrnlGroup.JournalGroup_ID
read related business field(s) on tJournal.JournalGroup_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tCMaskJrnlGroup.JournalGroup_ID
validate related business field(s) on tJournal.JournalGroup_ID