project QadFinancials > class BBudgetGroup > business logic query BudgetGroupPrim

Annotation

BudgetGroupPrim; prim-query on table budgetgroup that converts the logical key (code) into the physical key (ID)

Parameters

iiBudgetGroupID	integer	BudgetGroupID
icBudgetGroupCode	character	BudgetGroupCode

query condition

each BudgetGroup where

BudgetGroup.BudgetGroup_ID = iiBudgetGroupID AND
BudgetGroup.BudgetGroupCode = icBudgetGroupCode AND
BudgetGroup.BudgetGroupCategory = 1

query resultset tqBudgetGroupPrim

field name	data type	db field	description
tiBudgetGroupCategory	integer	BudgetGroup.BudgetGroupCategory	Budget Group Category
tiBudgetGroup_ID	integer	BudgetGroup.BudgetGroup_ID	Record ID
tcBudgetGroupCode	character	BudgetGroup.BudgetGroupCode	Budget Group

Internal usage

QadFinancials

method BAnalyticalReport.CostCentreTransDet
method BAnalyticalReport.CostCentreTransDetHist
method BAnalyticalReport.CostCentreTransSumm
method BAnalyticalReport.CostCentreTransSummCompPer
method BAnalyticalReport.CostCentreTransSummHist
method BAnalyticalReport.ProjectTransDet
method BAnalyticalReport.ProjectTransDetHist
method BAnalyticalReport.ProjectTransSumm
method BAnalyticalReport.ProjectTransSummCompPer
method BAnalyticalReport.ProjectTransSummHist
method BAnalyticalReport.SafOnlyTransDet
method BAnalyticalReport.SafOnlyTransDetHist
method BAnalyticalReport.SafOnlyTransSumm
method BAnalyticalReport.SafOnlyTransSummCompPer
method BAnalyticalReport.SafOnlyTransSummHist
method BBudget.BudgetWBSAutoLinkAssignFDS
method BBudget.BudgetWBSUpdateSub
method BBudget.ValidateComponentBudgetWBS
method BCostCentre.ApiLoadCostCentreCalcBudget
method BDivision.ApiLoadDivisonCalcBudget
method BGL.ApiLoadGL
method BGL.ApiLoadGLCalcBudgetGroupCode
method BProject.ApiLoadProject
method BProject.ApiLoadProjectCalcBudgetGroupCode
read related business field(s) on tBudgetWBS.BudgetGroup_ID
read related business field(s) on tCostCentre.BudgetGroup_ID
read related business field(s) on tDivision.BudgetGroup_ID
read related business field(s) on tGL.BudgetGroup_ID
read related business field(s) on tProject.BudgetGroup_ID
read related business field(s) on tSaf.BudgetGroup_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tBudgetWBS.BudgetGroup_ID
validate related business field(s) on tCostCentre.BudgetGroup_ID
validate related business field(s) on tDivision.BudgetGroup_ID
validate related business field(s) on tGL.BudgetGroup_ID
validate related business field(s) on tProject.BudgetGroup_ID
validate related business field(s) on tSaf.BudgetGroup_ID