Professional Services Automation Data Dictionary

pse__Cost_Forecast__c

Label: Cost Forecast

Stores the cost forecast for a project or an opportunity.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
pse__Corp_Costs_Pending_Recognition__c Corp: Costs Pending Recognition Winter 2025 In the corporate currency, the costs that are ready for recognition on this cost forecast.

Summary
pse__Corp_Costs_Recognized_To_Date__c Corp: Costs Recognized to Date Winter 2025 In the corporate currency, the costs that have already been recognized on this cost forecast.

Summary
pse__Corp_Currency__c Corp: Currency Winter 2025 The corporate currency of the org at the time the cost forecast was run.

Text(3) false
pse__Corp_Margin__c Corp: Margin Winter 2025 In the corporate currency, the calculated margin.

Formula:
pse__Revenue_Forecast__r.pse__Corp_Revenue_Pending_Recognition__c + pse__Revenue_Forecast__r.pse__Corp_Revenue_Recognized_To_Date__c + pse__Revenue_Forecast__r.pse__Corp_Scheduled_Revenue__c + pse__Revenue_Forecast__r.pse__Corp_Unscheduled_Revenue__c - pse__Corp_Costs_Pending_Recognition__c - pse__Corp_Costs_Recognized_To_Date__c - pse__Corp_Scheduled_Costs__c - pse__Corp_Unscheduled_Costs__c
Currency(18,2)
pse__Corp_Pending_Costs_Before_Carryover__c Corp: Pending Costs Before Carryover Summer 2025 In the corporate currency, the costs that are ready for recognition minus any pending costs carried over when the relevant time period was closed for forecasting.

Summary
pse__Corp_Pending_Costs_Carried_Over__c Corp: Pending Costs Carried Over Summer 2025 In the corporate currency, the unfulfilled pending costs that were ready for recognition and were carried over when the relevant time period was closed for forecasting.

Summary
pse__Corp_Scheduled_Costs__c Corp: Scheduled Costs Winter 2025 In the corporate currency, the costs that are scheduled for recognition on this cost forecast.

Summary
pse__Corp_Total_Approved_Costs__c Corp: Total Approved Costs Winter 2025 The sum of the values in the Corp: Costs Recognized to Date and the Corp: Costs Pending Recognition fields.

Formula:
pse__Corp_Costs_Recognized_To_Date__c + pse__Corp_Costs_Pending_Recognition__c
Number(18,2) false
pse__Corp_Unfulfilled_Pending_Costs__c Corp: Unfulfilled Pending Costs Summer 2025 In the corporate currency, the costs that were ready for recognition but were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Corp_Unfulfilled_Scheduled_Costs__c Corp: Unfulfilled Scheduled Costs Summer 2025 In the corporate currency, the scheduled costs that were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Corp_Unfulfilled_Unscheduled_Costs__c Corp: Unfulfilled Unscheduled Costs Summer 2025 In the corporate currency, the unscheduled costs that were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Corp_Unscheduled_Costs__c Corp: Unscheduled Costs Winter 2025 In the corporate currency, the costs that are not scheduled for recognition on this cost forecast.

Summary
pse__Costs_Pending_Recognition__c Costs Pending Recognition Winter 2025 The costs that are ready for recognition on this cost forecast.

Summary
pse__Costs_Recognized_To_Date__c Costs Recognized to Date Winter 2025 The costs that have already been recognized on this cost forecast.

Summary
pse__Last_Updated__c Last Updated Winter 2025 Date and time when this cost forecast was last updated.

DateTime false
pse__Margin_Percent__c Margin (%) Winter 2025 The percentage of margin made on the revenue.

