Customer

See also the page on Customer data governance within the Data Governance directory

Data Object Definition

Customer represents all information related to a business partner of Solvay - a company or an organization - with whom a business relationship exists, involving the exchange of goods and/or services. It contains all the information such as the contact's name, email address, billing information, address, Corporate group and others attributes.

This data is available in the Data Ocean as of Q2 2023.

Data Model 

Customer data in the Data Lake is composed of 3 different table views:

1. V_DIM_customer
2. V_DIM_customer_corporate_group
3. V_DIM_customer_segmentation

Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.

Additional Info & Comments

• In Salesforce.com, Customers are referred to as Accounts, while SAP mostly uses the word Customer. The two terms can be used as synonyms, but in the Data Ocean we generally prefer the term Customer.
• There are different types of customers. One key distinction is sold-to vs. ship-to customers. The sold-to customer is the entity that is negotiating the price and placing the order (e.g. a corporate headquarters), while the ship-to partner is the one that is physically receiving the goods (e.g. a warehouse or production site). It is possible for customers to be sold-to and ship-to customer at the same time, or for customers to be the sold-to on one order but the ship-to on another.

Data Flow

Tables & Attributes

View ID: prj-data-pricing-dev.DataOcean.V_DIM_customer

View ID: prj-data-pricing-dev.DataOcean.V_DIM_customer_corporate_group

View ID: prj-data-pricing-dev.DataOcean.V_DIM_customer_segmentation