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