project QadFinancials > class BPeriod > business logic query PeriodByPeriodStartEndDate

Description

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


Parameters


iiCompanyIdintegerCompany id
itDatedatedate
iiPeriodIdintegerPeriod ID
iiPeriodYearintegerYear of period
iiPeriodPeriodintegerGL 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 namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tlPeriodIsPostingGLAllowedlogicalPeriod.PeriodIsPostingGLAllowedGL
tlPeriodIsPostingInvAllowedlogicalPeriod.PeriodIsPostingInvAllowedInventory
tlPeriodIsPostingOtherAllowlogicalPeriod.PeriodIsPostingOtherAllowOther
tlPeriodIsPostingPurchAllowlogicalPeriod.PeriodIsPostingPurchAllowPurchases
tlPeriodIsPostingSalesAllowlogicalPeriod.PeriodIsPostingSalesAllowSales
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL 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