| Transparency dashboard related | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Context | Requirements | Description | Data type | Right source | Joint/Relations with other field | Comments | Name in transparency dashboard | Source in transparency | Technical name of the field in the sources | Transformation | |
| Incoterm | |||||||||||
| Material code | |||||||||||
| Ship to code | |||||||||||
| Organization | Group of Activity | ||||||||||
| Customer | Country ship to | QVSBS_BW_QRY_CPCOPA03_0001 QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001 | [4CPCOPA03-SHIP_COUNTRY] Country of destination [10COUNTRY] Ship-to party > Country (Name) C_SHTCTRY | ||||||||
| Customer | Country (Sold-To) | china is under spp but for novecare will be under asia | QV_BW_QRY_MVSDSO61_0001 | "[0COUNTRY] Country if empty => [C_SHIPTID] Ship-to party\Attributes\[0COUNTRY] Country key" | |||||||
| Organization | GBU region | Customize field to reflect the pricing organisation of the GBUs Example: For SpP, the GBU region is China but for NC, it is Asia | SF or BW | Made in transparency dashboard | There are correction from BW → based on application requirements there are some rules | There are 4 regions predefined by Solvay and each GBU could have new/customized regions for spp there is a table in Icare to get the regions ) for others rules are hard coded | |||||
| Organization | End use | ||||||||||
| GBU product family | |||||||||||
| Market | Enterprise segment | Master | |||||||||
| Market | GBU segment | Refer to the market like automotive (this important for price optimization not enterprise segment→ novecare) | |||||||||
| Market | Market | ||||||||||
| Group customer segment | It refers to Solvay group level of segmentation for customer. Depends on the service level a customer receives from Solvay, it can be classified as KA, or standard, etc. The same customer segmentation can be applied at GBU level (below) | Master | QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001 | Bus_Rank__Corp_ | |||||||
| GBU customer segment | A customer receiving different service levels could be classified as KA for one GBU and Standard for other. Exceptions: GSKA- they remain GSKA for all GBUs. | Master | BW or SF(To check) | QV_BW_QRY_CPCOPC07_0001 | |||||||
| Product name | |||||||||||
| Product code | |||||||||||
| Product brand name | |||||||||||
| Sale Unite price | |||||||||||
| Volumes | |||||||||||
| Last invoice price | |||||||||||
| Shipping plant | |||||||||||
| Manufacturing plant | |||||||||||
| Forecast sale | |||||||||||
| Forecast unit price | |||||||||||
| Forecast volume | |||||||||||
Overview
Content Tools
Tasks