# Offer Product DMO

## Object Properties

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

## Relationships

- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **OfferId** has a FOREIGNKEY relationship with the [Offer DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-offerdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceName](#datasourcename)
- [DataSourceObjectId](#datasourceobjectid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_OfferId](#kq_offerid)
- [KQ_ProductId](#kq_productid)
- [LastModifiedDate](#lastmodifieddate)
- [Name](#name)
- [OfferId](#offerid)
- [ProductId](#productid)
- [SystemModstamp](#systemmodstamp)

### 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.

### CreatedDate

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

### DataSourceId

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

### DataSourceName

- **Field API Name:** `ssot__DataSourceName__c`
- **Data Type:** TEXT
- **Description:** The source system name.

### DataSourceObjectId

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

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this OfferProduct record. Maximum size is 15 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_OfferId

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

### KQ_ProductId

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

### LastModifiedDate

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

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of the offer product record.

### OfferId

- **Field API Name:** `ssot__OfferId__c`
- **Data Type:** TEXT
- **Description:** The ID of the offer associated with product.

### ProductId

- **Field API Name:** `ssot__ProductId__c`
- **Data Type:** TEXT
- **Description:** The ID of the product associated with the offer.

### SystemModstamp

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