project QadFinancials > class BPeriod > business logic query PeriodByPeriodRange


Parameters


iiCompanyIdintegerCompany id
iiFromYearPeriodintegerFrom Period Year Period: (Year * 100) + period
iiToYearPeriodintegerTo Period Year Period: (Year * 100) + period


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYearPeriod >= iiFromYearPeriod AND
Period.PeriodYearPeriod <= iiToYearPeriod


query resultset tqPeriodByPeriodRange


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tlPeriodIsPostingGLAllowedlogicalPeriod.PeriodIsPostingGLAllowedGL
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Period)


Internal usage


QadFinancials
method BConsolid.ValidateComponentPost
method BConsolidDump.ValidateComponent
method BExpenseNoteReport.ExpenseNote
method BGL.ApiGetAccountBalance
method BGLReport.GetTrialBalanceYearClose
method BMassLayerTransfer.ApiGetJournalEntries
method BPeriod.CheckForCorrectionPeriod