| Term | Description | Data lake Table/Attributes | Data source system/ table | Deployment Status |
| Customer | Customer | V_DIM_customer | SAP BW/ MC_CUSTID SAP BW/TC_CUSTID SF CORE/ACCOUNT | Deployed |
| Customer group | Identifies a particular group of customers (for example, wholesale or retail) for the purpose of pricing or generating statistics. | |||
| Ship to | Refers to the customer that the material sold are shipped to. It is not necessarily the customer that buy the material. | |||
| Sold to | Refers to the customer that the material/product are sold to. This is the customer who is going to be invoiced. | |||
| Ship to KA | This concept addresses the final customer receiving the material sold. It is important to note that it is different from the ship to concept mentioned above. | |||
| Final consignee | Ship to KA mentioned above and Final consignee have the same meaning. The final consignee is used only for specialty polymer GBU. | |||
| Sales rep | ||||
| Country | Refers to the country where the customer address is (the customer can be ship to or sold to) | |||
| Region (Zone) | Region of the account | |||
| GBU region | It is a customize dimension made in the transparency dashboard based on the data object "Region (Zone)" to reflect the pricing organization of the GBUs. There are 4 known Solvay regions but it can happen that for one activity, GBU decides to change the region for a country. | |||
| Account manager | ||||
| Team cluster | ||||
| GBU customer segment | Customer segmentation is being defined at GBU level, allocating accounts to one of the 5 following segments: Strategic Key Accounts (SKAs), Key Accounts (KAs), Critical Accounts (CAs), Standard Accounts (SAs), Key and Standard Distributors (KDs and Ds) | |||
| Group customer segment | At Group level, GBU segmentations are consolidating into one Group segmentation, mainly for performance monitoring purpose, according to 2 elements: i) Per ExCom decision, a selection of accounts have been elevated to Group Strategic Key Accounts (GSKAs) status at Group level given their importance and stake for Solvay overall (see GSKA workstream playbook). All GSKAs are segmented as SKA at the GBU-level. ii) All other accounts are consolidated into the Group segmentation being either a Distributor (KD or SD) or considering their highest segments (SKA > KA > CA > SA) in case of cross-GBU accounts with different segment allocation per GBU | |||
| Material | ||||
| Material group/Product | ||||
| Product H4 | ||||
| HPAM | ||||
| Product hierarchy PIF | ||||
| Product hierarchy | ||||
| GBU product family | One product/material belongs to a product family per GBU. It is unique per combination of GBU and product/material | |||
| GBU material group | ||||
| HPAM | ||||
| Business line (Business Unit) | ||||
| Product manager | ||||
| Product line (0 to X) | ||||
| Product line E2E | ||||
| Packaging type | ||||
| Product brand | ||||
| Unit conversion rate | ||||
| Market | ||||
| End use | ||||
| Application | ||||
| Segment | ||||
| Enterprise segment | ||||
| Market cluster | ||||
| BDM | ||||
| Investor market group | ||||
| GBU segment | Segment related to the account (CS1 -SKA, CS2 - KA, CS3- CA, CS8 - KD, CS4 - SA, CS5 - SD, CS6 Not Valid, CS7 - Not yet Assigned) |
Overview
Content Tools
Tasks