291173
DHL C-TMS
Automatically Rebook Orders
FUNCTIONAL SPECIFICATION - 10.7
26/08/2011 - 1.0
Reference: FS 291173 AR-8KNL8H
Functional Overview
Client Requirement
Change Request Summary:
Automatically rebook orders (re-generate) in C-TMS depending on the reason code used to debrief. Set collection date to next working day.Paul McGoran/Manchester/UK/NFC
Change Request Details:
In addition regenerated orders should be created with mode "High Priority"
Benefits identified as a result of the change:
Orders regenerated as per the existing implementation
Solution
A new field will be added to the C-TMS Reason Codes table (SCH_REASON_CODE) called ACTION.
The following values will be allowed in the new field:
| N | Do nothing |
| R | Regenerate in full |
| O | Regenerate outstanding |
The use of the action code will be controlled by a new cost centre parameter called AUTO_REBOOK. When an order is allocated a reason code via non conformance, the reason code will be used to determine what further action is required.
If the reason code has been assigned the action N, no further action will be taken in C-TMS. If the reason code has an action code O, a re-book order will be created based on the outstanding quantities from the original order.. If the action code is R, further analysis of the reason code will be required. The reason codes that will be assigned the action R are listed below
| Code | Description | Functionality required
|
| 5 | 2 man job not notified | Re generate the whole order changing the DEL POINT REF to display 2M. |
| 4 | 3.5T transit not notified | Amend the from location to record the requirement for a 3.5T truck and re generate the order |
| 25 | 3.5T and two man | Amend the from location to record the requirement for a 3.5T truck and re generate the whole order, setting the DEL POINT REF to 2M. |
All orders generated based on the value of the AUTO_REBOOK parameter will be assigned the delivery type ’HIGH PRIORITY’. The collection and delivery windows will be set to the date of the next working day (TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
Scope
This change will be applied to system version 10.7..
Set-up
Pre-requisites
None
Menu Structure
Unchanged
Data
A new field will be added to the SCH_REASON_CODE table
ALTER TABLE SCH_REASON_CODE
ADD ACTION VARCHAR2(1);
Implementation Advice
In order to switch this new functionality on it will be necessary for a site superuser to set the AUTO_REBOOK parameter to Y for BGWCC in the below screen
| PARAM_NAME | AUTO_REBOOK |
| VALUE | Y |
| DESCRIPTION | Indicates if auto rebook is switched on when non conformance is added. |
| CONFIG_BY | COST_CENTRE |
| CONFIG_BY_VALUE | BGWCC |
The site super user will also be required to set the cost centre version of the existing system parameter CAL_WORKING_DAY_MAP for BGWCC.
| PARAM_NAME | CAL_WORKING_DAY_MAP |
| VALUE | ‘NNYYYYY’ |
| DESCRIPTION | Defines which days of the week are being worked - Sunday to Saturday, Y or N. |
| CONFIG_BY | COST_CENTRE |
| CONFIG_BY_VALUE | BGWCC |
Functional Description
A new field will be added to the Reason Codes master data table (SCH_REASON_CODE). The new field will be called ‘ACTION’. Valid values for the new field will be ‘O’,’R’,’N’ or null (see below for descriptions of each value). The new field will be added to the Business Data Management screen (below) and users will be able to assign one of the valid values to each reason code. Existing reason codes will not be amended by this change and the default values for these will be ‘N’ if not set.
The value assigned to the ACTION field will determine the action taken when the reason code is assigned to an order. This functionality will be controlled by a new system parameter AUTO_REBOOK, which will be set to Y, N or null.
When the new action code field is set to ‘O’, the order will be re-booked automatically for any outstanding quantity after the order has been debriefed. If the order has not been debriefed, the full quantity will be assigned to the rebooked Order.
If the action code is set to ‘R’, the order will be rebooked in full. For action ‘R’, there will be further analysis of the reason codes required.
Generally, an action ‘R’ will mean that the original order has been created incorrectly and the rebook is being generated to correct the issue. The following reason codes have been flagged as requiring action ‘R’.
| 5 | 2man job notified | Re generate the whole order changing the DEL POINT REF to display 2M. |
| 4 | 3.5t transit not notified | Amend the from location to record the requirement for a 3.5T truck and re generate the order |
| 25 | 3.5t and 2 man | Amend the from location to record the requirement for a 3.5T truck and re generate the whole order, setting the DEL POINT REF to 2M. |
If the action code is set to ‘N’ or blank, no further action will be taken after the reason code has been added through non-conformance.
After the re generation of orders the delivery type will be updated to ‘High’ and the collection window will be set to the next working day. For British Gas waste, the following days are classed as working days:
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
The new cost centre parameter CAL_WORKING_DAY_MAP will be used to ensure that orders are created for the next valid working day. The collection and delivery windows will be updated to the next working day and this will drive the schedule date.
In the instance where a Saturday order has been re-generated, the order will be created for collection on Tuesday, the next working day.
Table Updates Required
ALTER TABLE SCH_REASON_CODE
ADD COLUMN ACTION VARCHAR2(1);
INSERT INTO ADM_SYSTEM_PARAM (PARAM_NAME,
VALUE,
DISPLAYED,
USER_MODIFIABLE,
DESCRIPTION,
CONFIG_BY,
CONFIG_BY_VALUE)
VALUES (‘AUTO_REBOOK’,
N,
Y,
‘Indicates if auto rebook is switched on when non conformance is added’,
‘COST_CENTRE’,
NULL)
References
| EST-291173 AR-8KNL8H Automatically rebook Orders v0.1 | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Reviewed | ||||
| Revised | ||||
| Reviewed and Issued | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
