ER CTMS 044-045

From Calidus HUB
Revision as of 13:08, 10 August 2023 by StylesC (talk | contribs) (Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER044-045 }} {| class="wikitable" border="1" width="100%" |- bgcolor="sil...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER044-045


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks
DATA_ORS_SQL_467514.sql Database script 1.1 467514 - 2 New ORS type has been created called 'TRIP_LOCS' which has 5 columns:

SCHED_NAME - Range - Required

TRIP_ID

LOAD_LOC - Value - Required

UNLOAD_LOC - Value - Required

ROUTE_CODE


This ORS will give data about all the trips that went between 2 locations.

User Notes: In order to get unique records, user can use the sort and group_by tick box in the screen.

As Load and Unload locations are the selection criteria they can be discarded from the report by not including them, it can be done by unticking the Inc tick box.

DATA_ORS_MASTER_DATA_467514.sql Database script 1.1 " " " "
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=ER_CTMS_044-045&oldid=10699’