project QadFinancials > class BPeriod > business logic query PeriodByCyYearTypeStatus

Description

PeriodByCyYearTypeStatus


Parameters


iiCompanyIdintegerCompany id
iiPeriodYearintegerPeriod Year
icPeriodTypeCodecharacterPeriodTypeCode
icPeriodStatuscharacterPeriod Status
icPeriodStatusNotcharacter


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.PeriodTypeCode = icPeriodTypeCode AND
Period.PeriodStatus = icPeriodStatus AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodStatus <> icPeriodStatusNot


query sort order


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


query resultset tqPeriodByCyYearTypeStatus


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Period)


Internal usage


QadFinancials
method BYearClosing.ValidateComponentAll