business logic query PostingByJrnlTypebyLayerType

Parameters

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingPeriod = iiPeriod AND
Posting.PostingYear = iiPeriodYear

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
Journal.JournalTypeCode = icJournalType

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.
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
tiPostingPeriod	integer	Posting.PostingPeriod	The GL period for the posting. The period must be open.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tiPostingYearPeriod	integer	Posting.PostingYearPeriod	The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
	api annotation:		If Partial Update is true, the value defaults using PostingPeriod and PostingYear.

QadFinancials