ER CTMS 039-029

From Calidus HUB
Revision as of 17:04, 29 July 2021 by StylesC (talk | contribs)


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER039-029


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks
DATE_ADM_SYSTEM_PARAM_01778186.sql Database Script 1.1 01778186 - 3 The system parameters 'MIC_REDUCED_EVENTS' and 'MIC_3PL_TRIP_HOURS' will be used to reduce the number of messages that are sent to Microlise.

These events will be:


Trip status changed to 'ACCEPTED'

An order is added or removed from a trip

The delivery windows change on an order


The duration of the trips will be assessed for these reduced events when a number of hours is specified.

The duration of the trip must then not exceed the specified number of hours to trigger the event.

The number of hours for the trip will only apply to 'ACCEPTED' trip when reduced events are being assessed.

TRG_SCH_TRIP_XML_INT.sql Trip Interface Database Trigger 5.34 " " " "
TRG_STS_XML.sql Trip Stop Interface Database Trigger 5.22 " " " "
TRG_SHA_XML.sql Haulage Activity Interface Database Trigger 5.27 " " " "
TRG_SCH_ORD_EARLY_DEL.sql Order Early Delivery Date Interface Database Trigger 1.3 " " " "
TRG_SOL_XML.sql Order Line Interface Database Trigger 5.46 " " " "
TRG_SOI_XML.sql Order Item Interface Database Trigger 5.22 " " " "


New Parameters
Parameter Name Config Level Setting Value Result
MIC_REDUCED_EVENTS SYSTEM N Microlise will continue to receive all triggered events.
MIC_REDUCED_EVENTS SYSTEM Y Microlise will receive a reduced number of defined events.
MIC_3PL_TRIP_HOURS SYSTEM NULL Microlise will continue to receive all triggered events.
MIC_3PL_TRIP_HOURS SYSTEM NUMBER The number of elapsed hours that Microlise requires a trip not to exceed for the reduced number of events.