--- schema_version: "1" id: 365cf2a9ac1e66e4b1c1a40903ac4d6ef46c3841aef153c97a9856abdd8a38cf title: ccdw_dim_site 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_site.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.html source_site: developer.salesforce.com content_type: documentation content_hash: 92a63b73ce9d58f6ec361f607005e5090d33382d99ebd57fc914f177066e1d1d products: - Composable Storefront - Salesforce APIs --- # ccdw_dim_site This table stores information about different e-commerce sites or storefronts. | Column Alias | Data Type | Key | Description | Index? | | ------------------- | --------- | ------ | ----------------------------------------------------------------- | ------ | | `site_id (PK)` | SMALLINT | **PK** | Unique identifier for a site. | Yes | | `nsite_id` | VARCHAR | | The natural key of the site as represented in the source system. | Yes | | `site_display_name` | VARCHAR | | User-friendly display name for the site. | No | | `site_sitezone` | VARCHAR | | Normalized timezone for the site. | No | | `site_currency` | VARCHAR | | Alpha-3 currency code used by the site. | No | | `site_taxation` | VARCHAR | | Taxation rules or status for the site (for example, gross/net). | No | | `site_status` | VARCHAR | | Current operational status of the site. | No | | `realm_id` | SMALLINT | | Unique identifier for the realm the site belongs to. | No | | `nrealm_id` | VARCHAR | | The natural key of the realm as represented in the source system. | Yes | | `realm_timezone` | VARCHAR | | Timezone of the realm. | No | | `realm_currency` | VARCHAR | | Alpha-3 currency code used by the realm. | No |