business logic query TransientLayersCheck (distinct)

Parameters

each Posting where

Posting.Company_Id = iiCompanyId AND

first Journal (inner-join) where

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

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerType

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYear = iiYear AND
Period.PeriodPeriod = iiPeriod

field name	data type	db field	description
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcLayerCode	character	Layer.LayerCode	Layer Code
tcPostingParentText	character	Posting.PostingParentText	Contains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses.
	api annotation:		Value for this field defaults to blank.
tcPostingText	character	Posting.PostingText	Free text describing the posting.
	api annotation:		Value for this field defaults to blank
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
	api annotation:		In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.

QadFinancials