Salesforce Docs Portal

ccdl_customer_profile

Contains B2C Commerce customer profile information including contact details, preferences, and activity timestamps.

Default refresh frequency: Daily.

Primary Key: (universally unique identifier (UUID), customerListId).

Column Reference

Column Name Data Type Description
birthday Date Customer's birth date
companyName String Company name for B2B customers
creationDate DateTime Timestamp when the customer profile was created
customerListId String Customer list identifier
customerNo String Customer number identifier
email Email Customer's email address
fax String Customer's fax number
firstName String Customer's first name
gender Enum-Of-Int Customer's gender
jobTitle String Customer's job title
lastLoginTime DateTime Timestamp of customer's last login
lastModified DateTime Timestamp when the profile was last modified
lastName String Customer's last name
lastVisitTime DateTime Timestamp of customer's last site visit
nextBirthday Date Customer's next upcoming birthday
phoneBusiness String Customer's business phone number
phoneHome String Customer's home phone number
phoneMobile String Customer's mobile phone number
preferredLocale String Customer's preferred locale setting
salutation String Customer's salutation (for example, Mr., Mrs.)
secondName String Customer's middle or second name
suffix String Customer's name suffix
taxID String Customer's tax identification number
taxIDType Enum-Of-String Type of tax identifier
title String Customer's title
UUID String Unique customer identifier