Roles
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
The content of this macro can only be viewed by users who have logged in.
Data Sources, Type and Classification
SAP & CRM
Master Data
Internal Data
Data Protection and Update Frequency
No special access except for updates - only Data Stewards are permitted
On demand with required permission
Data Quality Issues and Rules
- Timeleness - Customer without any order since 3 years (current year + 3 years history) and not flagged "inactive", to be discussed: could we identify customers which disappeared (e.e. bankrupt)
- Uniqueness - Customer with the same name, same address and same VAT are duplicates
- Completeness - Corporate Group not assigned to customer: Source SalesForce CRM: check if corporate group is empty - report in CRM - also to be checked in ERP
- Completeness - Not assigned Ship-to KA
- Conformity - Account Sub-type maintained: End-User or Distributor but not empty
- Conformity - Customer Segmentation maintained: Key Account, Critical account or Standard Account but not empty
- Conformity - Customer creation in line with naming convention: Customer name created with Upper cases
Related Business Terms
| Data Attribute | Description | Link |
|---|---|---|
| Customer | A customer is a business partner with whom a business relationship exists. | In Progress |
| Customer Group: CRM Customer Corp. Group (PRS) | A Corporate Group is a parent account specifically created for grouping under one umbrella various accounts according to a commercial decision (In CRM tool). | |
| Customer Sales Area | A sales area is a combination of sales organization, distribution channel and division which need to be created for each customer (used in the orders and sales). | In Progress |
| Distribution Channel | The distribution channel represents the channel through which salable materials or services reach customers. (Can be called Market for financial) - only relevant to WP1 | In Progress |
| Distributor flag Y/N (Ship-to) | If the customer (Ship-to) is a Distributor. | |
| Distributor flag Y/N (Sold-to) | If the customer (Sold-to) is a Distributor. | |
| GBR: Application (Ship-to) | Application is a grouping of End-Use. | In Progress |
| GBR: Corporate End-use | It is a subcategory of Application and describes mainly objects manufactured by our direct customers (e.g. Camera: modules) or the main functionality of the product (e.g. moisturizing agent for shampoo). End-uses are defined at the level of the GBU. Maintained in GBR. | In Progress |
| GBR: GBU segment | Segment is a grouping of Application. | In Progress |
| GBR: Market (Sold-To) | Market is a grouping of Segments. | In Progress |
| Payment Term | Payment terms are specifications of amounts owed, how, when, and where payments are due on sales transactions between our customers and Solvay. | |
| PRS Customer | After creation, all customers (ship-to, bill-to, sold-to, payer) are registered in PRS (PF1 client 050). | In Progress |
| Sales Employee (Sold-to) | Sales representative following the sold to customer. | In Progress |
| Ship-to KA (GBR) | The Ship-to Key account is by default the Corporate Ship-to Group. However it can be changed for a specific product when the end-user account is different (ex Distributor or Warehouse). | More info |
| Ship-to Party | Ship-to party is the customer to which the physical goods are shipped or delivered. The location where the goods are to be delivered. | |
| Sold-to Party | Sold to party is the customer who places the order. |