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

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.

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.

Scope

This change will be applied to system version 10.6.

Set-up

Pre-requisites

None

Menu Structure

‘Unchanged’

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.

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

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

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 MTS Product Manager