Cc Dim Product DMO
This DMO contains detailed information about products and SKUs. Each SKU rolls up to a product.
Object API Name: CcDimProduct_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id
- cdp_sys_record_currency
- DataSourceId
- DataSourceObjectId
- Id
- InternalOrganizationId
- IsBundle
- IsMaster
- KQ_Id
- LastUpdatedDateTime
- NaturalProductId
- NaturalSkuId
- ProductBrand
- ProductDisplayName
- ProductEanCode
- ProductId
- ProductManufactureName
- ProductManufactureSku
- ProductUpcCode
- SkuBrand
- SkuDisplayName
- SkuEanCode
- SkuManufactureName
- SkuManufactureSku
- SkuUpcCode
- 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:
Id__c - Data Type: DOUBLE
- Description: Unique identifier for a Stock Keeping Unit (SKU).
- Field API Name:
InternalOrganizationId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
IsBundle__c - Data Type: BOOLEAN
- Description: Boolean indicating if it’s a product bundle.
- Field API Name:
IsMaster__c - Data Type: BOOLEAN
- Description: Boolean indicating if it’s a master product.
- Field API Name:
KQ_Id__c - Data Type: TEXT
- Description: Key Qualifier system field for Id
- Field API Name:
LastUpdatedDateTime__c - Data Type: DATETIME
- Description: Date and time when the product record was last updated.
- Field API Name:
NaturalProductId__c - Data Type: TEXT
- Description: Natural key of the product, representing the id of the product in the source system.
- Field API Name:
NaturalSkuId__c - Data Type: TEXT
- Description: Natural key of the SKU, representing the id of the SKU in the source system.
- Field API Name:
ProductBrand__c - Data Type: TEXT
- Description: Brand name of the product.
- Field API Name:
ProductDisplayName__c - Data Type: TEXT
- Description: User-friendly display name for the product.
- Field API Name:
ProductEanCode__c - Data Type: TEXT
- Description: EAN for the product.
- Field API Name:
ProductId__c - Data Type: DOUBLE
- Description: Unique identifier for a product.
- Field API Name:
ProductManufactureName__c - Data Type: TEXT
- Description: Manufacturer’s name for the product.
- Field API Name:
ProductManufactureSku__c - Data Type: TEXT
- Description: Manufacturer’s SKU for the product.
- Field API Name:
ProductUpcCode__c - Data Type: TEXT
- Description: UPC for the product.
- Field API Name:
SkuBrand__c - Data Type: TEXT
- Description: Brand name of the SKU.
- Field API Name:
SkuDisplayName__c - Data Type: TEXT
- Description: User-friendly display name for the SKU.
- Field API Name:
SkuEanCode__c - Data Type: TEXT
- Description: EAN (European Article Number) for the SKU.
- Field API Name:
SkuManufactureName__c - Data Type: TEXT
- Description: Manufacturer’s name for the SKU.
- Field API Name:
SkuManufactureSku__c - Data Type: TEXT
- Description: Manufacturer’s SKU for the product.
- Field API Name:
SkuUpcCode__c - Data Type: TEXT
- Description: UPC (Universal Product Code) for the SKU.