---
schema_version: "1"
id: ee06ae87a4ec3830d4b8d113e49a077bf5f11dfbcdf001a18de787795ed6b2d3
title: ccdw_dim_coupon
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_coupon.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_coupon.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c8b966019752f37063a13b9d8d715a3e784f8cc17d8af411628223f186f712b1
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_dim_coupon

This table provides details about coupons.

| Column Alias       | Data Type | Key    | Description                                                                        | Index? |
| ------------------ | --------- | ------ | ---------------------------------------------------------------------------------- | ------ |
| `coupon_id (PK)`   | INTEGER   | **PK** | Unique identifier for a coupon.                                                    | Yes    |
| `ncoupon_id`       | VARCHAR   |        | Natural key of the coupon, representing the ID of the coupon in the source system. | Yes    |
| `coupon_type`      | VARCHAR   |        | Type of coupon (for example, "Percentage", "Fixed Amount").                        | No     |
| `description`      | VARCHAR   |        | Description of the coupon.                                                         | No     |
| `is_enabled`       | BOOLEAN   |        | Boolean indicating if the coupon is enabled.                                       | No     |
| `redemption_limit` | INTEGER   |        | Maximum number of redemptions allowed per coupon code.                             | No     |
| `codes_count`      | INTEGER   |        | Total number of coupon codes available.                                            | No     |

<!-- **Indices**: `coupon_id`, `ncoupon_id` -->