291373

DHL C-TMS

Outputs Reports & Extracts

FUNCTIONAL SPECIFICATION - 10.7

08/12/11 - 1.0
Reference: 291373 MS-8KNHMH

FUNCTIONAL OVERVIEW

Client Requirement

Requirements and development of reporting pack.

Solution

A suite of CSV format data extracts will be developed to provide a management reporting pack for the Network Rail C-TMS solution.

The scope of outputs are;

The numbering convention above is provided to allow cross reference to the current reporting pack and will not be carried forward into C-TMS.

Each of the output in the scope list will be provided in CSV format generated from C-TMS exports menu. The summary description of each output is detailed below. DHL have provided a phase value which defines the priority of development as shown.

For all reports if new accounts (customers) are created these will be selectable where account (customer) or account type (customer group) is a selectable or account is displayed as a field in the output.

Revenue Check Account

This output will be provided as a data export in CSV format. The output is a revenue statement for orders debriefed on a specific date; this means the date and time the order status reaches ‘DELIVERED’ and the trip is at a status of COMPLETED or CONFIRMED.

The output will be provided with selection criteria debrief date from and to range and customer account(Heavy/Non Heavy). The output rows will be sorted by delivery date and time of each order.

Columns for each order will be;

Date Raised, Date Debriefed, Cancelled (true or false) and Status (Trip Status), Journey Number (schedule and trip number), Failure Reason, Order Number (cust ref), EFX number, Account (customer), Commodity Name, Week, Vehicle Type, Haulier, Mode (delivery type), Collection Site (name), Collection Postcode, Collection Planned Date, Delivery Site (name), Delivery Postcode, Delivery Planned Date, Journey Planned Distance Miles (trip), Order Planned Distance Miles, Order Pallets (LPNs), Order Weight, Calculated Revenue, Override Revenue, Total Revenue, Calculated Cost, Override Cost, Total Cost, Margin, Notes, Cost Code, Distance Revenue, Revenue Service & Revenue Surcharge Amount (repeated) Cost Service & Cost Surcharge Amount (repeated).

The service surcharges will be displayed horizontally – It is suggested that the most significant service codes are fixed as column headings and then others that are less often used grouped into an ‘other’ column.

Month End Accruals The Month End Accruals Report will contain same fields as “Revenue Check Account” and the same selection criteria but to display all orders collected within the selected date range. Note that Revenue Check Account shows all orders debriefed in a date range.

POD Scanning Performance (Will be Renamed Debrief Performance)

The POD scanning extract is a CSV output that shows for a schedule of trips (execution / delivery date of trip), the status of the trip. Trip status will reported as C-TMS trips status so, PLANNED, ACCEPTED (Briefed), EN-ROUTE(heavy orders will not move to s status of EN-ROUTE), CONFIRMED (means carrier has confirmed delivery), COMPLETED (means fully debriefed). A days column is displayed to measure days between job (planned delivery date) and debriefed date. Assume job means the planned delivery date. This output allows a measure of how quickly the carriers are returning paperwork and deliveries are fully debriefed. Selection criteria will be trip schedule or trip schedule range and optionally account type and carrier.

Additional requirements will be to change name of report to Debrief Performance and to add carrier code and carrier name as additional columns.

Each row of the output is a an order on a trip and the rows are sequenced by trip number; the columns displayed will be;

Delivery Date, Delivery Time (planned earliest delivery date time), Debriefed Date (when trip status becomes COMPLETED), Days Difference, Journey Number(schedule and trip number), carrier and carrier name, Order Number (cust ref) ,Trip Status and commodity.