project QadFinancials > class BGLCalendar > business logic query GLCalendarByYearPeriod

Description

Retrieve the GL period data for the specified year and period


Parameters


iiDomainIdintegerId of the domain
iiCalendarYearintegerCalendar year
iiCalendarPeriodintegerCalendar period
iiGLCalendarIdinteger


query condition


  each GLCalendar where
GLCalendar.GLCalendar_ID = iiGLCalendarId AND
GLCalendar.Domain_ID = iiDomainId AND
GLCalendar.GLCalendarYear = iiCalendarYear AND
GLCalendar.GLCalendarPeriod = iiCalendarPeriod


query sort order


GLCalendar.Domain_ID (ascending)
GLCalendar.GLCalendarYear (ascending)
GLCalendar.GLCalendarPeriod (ascending)


query resultset tqGLCalendarByYearPeriod


field namedata typedb fielddescription
tiDomain_IDintegerGLCalendar.Domain_IDBusiness Domain
ttGLCalendarEndDatedateGLCalendar.GLCalendarEndDatePeriod end date
tiGLCalendarPeriodintegerGLCalendar.GLCalendarPeriodGL Period
ttGLCalendarStartDatedateGLCalendar.GLCalendarStartDateStart Date
tcGLCalendarTypeCodecharacterGLCalendar.GLCalendarTypeCodeGL Period Type
tiGLCalendarYearintegerGLCalendar.GLCalendarYearGL Calendar Year
tiGLCalendar_IDintegerGLCalendar.GLCalendar_IDRecord ID
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(GLCalendar)


Internal usage


QadFinancials
method BCompany.AdditionalUpdates
method BGLCalendar.DataLoadMultiple
method BGLCalendar.DataNewMultipleCopyPeriodYear