StageHistories
Provides a chronological record of stage transitions for each deal, including timestamps and user information.
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the stage record. |
| DealId | String | Unique identifier of the deal associated with this stage. |
| Stage | String | Name or label of the deal stage. |
| Amount | Decimal | Monetary amount associated with the deal at this stage. |
| DurationDays | Integer | Number of days the deal remained in this stage. |
| ExpectedRevenue | Decimal | Estimated revenue expected from the deal at this stage. |
| Probability | Decimal | Likelihood of deal success at this stage, expressed as a percentage. |
| CloseDate | Date | Scheduled or actual date the deal is expected to close at this stage. |
| LastModifiedTime | Datetime | Timestamp indicating the last modification of this stage record. |
| ModifiedById | String | Identifier of the user who last modified the stage. |
| ModifiedByName | String | Full name of the user who last modified the stage. |
| ModifiedByEmail | String | Email address of the user who last modified the stage. |
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 |
| Fields | String | Fields to include in the response for this stage record. |