Opportunity
The Opportunity DMO is a Data Cloud data model object (DMO) for deals or sales that are in progress and not yet completed.
Columns
| Name | Type | References | Description |
| Close Date | Datetime | The date when the opportunity was closed. | |
| Contract | Varchar | A reference ID to contract associated with order. | |
| Created Date | Datetime | The date a record was created. | |
| Currency | Varchar | A reference ID to the currency of the sales opportunity. | |
| Customer Account | Varchar | A reference ID to business or person that is prospective buyer of opportunity's product or service. | |
| Data Source | Varchar | A reference ID to logical name for system that is source of records identified by External Record ID. | |
| Data Source Object | Varchar | A reference ID to logical name of object where record originated, for example a cloud storage file or another connector’s external object. | |
| Description | Varchar | A description of the opportunity. | |
| Engagement Channel | Varchar | A reference ID to the business or company that serves as a provider for engagement channel type. | |
| Engagement Channel Type | Varchar | A reference ID to method of message delivery, for example email, phone call, SMS message, or TV commercial. | |
| Expected Revenue Amount | Double | The calculated revenue based on amount and probability fields. | |
| External Record ID | Varchar | A reference ID to an external data source system. | |
| External Source ID | Varchar | A reference ID for the system in which the external record ID was assigned. | |
| Internal Organization | Varchar | A reference ID to business unit or other internal organization that owns the business account. | |
| Is Private | Varchar | An indicator if an opportunity can be shared with someone outside the opportunity team. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Lead | Varchar | A reference ID to person or company that shows interest in company's products. | |
| Lead Source | Varchar | A reference ID to source where lead was obtained. | |
| Name | Varchar | The name of the opportunity. | |
| Next Step | Varchar | A description of the next task needed to close an opportunity. | |
| Opportunity Forecast Category | Varchar | A reference ID to a revenue probability category within the sales cycle. | |
| Opportunity Id | Varchar | A unique ID used as primary key for the Opportunity DMO. | |
| Opportunity Name | Varchar | The name of the opportunity. | |
| Opportunity Stage | Varchar | A reference ID to phase or step of opportunity, for example, new, won, or closed. | |
| Opportunity Type | Varchar | A reference ID to the type of opportunity, for example, new or existing business. | |
| Partner Account | Varchar | A reference ID to external business supporting or participating in opportunity. | |
| Price Book | Varchar | A reference ID to sets of prices tailored to different needs. Using price books, each product can have many different prices. | |
| Probability | Double | The probability of closing an opportunity. | |
| Total Amount | Double | The estimated amount of the total sale. | |
| Total Product Quantity | Double | The total quantity value for all products, if the opportunity has products associated. |