---
schema_version: "1"
id: d872842d74978a6d67881a6c07bc0e9f371a13e47bc7c747409c3e7f0875b1d5
title: ccdl_sales_order_customer
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_data_cloud_ccdl_sales_order_customer.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_data_cloud_ccdl_sales_order_customer.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a9c3348673d20fb41afd986300c8afef4b816bee79b3f7078da6055070bb5da9
description: Contains customer details associated with B2C Commerce sales orders. Each record captures customer profile, default address, and billing address information at the time of order placement.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# ccdl\_sales\_order\_customer

Contains customer details associated with B2C Commerce sales orders. Each record captures customer profile, default address, and billing address information at the time of order placement.

Default refresh frequency: **Hourly**.

Primary Key: (customerNo, visitorId).

This table contains customer information from the headers of placed orders. All orders where visitor consent hasn't been given to track activities are excluded from this table.

## Column Reference

  
| Column Name | Data Type | Description |
| --- | --- | --- |
| buyerEmail | String | Order confirmation email |
| buyerName | String | Name of the buyer |
| customerCredentialsLogin | String | Login name of the customer |
| customerDefaultAddressAddress1 | String | Primary street address line |
| customerDefaultAddressAddress2 | String | Secondary street address line |
| customerDefaultAddressCity | String | City name |
| customerDefaultAddressCompanyName | String | Company name in address |
| customerDefaultAddressCountryCode | String | Country code |
| customerDefaultAddressFirstName | String | First name in address |
| customerDefaultAddressFullName | String | Full name in address |
| customerDefaultAddressJobTitle | String | Job title in address |
| customerDefaultAddressLastName | String | Last name in address |
| customerDefaultAddressPhone | String | Phone number in address |
| customerDefaultAddressPostalCode | String | Postal code or ZIP code |
| customerDefaultAddressPostBox | String | Post office box |
| customerDefaultAddressSalutation | String | Salutation in address |
| customerDefaultAddressSecondName | String | Middle/second name in address |
| customerDefaultAddressStateCode | String | State/province code |
| customerDefaultAddressSuffix | String | Name suffix in address |
| customerDefaultAddressSuite | String | Suite/apartment number |
| customerDefaultAddressTitle | String | Title in address |
| customerId | String | Unique customer identifier |
| customerListId | String | Customer list identifier |
| customerNo | String | Identifier for registered user |
| customerNote | String | Notes associated with the customer |
| customerPreferredLocale | String | Customer's preferred locale setting |
| customerProfileBirthday | Date | Customer's birth date |
| customerProfileCompanyName | String | Customer's company name |
| customerProfileCreationDate | Date | Profile creation timestamp |
| customerProfileEmail | String | Customer's email address |
| customerProfileFAX | String | Customer's fax number |
| customerProfileFirstName | String | Customer's first name |
| customerProfileGender | String | Gender of customer |
| customerProfileJobTitle | String | Customer's job title |
| customerProfileLastLoginTime | Date | Timestamp of last login |
| customerProfileLastName | String | Customer's last name |
| customerProfileLastVisitTime | Date | Timestamp of last visit |
| customerProfilePhoneHome | String | Customer's home phone |
| customerProfilePhoneMobile | String | Customer's mobile phone |
| customerProfileSalutation | String | Customer's salutation |
| customerProfileSecondName | String | Customer's middle/second name |
| customerProfileSuffix | String | Customer's name suffix |
| customerProfileTitle | String | Customer's title |
| invoiceToAddressAddress1 | String | Billing address line 1 |
| invoiceToAddressAddress2 | String | Billing address line 2 |
| invoiceToAddressCity | String | Billing address city |
| invoiceToAddressCountryCode | String | Billing address country code |
| invoiceToAddressFirstName | String | Billing address first name |
| invoiceToAddressFullName | String | Billing address full name |
| invoiceToAddressJobTitle | String | Billing address job title |
| invoiceToAddressLastName | String | Billing address last name |
| invoiceToAddressPhone | String | Billing address phone |
| invoiceToAddressPostalCode | String | Billing address postal code |
| invoiceToAddressPostBox | String | Billing address post box |
| invoiceToAddressSalutation | String | Billing address salutation |
| invoiceToAddressSecondName | String | Billing address second name |
| invoiceToAddressStateCode | String | Billing address state code |
| invoiceToAddressSuffix | String | Billing address name suffix |
| invoiceToAddressSuite | String | Billing address suite |
| invoiceToAddressTitle | String | Billing address title |
| isAnonymous | Boolean | Whether the customer is anonymous/guest |
| orderPlacedTimestamp | Date | Timestamp when the order was placed |
| tenantId | String | Tenant identifier |
| usid | String | Unique session identifier |
| version | String | Version of data stream |
| visitorId | String | Identifier of the site visitor who placed the order |