business logic query JournalByJournalLayerType

Description

GetJournal: JournalByJournalLayerType

iiJournalId	integer	JournalId
icJournalCode	character	Daybook Code
iiCompanyId	integer	Please enter a good description for this parameter.
icLayerTypeCode	character	LayerTypeCode (this is a RKBF and CB asked to add this parameter)

each Journal where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = iiJournalId AND
Journal.JournalCode = icJournalCode

first JournalType (inner-join) where

JournalType.JournalTypeCode = Journal.JournalTypeCode AND

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerTypeCode

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).
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.
tlJournalIsActive	logical	Journal.JournalIsActive	Indicate if this is an active daybook.
	api annotation:		Value for this field defaults to false.
tcJournalSecondDescription	character	Journal.JournalSecondDescription	Second Description
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".
tlJournalTypeIsCorrection	logical	JournalType.JournalTypeIsCorrection	Correction Daybook
tiLayer_ID	integer	Journal.Layer_ID	Link to Layer
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiSharedSet_ID	integer	Journal.SharedSet_ID	Link to SharedSet

QadFinancials