Cc Dim Product DMO

This DMO contains detailed information about products and SKUs. Each SKU rolls up to a product.

Object Properties

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

Fields

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.

Id

  • Field API Name: Id__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a Stock Keeping Unit (SKU).

InternalOrganizationId

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

IsBundle

  • Field API Name: IsBundle__c
  • Data Type: BOOLEAN
  • Description: Boolean indicating if it's a product bundle.

IsMaster

  • Field API Name: IsMaster__c
  • Data Type: BOOLEAN
  • Description: Boolean indicating if it's a master product.

KQ_Id

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

LastUpdatedDateTime

  • Field API Name: LastUpdatedDateTime__c
  • Data Type: DATETIME
  • Description: Date and time when the product record was last updated.

NaturalProductId

  • Field API Name: NaturalProductId__c
  • Data Type: TEXT
  • Description: Natural key of the product, representing the id of the product in the source system.

NaturalSkuId

  • Field API Name: NaturalSkuId__c
  • Data Type: TEXT
  • Description: Natural key of the SKU, representing the id of the SKU in the source system.

ProductBrand

  • Field API Name: ProductBrand__c
  • Data Type: TEXT
  • Description: Brand name of the product.

ProductDisplayName

  • Field API Name: ProductDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the product.

ProductEanCode

  • Field API Name: ProductEanCode__c
  • Data Type: TEXT
  • Description: EAN for the product.

ProductId

  • Field API Name: ProductId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a product.

ProductManufactureName

  • Field API Name: ProductManufactureName__c
  • Data Type: TEXT
  • Description: Manufacturer's name for the product.

ProductManufactureSku

  • Field API Name: ProductManufactureSku__c
  • Data Type: TEXT
  • Description: Manufacturer's SKU for the product.

ProductUpcCode

  • Field API Name: ProductUpcCode__c
  • Data Type: TEXT
  • Description: UPC for the product.

SkuBrand

  • Field API Name: SkuBrand__c
  • Data Type: TEXT
  • Description: Brand name of the SKU.

SkuDisplayName

  • Field API Name: SkuDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the SKU.

SkuEanCode

  • Field API Name: SkuEanCode__c
  • Data Type: TEXT
  • Description: EAN (European Article Number) for the SKU.

SkuManufactureName

  • Field API Name: SkuManufactureName__c
  • Data Type: TEXT
  • Description: Manufacturer's name for the SKU.

SkuManufactureSku

  • Field API Name: SkuManufactureSku__c
  • Data Type: TEXT
  • Description: Manufacturer's SKU for the product.

SkuUpcCode

  • Field API Name: SkuUpcCode__c
  • Data Type: TEXT
  • Description: UPC (Universal Product Code) for the SKU.