Versions Compared

Key

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

...

The central date used to show the data is the order confirmation date in MSF Supply. This means that an order created in year n and confirmed in year n+1 will be shown in the year n+1 data here.

Overall filter : OCB delivered clients only

Field

Comment

Transport Mode

Transport mode of the freight. If null or no freight, it is the transport mode of the OP

Country

Mission

Project Code

Identification code for the project

Order Type

It shows the order type (MED or LOG) 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, KC1*, KC2, KC2*, KC2SA, KCC Keep Cool 2-8 °C
KC1RT, KC2RT, KC3RT Keep Cool 2-8 °C - Regulated transport
KC3, KC3*, KC4 Keep Freeze -20°C

IsDgr

Regulated transport (dangerous goods):

KC1RT, KC2RT Regulated transport - Keep Cool 2-8 °C
KC3RT Regulated transport - Keep Freeze -20°C
RTR Regulated transport
RTRPR Regulated transport (precursors)
RTRTC Regulated transport - Controlled temperature <25 °C

IsArv

Antiretroviral items:

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

IsTc

Controlled temperature items ( <25 °C ) :

PSA Controlled temperature <25 °C - Psychotropic (locked up)
PSB Controlled temperature <25 °C - Psychotropic
PSBPR Controlled temperature <25 °C - Psychotropic (precursors)
RTRTC Controlled temperature <25 °C - Regulated transport
STP Controlled temperature <25 °C - Import license required
TC, SBB Controlled temperature <25 °C

IsArticleStup

Psychotropic items:

PSA, STP Import license required
PSBPR Check if import license necessary

Year/ Quarter

Year of order confirmation at MSF Supply (not order creation in the field nor budgetary year)

Origin Order Count

Number of Portal orders (unique references)

Order Count

Number of OP (Operations at MSF Supply)

Orderline Count

Number of order lines (OP)

Average Lines per Order

Orderline Count / Order Count (OP)

LOG Orderline Count

Number of LOG order lines (OP)

MED Orderline Count

Number of MED order lines (OP) 

Ordered Amount

Goods invoiced amount

LOG Ordered Amount

LOG goods invoiced amount 

MED Ordered Amount

MED goods invoiced amount 

% LOG Amount

% LOG goods invoiced amount 

% MED Amount

% MED goods invoiced amount 

% LOG Orderlines

% LOG order lines (OP)

% MED Orderlines

% MED order lines (OP)