business logic query LayerJournalForPosting

Parameters

iiCompanyId	integer	Company id
itDateFrom	date
itDateTo	date
icDescription	character
iiJournalId	integer
icLayerCode	character
icLayerTypeCode	character
iiPostingYearPeriod	integer
iiSkipJournalID	integer
icTargetJournalTypeCode	character

query condition

each Layer where

Layer.LayerTypeCode = icLayerTypeCode AND
Layer.LayerCode = icLayerCode

each Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Layer_ID = Layer.Layer_ID AND
Journal.Journal_ID = iiJournalId AND
Journal.Journal_ID <> iiSkipJournalID AND
Journal.JournalTypeCode = icTargetJournalTypeCode

each Posting (inner-join) where

Posting.Journal_ID = Journal.Journal_ID AND
Posting.Company_ID = iiCompanyId AND
Posting.PostingYearPeriod = iiPostingYearPeriod AND
Posting.PostingDate >= itDateFrom AND
Posting.PostingDate <= itDateTo AND
Posting.PostingText matches icDescription

each PostingTemplate (outer-join) where

PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.Posting_ID = Posting.Posting_ID AND

query resultset tqLayerJournalForPosting

field name	data type	db field	description
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
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".
tiLayer_ID	integer	Journal.Layer_ID	Link to Layer
tcLayerCode	character	Layer.LayerCode	Layer Code
tlLayerIsActive	logical	Layer.LayerIsActive	Active
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiPosting_ID	integer	Posting.Posting_ID	Record ID
tcPostingAutoReversalType	character	Posting.PostingAutoReversalType	If this posting is involved in automatic reversal activity of posting, value of this field will indicate whether this posting is the original one or the reversing one. It is calculated by the system.
	api annotation:		If the flag PostingIsAutoReversal is "true", the field value defaults to "ORIGINAL ENTRY" for the original posting, and to "REVERSING ENTRY" for the reversing posting.
ttPostingDate	date	Posting.PostingDate	The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tlPostingIsAutoReversal	logical	Posting.PostingIsAutoReversal	Indicate whether the posting leads to an automatic reversal.
	api annotation:		Value for this field defaults to "false".
tiPostingPeriod	integer	Posting.PostingPeriod	The GL period for the posting. The period must be open.
tiPostingTemplate_ID	integer	PostingTemplate.PostingTemplate_ID	Record ID
tcPostingTemplateCode	character	PostingTemplate.PostingTemplateCode	Template Code
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.
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.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Layer),rowid(Journal),rowid(Posting),rowid(PostingTemplate)

Internal usage

QadFinancials

method BMassLayerTransfer.ApiGetJournalEntries