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. |
| Potential_Name_Id | String | The identifier of the deal associated with this history record. |
| Stage | String | The stage of the deal recorded in this history entry. |
| Stage_Duration_Calendar_Days | Int | The number of calendar days the deal remained in this stage. |
| Modified_By_Id | String | The identifier of the user who modified this deal history entry. |
| Modified_Time | 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. |
| Expected_Revenue | Decimal | The expected revenue from the deal at this stage. |
| Closing_Date | Date | The closing date of the deal as recorded in this history entry. |
| Id_CustomModule | Long | The internal system identifier for this history record. |
| Last_Activity_Time | Datetime | The date and time of the last activity related to this deal history entry. |
| Moved_To__s | 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 more granular control over the data returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String | The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field. |
| Trigger | String | To trigger the rule while inserting record into CRM account. |