290798
DHL C-TMS
Additional Paragon Fields
FUNCTIONAL SPECIFICATION - 10.6
03/08/2011 - 1.1
Reference: FS 290798 OB-8K8DY2
Functional Overview
Client Requirement
Change Request Summary:
Change to the Paragon Interface to include volumetric data for each order.
Change Request Details:
The business requires addition volumetric fields to be added to the paragon export to allow for better paragon planning.
Benefits identified as a result of the change:
Better volumetric data will give more accurate planning.
Solution
There is already a Dunelm specific version of the CSV export from C-TMS to Paragon.
This code is split into 2 sections, the first section for the collection orders (at manifest level – Booking Reference) and the second section for the delivery orders (at order level – OMS reference).
Both of these sections are going to be extended to add the 8 new requested fields.
All of the new fields are summations of the volume for specific DU types at either manifest or order level as appropriate for each section.
Title DU Type
CALL.USER04 PALLET
CALL.USER05 OHPAL
CALL.USER06 OSPAL
CALL.USER07 CTN
CALL.USER08 OCTN
CALL.USER09 BAG
CALL.USER10 ROLL
CALL.USER11 TOTE
Scope
This change will be applied to system version 10.6.
Functional Description
CSV Export Changes
Changes will be made to the existing CSV package which already has code specific to Dunelm for producing a file containing the orders ready for loading into Paragon.
This code is split into collection and delivery legs for the orders.
The collection legs for the orders are consolidated at manifest level (Booking Reference) with a line per manifest being added to the file produced for export.
The delivery legs for the orders are consolidated at order level (OMS Reference) with a line per order being added to the file produced for export.
The process for both of the above leg types already selects all order lines that are to be included for each output line and summarizes at DU type in order to calculate the variable loading/unloading times.
This process will be altered to also total the volume for each of the 8 Dunelm specific DU types (PALLET, OHPAL, OSPAL, CTN, OCTN, BAG, ROLL and TOTE).
The additional 8 new fields will be added to the header section at the end of the headings line in the following sequence :-
‘CALL.USER04’
‘CALL.USER05’
‘CALL.USER06’
‘CALL.USER07’
‘CALL.USER08’
‘CALL.USER09’
‘CALL.USER10’
‘CALL.USER11’
The calculated volume summary for each DU type will be added to the details at the end of the detail line in the following DU type sequence :-
PALLET
OHPAL
OSPAL
CTN
OCTN
BAG
ROLL
TOTE
NB) Currently the volume is multiplied by a factor of 10 (as requested in the original design) before writing it to the file so these new volume fields will also be multiplied by a factor of 10 to keep it consistent.
OB – The above is currently in use because Paragon cannot accept decimal places. The volume fields in the live environment will be changed to not include decimals so the new fields will no need to be times by ten. The existing fields will need to continue to be times by 10.
The rest of the data sent in the export file will be unchanged.
References
| EST-290798 OB-8K8DY2 Additional Paragon Fields v1.0.doc | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Reviewed and Issued | ||||
| Comments added in red by OB (DHL) | ||||
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
