business logic query PeriodByPeriodStartEndDate

Description

Validates if a given date respects the start/end date of a given period

Parameters

iiCompanyId	integer	Company id
itDate	date	date
iiPeriodId	integer	Period ID
iiPeriodYear	integer	Year of period
iiPeriodPeriod	integer	GL Period

query condition

each Period where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod AND
Period.PeriodStartDate <= itDate AND
Period.PeriodEndDate >= itDate

query resultset tqPeriodByPeriodStartEndDate

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
tlPeriodIsPostingOtherAllow	logical	Period.PeriodIsPostingOtherAllow	Other
tlPeriodIsPostingPurchAllow	logical	Period.PeriodIsPostingPurchAllow	Purchases
tlPeriodIsPostingSalesAllow	logical	Period.PeriodIsPostingSalesAllow	Sales
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 BBankEntry.ValidateComponentPre
method BCInvoice.DefaultValuesReversePeriod
method BCInvoice.ValidateComponentPost
method BCreditorReport.CInvoiceRegister
method BDebtorFinanceCharge.FCDInvoiceCommit
method BDInvoice.ValidateComponentAllPostPostingDate
method BGLOpenItemProcessor.GLOpenItemInitializationValidate
method BGLReport.FindWholePeriodRange
method BPosting.ValidateComponentPostPosting2
method BPosting.ValidateComponentPreAssignPosting1