project QadFinancials > class BPeriod > business logic query PeriodByCompanyIsOpen

Parameters

iiCompanyId	integer	Company id
ilIsPostingGLAllowed	logical

query condition

each Period where

Period.Company_Id = iiCompanyId AND
Period.PeriodIsPostingGLAllowed = ilIsPostingGLAllowed

query sort order

Period.PeriodYear (ascending)
Period.PeriodPeriod (ascending)

query resultset tqPeriodByCompanyIsOpen

field name	data type	db field	description
tiCompany_ID	integer	Period.Company_ID	Link to Company
tiPeriod_ID	integer	Period.Period_ID	Record ID
ttPeriodEndDate	date	Period.PeriodEndDate	End Date
tlPeriodIsPostingGLAllowed	logical	Period.PeriodIsPostingGLAllowed	GL
tlPeriodIsPostingInvAllowed	logical	Period.PeriodIsPostingInvAllowed	Inventory
tlPeriodIsPostingPurchAllow	logical	Period.PeriodIsPostingPurchAllow	Purchases
tlPeriodIsPostingSalesAllow	logical	Period.PeriodIsPostingSalesAllow	Sales
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
ttPeriodStartDate	date	Period.PeriodStartDate	Start Date
tcPeriodTypeCode	character	Period.PeriodTypeCode	GL Period Type
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
tiPeriodYearPeriod	integer	Period.PeriodYearPeriod	GL Calendar Year/GL Period
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Period)

Internal usage

QadFinancials

method BDInvoice.GetPeriodDateForDeduction
method BGLReport.CalMeasureActualsForISGL
method BGLReport.CalMeasureActualsForMultiColISGL
method BPeriod.GetDefaultPeriodDate