# Product Category Product DMO

## Object Properties

**Object API Name:** `ssot__ProductCategoryProduct__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.
- **ProductCategoryId** has a FOREIGNKEY relationship with the [Product Category DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productcategorydmo-dmo.md) `Id` field.

## Fields

- [ActiveFromDateTime](#activefromdatetime)
- [ActiveToDateTime](#activetodatetime)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ExternalRecordId](#externalrecordid)
- [ExternalSourceId](#externalsourceid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsPrimaryCategory](#isprimarycategory)
- [KQ_Id](#kq_id)
- [KQ_ProductCategoryId](#kq_productcategoryid)
- [KQ_ProductId](#kq_productid)
- [LastModifiedDate](#lastmodifieddate)
- [ProductCategoryId](#productcategoryid)
- [ProductId](#productid)

### ActiveFromDateTime

- **Field API Name:** `ssot__ActiveFromDateTime__c`
- **Data Type:** DATETIME
- **Description:** From what date is the product active within the category.

### ActiveToDateTime

- **Field API Name:** `ssot__ActiveToDateTime__c`
- **Data Type:** DATETIME
- **Description:** To what date is the product active within the category.

### 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 the record was originally created.

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

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

### Id

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

### IsPrimaryCategory

- **Field API Name:** `ssot__IsPrimaryCategory__c`
- **Data Type:** BOOLEAN
- **Description:** Indicates whether this record is primary category (true) or not (false).

### KQ_Id

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

### KQ_ProductCategoryId

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

### 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 of the last modification to this record.

### ProductCategoryId

- **Field API Name:** `ssot__ProductCategoryId__c`
- **Data Type:** TEXT
- **Description:** Reference to what category the product is made part of.

### ProductId

- **Field API Name:** `ssot__ProductId__c`
- **Data Type:** TEXT
- **Description:** Reference to what product was assigned to the category.