289051 - Revision history

DuttonT: /* Stop Sequences */

2011-08-17T09:20:59Z

Stop Sequences

← Older revision		Revision as of 11:20, 17 August 2011
Line 161:		Line 161:


	#		'''Table Updates Required'''
	#:
	~~#::~~
	~~#:::~~
	~~#::::~~
	~~#:::::~~
	~~#::::::~~
	~~#:::::::~~
	~~#:::::::#~~ '''Table Updates Required'''

	The new system parameter may be created using the following script:		The new system parameter may be created using the following script:
Line 271:		Line 263:

	\|}		\|}


	=AUTHORISED BY=		=AUTHORISED BY=

DuttonT at 09:20, 17 August 2011

2011-08-17T09:20:15Z

← Older revision		Revision as of 11:20, 17 August 2011
Line 3:		Line 3:

	== Client Requirement ==		== Client Requirement ==

	'''Change Request Summary:'''		'''Change Request Summary:'''


	Change to the Existing Microlise interface to bring it back in line with Phase two project Delivery.		Change to the Existing Microlise interface to bring it back in line with Phase two project Delivery.
Line 10:		Line 10:

	'''Change Request Details:'''		'''Change Request Details:'''


	The existing Microlise interface requires changing to allow for phase two functionality (the systematic collections) to be handled correctly.Currently, the interface between C-TMS and Microlise (via ESI) isn't working correctly. Outbound from C-TMS to Microlise, the journey update messages are causing validation errors at Microlise as we are breaking two of the primary keys within their database. From Microlise back to C-TMS, the sequence of the drops is incorrect, causing the debrief screen to be thrown out, and the times against the drops being in the wrong place.After investigation work by all 3 parties and the project team, a solution has been identified where certain messages will be being suppressed from C-TMS to Microlise, and to use the unique stop_id (not visible to users but held within the database itself), as a unique stop number to be passed to Microlise.		The existing Microlise interface requires changing to allow for phase two functionality (the systematic collections) to be handled correctly.Currently, the interface between C-TMS and Microlise (via ESI) isn't working correctly. Outbound from C-TMS to Microlise, the journey update messages are causing validation errors at Microlise as we are breaking two of the primary keys within their database. From Microlise back to C-TMS, the sequence of the drops is incorrect, causing the debrief screen to be thrown out, and the times against the drops being in the wrong place.After investigation work by all 3 parties and the project team, a solution has been identified where certain messages will be being suppressed from C-TMS to Microlise, and to use the unique stop_id (not visible to users but held within the database itself), as a unique stop number to be passed to Microlise.

			== Solution ==

	~~== Solution ==~~
	The following changes will be made:		The following changes will be made:


	# The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.		# The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.
Line 23:		Line 21:
	# The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders; therefore, when they are sent to Microlise the trip stop is only included if it contains at least one order not inserted by Microlise.		# The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders; therefore, when they are sent to Microlise the trip stop is only included if it contains at least one order not inserted by Microlise.

	# <nowiki>A new system parameter called ‘MIC_USE_STOP_ID’ will be created to control whether the stop ID is used by Microlise instead of the stop number in the XML tag <STOP_SEQ>: if the system parameter is set to ‘Y’ then the stop ID will be used and the stop number obtained for the stop ID when it is received from Microlise.</nowiki>

	== Scope ==		== Scope ==
Line 31:		Line 29:
	== Pre-requisites ==		== Pre-requisites ==
	None		None


	== Menu Structure ==		== Menu Structure ==
	‘Unchanged’		‘Unchanged’

			== Data ==

	~~== Data ==~~
	# A new system parameter will be introduced (see Appendix A for the script for creation).		# A new system parameter will be introduced (see Appendix A for the script for creation).

Line 45:		Line 42:

	= Functional Description =		= Functional Description =

	== System Parameters ==		== System Parameters ==

	A new system parameter called ‘MIC_USE_STOP_ID’ will store a comma-delimited list of prefixes that will exclude the storage of a new asset.		A new system parameter called ‘MIC_USE_STOP_ID’ will store a comma-delimited list of prefixes that will exclude the storage of a new asset.


	The description of the system parameter will be:		The description of the system parameter will be:


	‘Determines if the stop ID or the stop sequence will be used by Microlise, if 'Y' then the stop ID will be used.’		‘Determines if the stop ID or the stop sequence will be used by Microlise, if 'Y' then the stop ID will be used.’

			== ‘INT_XML_MIC’ Package ==

	~~== ‘INT_XML_MIC’ Package ==~~
	The following changes will be made to the ‘INT_XML_MIC’ package.		The following changes will be made to the ‘INT_XML_MIC’ package.

			=== Collection Details ===

	~~=== Collection Details ===~~
	The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.		The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.


	Trips may be considered in the examples below for when the system parameter is set to ‘TRUNK’:		Trips may be considered in the examples below for when the system parameter is set to ‘TRUNK’:



