project QadFinancials > class BRecurringEntry > business logic query RecEntryLineByTillPostingDate
Description
Query to select the Recurring Entry Line Posting to Execute
Parameters
| iiCompanyId | integer | Company id |
| itTillAccountingDate | date | |
| icPostingTemplateCode | character | Posting Template Code |
| icRecEntryFreq | character | Frequency |
| icRecEntryUpdate | character | Update Type (Forbidden/Allowed/Mandatory) |
| icJournalCode | character | Daybook Code |
| icRecEntryLineStatus | character | Status (Waiting) |
| ilRecEntryIsActive | logical | Active |
| icRecEntryCode | character | |
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 name | data type | db field | description |
|---|
| tiPosting_ID | integer | PostingTemplate.Posting_ID | Link to Posting |
| tcRecEntryCode | character | RecEntry.RecEntryCode | Code |
| ttRecEntryEndDate | date | RecEntry.RecEntryEndDate | End Date |
| tlRecEntryIsActive | logical | RecEntry.RecEntryIsActive | Active |
| tcRecEntryLineStatus | character | RecEntryLine.RecEntryLineStatus | Status |
| tiRecEntry_ID | integer | RecEntry.RecEntry_ID | Record ID |
| tiRecEntryLine_ID | integer | RecEntryLine.RecEntryLine_ID | Record ID |
| tiPostingTemplate_ID | integer | RecEntry.PostingTemplate_ID | Template Code |
| tcPostingTemplateCode | character | PostingTemplate.PostingTemplateCode | Template Code |
| tiJournal_ID | integer | RecEntry.Journal_ID | Daybook Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiLayer_ID | integer | Journal.Layer_ID | Link to Layer |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tcRecEntryFreq | character | RecEntry.RecEntryFreq | Frequency |
| tcRecEntryUpdate | character | RecEntry.RecEntryUpdate | Update Type |
| tcRecEntryLineCode | character | RecEntryLine.RecEntryLineCode | Code |
| tiPeriod_ID | integer | RecEntryLine.Period_ID | GL Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| ttRecEntryLinePostingDate | date | RecEntryLine.RecEntryLinePostingDate | Posting Date |
| ttRecEntryLineReversingDate | date | RecEntryLine.RecEntryLineReversingDate | Reversing Date |
| tdRecEntryLineAmountLC | decimal | RecEntryLine.RecEntryLineAmountLC | BC Amount |
Internal usage
QadFinancials