project QadFinancials > class BPeriod > business logic query PeriodByYearPeriodNull

Description

give some fields for that company,sort on year

Parameters


iiCompanyIdintegerCompany id
iiPeriodYearintegerAccounting Year
iiPeriodPeriodintegerGL Period
iiPeriodIdintegerPeriod ID

query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodId AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod AND
(Period.PeriodPeriod = 0 OR
NOT (0 = iiPeriodPeriod ))

      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 tqPeriodByYearPeriodNull


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
tlPeriodIsReportCheckedlogicalPeriod.PeriodIsReportCheckedChecked/Reported
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

Internal usage


QadFinancials
method BPosting.AddPostingHeader
method BPeriod.GetDefaultPeriodDate