--- schema_version: "1" id: 3a87311e6043f6a3cf1260ba255c1894adc94cbdc3f5a9e39a1e039f149c4a56 title: ccdw_dim_customer 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_customer.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_customer.html source_site: developer.salesforce.com content_type: documentation content_hash: 609f83093675853c26cc7253b7000d19223c5e086ea4a71855dc58e8491126e1 products: - Composable Storefront - Salesforce APIs --- # ccdw_dim_customer This table contains detailed information about registered customers. Unregistered buyers (guest checkouts) aren't included in this table. In fact tables, records for unregistered buyers have `customer_id = 1`, which can't be used to distinguish one unregistered buyer from another. | Column Alias | Data Type | Key | Description | Index? | | ------------------ | --------- | ------ | -------------------------------------------------------------------------------------- | ------ | | `customer_id (PK)` | BIGINT | **PK** | Unique identifier for a customer. | Yes | | `ncustomer_id` | VARCHAR | | Natural key of the customer, representing the ID of the customer in the source system. | Yes | | `login` | VARCHAR | | Customer's login name or ID. | No | | `salutation` | VARCHAR | | Customer's salutation (for example, "Mr.", "Ms."). | No | | `title` | VARCHAR | | Customer's title. | No | | `job_title` | VARCHAR | | Customer's job title. | No | | `first_name` | VARCHAR | | Customer's first name. | No | | `second_name` | VARCHAR | | Customer's middle name. | No | | `last_name` | VARCHAR | | Customer's last name. | No | | `suffix` | VARCHAR | | Customer's name suffix. | No | | `gender` | VARCHAR | | Customer's gender. | No | | `dob` | DATE | | Customer's date of birth. | No | | `email_address` | VARCHAR | | Customer's email address. | No | | `phone_home` | VARCHAR | | Customer's home phone number. | No | | `phone_business` | VARCHAR | | Customer's business phone number. | No | | `phone_mobile` | VARCHAR | | Customer's mobile phone number. | No | | `fax` | VARCHAR | | Customer's fax number. | No | | `repeat_buyer` | BOOLEAN | | Boolean indicating if the customer is a repeat buyer. | No | | `purchase_count` | INTEGER | | Total number of purchases made by the customer. | No |