...
This report presents an overview on the orders to MSF Supply.
ChampsField | Comments DDERemarks | ||||||||
---|---|---|---|---|---|---|---|---|---|
Transport Mode | I have asked Agathe | It’s the 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 Order lines handled as Technical orders | |||||
IsKC | Keep cool goods: KC1 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 IsDgr | Dangerous goods (regulated transport): KC1RT Keep Cool 2-8 °C - Dangerous goods | ||||||||
IsArv | Antiretroviral items: KC2SA Keep Cool 2-8 °C | ||||||||
IsTc | Controlled temperature items ( <25 °C ) : PSA Import license required - Split order | 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 | |||||||
SBB Controlled temperature <25 °C | |||||||||
IsArticleStup | Psychotropic items: PSA Import license required - Split order | ||||||||
Année/ Trimestre | Year of order creation confirmation 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 ?Doneorders | ||||||||
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
...