DealHistory
Presents a timeline of key updates to each deal, such as stage changes, owner reassignments, and expected revenue edits.
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the deal history entry. |
| DealName_Id | String | Identifier of the deal associated with this history entry. |
| DealName_Name | String | Name of the deal associated with this history entry. |
| Stage | String | Name of the deal stage recorded in this history entry. |
| StageDuration(CalendarDays) | Int | Total number of calendar days the deal remained in this stage. |
| ModifiedBy_Id | String | Identifier of the user who made the modification. |
| ModifiedBy_Name | String | Name of the user who made the modification. |
| ModifiedTime | Datetime | Date and time when the modification was made. |
| Amount | Decimal | Amount value associated with the deal at this stage. |
| Probability(%) | Int | Probability percentage of successfully closing the deal at this stage. |
| ExpectedRevenue | Decimal | Expected revenue based on the deal's amount and probability. |
| ClosingDate | Date | Expected closing date for the deal at this stage. |
| LastActivityTime | Datetime | Timestamp of the most recent activity related to the deal. |
| MovedTo | String | Name of 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 | Fields used to check for duplicate records during an upsert operation. |
| CustomViewId | Long | Custom view identifier used for filtering this record. Works when the useCOQL parameter is set to false. |
| Trigger | String | Flag used to trigger rules when inserting the record into the CRM account. |