| Actual shipped (ETD) | This is the quantities (in KG) already shipped to the customer. |
|---|
| Actual Production |
|
|---|
| Actual Receipt from SAP(ETA) | Past orders in SAP (customers, Inter Sites), in delivery date |
|---|
| Assignment percentage |
|
|---|
| Actual and projected inventory | End of month projected inventory validated during the S&OP exercise |
|---|
|
| BackOrders (ETD) | BackOrders is a quantitie confirmed but not shipped in due time. |
|---|
|
|
|---|
|
| Distribution multiple |
|
|---|
| Distribution lead time |
|
|---|
| Demand still to be shipped | Demand still to be shipped calculate which quantity you still have to shipped. |
|---|
| Dependant Requirement | Requirements from the BOM / MRP calcul |
|---|
| Days of stock | This is the number of days remaining in stock. This datafield is equal to: End of month inventory / (Actuals Shipped + Actuals consumption). If the value is above 30 days of stock, Dynasys highlight the value in red. |
|---|
|
| External Purchase order SAP | Data coming from SAP: Purchase order created with reception planned after the current month |
|---|
|
|
|---|
|
| Fixed lot size SAP |
|
|---|
| Forecast from DP (ETD) | The forecast data is coming from DP and will be used for the calculation of Independant requirements with the netting. |
|---|
| Final Demand (ETD) | Final Demand is the maximum between the forecast and the Actual shipped+ OrderBook. (if you do not delete the forecast or the order) |
|---|
| Firm shipping Requirement (ETD) |
|
|---|
| Firm Receipt from SAP (ETA) | Current orders in SAP (customers, Inter Sites), in delivery date |
|---|
| Force proposed receipt requirement |
|
|---|
| Force shipping plan |
|
|---|
|
| Initial inventory |
|
|---|
| In transit stock from SAP |
|
|---|
|
| Main Shipping Site |
|
|---|
| Minimum lot size |
|
|---|
|
| Order Book to be issued (Confirmed - ETD) | OrderBook come from SAP and take into consideration: - The deliveries & sales orders
- Open orders (Orders requested or confirmed or blocked)
- The goods issue date
|
|---|
|
|
|---|
|
| Pending orders (ETD) |
|
|---|
| Procurement Type |
|
|---|
| Pallet size SAP |
|
|---|
| Proposed receipt plan (ETA) |
|
|---|
| Proposed production plan | Calculated production plan by Dynasys |
|---|
| Proposed Receipt Requirement (ETA) | Calculated orders by Dynasys |
|---|
|
| Rounding value SAP |
|
|---|
| Receipt plan ( ETA) | Receipt Plan by All destination, in the receipt month |
|---|
|
| SPK Code |
|
|---|
Supply Planner |
|
|---|
| Safety stock SAP |
|
|---|
| Safety stock as a coverage |
|
|---|
| Safety stock V3 |
|
|---|
| Safety stock final |
|
|---|
| Service level |
|
|---|
| Shipping Requirement (ETD) |
|
|---|
| Shipping plan (ETD) |
|
|---|
| Shortages |
|
|---|
|
| Total RLT SAP |
|
|---|
| Total Orders | Total Orders is the sum of all orders : - Actual Shipped
- Orderbook
- BackOrders
|
|---|
|
| Valuation Class |
|
|---|
| Vendor stock SAP |
|
|---|
|
|
|
BFC Activity 1 | To be defined |
|
|---|
BFC BU (Plant) | BU related to the plant site
| Ex for a site: GBU = TS BU can be Polymer Additive OR Mining OR Phosphorus |
|---|
BFC BU (Site) | BU related to the site attribute |
|
|---|
BFC GBU (Plant) | GBU related to the plant attribute |
|
|---|
BFC GBU (Site) | GBU related to the site attribute |
|
|---|
BFC Market (Plant) | Market attached to the plant attribute |
|
|---|
BFC Market (Site) | Market attached to the site attribute. |
|
|---|
Buyer (Plant) | Buyer's name or ID in charge of the corresponding plant |
|
|---|
Buyer (Site) | Buyer's name or ID in charge of the corresponding site |
|
|---|
|
Calendar (Year/Month) | Horizon to define and select in the report through the " Prompt " view.
Mandatory in order to display data. |
|---|
Catalog LT (SAP) | Catalog Lead Time starting from “Order Entry Date” until “Material Availability date".
This lead time comes from SAP |
|---|
City (Plant) | City information attached to the plant attribute |
|---|
City (Site) | City information attached to the site attribute |
|---|
Classification (Plant) | TBD |
|---|
Classification (Site) | TBD |
|---|
Commercial Product / Material Group | Material group aggregation
Can be Commercial Product / Material Group / Product Group, depending on the GBU. |
|---|
Country (Plant) | Country of the plant attribute |
|---|
Country (Site) | Country related to the site attribute |
|---|
CRM Prospect Code | TBD |
|---|
|
Division | Division of the product = material aggregation
It is used to have another aggregated level of Product type | Example:
For PEROX = New Product Type in Dynasys (PAA/H2O2 etc...) |
|---|
|
GBR GBU Mat Group | Material group associated to the Material
This information comes from the GBR (GBR = Global Business Repository)
==> database to manage master data not existing in SAP, but used in all reporting tools |
|---|
GBR GBU Mat Sub-group | Material sub group associated to the Material
This information comes from the GBR (GBR = Global Business Repository)
==> database to manage master data not existing in SAP, but used in all reporting tools |
|---|
GBR Ship-to-KA (Plant) | Ship-to-KA related to the plant dimension.
Ship-to-KA = Group of Ship-to (ex : Michelin is a ShiptoKA and Michelin France= Shipto, Michelin Poland= Ship-to)
This information comes from the GBR (GBR = Global Business Repository)
==> database to manage master data not existing in SAP, but used in all reporting tools |
|---|
GBR Ship-to-KA (Site) | Ship-to-KA related to the site dimension.
Ship-to-KA = Group of Ship-to (ex : Michelin is a ShiptoKA and Michelin France= Shipto, Michelin Poland= Ship-to)
This information comes from the GBR (GBR = Global Business Repository)
==> database to manage master data not existing in SAP, but used in all reporting tools |
|---|
GBR Ship-to-KA adjusted (Plant) | TBD |
|---|
GBR Ship-to-KA adjusted (Site) | TBD |
|---|
Geo Zone (Plant) | Geographical Zone of the plant attribute
It is not necessarily = Zone S&OP |
|---|
Geo Zone (Site) | Geographical Zone of the site attribute
It is not necessarily = Zone S&OP |
|---|
|
Key RM (Plant) | TBD |
|---|
Key RM (Site) | TBD |
|---|
|
Last Updated on (Plant) | TBD |
|---|
Last Updated on (Site) | TBD |
|---|
|
Main Production Plant (Plant) | Main Production Plant of the specific Plant (attribute). Is different following the site displayed in the "Plant" dimension |
|---|
Main Production Plant (Site) | Main Production Plant of the specific Site (attribute). Is different following the site displayed in the "Site" dimension |
|---|
Main Shipping Plant (Plant) | Main Shipping Plant associated to the specific Plant (attribute). Is different following the site displayed in the "Plant" dimension |
|---|
Main Shipping Plant (Site) | Main Shipping Plant associated to the specific Site (attribute). Is different following the site displayed in the "Site" dimension |
|---|
Material | Material code and name to display in the report. One of the most important attribute of the query. |
|---|
Material group | Material group aggregation used to aggregate Materials and have another level of display |
|---|
Material type | Type of the material (Raw materials / Semi-finished / Finished goods / Trading goods / others...) |
|---|
Measures | Indicators of the report. Most important attribute. This is where you will be able to add / remove indicators of the report. |
|---|
Mini zone (Plant) | Mini Zone of the Plant (Can be a country (Brazil/France...), or a zone (e.g. "Eastern Countries")" |
|---|
Mini zone (Site) | Mini Zone of the Site (Can be a country (Brazil/France...), or a zone (e.g. "Eastern Countries")" |
|---|
MRP controller | TBD |
|---|
|
Plant | As reminder, a SKU can be Receiving or Shipping site. This "Plant" attribute will then display the site attached to the SKU, whether it is RECEIVING or SHIPPING. ==> it will depend on the type of indicator that you selected. Example: if you select External Flows ETD in the Measures attribute, the SKU as indicator is a Shipping SKU, meaning that the Site you will see in the "Plant" attribute will be a shipping site. |
|---|
Price Advisor | TBD |
|---|
Price Advisor impact | TBD |
|---|
Prod.hierarchy | Product hierarchy. Used as an aggregration of the material. |
|---|
Product Category (Plant) | TBD |
|---|
Product Category (Site) | TBD |
|---|
|
Reg Sales Manager | TBD |
|---|
Region (Plant) | Region of a the plant within a country |
|---|
Region (Site) | Region of a the site within a country |
|---|
|
Sales Region | TBD |
|---|
SHS RLT | Represents the total time between placing a production / replenishment order and the availability date. |
|---|
Site | The "Site" attribute is the site that is not attached to the SKU. It can be a Receiving or Shipping site, depending on the indicator you selected. Example: if you select External Flows ETD in the Measures attribute, the SKU as indicator is a Shipping SKU, meaning that the Site you will see in the "Plant" attribute will be a shipping site and therefore the site in the "Site" attribute is the receiving site. |
|---|
SOP Planner (Plant) | S&OP planner in charge of the plant (specific to CH) |
|---|
SOP Planner (Site) | S&OP planner in charge of the site (specific to CH) |
|---|
Source System | Source system where the material comes from (WP1/PF1). |
|---|
Standard cost from S | TBD |
|---|
Stock Hold. Strategy | Stock Holding Strategy. Can be: |
|---|
|
TRLT (SAP) | Total Replenishment Lead Time from SAP It is the total period of time required to produce an item. |
|---|
Type of site (Plant) | Type of site attached to the plant attribute (e.g: prod site / warehouse...) |
|---|
Type of site (Site) | Type of site attached to the site attribute (e.g: prod site / warehouse...) |
|---|
|
Valuation Class (Plant) | Valuation class associated to the plant attribute. A valuation class is a group of materials which have the same account determination. Different materials with similar properties are grouped together by valuation class. Eg Raw material, Finished Goods, Semi-Finished. |
|---|
Valuation Class (Site) | Valuation class associated to the site attribute. A valuation class is a group of materials which have the same account determination. Different materials with similar properties are grouped together by valuation class. Eg Raw material, Finished Goods, Semi-Finished. |
|---|
|
Work Center | Equivalent to "Resource" in Dynasys |
|---|
|
Zone SOP (Plant) | Zone S&OP attached to the site in the "Plant" attribute. Sometimes, the S&OP zone is different from the Geo Zone, depending of flows. |
|---|
Zone SOP (Site) | Zone S&OP attached to the site in the "Plant" attribute. Sometimes, the S&OP zone is different from the Geo Zone, depending of flows. |
|---|
|
|
|
Actual Production | Actual production with no consideration of the ressource |
|---|
Actual shipped and final demand (ETD) | - Past: Actual shipped in ETD (Good issue date) filtered only to ShipTo destination
- Future: Customer Demand taken by the DRP to calculate the requirements (after netting process)
|
|---|
Actual shipped ETD | Actual shipped in ETD (Good issue date) filtered only to ShipTo destination |
|---|
Actuals and projected inventory | Actuals and projected inventory |
|---|
Anticipated inventory | Fraction of the inventory used for covering future requirements. |
|---|
Available capacity | Capacity by ressource per period (opening days x hours per day) |
|---|
Available inventory (Budget) | Projected stock end of month calculated by the tool with the Budget Forecast from DP |
|---|
Available inventory as validated | End of month projected inventory validated during the S&OP exercise |
|---|
|
Backorders in ETD | Orders in a past period in SAP |
|---|
Balance | Difference between demand (or unconstraint production) and Production plan |
|---|
BFR Forecast from DP ( ETA) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year |
|---|
BFR Forecast from DP ( ETD) | BFR Forecast validated in DP for end of current year / the BFR forecast is a revision of the Budget done at the middle of the year until the end of the current year |
|---|
Blocked stock | Blocked stock from SAP (viewable in transaction MMBE) |
|---|
Budget final demand ETD | Final demand after netting calculated by the tool with the Budget Forecast from DP |
|---|
Budget Forecast from DP (ETA) | Budget Forecast validated in DP for Y+1 / the budget forecast is the quantity planned to be sold in year + 1 (at DFU level) |
|---|
Budget Forecast from DP (ETD) | Budget Forecast validated in DP for Y+1 / the budget forecast is the quantity planned to be sold in year + 1 (at DFU level) |
|---|
Budget production Plan | Production Plan validated during the Budget process |
|---|
Budget Shipping Plan ETD | Shipping plan calculated by the tool with the Budget Forecast from DP |
|---|
Budget Shipping requirement ETD | Shipping requirement calculated by the tool with the Budget Forecast from DP |
|---|
Budget Working stock | For Silica: Working stock validated during the last Budget exercice |
|---|
|
Constraint demand (ETA) | Receipt plan by customers in the receipt month |
|---|
Cumulative Balance | Balance cumulated over the entire horizon |
|---|
Cycle stock | Cycle stock calculated for P&I exercise |
|---|
|
Demand Review (ETA) | For Silica: Demand Review validated in DP |
|---|
|
External flow detailed (ETD) | Plan to ship to customers in shipping period with destination detailed |
|---|
External flows (ETD) | Plan to ship to customers in shipping period without the destination detailed |
|---|
|
Final Demand as Validated ETD | Customer Demand taken by the DRP to calculate the requirements (after netting process) |
|---|
Final Forecast from DP (ETA) | Final forecast coming from DP defined in ETA |
|---|
Final Forecast from DP (ETA) M-1 | Forecast from DP validated last month |
|---|
Final Forecast from DP (ETD) M-1 | Forecast from DP validated last month |
|---|
Final forecast from DP ETD | Final forecast coming from DP defined in ETD |
|---|
Final Safety Stock | Safety stock taken in the planning |
|---|
Firm Receipt ETA | Current orders in SAP (customers, Inter Sites) in delivery date |
|---|
Firm Shipments ETD | Current orders in ETD (customer orders, inter site orders) |
|---|
Firm Shipping Requirements ETD | Need to ship based on firm order book |
|---|
Forecast consumption ETD % | =Orderbook / Forecast in percentages |
|---|
|
Gross Requirements (ETD) | Gross Requirement = Internal Flow+ External Flow+ Dependant Requirement (Internal consumption) |
|---|
|
In transit inventory from SAP (ETA) | Stock in transit between two sites diplayed in the received period (coming from SAP) |
|---|
Initial Inventory | Starting inventory for the current period (last dynamic refresh) |
|---|
Internal consumption | Dependant requirements for a component consumed in a parent product |
|---|
Internal flows (ETD) | Plan to ship to other intra GBU site (Inter site) in shipping period |
|---|
|
Load % | Load%= Production Requirements/ Available capacity x100 |
|---|
|
Maximum Daily Capacity (MDC) | Maximum capacity by product / Ressource in quantity per day |
|---|
|
Order book confirmed or requested ETD | Sum of the Order book in ETD coming from SAP confirmed and requested |
|---|
Order book requested ETD | Order book coming from SAP in ETD requested |
|---|
Orderbook ( ETD) | Order book coming from SAP in ETD |
|---|
Overall Equipment Effectiveness (OEE) | The overall equipment effectiveness (OEE) is a measure often used to calculate the return on assets in a business.
|
|---|
|
Past and future demand | Actual total demand and future demand |
|---|
Physical inventory | End of month physical inventory (all types / In transit exculeded) |
|---|
Planned Shutdown | The number of planned shutdown days / Resource |
|---|
Production capacity | Maximum capacity by product / Ressource in quantity |
|---|
Production capacity (H) | Maximum capacity by product / Ressource in hour |
|---|
Production plan as validated | Production plan validated during the S&OP process without taking in consideration the ressources |
|---|
Production plan by ressource as validated | Production plan validated during the S&OP process taking in consideration the ressources |
|---|
Production planned (H) | Production plan validated during the S&OP process per hour |
|---|
Production requirements | What we need to produce, considering the production constraints like batch size, minimum...
Could be considered as the Unconstraint production plan |
|---|
Projected inventory value | End of month projected inventory x CCR ( Unit Standard cost) |
|---|
Projected transit inventory ETA | Stock in transit between two site, current orders and dynasys planned, displayed in the month not yet arrived ("on the road") |
|---|
Purchase plan (ETA) | Receipt plan for products coming from external source (external supplier) |
|---|
|
QM Batch | QM Batch is a stock matched with quality inspection coming from SAP |
|---|
|
Receipt plan ETA | Receipt plan by all destination in the receipt month |
|---|
Restricted Stock (SAP) | Restricted inventory coming from SAP |
|---|
|
Safety stock (SAP) | Safety stock defined in SAP (MRP view) |
|---|
Safety stock V3 | Safety stock calculated in Dynasys, bases on the V3 formula (projected requirements variability, service level, RLT) |
|---|
Scheduled % | Planned production / Available Capacity per Resource |
|---|
Shipping plan | The shipping plan give you an overview of stock quantity need to be ship for each material and each shipping site |
|---|
Shipping plan as validated (ETD) | The shipping plan validated give you the validated quantity of stock need to be ship for each material and each shipping site |
|---|
Shipping requirements as validated (ETD) | Defined the quantity validated need to be ship in ETD based on Order book and Forecast after netting process |
|---|
Shipping requirements ETD | Defined the quantity need to be ship in ETD based on Order book and Forecast after netting process |
|---|
Shortages (ETA) | Shortages are created when the demand is superior of the actual stock and production capacity => Final stock expected <0 |
|---|
|
Unit Purchase cost in € | For Novecare: Forecasted purchased price calculated by raw material buyer |
|---|
|
Working Stock | For Silica: In the past: addition of EoM Unrestricted inventory + EoM vendor inventory + EoM QM batch // In the current month + future = available inventory calculated by the tool |
|---|
Working Stock as Validated | For Silica: Working stock validated during the last validation |
|---|
|
|
|
|
|
|