Overview
The dimOpportunityStatus table is designed to track various opportunities within a system. This table includes information such as whether the opportunity is open, on hold, obsolete, or converted. It also includes display settings for the status and descriptions for better clarity and categorization of the opportunity statuses.
common.dimOpportunityStatus
| Column Name | Description | Type | Is Unique |
|---|---|---|---|
| Id | The primary key for the table | number | Yes |
| Name | Status name | text | No |
| IsOpen | Indicates if the opportunity is open | true/false | No |
| IsOnHold | Indicates if the opportunity is on hold | true/false | No |
| IsObsolete | Indicates if the opportunity is obsolete | true/false | No |
| ExcludeFromPipeline | Indicates if the opportunity should be excluded from the pipeline | true/false | No |
| IsConverted | Indicates if the opportunity is converted | true/false | No |
| DisplayOrder | The display order of the status | number | No |
| Description | Description of the status | text | No |
| BackColour | Background colour for the status | number | No |
| ForeColour | Foreground colour for the status | number | No |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article