ForecastingSourceDefinition | Object Reference for Salesforce and Lightning Platform

The information in this topic applies only to forecast types created in Summer ’21 and later.

Note

Supported Calls

create(), delete(), describeSObjects(), query(), retrieve(), update(), upsert()

Fields

Field	Details
CategoryField	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description Name of the forecast category that is associated with the forecast type. Possible values are: `Opportunity.ForecastCategoryName`
DateField	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description Field that is used for the forecast type’s date type. For example, the CloseDate field on Opportunity is used for opportunity close date-based forecast types. Possible values are: `Opportunity.CloseDate` `OpportunityLineItem.ServiceDate` `OpportunityLineItemSchedule.ScheduleDate`
DeveloperName	Type string Properties Create, Filter, Group, Sort, Update Description The developer name of the forecasting source definition. Only users with View DeveloperName OR View Setup and Configuration permission can view, group, sort, and filter this field. Note
FamilyField	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description Use this field to group forecasts by product family. Possible values are: `Product2.Family`
Language	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description Language of the forecasting source definition. For example, English.
MasterLabel	Type string Properties Create, Filter, Group, Sort, Update Description Required. Controlling label for this forecasting source definition.
MeasureField	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description Field that is used for the forecast type’s measure. For example, the Amount field on Opportunity is associated with revenue-based forecast types. Possible values are: `Opportunity.Amount` `Opportunity.Custom` `Opportunity.TotalOpportunityQuantity` `OpportunityLineItem.Custom` `OpportunityLineItem.Quantity` `OpportunityLineItem.TotalPrice` `OpportunityLineItemSchedule.Custom` `OpportunityLineItemSchedule.Quantity` `OpportunityLineItemSchedule.Revenue` `OpportunitySplit.Custom` `OpportunitySplit.SplitAmount` Where `Custom` represents the name of the custom field that a forecast type’s measure is based on. Example: Use `Megawatts__c` to forecast energy consumption.
SourceObject	Type picklist Properties Create, Filter, Group, Restricted picklist, Sort Description Object associated with this forecasting source definition. Possible values are: `Opportunity` `OpportunityLineItem` `OpportunityLineItemSchedule` `OpportunitySplit` `Product2`
Territory2Field	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description For a territory-based forecast type, indicates the field that is used for territory information. Possible values are: `Opportunity.Territory2Id` For user role-based forecast types, this value is `null`.
UserField	Type picklist Properties Create, Filter, Group, Nillable, Restricted picklist, Sort Description Specifies who owns the forecast. Possible values are: `Opportunity.OwnerId` `OpportunitySplit.SplitOwnerId`

Usage

Use ForecastingSourceDefinition to define a forecast type’s structure. A forecasting source definition is joined via ForecastingTypeSource to ForecastingType.

In this example, a user role-based forecast type called Custom Amount Forecast is based on the Amount and Close Date fields on opportunities.

1ForecastingType type = new  sforce.SObject("ForecastingType");
2type.DeveloperName = "Custom_Amount_Forecast";
3type.MasterLabel = "Custom Amount Forecast";
4type.IsAmount = true;
5type.IsQuantity = false;
6type.RoleType = "R";
7type.DateType = "OpportunityCloseDate";
8String typeId = insert(type);
9
10ForecastingSourceDefinition sourceDefinition = new sforce.SObject("ForecastingSourceDefinition")
11sourceDefinition.DeveloperName = "Custom Amount Source";
12sourceDefinition.MasterLabel = "Custom_Amount_Source";
13sourceDefinition.SourceObject = "Opportunity";
14sourceDefinition.MeasureField = "Opportunity.Amount";
15sourceDefinition.DateField = "Opportunity.CloseDate";
16sourceDefinition.UserField = "Opportunity.OwnerId";
17sourceDefinition.CategoryField = "Opportunity.ForecastCategoryName";
18String sourceDefinitionId = insert(sourceDefinition);
19
20ForecastingTypeSource typeSource = new sforce.SObject("ForecastingTypeSource");
21typeSource.MasterLabel = "Custom Amount Type Source";
22typeSource.DeveloperName = "Custom_Amount_Type_Source";
23typeSource.ForecastingTypeId = typeId;
24typeSource.ForecastingSourceDefinitionId = sourceDefinitionId;
25typeSource.SourceGroup = 1;
26insert(typeSource);