business logic query GLCalendarByYearPeriod

Description

Retrieve the GL period data for the specified year and period

Parameters

iiDomainId	integer	Id of the domain
iiCalendarYear	integer	Calendar year
iiCalendarPeriod	integer	Calendar period
iiGLCalendarId	integer

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 name	data type	db field	description
tiDomain_ID	integer	GLCalendar.Domain_ID	Business Domain
ttGLCalendarEndDate	date	GLCalendar.GLCalendarEndDate	Period end date
tiGLCalendarPeriod	integer	GLCalendar.GLCalendarPeriod	GL Period
ttGLCalendarStartDate	date	GLCalendar.GLCalendarStartDate	Start Date
tcGLCalendarTypeCode	character	GLCalendar.GLCalendarTypeCode	GL Period Type
tiGLCalendarYear	integer	GLCalendar.GLCalendarYear	GL Calendar Year
tiGLCalendar_ID	integer	GLCalendar.GLCalendar_ID	Record ID
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(GLCalendar)

Internal usage

QadFinancials

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