Line 149:		Line 145:

	\|}		\|}

	Deliveries to a dealership loaded from a RDC location and collections from a dealership to be unloaded at a RDC location will be included for orders on ‘TRUNK’ trips.		Deliveries to a dealership loaded from a RDC location and collections from a dealership to be unloaded at a RDC location will be included for orders on ‘TRUNK’ trips.

			=== Source System ===

	~~=== Source System ===~~
	The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders.		The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders.


	When they are sent to Microlise the trip stop will only be included if it contains at least one order not inserted by Microlise.		When they are sent to Microlise the trip stop will only be included if it contains at least one order not inserted by Microlise.
Line 160:		Line 156:

	=== Stop Sequences ===		=== Stop Sequences ===
	<nowiki>A new system parameter called ‘MIC_USE_STOP_ID’ will be created to control whether the stop ID will be used by Microlise instead of the stop number in the XML tag <STOP_SEQ>: if the system parameter is set to ‘Y’ then the stop ID will be used and the stop number obtained for the stop ID when it is received from Microlise.</nowiki>


	~~<nowiki>The stop ID will be stored in the XML tag <STOP_ID> as described in v2.20 of the TripOrder.xsd file.</nowiki>~~


	The stop ID may be a hyphen-delimited list of stop IDs should the stops be consolidated.		The stop ID may be a hyphen-delimited list of stop IDs should the stops be consolidated.


	~~<nowiki>New tag <STOP_ID> will be introduced to send to, and receive from, Microlise based on the stop ID at the trip stop to accompany the stop number in the tag <STOP_SEQ>.</nowiki>~~

	#		#
Line 179:		Line 169:
	#::::::		#::::::
	#:::::::		#:::::::
	#:::::::# '''~~table updates REQUIRED~~'''		#:::::::# '''Table Updates Required'''

	The new system parameter may be created using the following script:		The new system parameter may be created using the following script:


	~~[[Image:]]~~


	The new source system may be created using the following script:		The new source system may be created using the following script:


	~~[[Image:]]~~





Line 223:		Line 203:

	\|}		\|}


	'''Glossary'''		'''Glossary'''

DuttonT: New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Automotive Microlise Updates|Reference=289051 OB-8HGCRZ |Version=1.0|Date=|Sysver=10.6|Client=DHL C-TMS}} == Client Requirement == '''Ch...

2011-08-17T09:15:06Z

New page: {{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Automotive Microlise Updates|Reference=289051 OB-8HGCRZ |Version=1.0|Date=|Sysver=10.6|Client=DHL C-TMS}} == Client Requirement == '''Ch...

New page

{{Doc_Title|System=FUNCTIONAL SPECIFICATION|Title=Automotive Microlise Updates|Reference=289051 OB-8HGCRZ |Version=1.0|Date=|Sysver=10.6|Client=DHL C-TMS}}

== Client Requirement ==
'''Change Request Summary:'''

Change to the Existing Microlise interface to bring it back in line with Phase two project Delivery.

'''Change Request Details:'''

The existing Microlise interface requires changing to allow for phase two functionality (the systematic collections) to be handled correctly.Currently, the interface between C-TMS and Microlise (via ESI) isn't working correctly. Outbound from C-TMS to Microlise, the journey update messages are causing validation errors at Microlise as we are breaking two of the primary keys within their database. From Microlise back to C-TMS, the sequence of the drops is incorrect, causing the debrief screen to be thrown out, and the times against the drops being in the wrong place.After investigation work by all 3 parties and the project team, a solution has been identified where certain messages will be being suppressed from C-TMS to Microlise, and to use the unique stop_id (not visible to users but held within the database itself), as a unique stop number to be passed to Microlise.

== Solution ==
The following changes will be made:

# The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.

# The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders; therefore, when they are sent to Microlise the trip stop is only included if it contains at least one order not inserted by Microlise.

# <nowiki>A new system parameter called ‘MIC_USE_STOP_ID’ will be created to control whether the stop ID is used by Microlise instead of the stop number in the XML tag <STOP_SEQ>: if the system parameter is set to ‘Y’ then the stop ID will be used and the stop number obtained for the stop ID when it is received from Microlise.</nowiki>

