# Supplier Product DMO

Represents the products or services that a supplier provides to a company.

## Object Properties

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

## Relationships

- **SupplierId** has a FOREIGNKEY relationship with the [Supplier DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-supplierdmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **DefaultProductEmssnFctrId** has a FOREIGNKEY relationship with the [Product Emissions Factor DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productemissionsfactordmo-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

- [AttributeEndDate](#attributeenddate)
- [AttributeStartDate](#attributestartdate)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DefaultProductEmssnFctrId](#defaultproductemssnfctrid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsActiveInd](#isactiveind)
- [KQ_DefaultProductEmssnFctrId](#kq_defaultproductemssnfctrid)
- [KQ_Id](#kq_id)
- [KQ_ProductCategoryId](#kq_productcategoryid)
- [KQ_ProductId](#kq_productid)
- [KQ_SupplierId](#kq_supplierid)
- [ManufacturerPartNumber](#manufacturerpartnumber)
- [ProductCategoryId](#productcategoryid)
- [ProductId](#productid)
- [SourcingAllocPercentagePct](#sourcingallocpercentagepct)
- [SupplierId](#supplierid)
- [SupplierPartNumber](#supplierpartnumber)
- [SupplierProductName](#supplierproductname)
- [SupplierRankQty](#supplierrankqty)

### AttributeEndDate

- **Field API Name:** `AttributeEndDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the product attribute becomes inactive.

### AttributeStartDate

- **Field API Name:** `AttributeStartDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the product attribute becomes active.

### cdp_sys_record_currency

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

### DataSourceId

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

### DataSourceObjectId

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

### DefaultProductEmssnFctrId

- **Field API Name:** `DefaultProductEmssnFctrId__c`
- **Data Type:** TEXT
- **Description:** The default emissions factor associated with this product that's purchased from the supplier.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** Id of the record.

### InternalOrganizationId

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

### IsActiveInd

- **Field API Name:** `IsActiveInd__c`
- **Data Type:** BOOLEAN
- **Description:** Indicates whether the product is currently active or inactive.

### KQ_DefaultProductEmssnFctrId

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

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

### KQ_SupplierId

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

### ManufacturerPartNumber

- **Field API Name:** `ManufacturerPartNumber__c`
- **Data Type:** TEXT
- **Description:** OEM or manufacturer part number for the product. Required for traceability when the supplier is a distributor selling third-party brand parts.

### ProductCategoryId

- **Field API Name:** `ProductCategoryId__c`
- **Data Type:** TEXT
- **Description:** A category of products that's offered by the supplier for managed events.

### ProductId

- **Field API Name:** `ProductId__c`
- **Data Type:** TEXT
- **Description:** The product that the organization is purchasing from the associated supplier.

### SourcingAllocPercentagePct

- **Field API Name:** `SourcingAllocPercentagePct__c`
- **Data Type:** DOUBLE
- **Description:** The sourcing allocation percentage of a supplier towards the total quantity that's purchased by an organization.

### SupplierId

- **Field API Name:** `SupplierId__c`
- **Data Type:** TEXT
- **Description:** The supplier that is associated with this supplier product record. This is a relationship field.

### SupplierPartNumber

- **Field API Name:** `SupplierPartNumber__c`
- **Data Type:** TEXT
- **Description:** Supplier's internal part number or SKU for the product. Critical for purchase orders, traceability, and supplier communications. Different from Product2.ProductCode, which is the customer's part number.

### SupplierProductName

- **Field API Name:** `SupplierProductName__c`
- **Data Type:** TEXT
- **Description:** The name of the record.

### SupplierRankQty

- **Field API Name:** `SupplierRankQty__c`
- **Data Type:** DOUBLE
- **Description:** The rank given to the supplier that helps an organization determine when to engage a supplier to make a purchase.