# Offer DMO

## Object Properties

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

## Relationships

- **PromotionId** has a FOREIGNKEY relationship with the [Promotion DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-promotiondmo-dmo.md) `Id` field.
- **CouponId** has a FOREIGNKEY relationship with the [Coupon DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-coupondmo-dmo.md) `Id` field.
- **CampaignId** has a FOREIGNKEY relationship with the [Campaign DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-campaigndmo-dmo.md) `Id` field.

## Fields

- [CampaignId](#campaignid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CouponId](#couponid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceName](#datasourcename)
- [DataSourceObjectId](#datasourceobjectid)
- [Description](#description)
- [EndDateTime](#enddatetime)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_CampaignId](#kq_campaignid)
- [KQ_CouponId](#kq_couponid)
- [KQ_Id](#kq_id)
- [KQ_PromotionId](#kq_promotionid)
- [LastModifiedDate](#lastmodifieddate)
- [Name](#name)
- [OfferCodeText](#offercodetext)
- [OfferConfigurationText](#offerconfigurationtext)
- [PriorityNumber](#prioritynumber)
- [PromotionId](#promotionid)
- [RecordType](#recordtype)
- [StartDateTime](#startdatetime)
- [Status](#status)
- [SystemModstamp](#systemmodstamp)
- [UsageType](#usagetype)

### CampaignId

- **Field API Name:** `ssot__CampaignId__c`
- **Data Type:** TEXT
- **Description:** Specifies campaign associated with promotion.

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

### CouponId

- **Field API Name:** `ssot__CouponId__c`
- **Data Type:** TEXT
- **Description:** The coupon code associated with the offer.

### 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:** Represent name of the external source system name.

### 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:** The description of the offer.

### EndDateTime

- **Field API Name:** `ssot__EndDateTime__c`
- **Data Type:** DATETIME
- **Description:** The end date and time until which the offer is available for customers to use.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this Offer 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_CampaignId

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

### KQ_CouponId

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

### KQ_Id

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

### KQ_PromotionId

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

### 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:** The name of the offer.

### OfferCodeText

- **Field API Name:** `ssot__OfferCodeText__c`
- **Data Type:** TEXT
- **Description:** The unique code for the offer.

### OfferConfigurationText

- **Field API Name:** `ssot__OfferConfigurationText__c`
- **Data Type:** TEXT
- **Description:** The JSON-based configuration of the offer.

### PriorityNumber

- **Field API Name:** `ssot__PriorityNumber__c`
- **Data Type:** DOUBLE
- **Description:** The priority of this offer compared to other offers of the related promotion.

### PromotionId

- **Field API Name:** `ssot__PromotionId__c`
- **Data Type:** TEXT
- **Description:** The number of product facing front (visible to customer) on the retail shelf.

### RecordType

- **Field API Name:** `ssot__RecordType__c`
- **Data Type:** TEXT
- **Description:** The record type of the offer record.

### StartDateTime

- **Field API Name:** `ssot__StartDateTime__c`
- **Data Type:** DATETIME
- **Description:** The start date and time from which the offer is available for customers to use.

### Status

- **Field API Name:** `ssot__Status__c`
- **Data Type:** TEXT
- **Description:** The status of 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.

### UsageType

- **Field API Name:** `ssot__UsageType__c`
- **Data Type:** TEXT
- **Description:** The cross cloud use cases the record belongs to.