# Opportunity Product DMO

## Object Properties

**Object API Name:** `ssot__OpportunityProduct__dlm`\
**Category:** Unassigned\
**Availability:** Available in 254 and later versions\
**Primary Key Field:** Id

## Relationships

- **ProductId** has a FOREIGNKEY relationship with the [Master Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-masterproductdmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Goods Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-goodsproductdmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Bundle Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-bundleproductdmo-dmo.md) `Id` field.
- **OpportunityId** has a FOREIGNKEY relationship with the [Opportunity DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-opportunitydmo-dmo.md) `Id` field.

## Fields

- [CanUseQuantitySchedule](#canusequantityschedule)
- [CanUseRevenueSchedule](#canuserevenueschedule)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CloseDate](#closedate)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [CurrencyId](#currencyid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Description](#description)
- [DiscountPercentage](#discountpercentage)
- [ExternalRecordId](#externalrecordid)
- [ExternalSourceId](#externalsourceid)
- [HasQuantitySchedule](#hasquantityschedule)
- [HasRevenueSchedule](#hasrevenueschedule)
- [HasSchedule](#hasschedule)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_OpportunityId](#kq_opportunityid)
- [KQ_ProductId](#kq_productid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDate](#lastmodifieddate)
- [LastReferencedDate](#lastreferenceddate)
- [LastViewedDate](#lastvieweddate)
- [ListPriceAmount](#listpriceamount)
- [Name](#name)
- [OpportunityId](#opportunityid)
- [PricebookEntryId](#pricebookentryid)
- [ProductId](#productid)
- [ProductQuantity](#productquantity)
- [QuoteProductId](#quoteproductid)
- [ServiceDate](#servicedate)
- [SortOrderNumber](#sortordernumber)
- [SubtotalAmount](#subtotalamount)
- [SystemModstamp](#systemmodstamp)
- [TotalPriceAmount](#totalpriceamount)
- [UnitPriceAmount](#unitpriceamount)

### CanUseQuantitySchedule

- **Field API Name:** `ssot__CanUseQuantitySchedule__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the opportunity product can have a quantity schedule (true) or not (false). This field is read-only.

### CanUseRevenueSchedule

- **Field API Name:** `ssot__CanUseRevenueSchedule__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the opportunity product can have a revenue schedule (true) or not (false). This field is read-only.

### cdp_sys_record_currency

- **Field API Name:** `ssot__cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### CloseDate

- **Field API Name:** `ssot__CloseDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the close date.

### CreatedById

- **Field API Name:** `ssot__CreatedById__c`
- **Data Type:** TEXT
- **Description:** User who created the record.

### CreatedDate

- **Field API Name:** `ssot__CreatedDate__c`
- **Data Type:** DATETIME
- **Description:** Date and time when this record was created.

### CurrencyId

- **Field API Name:** `ssot__CurrencyId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceId

- **Field API Name:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### Description

- **Field API Name:** `ssot__Description__c`
- **Data Type:** TEXT
- **Description:** Description of an Opportunity.

### DiscountPercentage

- **Field API Name:** `ssot__DiscountPercentage__c`
- **Data Type:** DOUBLE
- **Description:** Discount for the product as a percentage.

### ExternalRecordId

- **Field API Name:** `ssot__ExternalRecordId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### ExternalSourceId

- **Field API Name:** `ssot__ExternalSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### HasQuantitySchedule

- **Field API Name:** `ssot__HasQuantitySchedule__c`
- **Data Type:** BOOLEAN
- **Description:** Read-only. Whether a quantity schedule was created for this object (true) or not (false).

### HasRevenueSchedule

- **Field API Name:** `ssot__HasRevenueSchedule__c`
- **Data Type:** BOOLEAN
- **Description:** Whether a revenue schedule was created for this object (true) or not (false).

### HasSchedule

- **Field API Name:** `ssot__HasSchedule__c`
- **Data Type:** BOOLEAN
- **Description:** If either HasQuantitySchedule or HasRevenueSchedule is true, this field is also true.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this OpportunityProduct record. Maximum size is 36 characters.

### InternalOrganizationId

- **Field API Name:** `ssot__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_OpportunityId

- **Field API Name:** `KQ_OpportunityId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for OpportunityId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### LastModifiedById

- **Field API Name:** `ssot__LastModifiedById__c`
- **Data Type:** TEXT
- **Description:** User who most recently changed the record.

### LastModifiedDate

- **Field API Name:** `ssot__LastModifiedDate__c`
- **Data Type:** DATETIME
- **Description:** Date and time when a user last modified this record.

### LastReferencedDate

- **Field API Name:** `ssot__LastReferencedDate__c`
- **Data Type:** DATETIME
- **Description:** Timestamp when this opportunity line item was last referenced.

### LastViewedDate

- **Field API Name:** `ssot__LastViewedDate__c`
- **Data Type:** DATETIME
- **Description:** Timestamp when this opportunity line item was last viewed.

### ListPriceAmount

- **Field API Name:** `ssot__ListPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** The price of the product within the price book, including currency.

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Short description of an Opportunity Product.

### OpportunityId

- **Field API Name:** `ssot__OpportunityId__c`
- **Data Type:** TEXT
- **Description:** The parent Opportunity Id.

### PricebookEntryId

- **Field API Name:** `ssot__PricebookEntryId__c`
- **Data Type:** TEXT
- **Description:** A list of products and their prices.

### ProductId

- **Field API Name:** `ssot__ProductId__c`
- **Data Type:** TEXT
- **Description:** What is intended to be sold. For example, goods, services, bundles, made to order products.

### ProductQuantity

- **Field API Name:** `ssot__ProductQuantity__c`
- **Data Type:** DOUBLE
- **Description:** Number of product units for the opportunity product.

### QuoteProductId

- **Field API Name:** `ssot__QuoteProductId__c`
- **Data Type:** TEXT
- **Description:** An item on a quote for prospective purchase of goods and/or services.

### ServiceDate

- **Field API Name:** `ssot__ServiceDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the service date.

### SortOrderNumber

- **Field API Name:** `ssot__SortOrderNumber__c`
- **Data Type:** DOUBLE
- **Description:** Number indicating the sort order selected by the user.

### SubtotalAmount

- **Field API Name:** `ssot__SubtotalAmount__c`
- **Data Type:** DOUBLE
- **Description:** Difference between standard and discounted pricing. Converted currency amounts when the opportunity's currency is different from the user's currency.

### SystemModstamp

- **Field API Name:** `ssot__SystemModstamp__c`
- **Data Type:** DATETIME
- **Description:** Date and time when this record was last modified by a user or by an automated process.

### TotalPriceAmount

- **Field API Name:** `ssot__TotalPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** Sum of all the product amounts for this opportunity product.

### UnitPriceAmount

- **Field API Name:** `ssot__UnitPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** The Unit Price for this opportunity line item.