Jose-Ignacio Patino


Miriam Luttrin - Stéphane Bourgeaud-lignot



General Description

The Orderbook follow-up dashboard provides a full and in-depth view on the orderbook
Scope:
  • All GBUs including Specialty Polymers and Composite Materials
  • Sales Orders only (External customers). No PO.
  • Exclusion of Peroxide JV.
Currencies and Exchange Rate:
  • EUR (CAR4 ) for Pending Orders 
  • EUR (CAR3) for Invoiced (P&L)
  • EUR (already converted by the GBU) for Composite Materials
  • Snapshots are stored directly in EUR, with the rate at the time we take the snapshot. If the rate is revised (monthly revision for instance), it will have no impact on the snapshot.

Sources for the dashboard include:

  • BW Global Sales queries (MVSDSO)
  • BW P&L query (MVCOPA)
  • Manual flat file for Composite Materials (non-SAP scope)
Data Refresh Frequency:
  • Daily for all GBUs in BW including the CM scope in SAP
  • Weekly (on mondays) for CM Scope not yet in SAP
Useful links on General Information and Sources:
  • To be Completed



  • ExCom members
  • Excellence Center
  • GBU Leadership Team
  • GBU CSR managers (TBC)


To be completed


Definitions



Definitions

(Definitions related to Orderbook, see EC Order management Playbook)

Invoiced Y-1 = Invoiced from P&L Query (or flat file)

Invoiced = Invoiced from P&L Query (or flat file)

Pending = Confirmed + Shipped not Billed from Global Sale Query (or flat file)

Not Confirmend = No confirmed from Global Sales Query (or flat file)



Data Sources / Mappings

QVSD_BW_QRY_MVSDSO41_SD004 (Snapshot to be invoiced).