281872

DHL MTS

2Create a CN Trip and Order Detail Export for Consolidation Centres

FUNCTIONAL SPECIFICATION - 10.6

- 1.0

Reference: FS 281872 JC-89ZH76

1. Functional Overview 1.1 Client Requirement

Change Request Summary:

CN Trip and Order Detail Export for Consolidation Centres.

Change Request Details:

Consolidation Centres, receiving their orders through Cross Dock will not be able to utilise the CN Trip and Order Detail Export as it is based on Group Name of the order. All orders delivered through the Consol Centres via Cross Dock retain the Group Name of the originating depot.

Benefits identified as a result of the change:

CN Trip and Order Detail Export is an essential component of the current CTMS system and is therefore required by the Consol Centres.

1.2 Solution

The ‘CN Trip and Order Detail’ export will be changed to enable the consolidation centres to select orders that they delivered as part of the cross-dock process.

If a specific value is set for the ‘Group Name’ parameter then the orders on the trips that satisfy the other parameters will also determine if the orders have been cross-docked through the consolidation centre.

A new system parameter will be introduced to control whether the export will allow the ‘Group Name’ to be applicable from cross-dock locations as well as the original location. If the new system parameter is active then any orders that have been loaded or unloaded (as specified in the ‘Activity’ parameter) at the cross-dock location (i.e. for the ‘Group Name ‘parameter) will be included also; this will then be regardless of the group name of the cross-docked orders.

If all group names are required (i.e. the ‘Group Name’ parameter is set to ‘ALL’) then all orders will be selected regardless of the group name of the order.

1.3 Scope This change will be applied to system version 10.6. 2. Set-up 2.1 Pre-requisites None 2.2 Menu Structure ‘Unchanged’ 2.3 Data

Create a new record in the REP_REPORT_PARAM table for the CN Trip and Order Extract. The new parameter will be called ‘LOADED_AT’. The parameter will not be mandatory.

3. Functional Description The CN Trip and Order Detail export have several parameters which are mandatory, including GROUP NAME. Users at consolidation centres are assigned GROUP NAMES such as SWC, NWC. There are never any orders which are assigned this GROUP NAME so when these users run the CN Trip and Order Detail export, no data is returned.

The orders which users at the console centres want to see, are those that have been cross docked at the console centres, where the GROUP NAME of the order is irrelevant. To accommodate users in console centres, an additional parameter will be added to the extract called LOADED AT.

This parameter will be in addition to the GROUP NAME and will be a list of the values the user is BASED_AT. This parameter will not be made mandatory and can be set to null. The value ‘ALL’ will also be available where the user has access to more than one BASED_AT location.

Selecting a specific LOADED AT value will search for any orders which have been loaded at the location, regardless of the GROUP NAME assigned to the order.

Some Examples below:

USER WOODS SCHED GROUP NWC BASED AT NWCONSOL EXELBAWT

User enters

SCHED_GROUP :NWC LOADED_AT :NWCONSOL

Data returned

Any orders where GROUP NAME = NWC and additionally any orders which have been loaded at NWCONSOL.

User enters

SCHED_GROUP :NWC LOADED_AT :ALL

Data returned

Any orders where GROUP NAME = NWC and additionally any orders which have been loaded at NWCONSOL or EXELBAWT

User enters

SCHED_GROUP :NWC LOADED_AT

Data returned

Any orders where GROUP NAME = NWC

EXAMPLE 2

USER COATESJ SCHED GROUP NWC SWC EXELBAWT BASED AT NWCONSOL SWCONSOL EXELBAWT

User enters

SCHED_GROUP :EXELBAWT LOADED_AT :NWCONSOL

Data returned

Any orders where GROUP NAME = EXELBAWT and additionally any orders which have been loaded at NWCONSOL.

User enters

SCHED_GROUP :EXELBAWT LOADED_AT :ALL

Data returned

Any orders where GROUP NAME EXELBAWT and additionally any orders which have been loaded at NWCONSOL, SWCONSOL or EXELBAWT

User enters

SCHED_GROUP :EXELBAWT LOADED_AT

Data returned

Any orders where GROUP NAME = EXELBAWT

Appendix A table updates REQUIRED Appendix B QUOTE & DoCuMENT History

Activity Estimate Quote

No. of Days No. of Days Daily Rate (£) Cost (£) Exc. VAT

Work to Date 0.00 0.00 500

Change Request Evaluation 0.50 0.50 500

Functional Specification 0.50 0.50 500

Technical Specification 0.00 0.00 500

Development 1.50 1.50 417

Testing & Release 0.50 0.50 417

Implementation 0.00 0.00 462

TOTAL

References Ref No Document Title & ID Version Date

EST-281872 JC-89ZH76 Create a CN Trip and Order Detail Export for Consolidation Centres v1.0 1.0

Glossary Term or Acronym Meaning

Document History Version Date Status Reason Initials 0.1 01/12/10 Draft Initial version SEW 1.0 02/12/10 Issued Reviewed Issued MJC

Authorised By

Matt Crisford

Development Manager

Peter Greer

TMSCC CTMS Product Manager