Orders by Year / Month
This report presents an overview on the orders to MSF Supply.
Transport Mode | I have asked Agathe |
Country | Mission |
Project Code | |
Order Type | It shows the order type as in the OP |
IsEmergency | It filters for orders that are processed as urgent in MSF Supply |
IsTechOrder | How does it work? Should be based on the mission ref. (ending with TEC…) |
IsKC | Keep Cool, what category exactly? all the “KC..” ? 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 (where you retrieve the info? fiche article ?) |
IsArv | Antiretroviral items (where you retrieve the info? fiche article ?) |
IsTc | Controlled temperature items ( <25 °C ) which of the above categories? |
IsArticleStup | Psychotropic items which of the above categories? |
Année/ Trimestre | Year of order creation at MSF Supply, i.e. not order creation in the field nor budgetary year. Can you rename them year / Q1, Q2, … |
Origin Order Count | Number of Portal order (correct?). If so, we can rename it Portal Order Count ? |
Order Count | Number of OP (Operations at MSF Supply) |
Orderline Count | Number of order lines (OP) |
Average Lines per Order | Order Count / Orderline Count (OP) |
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 |
|
|
|
|
|
|
|
|
|
0 Comments