business logic query BaseRecurringEntries

Parameters

iiCompanyId	integer	Company id
itFromDate	date
itToDate	date
icStatus	character
ilActive	logical

query condition

each RecEntry where

RecEntry.Company_Id = iiCompanyId AND
RecEntry.RecEntryStartDate <= itToDate AND
RecEntry.RecEntryIsActive = ilActive

first Journal (inner-join) where

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

first PostingTemplate (inner-join) where

PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.PostingTemplate_ID = RecEntry.PostingTemplate_ID AND

each RecEntryLine (conditional-join) where

RecEntryLine.RecEntry_ID = RecEntry.RecEntry_ID AND
RecEntryLine.RecEntryLinePostingDate >= itFromDate AND
RecEntryLine.RecEntryLinePostingDate <= itToDate AND
RecEntryLine.RecEntryLineStatus = icStatus

query resultset tqBaseRecurringEntries

field name	data type	db field	description
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcPostingTemplateCode	character	PostingTemplate.PostingTemplateCode	Template Code
tdRecEntryAmountLC	decimal	RecEntry.RecEntryAmountLC	BC Amount
tcRecEntryCode	character	RecEntry.RecEntryCode	Code
ttRecEntryEndDate	date	RecEntry.RecEntryEndDate	End Date
tcRecEntryFreq	character	RecEntry.RecEntryFreq	Frequency
tlRecEntryIsActive	logical	RecEntry.RecEntryIsActive	Active
tdRecEntryLineAmountLC	decimal	RecEntryLine.RecEntryLineAmountLC	BC Amount
tcRecEntryLineCode	character	RecEntryLine.RecEntryLineCode	Code
ttRecEntryLinePostingDate	date	RecEntryLine.RecEntryLinePostingDate	Posting Date
tcRecEntryLineStatus	character	RecEntryLine.RecEntryLineStatus	Status
ttRecEntryStartDate	date	RecEntry.RecEntryStartDate	Start Date
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(RecEntry),rowid(Journal),rowid(PostingTemplate),rowid(RecEntryLine)

Internal usage

QadFinancials

method BClosingPostingsReport.RecurringEntriesDet