business logic query JournalForJEDefault

Parameters

iiCompanyId	integer	Company id
icJournalCode	character
icJournalControl	character
icJournalTypeCode	character

query condition

each Journal where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.JournalCode = icJournalCode AND
Journal.JournalControl = icJournalControl AND
Journal.JournalTypeCode = icJournalTypeCode

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND

query resultset tqJournalForJEDefault

field name	data type	db field	description
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.
tlJournalIsActive	logical	Journal.JournalIsActive	Indicate if this is an active daybook.
	api annotation:		Value for this field defaults to false.
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".
tcLayerCode	character	Layer.LayerCode	Layer Code
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type

Internal usage

QadFinancials

method BCInvoice.CreateMFPosting