Orders by Year / Month
This report presents an overview on the orders to MSF Supply.
...
Champs
...
Comments DDE
...
Transport Mode
...
I have asked Agathe
...
It’s 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
...
How does it work? Should be based on the mission ref. (ending with TEC…)
...
it’s done this way
...
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
...
All the KCs : KC1/KC2/KC3/KCM/KC1PB/KC1RT/KC2*/KC2RT/KC2SA/KC2PB/KC3*/KC3SA/KC1*/KC4
...
IsDgr
...
Dangerous goods (where you retrieve the info? fiche article ?)
...
Articles with categorie : RTR/KC2RT/RTRPR/KC1RT/KC3RT/RTRTC as dangerous for us is more “transport regulated”
...
IsArv
...
Antiretroviral items (where you retrieve the info? fiche article ?)
...
Articles with categorie : KC3SA/SARV/SBB
...
IsTc
...
Controlled temperature items ( <25 °C ) which of the above categories?
...
Articles with categorie : TC/RTRTC/SBB/PSA/PSB/PSBPR/STP
...
IsArticleStup
...
Psychotropic items which of the above categories?
...
Articles with categorie: STP/PSA/PSBPR
...
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, …
...
It’s based on the order confirmation date.
When you are connected in english, should be translated automatically.
...
Origin Order Count
...
Number of Portal order (correct?). If so, we can rename it Portal Order Count ?
...
Done
...
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
...
yes it’s goods here.
...
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
...
...
...
...
...
...
...
...
...