Orders by Year / Month
This report presents an overview on the orders to MSF Supply.
IsEmergency | It filters for orders that are processed as urgent in MSF Supply, i.e. emergency number has been assigned after request by the cell |
Order Type | It shows the order type as in the OP |
IsTechOrder | How does it work? Should be based on the mission ref. (ending with TEC…) |
IsLcl | It filters for items flagged as “List Committed Lead Time” in the “fiche article” |
IsKC | Keep Cool, what category exactly? KC1 Keep Cool 2-8 °C KC1* Keep Cool 2-8 °C KC1RT Keep Cool 2-8 °C - Dangerous goods KC2 Keep Cool 2-8 °C KC2* Keep Cool 2-8 °C KC2RT Keep Cool 2-8 °C - Dangerous goods KC2SA Keep Cool 2-8 °C KC3 Keep Freeze -20°C KC3* Keep Freeze -20°C KC3RT Keep Freeze -20°C - Dangerous goods KC4 Keep Freeze -20°C KCC Keep Cool 2-8 °C KPR Check if import license necessary - Split order PSA Import license required - Split order PSB Check if import license necessary PSBPR Check if import license necessary - Split order RTR Dangerous goods - Regulated transport RTRPR Dangerous goods - Regulated transport - Check if import license necessary - Split order RTRTC Dangerous goods - Regulated transport - Controlled temperature <25 °C SARV Controlled temperature <25 °C SBB Controlled temperature <25 °C STP Import license required - Split order TC Controlled temperature <25 °C |
IsDgr | Dangerous goods (fiche article ?) |
IsArv | Antiretroviral items (fiche article?) |
IsTc | Controlled temperature items ( <25 °C ) |
IsStup | Psychotropic items |
Order Status |
|
Country |
|
Project Code |
|
Année | Year of order creation at MSF Supply, i.e. not order creation in the field nor budgetary year |
Order Count | Number of OP (Operations at MSF Supply) |
Orderline Count | Number of order lines, |
Average Lines per Order | Order Count / Orderline Count |
LOG Orderline Count |
|
MED Orderline Count |
|
Ordered Amount | Goods invoiced amount |
LOG Ordered Amount |
|
MED Ordered Amount |
|
% LOG Amount |
|
% MED Amount |
|
% LOG Orderlines |
|
% MED Orderlines |
|
|
|
|
|
|
|
|
|
Transport by Year / Month
Transport Mode | To ask Agathe for an explanation of the sub-transport modes. Can we remove “néant”? |
Dispatch Code |
|
Country |
|
CodeProjetCommande |
|
Shipment Type | Why there is REGULATION , and in Transport Mode we have REGULARISATION ? if they are the same it is better to have one |
IsDgrDangereux |
|
IsKcFroid |
|
Année | Year of the ETA (Estimated Time of Arrival) |
Transport File Count | Number of “dossiers”, i.e. freight numbers. Rename it Freight Count |
Shipment Count |
|
Packing Volume m3 | Rename it Volume m3 |
Packing Weight Kg | Rename it Weight Kg |
Packing transport Costs | Rename it Transport Cost |
Packing Goods Value | Rename it Goods Value |
Total transport €/m3 | Transport cost / volume |
Total transport €/kg | Transport cost / weight |
Lead time by Year / Month
Transport Mode | To ask Agathe for an explanation of the sub-transport modes. Can we remove “néant”? |
Dispatch Code |
|
Country |
|
Project Code |
|
|
|
|
|
|
|
|
|
Add Comment