business logic query BudgetByBudgetIDCodeStatus

Description

BudgetByBudgetIDCodeStatus; query that returns the budget info.
Including conitional-joins to project and costcentre and special conditions that allow a run-time check '= 0' for Project_ID and for CostCentre_ID (see parameter descriptions).

DO NOT MAKE ANY CHANGE TO THIS QUERY; THIS SHOULD BE AS SIMPLE AS POSSIBLE BECAUSE IT IS USED BY THE BUDGET-RESOLVE (first contact KriLae/WouAnt in case you need a change)

Whenever a field gets added to the result-set of this query, the same shoudl be done for the temp-table data-item tBudgetByBudgetIDCodeStatus (and it should be assigned/used accordingly in the program-code of course).

Parameters

iiBudgetID	integer	Budget ID
icBudgetCode	character	BudgetCode
icBudgetStatus	character	BudgetStatus
iiCompanyId	integer	Company id
icProjectCode	character	ProjectCode (conditional outer-join form budget to project)
icCostCentreCode	character	CostCentreCode (conditional outer-join form budget to CostCentre)
ilBudgetIsCheckActualOnLine	logical	BudgetIsCheckActualOnLine
ilBudgetIsCheckCommitOnLine	logical	BudgetIsCheckCommitOnLine
ilBudgetIsAutoRollUp	logical	BudgetIsAutoRollUp
iiProjectID	integer	ProjectID: Note that in case you pass value -999999 then this will result at run-time into a hard-coded condition "Budget.project_ID = 0"
iiCostCentreID	integer	CostCentreID: Note that in case you pass value -999999 then this will result at run-time into a hard-coded condition "Budget.CostCentre_ID = 0"
icBudgetType	character	BudgetType

query condition

each Budget where

Budget.BudgetCode = icBudgetCode AND
Budget.Budget_ID = iiBudgetID AND
Budget.BudgetStatus = icBudgetStatus AND
Budget.BudgetIsCheckActualOnLine = ilBudgetIsCheckActualOnLine AND
Budget.BudgetIsCheckCommitOnLine = ilBudgetIsCheckCommitOnLine AND
Budget.BudgetIsAutoRollUp = ilBudgetIsAutoRollUp AND
Budget.Project_ID = (if iiProjectID = -999999 then 0 else iiProjectID) AND
Budget.CostCentre_ID = (if iiCostCentreID = -999999 then 0 else iiCostCentreID) AND
Budget.BudgetType = icBudgetType

first CostCentre (conditional-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = Budget.CostCentre_ID AND
CostCentre.CostCentreCode = icCostCentreCode

first Currency (inner-join) where

Currency.Currency_ID = Budget.Currency_ID AND

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = Budget.Project_ID AND
Project.ProjectCode = icProjectCode

query resultset tqBudgetByBudgetIDCodeStatus

field name	data type	db field	description
tiBudget_ID	integer	Budget.Budget_ID	Record ID
tcBudgetCode	character	Budget.BudgetCode	Budget Code
tcBudgetCheckReportPeriod	character	Budget.BudgetCheckReportPeriod	Report Period Check
tlBudgetIsUsedForAllocation	logical	Budget.BudgetIsUsedForAllocation	Used for Allocation
tlBudgetIsSendWarning	logical	Budget.BudgetIsSendWarning	Send E-Mail on Warnings
tlBudgetIsAutoRollUp	logical	Budget.BudgetIsAutoRollUp	Auto Roll-Up
tlBudgetIsCheckActualOnLine	logical	Budget.BudgetIsCheckActualOnLine	Check Actuals Online
tlBudgetIsCheckCommitOnLine	logical	Budget.BudgetIsCheckCommitOnLine	Check Commitments Online
tlBudgetIsSendError	logical	Budget.BudgetIsSendError	Send E-Mail on Errors
tcBudgetType	character	Budget.BudgetType	Budget Type
tcBudgetDescription	character	Budget.BudgetDescription	Description
tcBudgetStatus	character	Budget.BudgetStatus	Status
tlBudgetIsCompanyDependent	logical	Budget.BudgetIsCompanyDependent	Entity Dependent
tlBudgetIsWithQuantityData	logical	Budget.BudgetIsWithQuantityData	Use Quantity Info
tcBudgetOverrunYTD	character	Budget.BudgetOverrunYTD	Overrun (YTD)
tcBudgetOverrunPeriod	character	Budget.BudgetOverrunPeriod	GL Period Overrun
tcBudgetOverrunTotal	character	Budget.BudgetOverrunTotal	Total Overrun
tiCurrency_ID	integer	Budget.Currency_ID	Currency Code
tiUsr_ID	integer	Budget.Usr_ID	Budget Administrator
tiProject_ID	integer	Budget.Project_ID	Project Code
tiCostCentre_ID	integer	Budget.CostCentre_ID	Cost Center Code
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcProjectCode	character	Project.ProjectCode	Project

Internal usage

QadFinancials

method BBudget.ApiGetBudgetWBS
method BBudget.ApiGetBudgetWBSSafInfo
method BBudget.BudgetCheckInfoResolveReadDB
method BBudget.CheckBudgetFDSWBS
method BBudget.InitialValues
method BBudgetRebuild.ApiRebuildBudget
method BProject.ValidateComponent
dataset BBudget.tBudgetByBudgetIDCodeStatus