project QadFinancials > class BPeriod > business logic query PeriodByID


Parameters


iiCompanyIdintegerCompany id
iiPeriodIDinteger


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodID


query resultset tqPeriodByID


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
tlPeriodIsPostingPCAllowedlogicalPeriod.PeriodIsPostingPCAllowedPeriodic Costing
tlPeriodIsPostingPurchAllowlogicalPeriod.PeriodIsPostingPurchAllowPurchases
tlPeriodIsPostingSalesAllowlogicalPeriod.PeriodIsPostingSalesAllowSales
tlPeriodIsReportCheckedlogicalPeriod.PeriodIsReportCheckedChecked/Reported
tiPeriodMark_IDintegerPeriod.PeriodMark_IDMark
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 BPosting.ValidateComponentPost
method BPosting.ValidateComponentPostPosting2
method BPosting.ValidateComponentPostStopQueries