OpportunityProduct
The Opportunity Product DMO is a Data Cloud data model object (DMO) for connecting an opportunity to the product that it represents, allowing for a many-to-many relationship.
Columns
| Name | Type | References | Description |
| Close Date | Datetime | The date when a record was closed. | |
| Created Date | Datetime | The date when a record was created. | |
| Currency | Varchar | A reference ID to the currency of the sales opportunity. | |
| Data Source | Varchar | A reference ID for the system in which the external record ID was assigned. | |
| Data Source Object | Varchar | A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object. | |
| Description | Varchar | The description of an opportunity. | |
| Discount Percentage | Double | The discount for a product as a percentage. | |
| 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. | |
| Last Modified Date | Datetime | The date when a user last modified a record. | |
| List Price Amount | Double | The price of a product. | |
| Name | Varchar | A short description of the opportunity’s product. | |
| Opportunity | Varchar | A reference ID to a deal or sale that is in progress and isn’t yet completed. | |
| Opportunity Product ID | Varchar | A unique ID used as primary key for the Opportunity Product DMO. | |
| Pricebook Entry | Varchar | A reference ID to list of products and their prices. | |
| Product | Varchar | A reference ID to what's intended to be sold, for example, goods or services. | |
| Product Quantity | Double | The number of product units in an opportunity. | |
| Quote Product | Varchar | A reference ID to item on a quote for prospective purchase of goods and services. | |
| Service Date | Datetime | The planned date when the to-be purchased product is in service. | |
| Subtotal Amount | Double | ||
| Total Price Amount | Double | The sum of all the product amounts for the opportunity’s product. |