Consumer Profile Location table

Release version: Australia

Updated March 12, 2026

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.

If you are a user with one of the sn_crm_foundation_admin, sn_crm_foundation_data_manager, sn_crm_consumer_relationship_data_manager, or sn_crm_consumer_data_manager roles, you can create, update, view, and delete the relationship between the consumer profiles and locations in the Consumer Profile Location table. If you are a user with one of the sn_crm_consumer_viewer, sn_crm_household_viewer, or sn_crm_foundation_data_viewer roles, you can view the records in the Consumer Profile Location table.

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.