# 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.