business logic query JournalByJournalTypeLayerType

Description

JournalByJournalTypeLayerType.

Parameters

iiCompanyId	integer
icJournalTypeCode	character	JournalTypeCode
icLayerCode	character	Layer Code
ilJournalIsActive	logical

query condition

each Journal where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalTypeCode = icJournalTypeCode AND
Journal.JournalIsActive = ilJournalIsActive

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerCode = icLayerCode

query resultset tqJournalByJournalTypeLayerType

field name	data type	db field	description
tlJournalIsActive	logical	Journal.JournalIsActive	Indicate if this is an active daybook.
	api annotation:		Value for this field defaults to false.
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiSharedSet_ID	integer	Journal.SharedSet_ID	Link to SharedSet
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalDescription	character	Journal.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".
tiLayer_ID	integer	Layer.Layer_ID	Record ID
tcLayerCode	character	Layer.LayerCode	Layer Code
tcLayerDescription	character	Layer.LayerDescription	Description

Internal usage

QadFinancials

method BJournal.PreValidateComponent
method BYearClosing.DefaultValuesLayer