291170
DHL C-TMS
Consultation on message format
FUNCTIONAL SPECIFICATION - 10.7
09/09/2011 - 1.0
Reference: FS 291170 AR-8KNKCV
Functional Overview
Client Requirement
Change Request Summary:
Consultation on message format, mapping through DHL Link and implementation support.Paul McGoran/Manchester/UK/NFC
Change Request Details:
Activity will include the Microlise mapping, emergency import sheet.QJI is dealt with elsewhere.
Benefits identified as a result of the change:
Interfaces maintained to other applications
Solution
Contingency Spreadsheet Import
The Contingency Spreadsheet will be loaded onto the C-TMS system using an IMPORT. The import format used will be the existing ORDER_AND_LINE format. The spreadsheet will be imported with every possible order line available , each line will be based on the British Gas Waste DU Types.
The processing of the ORDER_AND_LINE format will be amended based on the value of a new COST CENTRE PARAMETER called CONTINGENCY_IMPORT.
Based on the value of the cost centre parameter, the following functionality will be available:
- The line information in the first record of each order may be left blank without causing an error
- Only lines which have a quantity assigned will be processed, otherwise the system will ignore the line and not attempt to load it into C-TMS.
- Any unknown locations will be automatically created as part of the import.
The booking ref will not be imported as this will not be populated for contingency orders.
Microlise
A new cost centre version of the MIC_SO_REF_FORMAT parameter will be created and assigned the value 2. In the outbound flow additional code will be developed to format the so_ref based on a parameter value of 2.
New format for value 2 : TYPE-BOOKING_REF-TRIP-SEQ-ACT
Scope
This change will be applied to system version 10.7.0.
Set-up
Pre-requisites
When creating the Tractor and Trailer resources, the user will be required to set the relevant tractors and/or trailers to MICROLISE ENABLED. Tractor and Trailer records are maintained in the Resources screen.
Menu Structure
Unchanged
Data
A new sequence will be created called SEQ_BGW_LOCS.
Implementation Advice
A system super user will be required to set the new cost centre parameter CONTINGENCY_IMPORT to Y. This will be completed in the System Parameter screen.
A system super user will be required to promote the new Import to the relevant user groups. This is completed in the Access Control screen.
A system super user will be required to set the new COST CENTRE parameter MIC_SO_REF_FORMAT to 2 for BGWCC.
Functional Description
Contingency Import
A new import configuration will be created in the imports maintenance screen. The config will be based on the following fields:
| FIELD TYPE | SOURCE VALUE |
| ACTION | A |
| EXT_REF | 2 |
| CUSTOMER | 18 |
| COST_CENTRE | 10 |
| DEL_TYPE | 9 |
| FRLOC_NAME | 12 |
| FRLOC_TYPE | HOME |
| FRLOC_ADDR1 | 13 |
| FRLOC_ADDR2 | 14 |
| FRLOC_TOWN | 15 |
| FRLOC_CNTY | 17 |
| FRLOC_C_CODE | GB |
| FRLOC_PCODE | 16 |
| FRLOC_TYPE | DEL |
| TO_LOC | 19 |
| EARLY_AVAIL | 4 |
| LATE_AVAIL | 5 |
| EARLY_DEL | 6 |
| LATE_DEL | 7 |
| GROUP_NAME | 8 |
| PRODUCT | WASTE |
| DU_TYPE | 20 |
| QTY | 21 |
| WEIGHT_KG | 22 |
| SPECIAL_INSTR | 23 |
| BOOKING_REF | 3 |
| REC_TYPE | 1 |
| LINE_PRODUCT | WASTE |
| LINE_DU_TYPE | 2 |
| LINE_QTY | 3 |
| LINE_WEIGHT_KG | 4 |
The import type TI_ORDER is currently processed in the import package (IMP.sql). Changes will be made to the existing procedure based on the value of the new COST CENTRE parameter CONTINGENCY_IMPORT.
Changes to the procedure will include the following functionality:
- The schedule date will be created based on the value of the EARLY_AVAIL field.
- The Booking Ref will never be populated as this field is optional in C-TMS.
- The following fields defined as ORDER_AND_LINE and sourced from columns 20,21 and 22 will always be null as these fields are optional in C-TMS.
- DU_TYPE
- QTY
- WEIGHT_KG
- Any unknown collection locations will be automatically created. The location id will be generated as the characters ‘BGW’ and the next value of a new sequence number.
- All line records which have no quantity assigned will be ignored in processing and only records where a quantity is included will be selected and imported. Where the quantity is not set, the code will continue to the next line.
In the sample file below, only lines 5 and 8 will be processed, the code process the other lines ignoring the records as there is no quantity assigned.
Microlise
A new COST CENTRE parameter MIC_SO_REF_FORMAT will be created for cost centre BGWCC. The parameter will be set to 2. In the MICROLISE package (INT_XML_MIC.sql), code will be added to process a value of 2 for the Cost centre parameter MIC_SO_REF_FORMAT.
If the parameter has been set to 2, the so_ref will be generated based on the following data combined.
| Field | Value |
| STOP_TYPE | C- or D- |
| BOOKING_REF | SCH_ORD.BOOKING_REF |
| TRIP_ID | SCH_TRIP.TRIP_ID |
| STOP_NO | SCH_TRIP_STOP.STOP_NO |
| T_ACTIVITY | L or U |
References
| EST 291170 AR-8KNKCV Consultation on message format v0.1 | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Reviewed | ||||
| Reviewed and issued | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
