DealHistory
Displays a timeline of key updates to each deal, such as stage movement, owner reassignment, and expected revenue edits.
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier for the deal history record. |
| DealName_Id | String | The identifier of the deal associated with this history record. |
| DealName_Name | String | The name of the deal associated with this history record. |
| Stage | String | The stage of the deal recorded in this history entry. |
| StageDuration(CalendarDays) | Int | The number of calendar days the deal remained in this stage. |
| ModifiedBy_Id | String | The identifier of the user who modified this deal history entry. |
| ModifiedBy_Name | String | The name of the user who modified this deal history entry. |
| ModifiedTime | Datetime | The date and time when this deal history entry was last modified. |
| Amount | Decimal | The monetary amount associated with the deal at this history stage. |
| Probability(%) | Int | The probability percentage of winning the deal at this stage. |
| ExpectedRevenue | Decimal | The expected revenue from the deal at this stage. |
| ClosingDate | Date | The closing date of the deal as recorded in this history entry. |
| RecordId | Long | The internal system identifier for this history record. |
| LastActivityTime | Datetime | The date and time of the last activity related to this deal history entry. |
| MovedTo | String | The stage the deal was moved to after this entry. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String | The field or fields used to check for duplicate records during an upsert operation. |
| CustomViewId | Long | The custom view identifier used to filter this record. Works only when the useCOQL parameter is false. |
| Trigger | String | Indicates whether to trigger a rule when inserting a record into the CRM account. |