Opportunity Historical Trend DMO

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

• cdp_sys_record_currency
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• EffectiveFromDate
• EffectiveToDate
• Id
• InternalOrganizationId
• KQ_Id
• NewAmount
• NewCloseDate
• NewForecastCategoryName
• NewProbabilityPercent
• NewStageName
• OldAmount
• OldCloseDate
• OldForecastCategoryName
• OldProbabilityPercent
• OldStageName
• OpportunityId
• SystemModstamp

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

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

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

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

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

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

• 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).

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

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

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• 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).

• Field API Name: ssot__NewCloseDate__c
• Data Type: DATETIME
• Description: Close Date value after update.

• Field API Name: ssot__NewForecastCategoryName__c
• Data Type: TEXT
• Description: ForcastingCategoryName value after update.

• Field API Name: ssot__NewProbabilityPercent__c
• Data Type: DOUBLE
• Description: Probability value after update.

• Field API Name: ssot__NewStageName__c
• Data Type: TEXT
• Description: StageName value after update.

• Field API Name: ssot__OldAmount__c
• Data Type: DOUBLE
• Description: Amount value before update.

• Field API Name: ssot__OldCloseDate__c
• Data Type: DATETIME
• Description: Close Date value before update.

• Field API Name: ssot__OldForecastCategoryName__c
• Data Type: TEXT
• Description: ForcastingCategoryName value before update.

• Field API Name: ssot__OldProbabilityPercent__c
• Data Type: DOUBLE
• Description: Probability value before update.

• Field API Name: ssot__OldStageName__c
• Data Type: TEXT
• Description: StageName value before update.

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

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