| Term | Definition | Data lake table | Source system/table/Attribute | Status | |
|---|---|---|---|---|---|
| Customer | |||||
| Customer group | |||||
| 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) | |||||
| GBU region | |||||
| 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) | Governance |