DealPipelineStages
The stages for a given Deal Pipeline.
Table Specific Information
Deal pipeline stages represent the individual stages of a given pipeline that a Deal may currently be on.
Select
When selecting deal pipeline stages, they can only be filtered by the PipelineId. For example:
SELECT * FROM DealPipelineStages WHERE PipelineId = 12345
Columns
| Name | Type | References | Description |
| PipelineId [KEY] | String |
DealPipelines.PipelineId | The id of the pipeline. |
| StageId [KEY] | String | The id of the stage. | |
| PipelineName | String | The name of the pipeline. | |
| PipelineIsActive | Boolean | A boolean indicating if the pipeline is active or not. | |
| StageName | String | The name of the stage. | |
| StageIsActive | Boolean | A boolean indicating if the stage is active or not. | |
| StageClosedWon | Boolean | A boolean indicating if the stage indicates that the deal was closed and won. | |
| StageDisplayOrder | Integer | The display order of the stage in the deal. | |
| StageProbability | Double | The estimated probability of closing the deal at this stage. |