business logic query BudgetWBSByBudgetIDWBSCode

Description

BudgetWBSByBudgetID

Parameters

iiBudgetID	integer	Budget ID
iiBudgetWBSID	integer	BudgetWBSID
icBudgetWBSCode	character	BudgetWBSCode
iiParentBudgetWBSID	integer	ParentBudgetWBSID
icBudgetCode	character	BudgetCode
icBudgetStatus	character	BudgetStatus

query condition

each BudgetWBS where

BudgetWBS.Budget_ID = iiBudgetID AND
BudgetWBS.BudgetWBS_ID = iiBudgetWBSID AND
BudgetWBS.BudgetWBSCode = icBudgetWBSCode AND
BudgetWBS.ParentBudgetWBS_ID = iiParentBudgetWBSID

first AltCOAGroup (conditional-join) where

AltCOAGroup.AltCOAGroup_ID = BudgetWBS.AltCOAGroup_ID AND

first Budget (inner-join) where

Budget.Budget_ID = BudgetWBS.Budget_ID AND
Budget.BudgetCode = icBudgetCode AND
Budget.BudgetStatus = icBudgetStatus

first BudgetGroup (conditional-join) where

BudgetGroup.BudgetGroup_ID = BudgetWBS.BudgetGroup_ID AND

first Unit (outer-join) where

Unit.Unit_ID = BudgetWBS.Unit_ID AND

query resultset tqBudgetWBSByBudgetID

field name	data type	db field	description
tiAltCOAGroup_ID	integer	BudgetWBS.AltCOAGroup_ID	Alternate COA Group
tcAltCOAGroupCode	character	AltCOAGroup.AltCOAGroupCode	Alternate COA Group Code
tiBudget_ID	integer	BudgetWBS.Budget_ID	Link to Budget
tcBudgetCode	character	Budget.BudgetCode	Budget Code
tiBudgetFDS_ID	integer	BudgetWBS.BudgetFDS_ID	Link to BudgetFDS
tiBudgetFDSSeq	integer	BudgetWBS.BudgetFDSSeq	COA Sequence
tcBudgetFDSType	character	BudgetWBS.BudgetFDSType	COA Type
tiBudgetGroup_ID	integer	BudgetWBS.BudgetGroup_ID	Budget Group
tcBudgetGroupCode	character	BudgetGroup.BudgetGroupCode	Budget Group
tlBudgetGroupIsActive	logical	BudgetGroup.BudgetGroupIsActive	Active
tlBudgetIsReportStruct	logical	Budget.BudgetIsReportStruct	Use as Report
tcBudgetStatus	character	Budget.BudgetStatus	Status
tiBudgetWBS_ID	integer	BudgetWBS.BudgetWBS_ID	Record ID
tcBudgetWBSCategory	character	BudgetWBS.BudgetWBSCategory	Category
tcBudgetWBSCode	character	BudgetWBS.BudgetWBSCode	WBS Code
tcBudgetWBSComment	character	BudgetWBS.BudgetWBSComment	Comment
tcBudgetWBSCostRevenue	character	BudgetWBS.BudgetWBSCostRevenue	Cost/Revenue
tcBudgetWBSCostType	character	BudgetWBS.BudgetWBSCostType	Cost Type
tcBudgetWBSFDSCode	character	BudgetWBS.BudgetWBSFDSCode	COA Code
tcBudgetWBSFDSDefault	character	BudgetWBS.BudgetWBSFDSDefault	COA Default
tcBudgetWBSFDSFromCode	character	BudgetWBS.BudgetWBSFDSFromCode	From COA
tcBudgetWBSFDSList	character	BudgetWBS.BudgetWBSFDSList	COA List
tcBudgetWBSFDSToCode	character	BudgetWBS.BudgetWBSFDSToCode	To COA
tlBudgetWBSIsHideOnReport	logical	BudgetWBS.BudgetWBSIsHideOnReport	Hide On Reporting
tlBudgetWBSIsInvertBase	logical	BudgetWBS.BudgetWBSIsInvertBase	Invert Base Sign
tlBudgetWBSIsPrintDesc	logical	BudgetWBS.BudgetWBSIsPrintDesc	Print Description
tlBudgetWBSIsRollUp	logical	BudgetWBS.BudgetWBSIsRollUp	Roll Up Amount
tlBudgetWBSIsWithSumLine	logical	BudgetWBS.BudgetWBSIsWithSumLine	Print Sum Line
tiBudgetWBSLineNumber	integer	BudgetWBS.BudgetWBSLineNumber	Class
tcBudgetWBSOverrunPeriod	character	BudgetWBS.BudgetWBSOverrunPeriod	GL Period Overrun
tcBudgetWBSOverrunTotal	character	BudgetWBS.BudgetWBSOverrunTotal	Total Overrun
tcBudgetWBSOverrunYTD	character	BudgetWBS.BudgetWBSOverrunYTD	Overrun (YTD)
tdBudgetWBSPercOfComp	decimal	BudgetWBS.BudgetWBSPercOfComp	Percentage (ETC)
tdBudgetWBSSeq	decimal	BudgetWBS.BudgetWBSSeq	WBS Seq
tcBudgetWBSStatus	character	BudgetWBS.BudgetWBSStatus	Status
tcBudgetWBSTopicDescription	character	BudgetWBS.BudgetWBSTopicDescription	Topic Description
tiCostCentreSharedSet_ID	integer	Budget.CostCentreSharedSet_ID	Link to SharedSet
tiDivisionSharedSet_ID	integer	Budget.DivisionSharedSet_ID	Link to SharedSet
tiGLSharedSet_ID	integer	Budget.GLSharedSet_ID	Link to SharedSet
tiParentBudgetWBS_ID	integer	BudgetWBS.ParentBudgetWBS_ID	Link to BudgetWBS
tiSafConcept_ID	integer	BudgetWBS.SafConcept_ID	SAF Concept Code
tiSafStructure_ID	integer	BudgetWBS.SafStructure_ID	SAF Structure
tiUnit_ID	integer	BudgetWBS.Unit_ID	GL Account Unit of Measure
tcUnitCode	character	Unit.UnitCode	Unit of Measure
tlUnitIsActive	logical	Unit.UnitIsActive	Active
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BudgetWBS),rowid(AltCOAGroup),rowid(Budget),rowid(BudgetGroup),rowid(Unit)

Internal usage

QadFinancials

method BBudget.ApiGetBudgetWBS
method BBudget.ApiGetBudgetWBSSafInfo
method BBudget.ApiGetBudgetWBSSafInfoDetails
method BBudget.BudgetCheckFDSOverlap
method BBudgetLinkAcc.ApiCreateOrUpdateBudgetLinkAcc
method BBudgetLinkAccDet.ApiCreateOrUpdateBudgetLinkAccDet