business logic query PostingByJournalCode

Description

This query returns original posting record on the basis of Journal Code, PeriodYear and Voucher.

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingVoucher = iiPostingVoucher 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.JournalCode = icJournalCode

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYear = iiPeriodYear

field name	data type	db field	description
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
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.
tiPosting_ID	integer	Posting.Posting_ID	Record ID
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
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.
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).

QadFinancials