project QadFinancials > class BBudget > business logic query BudgetVersionByBudgetIDStat

Description

BudgetVersionByBudgetIDStat; query on BudgetVersion


Parameters


iiBudgetIDintegerBudget ID
iiBudgetVersionIDintegerBudgetVersionID
ilBudgetVersionIsActivelogicalBudgetVersionIsActive


query condition


  each BudgetVersion where
BudgetVersion.Budget_ID = iiBudgetID AND
BudgetVersion.BudgetVersion_ID = iiBudgetVersionID AND
BudgetVersion.BudgetVersionIsActive = ilBudgetVersionIsActive

      first ReportPeriod (inner-join) where
ReportPeriod.ReportPeriod_ID = BudgetVersion.ReportPeriod_ID AND


query resultset tqBudgetVersionByBudgetIDStat


field namedata typedb fielddescription
tcBudgetVersionCommentcharacterBudgetVersion.BudgetVersionCommentComment
tdBudgetVersionPercCompletdecimalBudgetVersion.BudgetVersionPercComplet% of Completion
tiReportPeriod_IDintegerBudgetVersion.ReportPeriod_IDFrom Report Pd
tlReportPeriodIsReportedlogicalReportPeriod.ReportPeriodIsReportedReported
tiReportPeriodPeriodintegerReportPeriod.ReportPeriodPeriodGL Period
tiReportPeriodYearintegerReportPeriod.ReportPeriodYearYear
tiBudget_IDintegerBudgetVersion.Budget_IDLink to Budget
tiBudgetVersion_IDintegerBudgetVersion.BudgetVersion_IDRecord ID
tcBudgetVersionCodecharacterBudgetVersion.BudgetVersionCodeVersion Code
tcBudgetVersionDescriptioncharacterBudgetVersion.BudgetVersionDescriptionDescription
ttBudgetVersionCreateDatedateBudgetVersion.BudgetVersionCreateDateCreation Date
tiBudgetVersionCreateTimeintegerBudgetVersion.BudgetVersionCreateTimeCreation Time
tlBudgetVersionIsActivelogicalBudgetVersion.BudgetVersionIsActiveActive


Internal usage


QadFinancials
method BBudget.ApiGetBudgetWBSWithFigures
method BBudget.BudgetCheckInfoResolve
method BBudget.BudgetCheckInfoResolveQueryStart
method BBudget.BudgetCheckInfoResolveQueryStop
method BGLReport.GetBudgetInfo
method BGLReport.GetBudgetInfoForBSIS