Orders by Year / Month
This report presents an overview on the orders to MSF Supply.
...
Field
...
Remarks
...
Transport Mode
...
The transport mode of the freight, if null or no freight, it’s the transport mode of the OP
...
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
...
Order lines handled as Technical orders
...
IsKC
...
Keep cool goods:
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
...
IsDgr
...
Dangerous goods (regulated transport):
KC1RT Keep Cool 2-8 °C - Dangerous goods
KC2RT Keep Cool 2-8 °C - Dangerous goods
KC3RT Keep Freeze -20°C - Dangerous goods
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
...
IsArv
...
Antiretroviral items:
KC2SA Keep Cool 2-8 °C
SARV Controlled temperature <25 °C
SBB Controlled temperature <25 °C
...
IsTc
...
Controlled temperature items ( <25 °C ) :
PSA Import license required - Split order
PSB Check if import license necessary
PSBPR Check if import license necessary - Split order
RTRTC Dangerous goods - Regulated transport - Controlled temperature <25 °C
SBB Controlled temperature <25 °C
STP Import license required - Split order
TC Controlled temperature <25 °C
...
IsArticleStup
...
Psychotropic items:
PSA Import license required - Split order
PSBPR Check if import license necessary - Split order
STP Import license required - Split order
...
Année/ Trimestre
...
Year of order confirmation at MSF Supply (not order creation in the field nor budgetary year)
...
Origin Order Count
...
Number of Portal orders
...
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
...
Champs
...
Comments DDE
...
Transport Mode
...
I have asked Agathe
...
idem orders
...
Dispatch Code
...
Delivery code defined in MSF Supply, usually associated with the capital
...
Country
...
Mission
...
Project Code
...
...
Shipment Type
...
REGULATION ,but in Transport Mode we have REGULARISATION
...
I removed regul from both reports.
...
IsDgr
...
Dangerous goods (where you retrieve the info? fiche article ?)
...
idem orders
...
IsKc
...
Keep Cool, what category exactly? all the “KC..” ?
...
idem orders
...
Année/ Trimestre
...
Year ETA ? Can you rename them year / Q1, Q2, …
...
The report here is based on the Shipment Date
idem orders
...
Transport File Count
...
Number of “dossiers”, i.e. freight numbers. Rename it Freight Count
...
not sure as you have the “shipment count” just aside
...
Shipment Count
...
How is it calculated?
...
It’s for one dispatch code, one trnaport mode, one departure date.
this is the freight for me. To be seen with Agathe ?
...
Packing Volume m3
...
Can we rename it Volume m3 ?
...
done
...
Packing Weight Kg
...
Can we rename it Weight Kg ?
...
done
...
Packing transport Costs
...
Can we rename it Transport Cost ?
...
done
...
Packing Goods Value
...
Can we rename it Goods Value ?
...
done
...
Total transport €/m3
...
Transport cost / volume
...
Total transport €/kg
...
Transport cost / weight
...
Shipment Count per Month
Lead time by Year / Month
...
Champ
...
Comments DDE
...
Transport Mode
...
To ask Agathe for an explanation of the sub-transport modes. Can we remove “néant”?
...
I do not see a “néant” here, I removed it from the other reports.
...
Dispatch Code
...
...
Country
...
...
Project Code
...
...
...
...
...
...
...
...
...