Versions Compared

Key

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

Orders by Year / Month

This report presents an overview on the orders to MSF Supply.

Field

Remarks

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

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

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) 

 

Transport by Year / Month

Champs

Transport Mode

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

Dispatch Code

Delivery code defined in MSF Supply, usually associated with the capital

Country

Mission

Project Code

Identification code for project

Shipment Type

Via MSF Supply: shipped from MSF Supply’s warehouse

Direct:: shipped from another location

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

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

Année/ Trimestre

Date of the shipment, i.e. when the goods were shipped to the field

Transport File Count

Number of “dossiers”, i.e. count of freight numbers

Shipment Count

Consolidated freights according to the pick up date, transport mode and destination, i.e. freights that have the same 3 criteria equal 1 shipment

Volume m3

Volume of the packing

Weight Kg

Weight of the packing

Transport Costs

Invoiced transport cost

Goods Value

Goods invoiced amount

Total transport €/m3

Transport cost / volume

Total transport €/kg

Transport cost / weight

Shipment Count per Month

Monthly display of shipments

 

Lead time by Year / Month

Champ

Comments DDE

Transport ModeTransport Mode

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

Dispatch Code 

Delivery code defined in MSF Supply, usually associated with the capital

Country

 

Project Code

 

 

 

 

 

 

 

 

 Mission

Project Code

Identification code for project

Orderline Count

Number of order lines (OP)

Order Type 

It shows the order type (MED or LOG) as in the OP

IsEmergency 

The order was handled as an emergency in MSF Supply, i.e. prioritized and managed with an emergency number

Is TechOrder 

Order lines handled as Technical orders

IsArticleKC

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

With GreenLight / Without GreenLight

Order lines for a country with or without pre-clearence requirement

S02 Validation LT

This is the lead time (LT) between the order creation in the Portal and the final validation from mission and/or cell for transmission to MSF Supply

S03 Confirmation LT

Lead time from the above to confirmation of the OP in MSF Supply, when the order becomes final

S04 Preparation LT

Lead time from the above to

S05 Documentation LT

S06 Pre-clearance LT

S07 Consolidation LT

S08 Transportation LT

S09 Reception LT