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 |
|
|
|
|
|
|
|
|
|