Forecasting Item DMO

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

  • 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. ForecastingItems 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__CreatedById__c
  • Data Type: TEXT
  • Description: The ID of the user who created this forecast item record.
  • Field API Name: std__CreatedDate__c
  • Data Type: DATETIME
  • Description: Timestamp when this forecast item was created.
  • 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__ForecastAmount__c
  • Data Type: DOUBLE
  • Description: The revenue forecast from the forecast manager’s perspective and the sum of the owner’s and subordinates’ and child territories’ opportunities, including all forecast adjustments.
  • Field API Name: std__ForecastAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the forecast amt. Do not include currency symbols or commas.
  • Field API Name: std__ForecastingGroupItem__c
  • Data Type: TEXT
  • Description: Alphanumeric string representing the forecasting group item.
  • Field API Name: std__ForecastingGroupItemId__c
  • Data Type: TEXT
  • Description: If a forecast group is assigned to the forecast type, the ID of the group value that the forecast total belongs to. This field is a relationship field. Available in API version 60.0 and later.
  • Field API Name: std__ForecastingItemCategory__c
  • Data Type: TEXT
  • Description: This field indicates which type of forecast rollup the forecasting item belongs to. Depending on whether your organization uses individual forecast category rollups or cumulative forecast rollups, you have these possible values for the ForecastingItemCategoryfield.Individual forecast category rollups: - PipelineOnly - Rollup from Pipeline opportunities only. - BestCaseOnly - Rollup from Best Case opportunities only. Adjustable. - MostLikelyOnly - Rollup from Most Likely opportunities only. Adjustable. - CommitOnly - Rollup from Commit opportunities only. Adjustable. Cumulative forecast rollups: - OpenPipeline - Rollup from Pipeline + Best Case + Most Likely + Commit opportunities. - BestCaseForecast - Rollup from Best Case + Most Likely + Commit + Closed opportunities. Adjustable. -MostLikelyForecast - Rollup from Most Likely + Commit + Closed opportunities. Adjustable. - CommitForecast - Rollup from Commit + Closed opportunities. Adjustable. Either cumulative or individual forecast category rollups: - ClosedOnly - Rollup from Closed opportunities only. The ForecastingItemCategory field differs from the ForecastCategoryName field. - The ForecastCategoryName field represents the forecast category of the underlying opportunities rolling up to forecast amounts. In organizations using cumulative forecast rollups, the ForecastCategoryName field can be null because the cumulative forecast amounts include opportunities from multiple forecast categories. - The new ForecastingItemCategory field represents the type of rollup a forecast amount or adjustment is from. In organizations using individual forecast category columns, it contains the individual forecast rollup categories. In organizations using cumulative forecast rollups, it contains the cumulative rollup categories.
  • Field API Name: std__ForecastingTypeId__c
  • Data Type: TEXT
  • Description: The ID of the related ForecastingType.
  • Field API Name: std__ForecastQuantity__c
  • Data Type: DOUBLE
  • Description: The quantity forecast from the forecast manager’s perspective and the sum of the owner’s and subordinates’ opportunities, including all forecast adjustments. This field is available in API version 28 and later.
  • Field API Name: std__HasAdjustment__c
  • Data Type: BOOLEAN
  • Description: A flag that indicates the forecasting item includes a manager adjustment. This flag is true only when the item includes an adjustment and the user performing the query has read access to the adjustment.
  • Field API Name: std__HasOwnerAdjustment__c
  • Data Type: BOOLEAN
  • Description: A flag that indicates the forecasting item includes an owner adjustment. This flag is true only when the item includes an adjustment and the user performing the query has read access to the adjustment. Available in API version 33.0 and later.
  • Field API Name: std__Id__c
  • Data Type: TEXT
  • Description: The unique identifier for the ForecastingItem record.
  • Field API Name: std__InternalOrganizationId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: std__IsAmount__c
  • Data Type: BOOLEAN
  • Description: True indicates that the adjustment is made in a revenue amount. If false, then IsQuantity must be true. This field is available in API version 28.0 and later.
  • Field API Name: std__IsQuantity__c
  • Data Type: BOOLEAN
  • Description: True indicates that the adjustment is made in a quantity amount. If false, then IsAmount must be true. This field is available in API version 28.0 and later.
  • Field API Name: std__LastModifiedById__c
  • Data Type: TEXT
  • Description: The ID of the user who last modified this forecast item record.
  • Field API Name: std__LastModifiedDate__c
  • Data Type: DATETIME
  • Description: Timestamp when this forecast item was last modified.
  • 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 forecast category mapped from Opportunity Stage.
  • Field API Name: std__OwnerId__c
  • Data Type: TEXT
  • Description: The ID of the forecast owner.
  • Field API Name: std__OwnerOnlyAmount__c
  • Data Type: DOUBLE
  • Description: The sum of a person’s revenue opportunities, without adjustments.
  • Field API Name: std__OwnerOnlyAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the owner only amt. Do not include currency symbols or commas.
  • Field API Name: std__OwnerOnlyQuantity__c
  • Data Type: DOUBLE
  • Description: The sum of a person’s quantity opportunities, without adjustments. This field is available in API version 28.0 and later.
  • Field API Name: std__ParentForecastingItemId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: std__ProductFamily__c
  • Data Type: TEXT
  • Description: The product family of the forecast item. This field is available in API version 29.0 and later. This field is read only.
  • Field API Name: std__QuotaAmount__c
  • Data Type: DOUBLE
  • Description: The quota amount assigned for this forecasting period.
  • Field API Name: std__QuotaAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the quota amt. Do not include currency symbols or commas.
  • Field API Name: std__QuotaQuantity__c
  • Data Type: DOUBLE
  • Description: The quota quantity assigned for this forecasting period.
  • Field API Name: std__SalesTerritoryId__c
  • Data Type: TEXT
  • Description: The Territory that owns this forecast.
  • Field API Name: std__SystemModstamp__c
  • Data Type: DATETIME
  • Description: Timestamp for the last system update to this forecast item.
  • Field API Name: std__WithoutAdjustmentsAmount__c
  • Data Type: DOUBLE
  • Description: The forecast amount before any manual adjustments.
  • Field API Name: std__WithoutAdjustmentsAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the without adjustments amt. Do not include currency symbols or commas.
  • Field API Name: std__WithoutAdjustmentsQuantity__c
  • Data Type: DOUBLE
  • Description: The sum of a person’s owned quantity opportunities and also their subordinates’ opportunities, without adjustments. Subordinates include everyone reporting up to a person in the forecast hierarchy.
  • Field API Name: std__WithoutManagerAdjustmentAmount__c
  • Data Type: DOUBLE
  • Description: The forecast amount including only owner adjustments (excluding manager adjustments which is made above the forecast owner).
  • Field API Name: std__WithoutManagerAdjustmentAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the without manager adjustment amt. Do not include currency symbols or commas.
  • Field API Name: std__WithoutManagerAdjustmentQuantity__c
  • Data Type: DOUBLE
  • Description: The forecast number as seen by the forecast owner. This number is the sum of the owner’s quantity opportunities and subordinates’ opportunities, including adjustments made on the subordinates’ forecasts. It doesn’t include adjustments made by forecast managers above the owner in the forecast hierarchy.
  • Field API Name: std__WithoutOwnerAdjustmentAmount__c
  • Data Type: DOUBLE
  • Description: The forecast amount includes subordinate's forecast (includes adjustments) and excludes adjustment made by the forecast owner.
  • Field API Name: std__WithoutOwnerAdjustmentAmt__c
  • Data Type: CURRENCY
  • Description: Monetary amount representing the without owner adjustment amt. Do not include currency symbols or commas.
  • Field API Name: std__WithoutOwnerAdjustmentQuantity__c
  • Data Type: DOUBLE
  • Description: The forecast quantity as seen by the forecast owner without the owner's adjustment. This number is the sum of the subordinate's opportunities, including adjustments made by their manager or by the subordinate themselves, plus the rollup of the owner's own opportunities. It doesn’t include adjustments made by the forecast owner.