Formula:
IF(pse__Revenue_Forecast__r.pse__Actuals__c + pse__Revenue_Forecast__r.pse__Scheduled_Revenue__c + pse__Revenue_Forecast__r.pse__Unscheduled_Revenue__c = 0, IF(pse__Total_Approved_Costs__c + pse__Scheduled_Costs__c + pse__Unscheduled_Costs__c = 0, 0, -1), pse__Margin__c / (pse__Revenue_Forecast__r.pse__Actuals__c + pse__Revenue_Forecast__r.pse__Scheduled_Revenue__c + pse__Revenue_Forecast__r.pse__Unscheduled_Revenue__c) )
Percent(18,2)
pse__Margin__c Margin Winter 2025 The calculated margin.

Formula:
pse__Revenue_Forecast__r.pse__Revenue_Pending_Recognition__c + pse__Revenue_Forecast__r.pse__Revenue_Recognized_To_Date__c + pse__Revenue_Forecast__r.pse__Scheduled_Revenue__c + pse__Revenue_Forecast__r.pse__Unscheduled_Revenue__c - pse__Costs_Pending_Recognition__c - pse__Costs_Recognized_To_Date__c - pse__Scheduled_Costs__c - pse__Unscheduled_Costs__c
Currency(18,2)
pse__Milestone__c Milestone Winter 2025 Lookup to the milestone this cost forecast relates to.

Looks up to: pse__Milestone__c
Lookup false
pse__Opportunity_Probability__c Opportunity Probability (%) Winter 2025 The probability of the opportunity that this cost forecast relates to.

Percent(3,0) false
pse__Opportunity__c Opportunity Winter 2025 Lookup to the opportunity this cost forecast relates to.

Looks up to: Opportunity

Lookup false
pse__Pending_Costs_Before_Carryover__c Pending Costs Before Carryover Summer 2025 Costs that are ready for recognition minus any pending costs carried over when the relevant time period was closed for forecasting.

Summary
pse__Pending_Costs_Carried_Over__c Pending Costs Carried Over Summer 2025 Unfulfilled pending costs that were ready for recognition and were carried over when the relevant time period was closed for forecasting.

Summary
pse__Project__c Project Winter 2025 Lookup to the project this cost forecast relates to.

Looks up to: pse__Proj__c
Lookup false
pse__Resource__c Resource Spring 2025 Lookup to the resource the cost forecast relates to.

Looks up to: Contact

Lookup false
pse__Revenue_Forecast__c Revenue Forecast Winter 2025 Lookup to the revenue forecast this cost forecast relates to.

Looks up to: pse__Revenue_Forecast__c
Lookup false
pse__Scheduled_Costs__c Scheduled Costs Winter 2025 The costs that are scheduled for recognition on this cost forecast.

Summary
pse__Time_Period_End__c Time Period End Winter 2025 End date of the time period this record relates to.

Formula:
pse__Time_Period__r.pse__End_Date__c
Date false
pse__Time_Period_Start__c Time Period Start Winter 2025 Start date of the time period this record relates to.

Formula:
pse__Time_Period__r.pse__Start_Date__c
Date false
pse__Time_Period__c Time Period Winter 2025 Lookup to the time period set on this cost forecast.

Looks up to: pse__Time_Period__c
Lookup true
pse__Total_Approved_Costs__c Total Approved Costs Winter 2025 The sum of the values in the Costs Recognized to Date and the Costs Pending Recognition fields.

Formula:
pse__Costs_Recognized_To_Date__c + pse__Costs_Pending_Recognition__c
Currency(18,2) false
pse__Unfulfilled_Pending_Costs__c Unfulfilled Pending Costs Summer 2025 Costs that were ready for recognition but were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Unfulfilled_Scheduled_Costs__c Unfulfilled Scheduled Costs Summer 2025 Scheduled costs that were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Unfulfilled_Unscheduled_Costs__c Unfulfilled Unscheduled Costs Summer 2025 Unscheduled costs that were not fulfilled before the relevant time period was closed for forecasting.

Summary
pse__Unscheduled_Costs__c Unscheduled Costs Winter 2025 The costs that are not scheduled for recognition on this cost forecast.

Summary


© Copyright 2009–2025 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.