== Scope ==
This change will be applied to system version 10.6.0.

= Set-up =
== Pre-requisites ==
None

== Menu Structure ==
‘Unchanged’

== Data ==
# A new system parameter will be introduced (see Appendix A for the script for creation).

# The new source system will be introduced (see Appendix A for the script for their creation).

# The existing system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ should be set to ‘TRUNK’.

= Functional Description =
== System Parameters ==
A new system parameter called ‘MIC_USE_STOP_ID’ will store a comma-delimited list of prefixes that will exclude the storage of a new asset.

The description of the system parameter will be:

‘Determines if the stop ID or the stop sequence will be used by Microlise, if 'Y' then the stop ID will be used.’

== ‘INT_XML_MIC’ Package ==
The following changes will be made to the ‘INT_XML_MIC’ package.

=== Collection Details ===
The collection details will be sent to Microlise for the dealerships if the system parameter ‘MIC_SUPPRESS_ORDER_SEGMENT’ is set to ‘TRUNK’ and the trip is between an RDC location and a dealership location in either direction. At present this system parameter is set to ‘TRUNK’ for Automotive so only delivery activities at the order destination would be included.

Trips may be considered in the examples below for when the system parameter is set to ‘TRUNK’:

{| style="border-spacing:0;"
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''Source'''
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''Destination'''
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''From'''
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''Type'''
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''To'''
| style="background-color:#ffff99;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''Type'''
| style="background-color:#ffff99;border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| '''Included'''

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| ORIGIN
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC2
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC2
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC3
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC3
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| BRANCH
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Y

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| ORIGIN
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| BRANCH
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| BRANCH
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| ORIGIN
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC4
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| BRANCH
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC3
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Y

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC3
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC2
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC2
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| RDC
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| LOC1
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| ORIGIN
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| N

|}
Deliveries to a dealership loaded from a RDC location and collections from a dealership to be unloaded at a RDC location will be included for orders on ‘TRUNK’ trips.

=== Source System ===
The file received from Microlise creates a new order if the TMS order reference is null, if such an order is created then the source system of the order will be set to ‘MIC’ to identify these orders.

When they are sent to Microlise the trip stop will only be included if it contains at least one order not inserted by Microlise.

=== Stop Sequences ===
<nowiki>A new system parameter called ‘MIC_USE_STOP_ID’ will be created to control whether the stop ID will be used by Microlise instead of the stop number in the XML tag <STOP_SEQ>: if the system parameter is set to ‘Y’ then the stop ID will be used and the stop number obtained for the stop ID when it is received from Microlise.</nowiki>

<nowiki>The stop ID will be stored in the XML tag <STOP_ID> as described in v2.20 of the TripOrder.xsd file.</nowiki>

The stop ID may be a hyphen-delimited list of stop IDs should the stops be consolidated.

<nowiki>New tag <STOP_ID> will be introduced to send to, and receive from, Microlise based on the stop ID at the trip stop to accompany the stop number in the tag <STOP_SEQ>.</nowiki>

#
#:
#::
#:::
#::::
#:::::
#::::::
#:::::::
#:::::::# '''table updates REQUIRED'''

The new system parameter may be created using the following script:

[[Image:]]

The new source system may be created using the following script:

[[Image:]]

'''References'''

{| style="border-spacing:0;"
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Ref No'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Document Title & ID'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Version'''</center>
| style="background-color:#c0c0c0;border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Date'''</center>

|-
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>1</center>
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| EST-289051 OB-8HGCRZ Automotive Microlise Updates v1.0.doc
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>1.0</center>
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>03/06/11</center>

|-
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|}

'''Glossary'''

{| style="border-spacing:0;"
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Term or Acronym'''</center>
| style="background-color:#c0c0c0;border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Meaning'''</center>

|-
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| C-TMS
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Calidus TMS

|-
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|-
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|}

'''Document History'''

{| style="border-spacing:0;"
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Version'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Date'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Status'''</center>
| style="background-color:#c0c0c0;border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Reason'''</center>
| style="background-color:#c0c0c0;border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>'''Initials'''</center>

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>0.1</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>03/06/11</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>Draft</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Initial version
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>PDR</center>

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>1.0</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>15/06/11</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>Issue</center>
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| Reviewed and Issued
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"| <center>MJC</center>

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|-
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|
| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"|

|}

=AUTHORISED BY=

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

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

|}