Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
KC1*     Keep Cool 2-8 °C
KC1RT    KC1RT Keep Cool 2-8 °C - Dangerous goods
KC2    KC2 Keep Cool 2-8 °C
KC2*     Keep Cool 2-8 °C °C
KC2RT    KC2RT Keep Cool 2-8 °C - Dangerous goods
KC2SA    KC2SA Keep Cool 2-8 °C
KC3    KC3 Keep Freeze -20°C
KC3*     Keep Freeze -20°C
KC3RT    KC3RT Keep Freeze -20°C - Dangerous goods
KC4    KC4 Keep Freeze -20°C
KCC    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    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    RTRPR Dangerous goods - Regulated transport - Check if import license necessary - Split order
RTRTC    RTRTC Dangerous goods - Regulated transport - Controlled temperature <25 °CSARV   

IsArv

Antiretroviral items:

KC2SA Keep Cool 2-8 °C
SARV Controlled temperature <25 °C
SBB    SBB Controlled temperature <25 °CSTP   

IsTc

Controlled temperature items ( <25 °C ) :

PSA Import license required - Split order
TC     PSB Check if import license necessary
PSBPR Check if import license necessary - Split order
RTRTC Dangerous goods - Regulated transport - 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

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

...