---
schema_version: "1"
id: 17c779a805db0040e7a0df955f554d4865c928122cb15c1c9480c6758e12acfd
title: ccdw_dim_product
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_dim_product.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_product.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 4870d2dc1cada01a754cec1c17fa3916138826e501f67aa8581e97cfa3b08a73
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_dim_product

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

| Column Alias               | Data Type | Key    | Description                                                                          | Index? |
| -------------------------- | --------- | ------ | ------------------------------------------------------------------------------------ | ------ |
| `sku_id (PK)`              | INTEGER   | **PK** | Unique identifier for a Stock Keeping Unit (SKU).                                    | Yes    |
| `nsku_id`                  | VARCHAR   |        | Natural key of the SKU, representing the ID of the SKU in the source system.         | Yes    |
| `sku_display_name`         | VARCHAR   |        | User-friendly display name for the SKU.                                              | No     |
| `sku_upc_code`             | VARCHAR   |        | UPC (Universal Product Code) for the SKU.                                            | No     |
| `sku_ean_code`             | VARCHAR   |        | EAN (European Article Number) for the SKU.                                           | No     |
| `sku_brand`                | VARCHAR   |        | Brand name of the SKU.                                                               | No     |
| `sku_manufacture_name`     | VARCHAR   |        | Manufacturer's name for the SKU.                                                     | No     |
| `sku_manufacture_sku`      | VARCHAR   |        | Manufacturer's SKU for the product.                                                  | No     |
| `product_id`               | INTEGER   |        | Unique identifier for a product.                                                     | Yes    |
| `nproduct_id`              | VARCHAR   |        | Natural key of the product, representing the ID of the product in the source system. | Yes    |
| `product_display_name`     | VARCHAR   |        | User-friendly display name for the product.                                          | No     |
| `product_upc_code`         | VARCHAR   |        | UPC for the product.                                                                 | No     |
| `product_ean_code`         | VARCHAR   |        | EAN for the product.                                                                 | No     |
| `product_brand`            | VARCHAR   |        | Brand name of the product.                                                           | No     |
| `product_manufacture_name` | VARCHAR   |        | Manufacturer's name for the product.                                                 | No     |
| `product_manufacture_sku`  | VARCHAR   |        | Manufacturer's SKU for the product.                                                  | No     |
| `is_master`                | BOOLEAN   |        | Boolean indicating if it's a master product.                                         | No     |
| `is_bundle`                | BOOLEAN   |        | Boolean indicating if it's a product bundle.                                         | No     |

<!-- **Indices**: `sku_id`, `nsku_id`, `product_id`, `nproduct_id` -->