ER CTMS 044-045: Difference between revisions

From Calidus HUB
(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...")
 
m (Text replacement - "[[Category:{{#var:System}} ER]]↵" to "[[Category:{{#var:System}} ER]]Category:ER CTMS 044")
 
Line 46: Line 46:


<noinclude>
<noinclude>
[[Category:{{#var:System}} ER]]
[[Category:{{#var:System}} ER]][[Category:ER CTMS 044]]</noinclude>
</noinclude>

Latest revision as of 09:51, 14 July 2025


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 " " " "