---
schema_version: "1"
id: e6abda7ca863a04d1996dcf851bbcbfeac1dff90724d918dddb3b6de6dafbe40
title: ccdw_dim_currency
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_currency.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_currency.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 775c102bfbeab44e5175aa96da480fb38920d8fad12c8344273288a76157c992
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_dim_currency

This table provides details about various currencies. Each row represents an ISO 4217 currency.

| Column Alias              | Data Type | Key    | Description                                                | Index? |
| ------------------------- | --------- | ------ | ---------------------------------------------------------- | ------ |
| `currency_id (PK)`        | SMALLINT  | **PK** | Unique identifier for a currency.                          | Yes    |
| `alpha_code`              | VARCHAR   |        | Alpha-3 code for the currency (for example, "USD", "EUR"). | Yes    |
| `display_name`            | VARCHAR   |        | User-friendly display name for the currency.               | No     |
| `numeric_code`            | INTEGER   |        | Numeric code for the currency.                             | No     |
| `symbol`                  | VARCHAR   |        | Symbol for the currency (for example, "\$", "€").          | No     |
| `default_fraction_digits` | SMALLINT  |        | Number of default fraction digits for the currency.        | No     |

<!-- **Indices**: `currency_id`, `alpha_code` -->