business logic query PostingByReportingJournalExcep

Parameters

iiCompanyId	integer	Company id
itFromPostingDate	date
itToPostingDate	date

query condition

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingDate >= itFromPostingDate AND
Posting.PostingDate <= itToPostingDate AND
Posting.Journal_ID <> Posting1.ReportingJournal_ID AND
Posting.ReportingJournal_ID <> 0

first Journal1 (inner-join) where

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

first Journal2 (inner-join) where

Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = Posting.ReportingJournal_ID AND

query resultset tqPostingByReportingJournalExcep

field name	data type	db field	description
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiJournal_ID	integer	Journal2.Journal_ID	Record ID
tcJournalCode	character	Journal1.JournalCode	A daybook code (maximum eight characters).
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).
tiPostingPeriod	integer	Posting.PostingPeriod	The GL period for the posting. The period must be open.
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.
tcReportingJournalCode	character	Journal2.JournalCode	A daybook code (maximum eight characters).
tcReportingJournalDescription	character	Journal2.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.

Internal usage

QadFinancials

method BReportingJournalReport.ReportingJournalExceptReport