CTMS 11.0 ER020-053

From Calidus HUB


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER020-053


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
DP_INT_XML_MIC2.sql CTMS to Mic Interface 1.8 336591 - 3 Amend the calculation of the 'journeySiteNote'.

Modify the logic so that for the SU stop 1, the journey site note is populated from the Trip General Comments. If there are no records then don't generate the tag for the SU stop 1. Remove the hard-code 'ORDERS:' that is not needed.


For each successive site visit (stop in C-TMS) include the special instructions for the order or orders on the stop. Again remove any CRLF and replace with space, deal with special characters like & and £. If more than one order on the stop then concatenate the special instructions and separate with a space. Leave out the tag altogether if no special instructions on the order. Remove the hard-code 'ORDERS:' that is not needed.

Dave Meir