Page Comparison

Transport Mode

The transport Transport mode of the freight, if . If null or no freight, it’s 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 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* , KC1*, KC2, KC2*, KC2SA, KCC Keep Cool 2-8 °C
KC1RT, KC2RT, KC3RT 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
Regulated transport
KC3, KC3*, KC4 Keep Freeze -20°CKCC Keep Cool 2-8 °C

IsDgr

Dangerous goods (regulated transportRegulated transport (dangerous goods):

KC1RT Keep Cool 2-8 °C - Dangerous goods
KC2RT , KC2RT Regulated transport - Keep Cool 2-8 °C - Dangerous goods
KC3RT Regulated transport - Keep Freeze -20°C - Dangerous goods
RTR Dangerous goods - Regulated transport
RTRPR Dangerous goods - Regulated transport - Check if import license necessary - Split order(precursors)
RTRTC Dangerous goods - 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 Import license required - Split order
PSB Check if import license necessary
PSBPR Check if import license necessary - Split order
RTRTC Dangerous goods - Regulated transport - 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
SBB STP Controlled temperature <25 °C
STP - Import license required - Split order
TC, SBB Controlled temperature <25 °C

IsArticleStup

Psychotropic items:

PSA, STP 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 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 Mode

I have asked Agathe

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

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

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. Rename it Freight Countnot 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 ?

doneConsolidated 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

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