Forecasting Fact DMO

Object API Name: std__ForecastingFactDmo__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• BusinessPeriodId
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• ForecastedObject
• ForecastedObjectId
• ForecastedOpportunityProductId
• ForecastedOpportunitySplitId
• ForecastedSubObject
• ForecastedSubObjectId
• ForecastedSubOpportunitySplitId
• ForecastedSubOppProductSplit
• ForecastingGroupItemId
• ForecastingItemId
• ForecastingTypeId
• Id
• InternalOrganizationId
• NameInterfaceField
• OpportunityForecastCategory
• OpportunityId
• OwnerId
• ProductFamily
• SalesTerritoryId
• TargetValueNumber

• Field API Name: std__BusinessPeriodId__c
• Data Type: TEXT
• Description: Period ID for the forecast. This is a One to One (1:1) relationship field. ForecastingFacts is the relationship name and Business Period is the referenced object. Maximum size is 15 characters.

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__ForecastedObject__c
• Data Type: TEXT
• Description: Forecasted Object's Domain Name.

• Field API Name: std__ForecastedObjectId__c
• Data Type: TEXT
• Description: Contains the Split ID of the forecasted OpportunitySplit object if the forecast data source is opportunity splits or the OpportunityLineItem ID of the forecasted opportunity if the data source is product families. If the data source is product families and the opportunity has no line item, this field is null. If the forecast data source is opportunities, this field is null. This field is available in API version 29 and later. This field is read only.

• Field API Name: std__ForecastedOpportunityProductId__c
• Data Type: TEXT
• Description: Opportunity Line Item (Opportunity Product) used in forecasted fact. Opportunity line item links a Product2 to an Opportunity under a specific Pricebook.

• Field API Name: std__ForecastedOpportunitySplitId__c
• Data Type: TEXT
• Description: Opportunity Split used in forecasted fact. OpportunitySplit credits one or more opportunity team members with a portion of the opportunity amount.

• Field API Name: std__ForecastedSubObject__c
• Data Type: TEXT
• Description: Forecasted SubObject's Domain Name.

• Field API Name: std__ForecastedSubObjectId__c
• Data Type: TEXT
• Description: Possible values: - If the forecast data source is OpportunityLineItemSplit, and the opportunity has line items and line item splits, then this field contains the ID of the forecasted OpportunityLineItemSplit object. - If the forecast data source is OpportunityLineItemSplit, and the opportunity has line items but no line item splits, this field contains the ID of the forecasted OpportunitySplit object. - If the forecast data source is OpportunityLineItemSchedule, this field contains the OpportunityLineItemSchedule ID of the forecasted opportunity. - If the forecast data source is OpportunityLineItemSplit and the opportunity has no line item, this field is null. - If the forecast data source is OpportunityLineItemSchedule and the opportunity has no line item, this field is null. This field is available in API version 58.0 and later. This field is read only. This field is a polymorphic relationship field.

• Field API Name: std__ForecastedSubOpportunitySplitId__c
• Data Type: TEXT
• Description: Opportunity Split used in next level of forecasted fact. It credits one or more opportunity team members with a portion of the opportunity amount.

• Field API Name: std__ForecastedSubOppProductSplit__c
• Data Type: TEXT
• Description: Opportunity Product Split used in next level of forecasted fact. Itincludes SplitOwner, SplitPercentage, and SplitAmount fields.

• Field API Name: std__ForecastingGroupItemId__c
• Data Type: TEXT
• Description: ForecastingGroupItem reference. Dimension using a picklist other than PF.

• Field API Name: std__ForecastingItemId__c
• Data Type: TEXT
• Description: The ID of the ForecastingItem.

• Field API Name: std__ForecastingTypeId__c
• Data Type: TEXT
• Description: The ID of the related ForecastingType.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: The unique identifier for the record.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__NameInterfaceField__c
• Data Type: TEXT
• Description: Name of this record.

• Field API Name: std__OpportunityForecastCategory__c
• Data Type: TEXT
• Description: The category within the sales cycle to which an opportunity is assigned based on its opportunity stage. The standard forecast categories are Pipeline, Best Case, Commit, Omitted (not included in forecasts), and Closed. Salesforce admins can customize the forecast category names.

• Field API Name: std__OpportunityId__c
• Data Type: TEXT
• Description: The opportunity ID.

• Field API Name: std__OwnerId__c
• Data Type: TEXT
• Description: The ID of the opportunity owner.

• Field API Name: std__ProductFamily__c
• Data Type: TEXT
• Description: The product family grouping when product‑based forecasting is used. Picklist?

• Field API Name: std__SalesTerritoryId__c
• Data Type: TEXT
• Description: The ID of the territory to forecast on. Maximum size is 15 characters.

• Field API Name: std__TargetValueNumber__c
• Data Type: DOUBLE
• Description: Target value of the forecast amount.