DuttonT at 14:07, 9 May 2011

2011-05-09T14:07:33Z

← Older revision		Revision as of 16:07, 9 May 2011
Line 66:		Line 66:
	\| EST-282442 JB-8AG2PE Modify LOTS MICROLISE messages generated from CTMS.doc		\| EST-282442 JB-8AG2PE Modify LOTS MICROLISE messages generated from CTMS.doc
	\| <center>1</center>		\| <center>1</center>
	\| <center>06/01/10</center>		\| <center>08/11/10</center>
	\|}		\|}

DuttonT at 14:05, 9 May 2011

2011-05-09T14:05:45Z

← Older revision		Revision as of 16:05, 9 May 2011
Line 42:		Line 42:
	This change will be applied to system version 10.6.0 on CONTST and once approved CONPRD.		This change will be applied to system version 10.6.0 on CONTST and once approved CONPRD.

	~~==Data==~~

	=FUNCTIONAL DESCRIPTION=		=FUNCTIONAL DESCRIPTION=
Line 83:		Line 83:
	\| <center>Draft</center>		\| <center>Draft</center>
	\| Initial version		\| Initial version
			\|
	\| <center>SW</center>		\| <center>SW</center>
	\|}		\|}

DuttonT: New page: =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 supplie...

2011-05-09T14:04:12Z

New page

=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.

==Data==

=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=

{| Border="1"
| <center>'''Ref No'''</center>
| <center>'''Document Title & ID'''</center>
| <center>'''Version'''</center>
| <center>'''Date'''</center>

|-
| <center>1</center>
| EST-282442 JB-8AG2PE Modify LOTS MICROLISE messages generated from CTMS.doc
| <center>1</center>
| <center>06/01/10</center>
|}

=DOCUMENT HISTORY=

{| Border="1"
| <center>'''Version'''</center>
| <center>'''Date'''</center>
| <center>'''Status'''</center>
| <center>'''Reason'''</center>
| <center>'''Initials'''</center>

|-
| <center>0.1</center>
| <center>Draft</center>
| Initial version
| <center>SW</center>
|}

=AUTHORISED BY=

{| Border="1"
| '''''Matt Crisford'''''
| Development Manager
|

|-
| '''''Peter Greer'''''
| TMSCC MTS Product Manager
|

|}

282442 - Revision history

DuttonT at 14:07, 9 May 2011

DuttonT at 14:05, 9 May 2011

DuttonT: New page: =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 supplie...