Consumer Profile Location table

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • The Consumer Profile Location [sn_csm_consumer_profile_location] table stores the relationship between the consumer profiles and locations.

    Starting with the Vancouver release, the Consumer Profile Location [sn_csm_consumer_profile_location] table was introduced. By using this table, you can enhance your consumer profiles to support multiple addresses. Adding this functionality enables the relationship between the consumer profiles and locations, which enables various industries to manage multiple addresses for the individual profiles.

    Table 1. Consumer Profile Location table fields

    Field

    Data type

    Description

    Consumer profile

    Reference

    Profile that is associated with a consumer.

    Location

    Reference

    Locations detail that is associated with the consumer.

    Location type

    List

    Type of location that this record represents such as billing, shipping, and mailing.

    Note:
    You can associate a consumer profile location record with one or multiple location types.

    Active

    True/False
    Status of the consumer profile-address mapping.
    Note:
    By default, the active field is set to True, but you can disable the Consumer Profile Location linkage by setting it to False.