282442
282442 - JB-8AG2PE/ Modify LOTS MICROLISE messages generated from CTMS
Copyright OBS Logistics © 2010
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
FUNCTIONAL OVERVIEW
Client Requirement
Change Request Summary: Modify LOTS / Microlise XML messages generated from CTMSStuart Foster/Milton Keynes/UK/NFC Change Request Details: 1. For the messages sent from CTMs to LOTS , make the following message types to be one message per order rather than multiple messages in one file generated every 5 mins.
BOO SCN RBO CAN
2. Change the current filename convention for the CTMS to MICROLISE & CTMS to LOTS flow where message type is TRP from <SOURCE>_<DESTINATION>_<DATABASE>_<MESSAGE_TYPE>_<DATETIME>.XML (what I think is current) to <SOURCE>_<DESTINATION>_<OWNING_DEPOT>_<MESSAGE_TYPE>_<DATETIME>.XML (what I think is current)
3.Change the current filename convention for the CTMS to LOTS message for none TRP events (BOO,SCN,CAN,RBO from <SOURCE>_<DESTINATION>_<DATABASE>_<MESSAGE_TYPE>_<DATETIME>.XML (what I think is current) to <SOURCE>_<DESTINATION>_<WMS_OWNER>_<MESSAGE_TYPE>_<DATETIME>.XML (what I think is current)
4. Apply the 2.10 XSD that Graham Rothwell is developing , to the LOTS flows generated out of CTMS and for inbound from LOTS.
Benefits identified as a result of the change: Allows ESI to easily split the messages up by owning contract. For future implementations it will save cost.
This is my proposed solution but need to discuss with OBS analyst.
Scope
This change will be applied to system version 10.6.0 on CONTST and once approved CONPRD.
FUNCTIONAL DESCRIPTION
Only the Microlise changes and the application of the XSD will be developed. The microlise changes will be applied to the PROCESS_XML_OUTBOUND_MIC procedure of INT_XML_OUT2 package.
The changes to the filename will be parameterised based on a new system parameter MIC_OWNING_DEPOT. If this parameter is set to Y, the filename will be changed to include the owning_depot rather than the DATABASE.
The latest version of the XSD will be applied. Again this will be based on a system parameter called STOP_PID. If the parameter is set to Y, then the stop_pid will be included in the output. Stop_pid relates to the LAST 6 DIGITS of sch_trip_stop.trip_id from the database. The changes will be made in the GEN_STOP_DET procedure of INT_XLM_OUT2.
REFERENCES
| EST-282442 JB-8AG2PE Modify LOTS MICROLISE messages generated from CTMS.doc |
DOCUMENT HISTORY
| Initial version |
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
