Cc Dim Customer DMO

This DMO contains detailed information about customers.

Object API Name: CcDimCustomer_std__dlm
Category: Profile
Availability: Available in 260 and later versions
Primary Key Field: Id

  • Field API Name: cdp_sys_record_currency__c
  • Data Type: TEXT
  • Description: System-generated metadata field that stores a 3-letter ISO currency code.
  • Field API Name: DataSourceId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: DataSourceObjectId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: Dob__c
  • Data Type: DATEONLY
  • Description: Customer’s date of birth.
  • Field API Name: EmailAddress__c
  • Data Type: TEXT
  • Description: Customer’s email address.
  • Field API Name: Fax__c
  • Data Type: TEXT
  • Description: Customer’s fax number.
  • Field API Name: FirstName__c
  • Data Type: TEXT
  • Description: Customer’s first name.
  • Field API Name: Gender__c
  • Data Type: TEXT
  • Description: Customer’s gender.
  • Field API Name: Id__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a customer.
  • Field API Name: InternalOrganizationId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: IsRepeatBuyer__c
  • Data Type: BOOLEAN
  • Description: Boolean indicating if the customer is a repeat buyer.
  • Field API Name: JobTitle__c
  • Data Type: TEXT
  • Description: Customer’s job title.
  • Field API Name: KQ_Id__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for Id
  • Field API Name: LastName__c
  • Data Type: TEXT
  • Description: Customer’s last name.
  • Field API Name: LastUpdatedDateTime__c
  • Data Type: DATETIME
  • Description: Date and time when the customer record was last updated.
  • Field API Name: Login__c
  • Data Type: TEXT
  • Description: Customer’s login name or ID.
  • Field API Name: NaturalCustomerId__c
  • Data Type: TEXT
  • Description: Natural key of the customer, representing the id of the customer in the source system.
  • Field API Name: PhoneBusiness__c
  • Data Type: TEXT
  • Description: Customer’s business phone number.
  • Field API Name: PhoneHome__c
  • Data Type: TEXT
  • Description: Customer’s home phone number.
  • Field API Name: PhoneMobile__c
  • Data Type: TEXT
  • Description: Customer’s mobile phone number.
  • Field API Name: PurchaseCount__c
  • Data Type: DOUBLE
  • Description: Total number of purchases made by the customer.
  • Field API Name: Salutation__c
  • Data Type: TEXT
  • Description: Customer’s salutation (for example, “Mr.”, “Ms.”).
  • Field API Name: SecondName__c
  • Data Type: TEXT
  • Description: Customer’s middle name.
  • Field API Name: Suffix__c
  • Data Type: TEXT
  • Description: Customer’s name suffix.
  • Field API Name: Title__c
  • Data Type: TEXT
  • Description: Customer’s title.