---
schema_version: "1"
id: f050c8d534047fd50479386a3056552ff076da5f353f0c93abbe45fe981b1352
title: Opportunity Historical Trend DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-opportunityhistoricaltrenddmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-opportunityhistoricaltrenddmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 34795294255779d7829520a00760e7655389ecbd64d3d301a915f5d580654f42
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Opportunity Historical Trend DMO

## Object Properties

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

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EffectiveFromDate](#effectivefromdate)
- [EffectiveToDate](#effectivetodate)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [NewAmount](#newamount)
- [NewCloseDate](#newclosedate)
- [NewForecastCategoryName](#newforecastcategoryname)
- [NewProbabilityPercent](#newprobabilitypercent)
- [NewStageName](#newstagename)
- [OldAmount](#oldamount)
- [OldCloseDate](#oldclosedate)
- [OldForecastCategoryName](#oldforecastcategoryname)
- [OldProbabilityPercent](#oldprobabilitypercent)
- [OldStageName](#oldstagename)
- [OpportunityId](#opportunityid)
- [SystemModstamp](#systemmodstamp)

### cdp_sys_record_currency

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

### CreatedById

- **Field API Name:** `ssot__CreatedById__c`
- **Data Type:** TEXT
- **Description:** The user who created the record.

### CreatedDate

- **Field API Name:** `ssot__CreatedDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time when this record was created.

### DataSourceId

- **Field API Name:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### EffectiveFromDate

- **Field API Name:** `ssot__EffectiveFromDate__c`
- **Data Type:** DATETIME
- **Description:** indicate this historical trending record valid from date.

### EffectiveToDate

- **Field API Name:** `ssot__EffectiveToDate__c`
- **Data Type:** DATETIME
- **Description:** indicate this historical trending record valid to date (the latest record is always valid, the date is set to 3000/1/1).

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this OpportunityHistoricalTrend record. Maximum size is 15 characters.

### InternalOrganizationId

- **Field API Name:** `ssot__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### NewAmount

- **Field API Name:** `ssot__NewAmount__c`
- **Data Type:** DOUBLE
- **Description:** Amount value after update (can be same as before value if update operation only update other historical trending tracking fields).

### NewCloseDate

- **Field API Name:** `ssot__NewCloseDate__c`
- **Data Type:** DATETIME
- **Description:** Close Date value after update.

### NewForecastCategoryName

- **Field API Name:** `ssot__NewForecastCategoryName__c`
- **Data Type:** TEXT
- **Description:** ForcastingCategoryName value after update.

### NewProbabilityPercent

- **Field API Name:** `ssot__NewProbabilityPercent__c`
- **Data Type:** DOUBLE
- **Description:** Probability value after update.

### NewStageName

- **Field API Name:** `ssot__NewStageName__c`
- **Data Type:** TEXT
- **Description:** StageName value after update.

### OldAmount

- **Field API Name:** `ssot__OldAmount__c`
- **Data Type:** DOUBLE
- **Description:** Amount value before update.

### OldCloseDate

- **Field API Name:** `ssot__OldCloseDate__c`
- **Data Type:** DATETIME
- **Description:** Close Date value before update.

### OldForecastCategoryName

- **Field API Name:** `ssot__OldForecastCategoryName__c`
- **Data Type:** TEXT
- **Description:** ForcastingCategoryName value before update.

### OldProbabilityPercent

- **Field API Name:** `ssot__OldProbabilityPercent__c`
- **Data Type:** DOUBLE
- **Description:** Probability value before update.

### OldStageName

- **Field API Name:** `ssot__OldStageName__c`
- **Data Type:** TEXT
- **Description:** StageName value before update.

### OpportunityId

- **Field API Name:** `ssot__OpportunityId__c`
- **Data Type:** TEXT
- **Description:** Required. The unique identifier for the related Opportunity record. Maximum size is 15 characters.

### SystemModstamp

- **Field API Name:** `ssot__SystemModstamp__c`
- **Data Type:** DATETIME
- **Description:** The date and time when this record was last modified by a user or by an automated process.