project QadFinancials > class BPeriod > business logic query PeriodForStartEndDateYearPd

Description

PeriodForStartEndDateYearPd: Query that returns the start and end date of a period based upon the company, year and period.


Parameters


iiCompanyIdintegerCompany id
iiPeriodYearintegerYear of period
iiPeriodPeriodintegerGL Period


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = Period.Company_ID AND


query resultset tqPeriodForStartEndDateYearPd


field namedata typedb fielddescription
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type


Internal usage


QadFinancials
method BPeriod.MultiCompanyVerifications
method BRevaluation.MultiCompanyVerificationSimulate