business logic query ProjectBudgetByProjectID

Parameters

iiCompanyId	integer	Company id
iiProject_ID	integer
ilActiveBudget	logical

query condition

each Project where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = iiProject_ID

each Budget (conditional-join) where

Budget.Project_ID = Project.Project_ID AND

each BudgetCompany (conditional-join) where

BudgetCompany.Company_Id = iiCompanyId AND
BudgetCompany.Budget_ID = Budget.Budget_ID AND

first Company (conditional-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = BudgetCompany.Company_ID AND

each BudgetPeriod (conditional-join) where

BudgetPeriod.Budget_ID = Budget.Budget_ID AND

each BudgetVersion (conditional-join) where

BudgetVersion.Budget_ID = Budget.Budget_ID AND
BudgetVersion.BudgetVersionIsActive = ilActiveBudget

each BudgetVersionFig (conditional-join) where

BudgetVersionFig.BudgetVersion_ID = BudgetVersion.BudgetVersion_ID AND

first BudgetWBS1 (conditional-join) where

BudgetWBS1.BudgetWBS_ID = BudgetVersionFig.BudgetWBS_ID AND

each BudgetWBS2 (conditional-join) where

BudgetWBS2.Budget_ID = Budget.Budget_ID AND

first BudgetGroup (conditional-join) where

BudgetGroup.BudgetGroup_ID = Project.BudgetGroup_ID AND

query resultset tqProjectBudgetByProjectID

field name	data type	db field	description
tiBudget_ID	integer	Budget.Budget_ID	Record ID
tcBudgetCheckReportPeriod	character	Budget.BudgetCheckReportPeriod	Report Period Check
tcBudgetCode	character	Budget.BudgetCode	Budget Code
tcBudgetCompanyCode	character	Company.CompanyCode	Entity Code
tcBudgetDescription	character	Budget.BudgetDescription	Description
tiBudgetFDSSeq	integer	BudgetWBS2.BudgetFDSSeq	COA Sequence
tcBudgetFDSType	character	BudgetWBS2.BudgetFDSType	COA Type
tcBudgetFigureWBSCode	character	BudgetWBS1.BudgetWBSCode	WBS Code
tiBudgetGroup_ID	integer	BudgetGroup.BudgetGroup_ID	Record ID
tcBudgetGroupCode	character	BudgetGroup.BudgetGroupCode	Budget Group
tcBudgetGroupDescription	character	BudgetGroup.BudgetGroupDescription	Description
tlBudgetGroupIsActive	logical	BudgetGroup.BudgetGroupIsActive	Active
tiBudgetInputLevelBudget	integer	Budget.BudgetInputLevelBudget	Input Level (Budget)
tiBudgetInputLevelEAC	integer	Budget.BudgetInputLevelEAC	Input Level (PM)
tiBudgetInputLevelFin	integer	Budget.BudgetInputLevelFin	Input Level (Fin)
tlBudgetIsAutoRollUp	logical	Budget.BudgetIsAutoRollUp	Auto Roll-Up
tlBudgetIsCheckActualOnLine	logical	Budget.BudgetIsCheckActualOnLine	Check Actuals Online
tlBudgetIsCheckCommitOnLine	logical	Budget.BudgetIsCheckCommitOnLine	Check Commitments Online
tlBudgetIsCompanyDependent	logical	Budget.BudgetIsCompanyDependent	Entity Dependent
tlBudgetIsWithQuantityData	logical	Budget.BudgetIsWithQuantityData	Use Quantity Info
tcBudgetOverrunPeriod	character	Budget.BudgetOverrunPeriod	GL Period Overrun
tcBudgetOverrunTotal	character	Budget.BudgetOverrunTotal	Total Overrun
tcBudgetOverrunYTD	character	Budget.BudgetOverrunYTD	Overrun (YTD)
tcBudgetPeriodCode	character	BudgetPeriod.BudgetPeriodCode	Period Code
ttBudgetPeriodFromDate	date	BudgetPeriod.BudgetPeriodFromDate	Start Date
tiBudgetPeriodSeq	integer	BudgetPeriod.BudgetPeriodSeq	GL Period Seq
ttBudgetPeriodTillDate	date	BudgetPeriod.BudgetPeriodTillDate	End Date
tcBudgetStatus	character	Budget.BudgetStatus	Status
tcBudgetVersionCode	character	BudgetVersion.BudgetVersionCode	Version Code
tcBudgetVersionComment	character	BudgetVersion.BudgetVersionComment	Comment
ttBudgetVersionCreateDate	date	BudgetVersion.BudgetVersionCreateDate	Creation Date
tiBudgetVersionCreateTime	integer	BudgetVersion.BudgetVersionCreateTime	Creation Time
tcBudgetVersionDescription	character	BudgetVersion.BudgetVersionDescription	Description
tiBudgetVersionFig_ID	integer	BudgetVersionFig.BudgetVersionFig_ID	Record ID
tdBudgetVersionFig01EacQTY	decimal	BudgetVersionFig.BudgetVersionFig01EacQTY	PM Forecast Qty (01)
tdBudgetVersionFig01EacTC	decimal	BudgetVersionFig.BudgetVersionFig01EacTC	PM Forecast Cost LTE (01)
tdBudgetVersionFig01FinQTY	decimal	BudgetVersionFig.BudgetVersionFig01FinQTY	Contr Forecast Qty (01)
tdBudgetVersionFig01FinTC	decimal	BudgetVersionFig.BudgetVersionFig01FinTC	Contr Forecast Cost LTE (01)
tdBudgetVersionFig01QTY	decimal	BudgetVersionFig.BudgetVersionFig01QTY	Budget Qty (01)
tdBudgetVersionFig01SEacTC	decimal	BudgetVersionFig.BudgetVersionFig01SEacTC	PM Forecast Revenue (01)
tdBudgetVersionFig01SFinTC	decimal	BudgetVersionFig.BudgetVersionFig01SFinTC	Contr Forecast Rev (01)
tdBudgetVersionFig01STC	decimal	BudgetVersionFig.BudgetVersionFig01STC	Budget Rev (01)
tdBudgetVersionFig01TC	decimal	BudgetVersionFig.BudgetVersionFig01TC	Budget Cost (01)
tdBudgetVersionFig02EacQTY	decimal	BudgetVersionFig.BudgetVersionFig02EacQTY	PM Forecast Qty (02)
tdBudgetVersionFig02EacTC	decimal	BudgetVersionFig.BudgetVersionFig02EacTC	PM Forecast Cost LTE (02)
tdBudgetVersionFig02FinQTY	decimal	BudgetVersionFig.BudgetVersionFig02FinQTY	Contr Forecast Qty (02)
tdBudgetVersionFig02FinTC	decimal	BudgetVersionFig.BudgetVersionFig02FinTC	Contr Forecast Cost LTE (02)
tdBudgetVersionFig02QTY	decimal	BudgetVersionFig.BudgetVersionFig02QTY	Budget Qty (02)
tdBudgetVersionFig02SEacTC	decimal	BudgetVersionFig.BudgetVersionFig02SEacTC	PM Forecast Revenue (02)
tdBudgetVersionFig02SFinTC	decimal	BudgetVersionFig.BudgetVersionFig02SFinTC	Contr Forecast Rev (02)
tdBudgetVersionFig02STC	decimal	BudgetVersionFig.BudgetVersionFig02STC	Budget Rev (02)
tdBudgetVersionFig02TC	decimal	BudgetVersionFig.BudgetVersionFig02TC	Budget Cost (02)
tdBudgetVersionFig03EacQTY	decimal	BudgetVersionFig.BudgetVersionFig03EacQTY	PM Forecast Qty (03)
tdBudgetVersionFig03EacTC	decimal	BudgetVersionFig.BudgetVersionFig03EacTC	PM Forecast Cost LTE (03)
tdBudgetVersionFig03FinQTY	decimal	BudgetVersionFig.BudgetVersionFig03FinQTY	Contr Forecast Qty (03)
tdBudgetVersionFig03FinTC	decimal	BudgetVersionFig.BudgetVersionFig03FinTC	Contr Forecast Cost LTE (03)
tdBudgetVersionFig03QTY	decimal	BudgetVersionFig.BudgetVersionFig03QTY	Budget Qty (03)
tdBudgetVersionFig03SEacTC	decimal	BudgetVersionFig.BudgetVersionFig03SEacTC	PM Forecast Revenue (03)
tdBudgetVersionFig03SFinTC	decimal	BudgetVersionFig.BudgetVersionFig03SFinTC	Contr Forecast Rev (03)
tdBudgetVersionFig03STC	decimal	BudgetVersionFig.BudgetVersionFig03STC	Budget Rev (03)
tdBudgetVersionFig03TC	decimal	BudgetVersionFig.BudgetVersionFig03TC	Budget Cost (03)
tdBudgetVersionFig04EacQTY	decimal	BudgetVersionFig.BudgetVersionFig04EacQTY	PM Forecast Qty (04)
tdBudgetVersionFig04EacTC	decimal	BudgetVersionFig.BudgetVersionFig04EacTC	PM Forecast Cost LTE (04)
tdBudgetVersionFig04FinQTY	decimal	BudgetVersionFig.BudgetVersionFig04FinQTY	Contr Forecast Qty (04)
tdBudgetVersionFig04FinTC	decimal	BudgetVersionFig.BudgetVersionFig04FinTC	Contr Forecast Cost LTE (04)
tdBudgetVersionFig04QTY	decimal	BudgetVersionFig.BudgetVersionFig04QTY	Budget Qty (04)
tdBudgetVersionFig04SEacTC	decimal	BudgetVersionFig.BudgetVersionFig04SEacTC	PM Forecast Revenue (04)
tdBudgetVersionFig04SFinTC	decimal	BudgetVersionFig.BudgetVersionFig04SFinTC	Contr Forecast Rev (04)
tdBudgetVersionFig04STC	decimal	BudgetVersionFig.BudgetVersionFig04STC	Budget Rev (04)
tdBudgetVersionFig04TC	decimal	BudgetVersionFig.BudgetVersionFig04TC	Budget Cost (04)
tdBudgetVersionFig05EacQTY	decimal	BudgetVersionFig.BudgetVersionFig05EacQTY	PM Forecast Qty (05)
tdBudgetVersionFig05EacTC	decimal	BudgetVersionFig.BudgetVersionFig05EacTC	PM Forecast Cost LTE (05)
tdBudgetVersionFig05FinQTY	decimal	BudgetVersionFig.BudgetVersionFig05FinQTY	Contr Forecast Qty (05)
tdBudgetVersionFig05FinTC	decimal	BudgetVersionFig.BudgetVersionFig05FinTC	Contr Forecast Cost LTE (05)
tdBudgetVersionFig05QTY	decimal	BudgetVersionFig.BudgetVersionFig05QTY	Budget Qty (05)
tdBudgetVersionFig05SEacTC	decimal	BudgetVersionFig.BudgetVersionFig05SEacTC	PM Forecast Revenue (05)
tdBudgetVersionFig05SFinTC	decimal	BudgetVersionFig.BudgetVersionFig05SFinTC	Contr Forecast Rev (05)
tdBudgetVersionFig05STC	decimal	BudgetVersionFig.BudgetVersionFig05STC	Budget Rev (05)
tdBudgetVersionFig05TC	decimal	BudgetVersionFig.BudgetVersionFig05TC	Budget Cost (05)
tdBudgetVersionFig06EacQTY	decimal	BudgetVersionFig.BudgetVersionFig06EacQTY	PM Forecast Qty (06)
tdBudgetVersionFig06EacTC	decimal	BudgetVersionFig.BudgetVersionFig06EacTC	PM Forecast Cost LTE (06)
tdBudgetVersionFig06FinQTY	decimal	BudgetVersionFig.BudgetVersionFig06FinQTY	Contr Forecast Qty (06)
tdBudgetVersionFig06FinTC	decimal	BudgetVersionFig.BudgetVersionFig06FinTC	Contr Forecast Cost LTE (06)
tdBudgetVersionFig06QTY	decimal	BudgetVersionFig.BudgetVersionFig06QTY	Budget Qty (06)
tdBudgetVersionFig06SEacTC	decimal	BudgetVersionFig.BudgetVersionFig06SEacTC	PM Forecast Revenue (06)
tdBudgetVersionFig06SFinTC	decimal	BudgetVersionFig.BudgetVersionFig06SFinTC	Contr Forecast Rev (06)
tdBudgetVersionFig06STC	decimal	BudgetVersionFig.BudgetVersionFig06STC	Budget Rev (06)
tdBudgetVersionFig06TC	decimal	BudgetVersionFig.BudgetVersionFig06TC	Budget Cost (06)
tdBudgetVersionFig07EacQTY	decimal	BudgetVersionFig.BudgetVersionFig07EacQTY	PM Forecast Qty (07)
tdBudgetVersionFig07EacTC	decimal	BudgetVersionFig.BudgetVersionFig07EacTC	PM Forecast Cost LTE (07)
tdBudgetVersionFig07FinQTY	decimal	BudgetVersionFig.BudgetVersionFig07FinQTY	Contr Forecast Qty (07)
tdBudgetVersionFig07FinTC	decimal	BudgetVersionFig.BudgetVersionFig07FinTC	Contr Forecast Cost LTE (07)
tdBudgetVersionFig07QTY	decimal	BudgetVersionFig.BudgetVersionFig07QTY	Budget Qty (07)
tdBudgetVersionFig07SEacTC	decimal	BudgetVersionFig.BudgetVersionFig07SEacTC	PM Forecast Revenue (07)
tdBudgetVersionFig07SFinTC	decimal	BudgetVersionFig.BudgetVersionFig07SFinTC	Contr Forecast Rev (07)
tdBudgetVersionFig07STC	decimal	BudgetVersionFig.BudgetVersionFig07STC	Budget Rev (07)
tdBudgetVersionFig07TC	decimal	BudgetVersionFig.BudgetVersionFig07TC	Budget Cost (07)
tdBudgetVersionFig08EacQTY	decimal	BudgetVersionFig.BudgetVersionFig08EacQTY	PM Forecast Qty (08)
tdBudgetVersionFig08EacTC	decimal	BudgetVersionFig.BudgetVersionFig08EacTC	PM Forecast Cost-LTE (08)
tdBudgetVersionFig08FinQTY	decimal	BudgetVersionFig.BudgetVersionFig08FinQTY	Contr Forecast Qty (08)
tdBudgetVersionFig08FinTC	decimal	BudgetVersionFig.BudgetVersionFig08FinTC	Contr Forecast Cost LTE (08)
tdBudgetVersionFig08QTY	decimal	BudgetVersionFig.BudgetVersionFig08QTY	Budget Qty (08)
tdBudgetVersionFig08SEacTC	decimal	BudgetVersionFig.BudgetVersionFig08SEacTC	PM Forecast Revenue (08)
tdBudgetVersionFig08SFinTC	decimal	BudgetVersionFig.BudgetVersionFig08SFinTC	Contr Forecast Rev (08)
tdBudgetVersionFig08STC	decimal	BudgetVersionFig.BudgetVersionFig08STC	Budget Rev (08)
tdBudgetVersionFig08TC	decimal	BudgetVersionFig.BudgetVersionFig08TC	Budget Cost (08)
tdBudgetVersionFig09EacQTY	decimal	BudgetVersionFig.BudgetVersionFig09EacQTY	PM Forecast Qty (09)
tdBudgetVersionFig09EacTC	decimal	BudgetVersionFig.BudgetVersionFig09EacTC	PM Forecast Cost LTE (09)
tdBudgetVersionFig09FinQTY	decimal	BudgetVersionFig.BudgetVersionFig09FinQTY	Contr Forecast Qty (09)
tdBudgetVersionFig09FinTC	decimal	BudgetVersionFig.BudgetVersionFig09FinTC	Contr Forecast Cost LTE (09)
tdBudgetVersionFig09QTY	decimal	BudgetVersionFig.BudgetVersionFig09QTY	Budget Qty (09)
tdBudgetVersionFig09SEacTC	decimal	BudgetVersionFig.BudgetVersionFig09SEacTC	PM Forecast Revenue (09)
tdBudgetVersionFig09SFinTC	decimal	BudgetVersionFig.BudgetVersionFig09SFinTC	Contr Forecast Rev (09)
tdBudgetVersionFig09STC	decimal	BudgetVersionFig.BudgetVersionFig09STC	Budget Rev (09)
tdBudgetVersionFig09TC	decimal	BudgetVersionFig.BudgetVersionFig09TC	Budget Cost (09)
tdBudgetVersionFig10EacQTY	decimal	BudgetVersionFig.BudgetVersionFig10EacQTY	PM Forecast Qty (10)
tdBudgetVersionFig10EacTC	decimal	BudgetVersionFig.BudgetVersionFig10EacTC	PM Forecast Cost LTE (10)
tdBudgetVersionFig10FinQTY	decimal	BudgetVersionFig.BudgetVersionFig10FinQTY	Contr Forecast Qty (10)
tdBudgetVersionFig10FinTC	decimal	BudgetVersionFig.BudgetVersionFig10FinTC	Contr Forecast Cost LTE (10)
tdBudgetVersionFig10QTY	decimal	BudgetVersionFig.BudgetVersionFig10QTY	Budget Qty (10)
tdBudgetVersionFig10SEacTC	decimal	BudgetVersionFig.BudgetVersionFig10SEacTC	PM Forecast Revenue (10)
tdBudgetVersionFig10SFinTC	decimal	BudgetVersionFig.BudgetVersionFig10SFinTC	Contr Forecast Rev (10)
tdBudgetVersionFig10STC	decimal	BudgetVersionFig.BudgetVersionFig10STC	Budget Rev (10)
tdBudgetVersionFig10TC	decimal	BudgetVersionFig.BudgetVersionFig10TC	Budget Cost (10)
tdBudgetVersionFig11EacQTY	decimal	BudgetVersionFig.BudgetVersionFig11EacQTY	PM Forecast Qty (11)
tdBudgetVersionFig11EacTC	decimal	BudgetVersionFig.BudgetVersionFig11EacTC	PM Forecast Cost LTE (11)
tdBudgetVersionFig11FinQTY	decimal	BudgetVersionFig.BudgetVersionFig11FinQTY	Contr Forecast Qty (11)
tdBudgetVersionFig11FinTC	decimal	BudgetVersionFig.BudgetVersionFig11FinTC	Contr Forecast Cost LTE (11)
tdBudgetVersionFig11QTY	decimal	BudgetVersionFig.BudgetVersionFig11QTY	Budget Qty (11)
tdBudgetVersionFig11SEacTC	decimal	BudgetVersionFig.BudgetVersionFig11SEacTC	PM Forecast Revenue (11)
tdBudgetVersionFig11SFinTC	decimal	BudgetVersionFig.BudgetVersionFig11SFinTC	Contr Forecast Rev (11)
tdBudgetVersionFig11STC	decimal	BudgetVersionFig.BudgetVersionFig11STC	Budget Rev (11)
tdBudgetVersionFig11TC	decimal	BudgetVersionFig.BudgetVersionFig11TC	Budget Cost (11)
tdBudgetVersionFig12EacQTY	decimal	BudgetVersionFig.BudgetVersionFig12EacQTY	PM Forecast Qty (12)
tdBudgetVersionFig12EacTC	decimal	BudgetVersionFig.BudgetVersionFig12EacTC	PM Forecast Cost LTE (12)
tdBudgetVersionFig12FinQTY	decimal	BudgetVersionFig.BudgetVersionFig12FinQTY	Contr Forecast Qty (12)
tdBudgetVersionFig12FinTC	decimal	BudgetVersionFig.BudgetVersionFig12FinTC	Contr Forecast Cost LTE (12)
tdBudgetVersionFig12QTY	decimal	BudgetVersionFig.BudgetVersionFig12QTY	Budget Qty (12)
tdBudgetVersionFig12SEacTC	decimal	BudgetVersionFig.BudgetVersionFig12SEacTC	PM Forecast Revenue (12)
tdBudgetVersionFig12SFinTC	decimal	BudgetVersionFig.BudgetVersionFig12SFinTC	Contr Forecast Rev (12)
tdBudgetVersionFig12STC	decimal	BudgetVersionFig.BudgetVersionFig12STC	Budget Rev (12)
tdBudgetVersionFig12TC	decimal	BudgetVersionFig.BudgetVersionFig12TC	Budget Cost (12)
tdBudgetVersionFig13EacQTY	decimal	BudgetVersionFig.BudgetVersionFig13EacQTY	PM Frc Qty (13)
tdBudgetVersionFig13EacTC	decimal	BudgetVersionFig.BudgetVersionFig13EacTC	PM Forecast Cost LTE (13)
tdBudgetVersionFig13FinQTY	decimal	BudgetVersionFig.BudgetVersionFig13FinQTY	Contr Forecast Qty (13)
tdBudgetVersionFig13FinTC	decimal	BudgetVersionFig.BudgetVersionFig13FinTC	Contr Forecast Cost LTE (13)
tdBudgetVersionFig13QTY	decimal	BudgetVersionFig.BudgetVersionFig13QTY	Budget Qty (13)
tdBudgetVersionFig13SEacTC	decimal	BudgetVersionFig.BudgetVersionFig13SEacTC	PM Frc Rev (13)
tdBudgetVersionFig13SFinTC	decimal	BudgetVersionFig.BudgetVersionFig13SFinTC	Contr Forecast Rev (13)
tdBudgetVersionFig13STC	decimal	BudgetVersionFig.BudgetVersionFig13STC	Budget Rev (13)
tdBudgetVersionFig13TC	decimal	BudgetVersionFig.BudgetVersionFig13TC	Budget Cost (13)
tdBudgetVersionFig14EacQTY	decimal	BudgetVersionFig.BudgetVersionFig14EacQTY	PM Frc Qty (14)
tdBudgetVersionFig14EacTC	decimal	BudgetVersionFig.BudgetVersionFig14EacTC	PM Forecast Cost LTE (14)
tdBudgetVersionFig14FinQTY	decimal	BudgetVersionFig.BudgetVersionFig14FinQTY	Contr Forecast Qty (14)
tdBudgetVersionFig14FinTC	decimal	BudgetVersionFig.BudgetVersionFig14FinTC	Contr Forecast Cost LTE (14)
tdBudgetVersionFig14QTY	decimal	BudgetVersionFig.BudgetVersionFig14QTY	Budget Qty (14)
tdBudgetVersionFig14SEacTC	decimal	BudgetVersionFig.BudgetVersionFig14SEacTC	PM Frc Rev (14)
tdBudgetVersionFig14SFinTC	decimal	BudgetVersionFig.BudgetVersionFig14SFinTC	Contr Forecast Rev (14)
tdBudgetVersionFig14STC	decimal	BudgetVersionFig.BudgetVersionFig14STC	Budget Rev (14)
tdBudgetVersionFig14TC	decimal	BudgetVersionFig.BudgetVersionFig14TC	Budget Cost (14)
tdBudgetVersionFig15EacQTY	decimal	BudgetVersionFig.BudgetVersionFig15EacQTY	PM Frc Qty (15)
tdBudgetVersionFig15EacTC	decimal	BudgetVersionFig.BudgetVersionFig15EacTC	PM Forecast Cost LTE (15)
tdBudgetVersionFig15FinQTY	decimal	BudgetVersionFig.BudgetVersionFig15FinQTY	Contr Forecast Qty (15)
tdBudgetVersionFig15FinTC	decimal	BudgetVersionFig.BudgetVersionFig15FinTC	Contr Forecast Cost LTE (15)
tdBudgetVersionFig15QTY	decimal	BudgetVersionFig.BudgetVersionFig15QTY	Budget Qty (15)
tdBudgetVersionFig15SEacTC	decimal	BudgetVersionFig.BudgetVersionFig15SEacTC	PM Frc Rev (15)
tdBudgetVersionFig15SFinTC	decimal	BudgetVersionFig.BudgetVersionFig15SFinTC	Contr Forecast Rev (15)
tdBudgetVersionFig15STC	decimal	BudgetVersionFig.BudgetVersionFig15STC	Budget Rev (15)
tdBudgetVersionFig15TC	decimal	BudgetVersionFig.BudgetVersionFig15TC	Budget Cost (15)
tdBudgetVersionFig16EacQTY	decimal	BudgetVersionFig.BudgetVersionFig16EacQTY	PM Frc Qty (16)
tdBudgetVersionFig16EacTC	decimal	BudgetVersionFig.BudgetVersionFig16EacTC	PM Forecast Cost LTE (16)
tdBudgetVersionFig16FinQTY	decimal	BudgetVersionFig.BudgetVersionFig16FinQTY	Contr Forecast Qty (16)
tdBudgetVersionFig16FinTC	decimal	BudgetVersionFig.BudgetVersionFig16FinTC	Contr Forecast Cost LTE (16)
tdBudgetVersionFig16QTY	decimal	BudgetVersionFig.BudgetVersionFig16QTY	Budget Qty (16)
tdBudgetVersionFig16SEacTC	decimal	BudgetVersionFig.BudgetVersionFig16SEacTC	PM Frc Rev (16)
tdBudgetVersionFig16SFinTC	decimal	BudgetVersionFig.BudgetVersionFig16SFinTC	Contr Forecast Rev (16)
tdBudgetVersionFig16STC	decimal	BudgetVersionFig.BudgetVersionFig16STC	Budget Rev (16)
tdBudgetVersionFig16TC	decimal	BudgetVersionFig.BudgetVersionFig16TC	Budget Cost (16)
tdBudgetVersionFig17EacQTY	decimal	BudgetVersionFig.BudgetVersionFig17EacQTY	PM Frc Qty (17)
tdBudgetVersionFig17EacTC	decimal	BudgetVersionFig.BudgetVersionFig17EacTC	PM Forecast Cost LTE (17)
tdBudgetVersionFig17FinQTY	decimal	BudgetVersionFig.BudgetVersionFig17FinQTY	Contr Forecast Qty (17)
tdBudgetVersionFig17FinTC	decimal	BudgetVersionFig.BudgetVersionFig17FinTC	Contr Forecast Cost LTE (17)
tdBudgetVersionFig17QTY	decimal	BudgetVersionFig.BudgetVersionFig17QTY	Budget Qty (17)
tdBudgetVersionFig17SEacTC	decimal	BudgetVersionFig.BudgetVersionFig17SEacTC	PM Frc Rev (17)
tdBudgetVersionFig17SFinTC	decimal	BudgetVersionFig.BudgetVersionFig17SFinTC	Contr Forecast Rev (17)
tdBudgetVersionFig17STC	decimal	BudgetVersionFig.BudgetVersionFig17STC	Budget Rev (17)
tdBudgetVersionFig17TC	decimal	BudgetVersionFig.BudgetVersionFig17TC	Budget Cost (17)
tdBudgetVersionFig18EacQTY	decimal	BudgetVersionFig.BudgetVersionFig18EacQTY	PM Frc Qty (18)
tdBudgetVersionFig18EacTC	decimal	BudgetVersionFig.BudgetVersionFig18EacTC	PM Forecast Cost LTE (18)
tdBudgetVersionFig18FinQTY	decimal	BudgetVersionFig.BudgetVersionFig18FinQTY	Contr Forecast Qty (18)
tdBudgetVersionFig18FinTC	decimal	BudgetVersionFig.BudgetVersionFig18FinTC	Contr Forecast Cost LTE (18)
tdBudgetVersionFig18QTY	decimal	BudgetVersionFig.BudgetVersionFig18QTY	Budget Qty (18)
tdBudgetVersionFig18SEacTC	decimal	BudgetVersionFig.BudgetVersionFig18SEacTC	PM Frc Rev (18)
tdBudgetVersionFig18SFinTC	decimal	BudgetVersionFig.BudgetVersionFig18SFinTC	Contr Forecast Rev (18)
tdBudgetVersionFig18STC	decimal	BudgetVersionFig.BudgetVersionFig18STC	Budget Rev (18)
tdBudgetVersionFig18TC	decimal	BudgetVersionFig.BudgetVersionFig18TC	Budget Cost (18)
tdBudgetVersionFig19EacQTY	decimal	BudgetVersionFig.BudgetVersionFig19EacQTY	PM Frc Qty (19)
tdBudgetVersionFig19EacTC	decimal	BudgetVersionFig.BudgetVersionFig19EacTC	PM Forecast Cost LTE (19)
tdBudgetVersionFig19FinQTY	decimal	BudgetVersionFig.BudgetVersionFig19FinQTY	Contr Forecast Qty (19)
tdBudgetVersionFig19FinTC	decimal	BudgetVersionFig.BudgetVersionFig19FinTC	Contr Forecast Cost LTE (19)
tdBudgetVersionFig19QTY	decimal	BudgetVersionFig.BudgetVersionFig19QTY	Budget Qty (19)
tdBudgetVersionFig19SEacTC	decimal	BudgetVersionFig.BudgetVersionFig19SEacTC	PM Frc Rev (19)
tdBudgetVersionFig19SFinTC	decimal	BudgetVersionFig.BudgetVersionFig19SFinTC	Contr Forecast Rev (19)
tdBudgetVersionFig19STC	decimal	BudgetVersionFig.BudgetVersionFig19STC	Budget Rev (19)
tdBudgetVersionFig19TC	decimal	BudgetVersionFig.BudgetVersionFig19TC	Budget Cost (19)
tdBudgetVersionFig20EacQTY	decimal	BudgetVersionFig.BudgetVersionFig20EacQTY	PM Frc Qty (20)
tdBudgetVersionFig20EacTC	decimal	BudgetVersionFig.BudgetVersionFig20EacTC	PM Forecast Cost LTE (20)
tdBudgetVersionFig20FinQTY	decimal	BudgetVersionFig.BudgetVersionFig20FinQTY	Contr Forecast Qty (20)
tdBudgetVersionFig20FinTC	decimal	BudgetVersionFig.BudgetVersionFig20FinTC	Contr Forecast Cost LTE (20)
tdBudgetVersionFig20QTY	decimal	BudgetVersionFig.BudgetVersionFig20QTY	Budget Qty (20)
tdBudgetVersionFig20SEacTC	decimal	BudgetVersionFig.BudgetVersionFig20SEacTC	PM Frc Rev (20)
tdBudgetVersionFig20SFinTC	decimal	BudgetVersionFig.BudgetVersionFig20SFinTC	Contr Forecast Rev (20)
tdBudgetVersionFig20STC	decimal	BudgetVersionFig.BudgetVersionFig20STC	Budget Rev (20)
tdBudgetVersionFig20TC	decimal	BudgetVersionFig.BudgetVersionFig20TC	Budget Cost (20)
tdBudgetVersionFig21EacQTY	decimal	BudgetVersionFig.BudgetVersionFig21EacQTY	PM Frc Qty (21)
tdBudgetVersionFig21EacTC	decimal	BudgetVersionFig.BudgetVersionFig21EacTC	PM Forecast Cost LTE (21)
tdBudgetVersionFig21FinQTY	decimal	BudgetVersionFig.BudgetVersionFig21FinQTY	Contr Forecast Qty (21)
tdBudgetVersionFig21FinTC	decimal	BudgetVersionFig.BudgetVersionFig21FinTC	Contr Forecast Cost LTE (21)
tdBudgetVersionFig21QTY	decimal	BudgetVersionFig.BudgetVersionFig21QTY	Budget Qty (21)
tdBudgetVersionFig21SEacTC	decimal	BudgetVersionFig.BudgetVersionFig21SEacTC	PM Frc Rev (21)
tdBudgetVersionFig21SFinTC	decimal	BudgetVersionFig.BudgetVersionFig21SFinTC	Contr Forecast Rev (21)
tdBudgetVersionFig21STC	decimal	BudgetVersionFig.BudgetVersionFig21STC	Budget Rev (21)
tdBudgetVersionFig21TC	decimal	BudgetVersionFig.BudgetVersionFig21TC	Budget Cost (21)
tdBudgetVersionFig22EacQTY	decimal	BudgetVersionFig.BudgetVersionFig22EacQTY	PM Frc Qty (22)
tdBudgetVersionFig22EacTC	decimal	BudgetVersionFig.BudgetVersionFig22EacTC	PM Forecast Cost LTE (22)
tdBudgetVersionFig22FinQTY	decimal	BudgetVersionFig.BudgetVersionFig22FinQTY	Contr Forecast Qty (22)
tdBudgetVersionFig22FinTC	decimal	BudgetVersionFig.BudgetVersionFig22FinTC	Contr Forecast Cost LTE (22)
tdBudgetVersionFig22QTY	decimal	BudgetVersionFig.BudgetVersionFig22QTY	Budget Qty (22)
tdBudgetVersionFig22SEacTC	decimal	BudgetVersionFig.BudgetVersionFig22SEacTC	PM Frc Rev (22)
tdBudgetVersionFig22SFinTC	decimal	BudgetVersionFig.BudgetVersionFig22SFinTC	Contr Forecast Rev (22)
tdBudgetVersionFig22STC	decimal	BudgetVersionFig.BudgetVersionFig22STC	Budget Rev (22)
tdBudgetVersionFig22TC	decimal	BudgetVersionFig.BudgetVersionFig22TC	Budget Cost (22)
tdBudgetVersionFig23EacQTY	decimal	BudgetVersionFig.BudgetVersionFig23EacQTY	PM Frc Qty (23)
tdBudgetVersionFig23EacTC	decimal	BudgetVersionFig.BudgetVersionFig23EacTC	PM Forecast Cost LTE (23)
tdBudgetVersionFig23FinQTY	decimal	BudgetVersionFig.BudgetVersionFig23FinQTY	Contr Forecast Qty (23)
tdBudgetVersionFig23FinTC	decimal	BudgetVersionFig.BudgetVersionFig23FinTC	Contr Forecast Cost LTE (23)
tdBudgetVersionFig23QTY	decimal	BudgetVersionFig.BudgetVersionFig23QTY	Budget Qty (23)
tdBudgetVersionFig23SEacTC	decimal	BudgetVersionFig.BudgetVersionFig23SEacTC	PM Frc Rev (23)
tdBudgetVersionFig23SFinTC	decimal	BudgetVersionFig.BudgetVersionFig23SFinTC	Contr Forecast Rev (23)
tdBudgetVersionFig23STC	decimal	BudgetVersionFig.BudgetVersionFig23STC	Budget Rev (23)
tdBudgetVersionFig23TC	decimal	BudgetVersionFig.BudgetVersionFig23TC	Budget Cost (23)
tdBudgetVersionFig24EacQTY	decimal	BudgetVersionFig.BudgetVersionFig24EacQTY	PM Frc Qty (24)
tdBudgetVersionFig24EacTC	decimal	BudgetVersionFig.BudgetVersionFig24EacTC	PM Forecast Cost LTE (24)
tdBudgetVersionFig24FinQTY	decimal	BudgetVersionFig.BudgetVersionFig24FinQTY	Contr Forecast Qty (24)
tdBudgetVersionFig24FinTC	decimal	BudgetVersionFig.BudgetVersionFig24FinTC	Contr Forecast Cost LTE (24)
tdBudgetVersionFig24QTY	decimal	BudgetVersionFig.BudgetVersionFig24QTY	Budget Qty (24)
tdBudgetVersionFig24SEacTC	decimal	BudgetVersionFig.BudgetVersionFig24SEacTC	PM Frc Rev (24)
tdBudgetVersionFig24SFinTC	decimal	BudgetVersionFig.BudgetVersionFig24SFinTC	Contr Forecast Rev (24)
tdBudgetVersionFig24STC	decimal	BudgetVersionFig.BudgetVersionFig24STC	Budget Rev (24)
tdBudgetVersionFig24TC	decimal	BudgetVersionFig.BudgetVersionFig24TC	Budget Cost (24)
tlBudgetVersionIsActive	logical	BudgetVersion.BudgetVersionIsActive	Active
tdBudgetVersionPercComplet	decimal	BudgetVersion.BudgetVersionPercComplet	% of Completion
tcBudgetWBSCode	character	BudgetWBS2.BudgetWBSCode	WBS Code
tcBudgetWBSComment	character	BudgetWBS2.BudgetWBSComment	Comment
tcBudgetWBSCostRevenue	character	BudgetWBS2.BudgetWBSCostRevenue	Cost/Revenue
tcBudgetWBSCostType	character	BudgetWBS2.BudgetWBSCostType	Cost Type
tcBudgetWBSFDSCode	character	BudgetWBS2.BudgetWBSFDSCode	COA Code
tcBudgetWBSFDSDefault	character	BudgetWBS2.BudgetWBSFDSDefault	COA Default
tcBudgetWBSFDSFromCode	character	BudgetWBS2.BudgetWBSFDSFromCode	From COA
tcBudgetWBSFDSList	character	BudgetWBS2.BudgetWBSFDSList	COA List
tcBudgetWBSFDSToCode	character	BudgetWBS2.BudgetWBSFDSToCode	To COA
tcBudgetWBSOverrunPeriod	character	BudgetWBS2.BudgetWBSOverrunPeriod	GL Period Overrun
tcBudgetWBSOverrunTotal	character	BudgetWBS2.BudgetWBSOverrunTotal	Total Overrun
tcBudgetWBSOverrunYTD	character	BudgetWBS2.BudgetWBSOverrunYTD	Overrun (YTD)
tdBudgetWBSPercOfComp	decimal	BudgetWBS2.BudgetWBSPercOfComp	Percentage (ETC)
tdBudgetWBSSeq	decimal	BudgetWBS2.BudgetWBSSeq	WBS Seq
tcBudgetWBSStatus	character	BudgetWBS2.BudgetWBSStatus	Status
tiProject_ID	integer	Project.Project_ID	Record ID
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Project),rowid(Budget),rowid(BudgetCompany),rowid(Company),rowid(BudgetPeriod),rowid(BudgetVersion),rowid(BudgetVersionFig),rowid(BudgetWBS1),rowid(BudgetWBS2),rowid(BudgetGroup)

Internal usage

QadFinancials

method BProjectReport.ProjectMastercard