business logic query PeriodByStartDatePCAllowed

Description

PeriodByStartDatePCAllowed: query with paramater for the Company StartDate-after and PeriodIsPostingPCAllowed

Parameters

iiCompanyId	integer	Company id
ilPeriodIsPostingPCAllowed	logical	PeriodIsPostingPCAllowed
itPeriodStartDateAfter	date	PeriodStartDateAfter: pass a value for this parameter and the result-set will only contains records with a higher start-date
itPeriodStartDateBefore	date	PeriodStartDateBefore: pass a value for this parameter and the result-set will only contains records with a lower start-date

query condition

each Period where

Period.Company_Id = iiCompanyId AND
Period.PeriodStartDate > itPeriodStartDateAfter AND
Period.PeriodStartDate <= itPeriodStartDateBefore AND
Period.PeriodIsPostingPCAllowed = ilPeriodIsPostingPCAllowed

query resultset tqPeriodByStartDatePCAllowed

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
tlPeriodIsPostingPCAllowed	logical	Period.PeriodIsPostingPCAllowed	Periodic Costing
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
ttPeriodStartDate	date	Period.PeriodStartDate	Start Date
tcPeriodStatus	character	Period.PeriodStatus	Status
tcPeriodTypeCode	character	Period.PeriodTypeCode	GL Period Type
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
tiPeriodYearPeriod	integer	Period.PeriodYearPeriod	GL Calendar Year/GL Period

Internal usage

QadFinancials

method BPeriod.ValidateComponentPrePC