project QadFinancials > class BPeriod > business logic query PeriodByStartEndDate

Description

query based on start and end date,
returns the period_id


Parameters


iiCompanyIdintegerCompany id
itDatedate


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodStartDate <= itDate AND
Period.PeriodEndDate >= itDate

      first PeriodMark (inner-join) where
PeriodMark.Company_Id = iiCompanyId AND
PeriodMark.PeriodMark_ID = Period.PeriodMark_ID AND


query sort order


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


query resultset tqPeriodByStartEndDate


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
ttPeriodClosingDatedatePeriod.PeriodClosingDateClosing Date
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tlPeriodIsPostingGLAllowedlogicalPeriod.PeriodIsPostingGLAllowedGL
tlPeriodIsPostingInvAllowedlogicalPeriod.PeriodIsPostingInvAllowedInventory
tlPeriodIsPostingOtherAllowlogicalPeriod.PeriodIsPostingOtherAllowOther
tlPeriodIsPostingPurchAllowlogicalPeriod.PeriodIsPostingPurchAllowPurchases
tlPeriodIsPostingSalesAllowlogicalPeriod.PeriodIsPostingSalesAllowSales
tiPeriodMark_IDintegerPeriod.PeriodMark_IDMark
tcPeriodMarkCodecharacterPeriodMark.PeriodMarkCodeMark
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tcPeriodReportingPeriodcharacterPeriod.PeriodReportingPeriodReporting GL Period
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period


Internal usage


QadFinancials
method BAccountingInterface.FillProDsAccntBalance
method BAnalyticalReport.CostCentreTransDet
method BAPMatching.DefaultValuesDate
method BAPMatching.DefaultValuesInvoice
method BBankEntry.AddBankEntryHeader
method BBankEntry.AddBankEntryLine
method BBankEntry.DefaultPostingYearPeriod
method BBankEntry.ValidateComponentPre
method BBankStateImport.AdditionalUpdatesCodeStart2
method BBankStateImport.AdditionalUpdatesSwiftStart
method BCashBoxReport.CashBook
method BCashReport.InitialValues
method BCDocument.AdditionalUpdatesPosting
method BCDocument.AdditionalUpdatesPostingCrossCy
method BCDocument.ValidateComponentPre
method BCInvoice.CreateMFPosting
method BCInvoiceAPMatching.CreateCInvoice
method BOpenBalance.GetGeneralDefaults
method BDDocument.AdditionalUpdatesPosting
method BDDocument.ValidateComponentPre
method BDebtor.CalculateCreditOnTurnover
method BDInvoice.APIJournalNbrVal
method BDInvoice.GetPeriodDateForDeduction
method BDInvoice.InitialValues
method BDInvoiceJournalEntry.ApiStdMaintainTT
method BFixedAssetDepreciation.AdditionalUpdatesPosting
method BFixedAssetDepreciation.DepreciationMain
method BFixedAssetDepreciation.DepreciationMainSub
method BGL.ApiGLBCBalanceCalculation
method BGL.ApiGLTCBalanceCalculation
method BGLOpenItemProcessor.DefaultValuesPostingDate
method BGLReport.AccBalanceTOT
method BGLReport.BalanceSheetReport
method BGLReport.CalClosingBalance
method BGLReport.CalculateClosingBalanceForDate
method BGLReport.CalculateMeasureDateforBS
method BGLReport.CalculateMeasureDateforIS
method BGLReport.CalculateOpeningBalanceForDate
method BGLReport.CalculateOpeningBalanceForNumberingDate
method BGLReport.CalculateYTDBalanceForDate
method BGLReport.CalOpeningBalance
method BGLReport.CBGLReport
method BGLReport.ColumnarLedgers
method BGLReport.GetCorrectMeasureDateForIS
method BGLReport.GetYearPeriodForChineseBS
method BGLReport.GetYearPeriodForChineseIS
method BGLReport.SubLedgeReport
method BPosting.ValidateComponentReversingPostingCheck
method BPosting.ValidateComponentReversingPostingCreate
method BPosting.ValidateComponentReversingPostingModifyOriginal
method BJournalEntry.CreateRecEntryPosting
method BJournalEntry.CreateReverseEntryGetDefaults
method BJournalEntry.DefaultValuesPostingAutoReversalDate
method BPaymentSelection.ValidateComponentPre
method BPeriod.ApiGetPeriodByDate
method BPeriod.GetDefaultPeriodDate
method BQCrossCyPosting.ApiProcessQCrossCyPosting
method BRecurringEntry.GenerateCalendar
method BRecurringEntry.ValRecEntryEndDate
method BRecurringEntry.ValRecEntryLinePostingDate
method BRecurringEntry.ValRecEntryStartDate
method BRevaluation.GetDefaults
method BRevaluation.InitialValues
method BYearClosing.InitialValues
method TConvertInstalNETXML.SetOutputData