292350

DHL C-TMS

Microlise Integration

FUNCTIONAL SPECIFICATION - 10.7

26/10/11 - 2.0
Reference: 292350 - PM-8LZMEM

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’:

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:

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:

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

Ref No	Document Title & ID	Version	Date
1	EST-292350 – PM-8LZMEM Microlise Integration	1.0	06/10/2011

Glossary

Term or Acronym	Meaning
C-TMS	Calidus TMS

Document History

Version	Date	Status	Reason	Initials
0.1	12/10/11	Draft	Initial version	RE
0.2	13/10/11	Draft	Revised	MJC
1.0	13/10/11	Issue	Reviewed and Issued	MJC
1.1	20/10/11	Draft	Revised	RE
2.0	26/10/11	Issue	Issued	MJC

AUTHORISED BY

Matt Crisford	Development Manager
Peter Greer	TMSCC MTS Product Manager