Professional Services Automation Data Dictionary

Cost_Forecast__c

Label: Cost Forecast

Stores the cost forecast for a project or an opportunity.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
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
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
Corp_Currency__c Corp: Currency Winter 2025 The corporate currency of the org at the time the cost forecast was run.

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

Formula:
Revenue_Forecast__r.Corp_Revenue_Pending_Recognition__c + Revenue_Forecast__r.Corp_Revenue_Recognized_To_Date__c + Revenue_Forecast__r.Corp_Scheduled_Revenue__c + Revenue_Forecast__r.Corp_Unscheduled_Revenue__c - Corp_Costs_Pending_Recognition__c - Corp_Costs_Recognized_To_Date__c - Corp_Scheduled_Costs__c - Corp_Unscheduled_Costs__c
Currency(18,2)
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
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:
Corp_Costs_Recognized_To_Date__c + Corp_Costs_Pending_Recognition__c
Number(18,2) false
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
Costs_Pending_Recognition__c Costs Pending Recognition Winter 2025 The costs that are ready for recognition on this cost forecast.

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

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

DateTime false
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)
Margin__c Margin Winter 2025 The calculated margin.

Formula:
Revenue_Forecast__r.Revenue_Pending_Recognition__c + Revenue_Forecast__r.Revenue_Recognized_To_Date__c + Revenue_Forecast__r.Scheduled_Revenue__c + Revenue_Forecast__r.Unscheduled_Revenue__c - Costs_Pending_Recognition__c - Costs_Recognized_To_Date__c - Scheduled_Costs__c - Unscheduled_Costs__c
Currency(18,2)
Milestone__c Milestone Winter 2025 Lookup to the milestone this cost forecast relates to.

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

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

Looks up to: Opportunity

Lookup false
Project__c Project Winter 2025 Lookup to the project this cost forecast relates to.

Looks up to: Proj__c
Lookup false
Revenue_Forecast__c Revenue Forecast Winter 2025 Lookup to the revenue forecast this cost forecast relates to.

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

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

Formula:
Time_Period__r.End_Date__c
Date false
Time_Period_Start__c Time Period Start Winter 2025 Start date of the time period this record relates to.

Formula:
Time_Period__r.Start_Date__c
Date false
Time_Period__c Time Period Winter 2025 Lookup to the time period set on this cost forecast.

Looks up to: Time_Period__c
Lookup true
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:
Costs_Recognized_To_Date__c + Costs_Pending_Recognition__c
Currency(18,2) false
Unscheduled_Costs__c Unscheduled Costs Winter 2025 The costs that are not scheduled for recognition on this cost forecast.

Summary


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