TopOpenOpportunities
Highest-value open opportunities.
View Specific Information
Select
All filter conditions for this view are processed client-side within the driver.
SELECT * FROM TopOpenOpportunities
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the opportunity. |
| Name | String | The name of the opportunity. |
| ContactName | String | The name of the primary contact for the opportunity. |
| CompanyName | String | The name of the company associated with the opportunity. |
| StageId | String | The identifier of the current pipeline stage. |
| StageName | String | The name of the current pipeline stage. |
| EstCloseDate | Datetime | The estimated close date of the opportunity. |
| TotalValue | Decimal | The total value of the opportunity. |
| WeightedValue | Decimal | The probability-weighted value of the opportunity. |
| ContactCount | Integer | The number of contacts associated with the opportunity. |
| ProbabilityPct | Integer | The probability percentage of closing the opportunity. |