# Supplier Product Relation DMO

A directed relationship between two supplier products, such as a substitute, an alternate source, or a bill-of-materials parent-to-child (sub-component) link.

## Object Properties

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

## Relationships

- **SupplierProductId** has a FOREIGNKEY relationship with the [Supplier Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-supplierproductdmo-dmo.md) `Id` field.
- **RelatedSupplierProductId** has a FOREIGNKEY relationship with the [Supplier Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-supplierproductdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EndDate](#enddate)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsActive](#isactive)
- [Quantity](#quantity)
- [RelatedSupplierProductId](#relatedsupplierproductid)
- [RelationshipType](#relationshiptype)
- [StartDate](#startdate)
- [SupplierProductId](#supplierproductid)
- [SupplierProductRelationName](#supplierproductrelationname)

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

### EndDate

- **Field API Name:** `EndDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when this supplier product relationship is no longer effective.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** Unique identifier for the supplier product relation record.

### InternalOrganizationId

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

### IsActive

- **Field API Name:** `IsActive__c`
- **Data Type:** BOOLEAN
- **Description:** Indicates whether this supplier product relationship is currently active.

### Quantity

- **Field API Name:** `Quantity__c`
- **Data Type:** DOUBLE
- **Description:** The number of units of the related supplier product required per unit of the parent supplier product.

### RelatedSupplierProductId

- **Field API Name:** `RelatedSupplierProductId__c`
- **Data Type:** TEXT
- **Description:** The related supplier product that is a component of the parent supplier product.

### RelationshipType

- **Field API Name:** `RelationshipType__c`
- **Data Type:** TEXT
- **Description:** The type of relationship between the parent and related supplier products, such as primary or substitute.

### StartDate

- **Field API Name:** `StartDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when this supplier product relationship becomes effective.

### SupplierProductId

- **Field API Name:** `SupplierProductId__c`
- **Data Type:** TEXT
- **Description:** The parent supplier product in this relationship.

### SupplierProductRelationName

- **Field API Name:** `SupplierProductRelationName__c`
- **Data Type:** TEXT
- **Description:** Auto-generated unique identifier for this supplier product relation record.