project QadFinancials > class BRecurringEntry > business logic query RecEntryLineByTillPostingDate

Description

Query to select the Recurring Entry Line Posting to Execute


Parameters


iiCompanyIdintegerCompany id
itTillAccountingDatedate
icPostingTemplateCodecharacterPosting Template Code
icRecEntryFreqcharacterFrequency
icRecEntryUpdatecharacterUpdate Type (Forbidden/Allowed/Mandatory)
icJournalCodecharacterDaybook Code
icRecEntryLineStatuscharacterStatus (Waiting)
ilRecEntryIsActivelogicalActive
icRecEntryCodecharacter


query condition


  each RecEntry where
RecEntry.Company_Id = iiCompanyId AND
RecEntry.RecEntryIsActive = ilRecEntryIsActive AND
RecEntry.RecEntryFreq = icRecEntryFreq AND
RecEntry.RecEntryUpdate = icRecEntryUpdate AND
RecEntry.RecEntryCode = icRecEntryCode

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = RecEntry.Journal_ID AND
Journal.JournalCode = icJournalCode

          first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND

      first PostingTemplate (inner-join) where
PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.PostingTemplate_ID = RecEntry.PostingTemplate_ID AND
PostingTemplate.PostingTemplateCode = icPostingTemplateCode

      each RecEntryLine (inner-join) where
RecEntryLine.RecEntry_ID = RecEntry.RecEntry_ID AND
RecEntryLine.RecEntryLinePostingDate <= itTillAccountingDate AND
RecEntryLine.RecEntryLineStatus = icRecEntryLineStatus

          first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = RecEntryLine.Period_ID AND


query resultset tqRecEntryLineByTillPostingDate


field namedata typedb fielddescription
tiPosting_IDintegerPostingTemplate.Posting_IDLink to Posting
tcRecEntryCodecharacterRecEntry.RecEntryCodeCode
ttRecEntryEndDatedateRecEntry.RecEntryEndDateEnd Date
tlRecEntryIsActivelogicalRecEntry.RecEntryIsActiveActive
tcRecEntryLineStatuscharacterRecEntryLine.RecEntryLineStatusStatus
tiRecEntry_IDintegerRecEntry.RecEntry_IDRecord ID
tiRecEntryLine_IDintegerRecEntryLine.RecEntryLine_IDRecord ID
tiPostingTemplate_IDintegerRecEntry.PostingTemplate_IDTemplate Code
tcPostingTemplateCodecharacterPostingTemplate.PostingTemplateCodeTemplate Code
tiJournal_IDintegerRecEntry.Journal_IDDaybook Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiLayer_IDintegerJournal.Layer_IDLink to Layer
tcLayerCodecharacterLayer.LayerCodeLayer Code
tcRecEntryFreqcharacterRecEntry.RecEntryFreqFrequency
tcRecEntryUpdatecharacterRecEntry.RecEntryUpdateUpdate Type
tcRecEntryLineCodecharacterRecEntryLine.RecEntryLineCodeCode
tiPeriod_IDintegerRecEntryLine.Period_IDGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
ttRecEntryLinePostingDatedateRecEntryLine.RecEntryLinePostingDatePosting Date
ttRecEntryLineReversingDatedateRecEntryLine.RecEntryLineReversingDateReversing Date
tdRecEntryLineAmountLCdecimalRecEntryLine.RecEntryLineAmountLCBC Amount


Internal usage


QadFinancials
method BPeriod.ValidateComponentPost
method BRecurringEntry.ApiPostRecEntryApplyFilter