Supplier Product DMO

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

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

• SupplierId has a FOREIGNKEY relationship with the Supplier DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• DefaultProductEmssnFctrId has a FOREIGNKEY relationship with the Product Emissions Factor DMO Id field.
• ProductCategoryId has a FOREIGNKEY relationship with the Product Category DMO Id field.

• AttributeEndDate
• AttributeStartDate
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DefaultProductEmssnFctrId
• Id
• InternalOrganizationId
• IsActiveInd
• KQ_DefaultProductEmssnFctrId
• KQ_Id
• KQ_ProductCategoryId
• KQ_ProductId
• KQ_SupplierId
• ManufacturerPartNumber
• ProductCategoryId
• ProductId
• SourcingAllocPercentagePct
• SupplierId
• SupplierPartNumber
• SupplierProductName
• SupplierRankQty

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

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

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

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

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

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

• Field API Name: Id__c
• Data Type: TEXT
• Description: Id of the record.

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

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

• Field API Name: KQ_DefaultProductEmssnFctrId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DefaultProductEmssnFctrId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_ProductCategoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductCategoryId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_SupplierId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SupplierId

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

• Field API Name: ProductCategoryId__c
• Data Type: TEXT
• Description: A category of products that’s offered by the supplier for managed events.

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

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

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

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

• Field API Name: SupplierProductName__c
• Data Type: TEXT
• Description: The name of the record.

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