business logic query CMaskJrnlGrpByCMaskByJrnlCtrl

Parameters

iiCompanyId	integer	Company id
icCMaskId	character	Daybook mask ID.
icJournalControl	character	Daybook control

query condition

each CMaskJrnlGroup where

CMaskJrnlGroup.CMask_ID = icCMaskId

first JournalGroup (inner-join) where

JournalGroup.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
JournalGroup.JournalGroup_ID = CMaskJrnlGroup.JournalGroup_ID AND

each Journal (conditional-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalGroup_ID = JournalGroup.JournalGroup_ID AND
Journal.JournalControl = icJournalControl

query resultset tqCMaskJrnlGrpByCMaskByJrnlCtrl

field name	data type	db field	description
tiCMask_ID	integer	CMaskJrnlGroup.CMask_ID	Link to CMask
tiCMaskJrnlGroup_ID	integer	CMaskJrnlGroup.CMaskJrnlGroup_ID	Record ID
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalControl	character	Journal.JournalControl	A type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source.
tcJournalDescription	character	Journal.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.
tiJournalGroup_ID	integer	CMaskJrnlGroup.JournalGroup_ID	Link to JournalGroup
tcJournalGroupCode	character	JournalGroup.JournalGroupCode	Daybook Group Code
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".

Internal usage

QadFinancials

method BPeriod.ValidateComponentPre