Salesforce Docs Portal

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