292350
[[Image:]]
|
Version :
|
Copyright OBS Logistics © 2011
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
Contents
[#__RefHeading__25_1720706875 1. Functional Overview3]
[#__RefHeading__27_1720706875 2. Set-up4]
[#__RefHeading__29_1720706875 3. Functional Description5]
[#__RefHeading__31_1720706875 Appendix A MODULES TO BE CHANGED7]
[#__RefHeading__33_1720706875 Appendix B QUOTE & DoCuMENT History8]= Functional Overview =
Client Requirement
Change Request Summary:
Microlise to C-TMS integration.
Change Request Details:
Microlise to C-TMS - extend schema to include ETA. Implementation of Microlise integration.
Benefits identified as a result of the change:
Solution design requirement.
Solution
The Microlise to C-TMS flow uses the ‘TripOrder’ XML format and this format will be changed to include 2 extra ‘ETA’ items to store the estimated date and time of arrival at the next stop and the derivation date and time of the message event.
The ‘ETA’ items will use a ‘DATETIME’ data type and will be included in the ‘STOP_DETAIL’ section.
The processing of the file will be changed to extract the data from the ‘ETA’ items and use it to update the trip stop information.
See RIO 292352 PM-8LZMK3 for information regarding the processing of the ‘ETA’ items.
Scope
This change will be applied to system version 10.7 on INDTST and once approved INDPRD.
Set-up
Pre-requisites
None
Menu Structure
Unchanged
Data
New ‘ETA’ items will be added as new columns on the trip stop database table. This will be covered under the RIO 292352 PM-8LZMK3.
Functional Description
Business Data
Two new xml tags have been added to the ‘Trip Order v2.23.xsd’ file below labelled as ‘Stop Eta Date’ and ‘Stop Eta At Date’:
[[Image:]]
A new Event Type ‘ETA’ for the Inbound Microlise message will be expected to be received.
Inbound Microlise Message
The inbound Microlise process will be altered to receive the additional tags within the ‘Stop Detail’ section:
[[Image:]]
The ‘Stop Eta Date’ tag will indicate the Date and Time the driver is expected to arrive at the next stop. The ‘Stop Eta At Date’ tag will indicate the Date and Time the Microlise system calculated the ‘Stop Eta Date’.
The process will check that the trip and stop number the fields are received against are valid. Checks will also be made to ensure the fields are valid dates and times.
The process will be changed so that for event type ‘ETA’, the actual arrive and depart times will not be updated.
Changes to make the data passed into these tags visible within various screens within C-TMS are covered under the RIO 292352 PM-8LZMK3.
If any errors occur then they will be displayed in the ‘XML Trip’ tab of the Interface Errors screen where the user can set the ‘Source’ field to ‘MIC’. An example of an error occurring at this level is shown below:
[[Image:]]
Note that the ‘ETA’ items will not be visible in the ‘XML Trips’ tab page in the ‘Interface Errors’ screen.
MODULES TO BE CHANGED
| Module Name | Module Type | Notes |
| INT_XML_MIC.sql | Package | Inbound Microlise Message processing |
References
| EST-292350 – PM-8LZMEM Microlise Integration | |||
Glossary
| C-TMS | Calidus TMS |
Document History
| Initial version | ||||
| Revised | ||||
| Reviewed and Issued | ||||
| Revised | ||||
| Issued |
AUTHORISED BY
| Matt Crisford | Development Manager | |
| Peter Greer | TMSCC MTS Product Manager |
