project QadFinancials > class BClosingPostingsReport > business logic query BaseRecurringEntries


Parameters


iiCompanyIdintegerCompany id
itFromDatedate
itToDatedate
icStatuscharacter
ilActivelogical


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 namedata typedb fielddescription
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcPostingTemplateCodecharacterPostingTemplate.PostingTemplateCodeTemplate Code
tdRecEntryAmountLCdecimalRecEntry.RecEntryAmountLCBC Amount
tcRecEntryCodecharacterRecEntry.RecEntryCodeCode
ttRecEntryEndDatedateRecEntry.RecEntryEndDateEnd Date
tcRecEntryFreqcharacterRecEntry.RecEntryFreqFrequency
tlRecEntryIsActivelogicalRecEntry.RecEntryIsActiveActive
tdRecEntryLineAmountLCdecimalRecEntryLine.RecEntryLineAmountLCBC Amount
tcRecEntryLineCodecharacterRecEntryLine.RecEntryLineCodeCode
ttRecEntryLinePostingDatedateRecEntryLine.RecEntryLinePostingDatePosting Date
tcRecEntryLineStatuscharacterRecEntryLine.RecEntryLineStatusStatus
ttRecEntryStartDatedateRecEntry.RecEntryStartDateStart Date
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(RecEntry),rowid(Journal),rowid(PostingTemplate),rowid(RecEntryLine)


Internal usage


QadFinancials
method BClosingPostingsReport.RecurringEntriesDet