Professional Services Automation Object Model Diagrams
G Cost_Forecast__c Cost Forecast +Cost Forecast Name+NameName -Corp: Costs Pending Recognition-Corp_Costs_Pending_Recognition__cCorp_Costs_Pending_Recognition__c -Corp: Costs Recognized to Date-Corp_Costs_Recognized_To_Date__cCorp_Costs_Recognized_To_Date__c -Corp: Currency-Corp_Currency__cCorp_Currency__c #Corp: Margin#Corp_Margin__cCorp_Margin__c -Corp: Scheduled Costs-Corp_Scheduled_Costs__cCorp_Scheduled_Costs__c #Corp: Total Approved Costs#Corp_Total_Approved_Costs__cCorp_Total_Approved_Costs__c -Corp: Unscheduled Costs-Corp_Unscheduled_Costs__cCorp_Unscheduled_Costs__c -Costs Pending Recognition-Costs_Pending_Recognition__cCosts_Pending_Recognition__c -Costs Recognized to Date-Costs_Recognized_To_Date__cCosts_Recognized_To_Date__c -Last Updated-Last_Updated__cLast_Updated__c #Margin#Margin__cMargin__c #Margin (%)#Margin_Percent__cMargin_Percent__c -Milestone-Milestone__cMilestone__c -Opportunity-Opportunity__cOpportunity__c -Opportunity Probability (%)-Opportunity_Probability__cOpportunity_Probability__c -Project-Project__cProject__c -Revenue Forecast-Revenue_Forecast__cRevenue_Forecast__c -Scheduled Costs-Scheduled_Costs__cScheduled_Costs__c -Time Period-Time_Period__cTime_Period__c #Time Period End#Time_Period_End__cTime_Period_End__c #Time Period Start#Time_Period_Start__cTime_Period_Start__c #Total Approved Costs#Total_Approved_Costs__cTotal_Approved_Costs__c -Unscheduled Costs-Unscheduled_Costs__cUnscheduled_Costs__c Revenue_Forecast__c Revenue Forecast +Revenue Forecast Name+NameName -Actual Hours-Actual_Hours__cActual_Hours__c -Actual Weighted Effort-Actual_Weighted_Effort__cActual_Weighted_Effort__c #Actuals#Actuals__cActuals__c #Corp: Actuals#Corp_Actuals__cCorp_Actuals__c -Corp: Currency-Corp_Currency__cCorp_Currency__c -Corp: Revenue Pending Recognition-Corp_Revenue_Pending_Recognition__cCorp_Revenue_Pending_Recognition__c -Corp: Revenue Recognized to Date-Corp_Revenue_Recognized_To_Date__cCorp_Revenue_Recognized_To_Date__c -Corp: Scheduled Revenue-Corp_Scheduled_Revenue__cCorp_Scheduled_Revenue__c -Corp: Unscheduled Revenue-Corp_Unscheduled_Revenue__cCorp_Unscheduled_Revenue__c -Last Updated-Last_Updated__cLast_Updated__c -Milestone-Milestone__cMilestone__c -Opportunity-Opportunity__cOpportunity__c -Opportunity Probability (%)-Opportunity_Probability__cOpportunity_Probability__c -Project-Project__cProject__c -Revenue Pending Recognition-Revenue_Pending_Recognition__cRevenue_Pending_Recognition__c -Revenue Recognized to Date-Revenue_Recognized_To_Date__cRevenue_Recognized_To_Date__c -Scheduled Hours-Scheduled_Hours__cScheduled_Hours__c -Scheduled Revenue-Scheduled_Revenue__cScheduled_Revenue__c -Scheduled Weighted Effort-Scheduled_Weighted_Effort__cScheduled_Weighted_Effort__c -Time Period-Time_Period__cTime_Period__c #Time Period End#Time_Period_End__cTime_Period_End__c #Time Period Start#Time_Period_Start__cTime_Period_Start__c -Unscheduled Hours-Unscheduled_Hours__cUnscheduled_Hours__c -Unscheduled Revenue-Unscheduled_Revenue__cUnscheduled_Revenue__c + Run_Revenue_Forecast_Opportunity() + Run_Revenue_Forecast() Cost_Forecast__c->Revenue_Forecast__c Milestone__c Milestone Cost_Forecast__c->Milestone__c Opportunity Opportunity Cost_Forecast__c->Opportunity Proj__c Project Cost_Forecast__c->Proj__c Time_Period__c Time Period Cost_Forecast__c->Time_Period__c Cost_Forecast_Staging__c Cost Forecast Staging +Cost Forecast Staging Name+NameName -Cost Category-Cost_Category__cCost_Category__c -Cost Source-Cost_Source__cCost_Source__c -Cost Type-Cost_Type__cCost_Type__c -Costs Pending Recognition-Costs_Pending_Recognition__cCosts_Pending_Recognition__c -Costs Recognized to Date-Costs_Recognized_To_Date__cCosts_Recognized_To_Date__c -Milestone-Milestone__cMilestone__c -Opportunity-Opportunity__cOpportunity__c -Project-Project__cProject__c -Scheduled Costs-Scheduled_Costs__cScheduled_Costs__c -Time Period-Time_Period__cTime_Period__c -Unscheduled Costs-Unscheduled_Costs__cUnscheduled_Costs__c Cost_Forecast_Staging__c->Milestone__c Cost_Forecast_Staging__c->Opportunity Cost_Forecast_Staging__c->Proj__c Cost_Forecast_Staging__c->Time_Period__c Cost_Forecast_Type__c Cost Forecast Type +Cost Forecast Type Name+NameName -Corp: Costs Pending Recognition-Corp_Costs_Pending_Recognition__cCorp_Costs_Pending_Recognition__c -Corp: Costs Recognized to Date-Corp_Costs_Recognized_To_Date__cCorp_Costs_Recognized_To_Date__c -Corp: Currency-Corp_Currency__cCorp_Currency__c -Corp: Scheduled Costs-Corp_Scheduled_Costs__cCorp_Scheduled_Costs__c -Corp: Unscheduled Costs-Corp_Unscheduled_Costs__cCorp_Unscheduled_Costs__c -Cost Category-Cost_Category__cCost_Category__c -Cost Forecast-Cost_Forecast__cCost_Forecast__c -Cost Source-Cost_Source__cCost_Source__c -Cost Type-Cost_Type__cCost_Type__c -Costs Pending Recognition-Costs_Pending_Recognition__cCosts_Pending_Recognition__c -Costs Recognized to Date-Costs_Recognized_To_Date__cCosts_Recognized_To_Date__c -Last Updated-Last_Updated__cLast_Updated__c -Milestone-Milestone__cMilestone__c -Opportunity-Opportunity__cOpportunity__c -Project-Project__cProject__c -Scheduled Costs-Scheduled_Costs__cScheduled_Costs__c -Unscheduled Costs-Unscheduled_Costs__cUnscheduled_Costs__c Cost_Forecast_Type__c->Cost_Forecast__c Cost_Forecast_Type__c->Milestone__c Cost_Forecast_Type__c->Opportunity Cost_Forecast_Type__c->Proj__c Revenue_Forecast__c->Milestone__c Revenue_Forecast__c->Opportunity Revenue_Forecast__c->Proj__c Revenue_Forecast__c->Time_Period__c Revenue_Forecast_Batch__c Revenue Forecast Batch +Revenue Forecast Name+NameName -Batch ID-Batch_Id__cBatch_Id__c -Batch Process-Batch_Process__cBatch_Process__c -Status-Status__cStatus__c Revenue_Forecast_Batch_Lock__c Revenue Forecast Batch Lock +Revenue Forecast Batch Lock Name+NameName -Record ID-Record_Id__cRecord_Id__c Revenue_Forecast_Batch_Log__c Revenue Forecast Batch Log +Revenue Forecast Batch Log Name+NameName -Message-Message__cMessage__c -Opportunity-Opportunity__cOpportunity__c -Project-Project__cProject__c -Revenue Forecast Batch-Revenue_Forecast_Batch__cRevenue_Forecast_Batch__c Revenue_Forecast_Batch_Log__c->Revenue_Forecast_Batch__c Revenue_Forecast_Batch_Log__c->Opportunity Revenue_Forecast_Batch_Log__c->Proj__c Revenue_Forecast_Batch_Status__c Revenue Forecast Batch Status +Revenue Forecast Batch Status Name+NameName -Opportunity-Opportunity__cOpportunity__c -Record ID-Record_Id__cRecord_Id__c -Revenue Forecast Batch Update Pending-Revenue_Forecast_Batch_Update_Pending__cRevenue_Forecast_Batch_Update_Pending__c -Revenue Forecast Last Updated-Revenue_Forecast_Last_Updated__cRevenue_Forecast_Last_Updated__c -Revenue Forecast Processing Status-Revenue_Forecast_Processing_Status__cRevenue_Forecast_Processing_Status__c Revenue_Forecast_Batch_Status__c->Opportunity Revenue_Forecast_Setup__c Revenue Forecast Setup +Revenue Forecast Setup Name+NameName -Active-Active__cActive__c -Actuals Cutoff Day-Actuals_Cutoff_Day__cActuals_Cutoff_Day__c -Assignment % Complete Weighting Field-Assignment_Percent_Comp_Weighting_Field__cAssignment_Percent_Comp_Weighting_Field__c -Assignment Bill Rate Field-Assignment_Bill_Rate_Field__cAssignment_Bill_Rate_Field__c -Custom Date for Deliverable Expenses-Custom_Date_For_Deliverable_Expenses__cCustom_Date_For_Deliverable_Expenses__c -Custom Date for Deliverable Milestones-Custom_Date_For_Deliverable_Milestones__cCustom_Date_For_Deliverable_Milestones__c -Custom Date for Deliverable Misc Adjusts-Custom_Date_For_Deliverable_Misc_Adjusts__cCustom_Date_For_Deliverable_Misc_Adjusts__c -Custom Filter Field Set-Custom_Filter_Field_Set__cCustom_Filter_Field_Set__c -Enable Cost Forecasting-Enable_Cost_Forecasting__cEnable_Cost_Forecasting__c -Exclude Actuals After Cutoff Day-Exclude_Actuals_After_Cutoff_Day__cExclude_Actuals_After_Cutoff_Day__c -Exclude from Forecast Assignment Field-Exclude_From_Forecast_Assignment_Field__cExclude_From_Forecast_Assignment_Field__c -Exclude from Forecast RR Field-Exclude_From_Forecast_Resource_Req_Field__cExclude_From_Forecast_Resource_Req_Field__c -Exclude Opportunities-Exclude_Opportunities__cExclude_Opportunities__c -Exclude Opportunities for Versions-Exclude_Opportunities_For_Versions__cExclude_Opportunities_For_Versions__c -Exclude Probability from Opportunities-Exclude_Opportunity_Probabilities__cExclude_Opportunity_Probabilities__c -Exclude Resource Requests on Project-Exclude_Resource_Requests_On_Project__cExclude_Resource_Requests_On_Project__c -Exclude Revenue Recognition Actuals-Exclude_Revenue_Recognition_Actuals__cExclude_Revenue_Recognition_Actuals__c -Exclude Scheduled Hrs in Closed Periods-Exclude_Scheduled_Hrs_in_Closed_Periods__cExclude_Scheduled_Hrs_in_Closed_Periods__c -Exclude Unscheduled Revenue for Versions-Exclude_Unscheduled_Revenue_For_Versions__cExclude_Unscheduled_Revenue_For_Versions__c -Expected Project End Date Field on Opp-Project_End_Date_on_Opportunity__cProject_End_Date_on_Opportunity__c -Expected Project Start Date Field on Opp-Project_Start_Date_on_Opportunity__cProject_Start_Date_on_Opportunity__c -Forecast Factor Batch Size-Forecast_Factor_Batch_Size__cForecast_Factor_Batch_Size__c -Hover Details Field Set on Milestone-Hover_Details_Field_Set_On_Milestone__cHover_Details_Field_Set_On_Milestone__c -Hover Details Field Set on Opportunity-Hover_Details_Field_Set_On_Opportunity__cHover_Details_Field_Set_On_Opportunity__c -Hover Details Field Set on Project-Hover_Details_Field_Set_On_Project__cHover_Details_Field_Set_On_Project__c -Include Best Case-Include_Best_Case__cInclude_Best_Case__c -Include RRs on Opportunities-Include_RRs_on_Opportunities__cInclude_RRs_on_Opportunities__c -Include Unheld RRs with Schedules-Include_Unheld_RRs_with_Schedules__cInclude_Unheld_RRs_with_Schedules__c -Include Unheld RRs without Schedules-Include_Unheld_RRs_without_Schedules__cInclude_Unheld_RRs_without_Schedules__c -Include Worst Case-Include_Worst_Case__cInclude_Worst_Case__c -Maximum Concurrent Jobs-Maximum_Concurrent_Jobs__cMaximum_Concurrent_Jobs__c -Object for Version Grouping-Version_Grouping_Primary__cVersion_Grouping_Primary__c -Opportunity Batch Size-Opportunity_Batch_Size__cOpportunity_Batch_Size__c -Opportunity Best Case Threshold (%)-Opportunity_Best_Case_Threshold__cOpportunity_Best_Case_Threshold__c -Opportunity Expected Threshold (%)-Opportunity_Expected_Case_Threshold__cOpportunity_Expected_Case_Threshold__c -Opportunity Scheduler Batch Size-Opportunity_Scheduler_Batch_Size__cOpportunity_Scheduler_Batch_Size__c -Opportunity Worst Case Threshold (%)-Opportunity_Worst_Case_Threshold__cOpportunity_Worst_Case_Threshold__c -Persist Adjustments Across Versions-Persist_Adjustments_Across_Versions__cPersist_Adjustments_Across_Versions__c -Project Batch Size-Project_Batch_Size__cProject_Batch_Size__c -Project Scheduler Batch Size-Project_Scheduler_Batch_Size__cProject_Scheduler_Batch_Size__c -Resource Request Bill Rate Field-Resource_Request_Bill_Rate_Field__cResource_Request_Bill_Rate_Field__c -Respect Permission Controls-Respect_Permission_Controls__cRespect_Permission_Controls__c -Retain Pending Costs in Closed Periods-Retain_Pending_Costs_In_Closed_Periods__cRetain_Pending_Costs_In_Closed_Periods__c -Retain Pending Revenue in Closed Periods-Retain_Pending_Revenue_In_Closed_Periods__cRetain_Pending_Revenue_In_Closed_Periods__c -RR % Complete Weighting Field-Res_Req_Percent_Comp_Weighting_Field__cRes_Req_Percent_Comp_Weighting_Field__c -Total Hours Field on Project-Total_Hours_Field_on_Project__cTotal_Hours_Field_on_Project__c -Total Revenue Field on Milestone-Milestone_Total_Revenue_Field__cMilestone_Total_Revenue_Field__c -Total Revenue Field on Project-Project_Total_Revenue_Field__cProject_Total_Revenue_Field__c -Use Mid Month Forecast Calculations-Use_Mid_Month_Forecast_Calculations__cUse_Mid_Month_Forecast_Calculations__c -Use Sched and Actual Hrs for % Complete-Use_Sched_And_Actual_Hrs_In_Percent_Comp__cUse_Sched_And_Actual_Hrs_In_Percent_Comp__c -Use Weighting for % Complete-Use_Weighted_Percent_Comp_Calc__cUse_Weighted_Percent_Comp_Calc__c -Version Detail Batch Size-Version_Detail_Batch_Size__cVersion_Detail_Batch_Size__c -Version Forecast Period-Version_Forecast_Period__cVersion_Forecast_Period__c -Version Forecast Period Override-Version_Forecast_Period_Override__cVersion_Forecast_Period_Override__c Revenue_Forecast_Staging__c Revenue Forecast Staging +Revenue Forecast Staging Name+NameName -Actual Hours-Actual_Hours__cActual_Hours__c -Actual Weighted Effort-Actual_Weighted_Effort__cActual_Weighted_Effort__c -Milestone-Milestone__cMilestone__c -Project-Project__cProject__c -Revenue Pending Recognition-Revenue_Pending_Recognition__cRevenue_Pending_Recognition__c -Revenue Recognized to Date-Revenue_Recognized_To_Date__cRevenue_Recognized_To_Date__c -Revenue Source-Revenue_Source__cRevenue_Source__c -Revenue Type-Revenue_Type__cRevenue_Type__c -Scheduled Hours-Scheduled_Hours__cScheduled_Hours__c -Scheduled Revenue-Scheduled_Revenue__cScheduled_Revenue__c -Scheduled Weighted Effort-Scheduled_Weighted_Effort__cScheduled_Weighted_Effort__c -Time Period-Time_Period__cTime_Period__c -Unscheduled Hours-Unscheduled_Hours__cUnscheduled_Hours__c -Unscheduled Revenue-Unscheduled_Revenue__cUnscheduled_Revenue__c Revenue_Forecast_Staging__c->Milestone__c Revenue_Forecast_Staging__c->Proj__c Revenue_Forecast_Staging__c->Time_Period__c Revenue_Forecast_Type__c Revenue Forecast Type +Revenue Forecast Type Name+NameName #Actuals#Actuals__cActuals__c #Corp: Actuals#Corp_Actuals__cCorp_Actuals__c -Corp: Currency-Corp_Currency__cCorp_Currency__c -Corp: Revenue Pending Recognition-Corp_Revenue_Pending_Recognition__cCorp_Revenue_Pending_Recognition__c -Corp: Revenue Recognized to Date-Corp_Revenue_Recognized_To_Date__cCorp_Revenue_Recognized_To_Date__c -Corp: Scheduled Revenue-Corp_Scheduled_Revenue__cCorp_Scheduled_Revenue__c -Corp: Unscheduled Revenue-Corp_Unscheduled_Revenue__cCorp_Unscheduled_Revenue__c -Milestone-Milestone__cMilestone__c -Opportunity-Opportunity__cOpportunity__c -Project-Project__cProject__c -Revenue Forecast-Revenue_Forecast__cRevenue_Forecast__c -Revenue Pending Recognition-Revenue_Pending_Recognition__cRevenue_Pending_Recognition__c -Revenue Recognized to Date-Revenue_Recognized_To_Date__cRevenue_Recognized_To_Date__c -Revenue Source-Revenue_Source__cRevenue_Source__c -Revenue Type-Revenue_Type__cRevenue_Type__c -Scheduled Revenue-Scheduled_Revenue__cScheduled_Revenue__c -Unscheduled Revenue-Unscheduled_Revenue__cUnscheduled_Revenue__c Revenue_Forecast_Type__c->Revenue_Forecast__c Revenue_Forecast_Type__c->Milestone__c Revenue_Forecast_Type__c->Opportunity Revenue_Forecast_Type__c->Proj__c Milestone__c->Proj__c Opportunity->Proj__c Proj__c->Time_Period__c
© Copyright 2009–2025 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.