PATCH C-TMS P047

Release Notes

CALIDUS TMS

22nd Oct 2024 - 1.0
Reference: P047

SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS TMS users with the level of detail required to accurately test all software included in the patch. The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.

GLOSSARY OF TERMS

Term	Meaning
C-TMS	Transport Management System
C-WMS	Warehouse Management System
CR	Change Request
C-WCS	Warehouse Control System
C-ePOD	Electronic Proof of Delivery
C-MCS	Mobile Control System
C-TTM	Track and Trace Management
EDI	Electronic Data Interchange
TID	Testing Issue Development, or Log

TESTING PROCESS

TIDs AND RESOLUTION

If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.

FINAL 'END TO END' TESTING

Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.

AUTHORISATION

Authorisation from nominated release personnel only will be required when requesting a release to a production environment

CHANGE REQUESTS

Log Number: 00576827

Summary of Call	Install line created for wheel
Detail of Fix	Changes for 531320. Added decodes for product category for TYRE and NON-TYRE, only when quantity is greater than zero then the item is created.
Set-up and Configuration	No set-up/configuration required

Log Number: 03171309

Summary of Call	Order email address export
Detail of Fix	New ORS report called EX_ORDMAIL has been created which includes order level data and item level data. Order level data includes contact information like email which has been requested to add.
Set-up and Configuration	No set-up/configuration required

Log Number: 00528798

Summary of Call	Tracking Report
Detail of Fix	Two new values will be added to the Configurable Search Criteria in both the orders and orders wide screens. ORDER_ITEM extract is modified to have second level called ORD_ITEM_CONTENT.
Set-up and Configuration	No set-up/configuration required

Log Number: 00543347

Summary of Call	Order interface spec
Detail of Fix	New software developed to process order imports for customer
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
ALLOW_MULTIPLE_ADD_REFS	COST CENTRE	Y	Allow multiple additional references for an order

Log Number: 02756193

Summary of Call	Carbon Reporting
Detail of Fix	Provide output from all-CTMS databases to populate carbon reporting
Set-up and Configuration	No set-up/configuration required

Log Number: 02428249

Summary of Call	Customer-Specific Tracking File
Detail of Fix	A new EDI process has been introduced, featuring a parameter called 'SEND_EVENT_TRACKING'. When this parameter is set to 'Y', it incorporates the 'EVENT_TRACKING' section. Additionally, five new tags have been introduced in the 'MILESTONE' section: SEAL_NUMBER, FROM_LOC_LAT, FROM_LOC_LONG, TO_LOC_LAT, and TO_LOC_LONG. These tags will only be included if the 'SEND_EVENT_TRACKING' parameter is active and their values are not NULL. A revised format of the TripOrder.xsd has been developed to align with these requirements, ensuring that the five new tags are updated under MILESTONE section accordingly.
Set-up and Configuration	No set-up/configuration required

Log Number: 00605864

Summary of Call	Order Sub refs not in customer tracking file
Detail of Fix	Add SEND_SUB_REFERENCES EDI parameter to control the sending of sub references . Existing system parameter USE_XML_ORDER_SUB_REFS also needs to be made active for the cost centre
Set-up and Configuration	No set-up/configuration required

Log Number: 00606083

Summary of Call	Amend the trigger for tracking messages
Detail of Fix	Trigger corrected to use actual quantity.
Set-up and Configuration	No set-up/configuration required

Log Number: 00606761

Summary of Call	Ref missing from order sub references
Detail of Fix	Software release to correct missing customer references
Set-up and Configuration	No set-up/configuration required

Log Number: 00613005

Summary of Call	Changes to customer Order Interface
Detail of Fix	Amend customer order import to obtain pallet data from new tags
Set-up and Configuration	No set-up/configuration required

Log Number: 00623186

Summary of Call	Customer import reprocessing missing cust ref
Detail of Fix	Software release to create cust references when an order import is reprocessed
Set-up and Configuration	No set-up/configuration required

Log Number: 00624902

Summary of Call	Cust order items incorrect quantity
Detail of Fix	Updated item quantities to always show as 1
Set-up and Configuration	No set-up/configuration required

Log Number: 00623640

Summary of Call	Changes to customer tracking milestones
Detail of Fix	Additional milestones added to show arriving at and departing from consolidation facility
Set-up and Configuration	No set-up/configuration required

Log Number: 00625942

Summary of Call	Customer interface item identifier - remove underscore
Detail of Fix	Remove underscore from item id and set the item current location to GRID
Set-up and Configuration	No set-up/configuration required

Log Number: 00628135

Summary of Call	Change cust item identifier
Detail of Fix	Update the item id to use Pallet ID
Set-up and Configuration	No set-up/configuration required

Log Number: 00630454

Summary of Call	Store customer pallet ID in uppercase
Detail of Fix	Change DP_TES_EDI_IN in store pallet ID's in upper case
Set-up and Configuration	No set-up/configuration required

Log Number: 00631428

Summary of Call	Cust order import duplicate items
Detail of Fix	Changes to accommodate multiple pallets/orders
Set-up and Configuration	No set-up/configuration required

Log Number: 00632041

Summary of Call	Order interface for Aggregated order number
Detail of Fix	Changes made to customer order interface to store new aggregated order number
Set-up and Configuration	No set-up/configuration required

Log Number: 00645781

Summary of Call	Order Import Failure
Detail of Fix	Correct issue with multiple pallets/orders
Set-up and Configuration	No set-up/configuration required

Log Number: 00647837

Summary of Call	Customer order Refs not populated
Detail of Fix	Update customer order references as required, add reason code to all items
Set-up and Configuration	No set-up/configuration required

SUPPORT INCIDENTS

Log Number: 02730386

Summary of Call	Order progress
Detail of Fix	Introduced a cost centre configurable parameter to resolve the issue. The default value of parameter is 'N'. When parameter is set to 'Y' for the cost centre then PLANNED status is set to Webfleet.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
DON'T_SEND_PLANNED_TO_WEBFLEET	COST_CENTRE	Y/N	When the parameter is set control record is not sent for PLANNED status

Log Number: 03549900

Summary of Call	Order audit
Detail of Fix	The DU category of the order will be audited when the order is created or updated. The DU category will be 'PALLET' when the order contains a DU type of that category. The DU category will be 'PARCEL' when the order does not contain a DU type of the 'PALLET' category. The DU category will be NULL when the order does not contain a DU type.
Set-up and Configuration	No set-up/configuration required

Log Number: 00600347

Summary of Call	Planning Trip Updates
Detail of Fix	Exit loop if trailer type unpopulated
Set-up and Configuration	No set-up/configuration required

Log Number: 00624191

Summary of Call	Rebook order data missing
Detail of Fix	Data script created to populate missing reference data
Set-up and Configuration	No set-up/configuration required

Log Number: 00632457

Summary of Call	Inactive drivers and vehicles
Detail of Fix	The 'active' flag for the drivers in EPOD will refer to the 'inactive' flag for the driver or the link between the driver and the carrier. An inactive driver will not be active for EPOD independently of an active link between the driver and the carrier. An inactive link between the driver and the carrier will make the driver inactive for EPOD if the driver itself is active.
Set-up and Configuration	No set-up/configuration required

Log Number: 00622372

Summary of Call	Locking for orders in CTL
Detail of Fix	The users in the Call Logging screen in CTL will be advised when a lock is detected for an order when it is being updated.
Set-up and Configuration	No set-up/configuration required

Log Number: 02767706

Summary of Call	Users are advising they are receiving the please start order message
Detail of Fix	Modified the trigger to send the earlier stop_id to the program.
Set-up and Configuration	No set-up/configuration required

Log Number: 03010528

Summary of Call	Planning screen new configuration
Detail of Fix	Amended logic to have future historic dates in From schedule as requested and match the From schedule to Trip tree schedule irrespective of cost centre set, when the parameters are null.
Set-up and Configuration	No set-up/configuration required

TID CHANGES

Log Number: 00582177

Summary of Call	Customer location ID not updated in Import
Detail of Fix	Added customer update to import
Set-up and Configuration	No set-up/configuration required

Log Number: 00581533

Summary of Call	Auth ref not populating on POD sheet
Detail of Fix	Added Authority code to EPL_ACCOUNT tag for Service jobs
Set-up and Configuration	No set-up/configuration required

Log Number: 00583217

Summary of Call	Epod Error - product x ref
Detail of Fix	Prevent empty product codes form being created
Set-up and Configuration	No set-up/configuration required

Log Number: 00581531

Summary of Call	Multiple contacts displaying. Should be driver only
Detail of Fix	Do not update text on location contacts
Set-up and Configuration	No set-up/configuration required

Log Number: 00585174

Summary of Call	First stop departure for AM/Night runs
Detail of Fix	Correct start times on SU stop for AM runs
Set-up and Configuration	No set-up/configuration required

Log Number: 00585210

Summary of Call	Fixed Routes maintenance screen - search criteria resets
Detail of Fix	Check box values and route position maintained after editing a route
Set-up and Configuration	No set-up/configuration required

Log Number: 00590646

Summary of Call	Portal reporting drivers arrived when they haven't started the job
Detail of Fix	Add EPL_SEQUENCE to EPOD_JOB
Set-up and Configuration	No set-up/configuration required

Log Number: 00588541

Summary of Call	No DEL message sent from TMS for OMS 315
Detail of Fix	Added check before insert to see if records already exist and update instead of insert if found. Note that case 591914 is linked to case 588541.
Set-up and Configuration	No set-up/configuration required

Log Number: 00589819

Summary of Call	Special Instructions Causing Jobs to Fail
Detail of Fix	Increased the size limit to allow for large special instructions to be entered.
Set-up and Configuration	No set-up/configuration required

Log Number: 00591914

Summary of Call	Some Orders not updating Portal with Completion times
Detail of Fix	A 'DEL' message for 'LOTS' will be sent when a vehicle is inspected by 'EPOD' at the same time that a 'DEL' message is sent via the 'API' to 'Elucid'. Note that case 591914 is linked to case 588541.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585234

Summary of Call	Waterfall screen - Alloc Resources button and menu option call different screens
Detail of Fix	Made change to Alloc resource (right click menu) to call same resource allocation form when RES_AVAILABILITY_ALLOC parameter is configured for the cost_centre of the trip.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585205

Summary of Call	Scheduling engine - doesn't set the trailer type against the trip
Detail of Fix	Updated trailer type from route
Set-up and Configuration	No set-up/configuration required

Log Number: 00589803

Summary of Call	Mismatch for tyre qty when qty is updated/changed on the epod device
Detail of Fix	Updated items from actual quantity
Set-up and Configuration	No set-up/configuration required

Log Number: 00591939

Summary of Call	OMS 645 sent additional line to Elucid
Detail of Fix	Prevent items being added for installations without a position being specified.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585191

Summary of Call	Location EXT Ref and Paragon ID can't be seen on the Locations Maintenance screen.
Detail of Fix	Added new fields to location screen controlled by system parameter DISPLAY_PARAGON_LOC_ID "N" to not display "Y" to display.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
DISPLAY_PARAGON_LOC_ID	SYSTEM	Y/N	Display Paragon ID and EXT Ref in Locations Screen

Log Number: 00585190

Summary of Call	Location windows can't be viewed or edited in CTMS
Detail of Fix	New tab added to locations screen to maintain location windows
Set-up and Configuration	No set-up/configuration required

Log Number: 00601998

Summary of Call	Duplicate Service Item Line sent to Elucid
Detail of Fix	Processing of duplicate services removed
Set-up and Configuration	No set-up/configuration required

Log Number: 00601011

Summary of Call	Special Instructions error message
Detail of Fix	Added error message to allow for up to 4000 characters.
Set-up and Configuration	No set-up/configuration required

Log Number: 00587165

Summary of Call	Allocating multiple orders into trips
Detail of Fix	Only display planning popup when all delivery locations match
Set-up and Configuration	No set-up/configuration required

Log Number: 03719814

Summary of Call	Logix Import creating multiple pick ups
Detail of Fix	The current depot of the order will only be assessed and set for the first time when the order is validated when it has been cross-docked without yet setting the current depot. The intention is to account for when the order has been cross-docked on multiple routes to return to a depot.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585177

Summary of Call	Waterfall Screen: Sortation on new columns
Detail of Fix	Screen updated to correctly sort and display menu
Set-up and Configuration	No set-up/configuration required

Log Number: 00585187

Summary of Call	Some parameters can't be set from the screen
Detail of Fix	Add missing parameter configuration
Set-up and Configuration	No set-up/configuration required

Log Number: 00591663

Summary of Call	Order Services doesn't work as expected
Detail of Fix	Corrected tab page changed to query data when finance tab displayed.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585182

Summary of Call	Resource Maintenance/Drivers/Diary Exceptions - problems entering exception
Detail of Fix	Diary exception screen has been modified to avoid control entering unhandled exception.
Set-up and Configuration	No set-up/configuration required

Log Number: 00586888

Summary of Call	Resources Screen - Load Rates - can't enter multiple DU type rates
Detail of Fix	Clear out loading rates block when adding new record
Set-up and Configuration	No set-up/configuration required

Log Number: 00610089

Summary of Call	Missing title to start/end Times columns in Diary exceptions screen
Detail of Fix	Added titles to the Start and End time columns in Diary exceptions screen.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585186

Summary of Call	Resource Availability Allocation - problems with Save
Detail of Fix	Stop save confirmation message if changes have already been saved
Set-up and Configuration	No set-up/configuration required

Log Number: 00585183

Summary of Call	BDM screen/Shift Patterns - spurious error
Detail of Fix	Software release to correct error when no depot selected
Set-up and Configuration	No set-up/configuration required

Log Number: 00585193

Summary of Call	Flexipod flags not configurable in the system
Detail of Fix	Added checkbox for FlexiPOD in location maintenance (Special tab page) and resource maintenance screen (Carriers tab page) to controls whether the FlexiPOD interface is enabled for sending.
Set-up and Configuration	No set-up/configuration required

Log Number: 00585198

Summary of Call	ORS reports not in sync
Detail of Fix	Updated ORS reports to match on both systems added any missing standard reports
Set-up and Configuration	No set-up/configuration required

Log Number: 00609264

Summary of Call	Paragon Import
Detail of Fix	Software change to resolve performance issues
Set-up and Configuration	No set-up/configuration required

Log Number: 00611084

Summary of Call	No can message sent for Invalid orders
Detail of Fix	Prevent order going to Invalid status when all items are deleted from the order
Set-up and Configuration	No set-up/configuration required

Log Number: 00614444

Summary of Call	To release Update script for Geo_location table for new column UNL_LOCATION_CODE
Detail of Fix	Disabled all the triggers for GEO_LOCATION and enabled them again after updating the new column UNL_LOCATION_CODE.
Set-up and Configuration	No set-up/configuration required

Log Number: 00614441

Summary of Call	Duplication on invoice for OMS 2063
Detail of Fix	Only update inspections without faults setting despatched and delivered to ordered quantity.
Set-up and Configuration	No set-up/configuration required

Log Number: 00614901

Summary of Call	Location References don't display names correctly
Detail of Fix	Corrected the width of field and adjusted the layout of reference tab in Location screen to display the reference code and name configured against them.
Set-up and Configuration	No set-up/configuration required

Log Number: 00617056

Summary of Call	Del times show
Detail of Fix	Create control records always created for DELETED trips
Set-up and Configuration	No set-up/configuration required

Log Number: 00618294

Summary of Call	FIA Report showing inspections when they have been completed
Detail of Fix	Fix to view to link to res_vehicle_cust_loc correctly
Set-up and Configuration	No set-up/configuration required

Log Number: 00619005

Summary of Call	Incorrect registration sent to Elucid
Detail of Fix	Update vehicle details on a CALLOUT if different for original
Set-up and Configuration	No set-up/configuration required

Log Number: 00611272

Summary of Call	Additional axle config positions sent to device
Detail of Fix	Display error if trying to change the vehicle config for a vehicle in use.
Set-up and Configuration	No set-up/configuration required

Log Number: 03755459

Summary of Call	Special character in Interface file output to CV
Detail of Fix	The text for the special instructions and the order comments will run a function to remove a special character like a '¿', then remove any control characters, then run a script to remove other characters from the file before it is transferred. Alphanumeric characters and spaces, hyphens, underscores and full stops will be retained.
Set-up and Configuration	No set-up/configuration required

Log Number: 00596532

Summary of Call	POD emails being sent to customers despite the 'Report' box not checked in Call Logging
Detail of Fix	Added new parameter to control if the customer email address can be used when a job specific address record exists.
Set-up and Configuration	No set-up/configuration required

Log Number: 00625686

Summary of Call	Incorrect axle config on POD note
Detail of Fix	Customer added to vehicles cursor
Set-up and Configuration	No set-up/configuration required

Log Number: 00626445

Summary of Call	POD emails being sent when report box unchecked
Detail of Fix	Add NULL value check to cursors
Set-up and Configuration	No set-up/configuration required

Log Number: 00627741

Summary of Call	Job Cancellation/Re-instate issue
Detail of Fix	Allow orders to be removed from an EN-ROUTE trip if they have been collected but not delivered
Set-up and Configuration	No set-up/configuration required

Log Number: 00585176

Summary of Call	Trips screen: Show on map
Detail of Fix	Amended package to accommodate for dummy 499/500 stop numbers
Set-up and Configuration	No set-up/configuration required

Log Number: 00632231

Summary of Call	Email sent to customer in error
Detail of Fix	A contact for the location for the order will not be sent to EPOD when none of the contacts for the order itself are not enabled for reporting and tracking and the contact for the location itself is not enabled for reporting and tracking.
Set-up and Configuration	No set-up/configuration required

Log Number: 00641104

Summary of Call	Email sent to customer in error
Detail of Fix	Add location contact for the customer to message to epod. Update the send text box when updating location contacts
Set-up and Configuration	No set-up/configuration required

Log Number: 00642165

Summary of Call	Incorrect Time Displayed in Portal
Detail of Fix	Update first stop correctly when no collection performed
Set-up and Configuration	No set-up/configuration required

Log Number: 00638199

Summary of Call	Tracking emails not being sent in some scenarios
Detail of Fix	Add new parameter LOTS_ALWAYS_SEND_HDR_CONTACTS set to Y will ensure that both location and order contacts with the tracking box ticked are sent to LOTS in all messages
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
LOTS_ALWAYS_SEND_HDR_CONTACTS	Cost Centre	Y/N	Always send location contacts with order contacts to lots

Log Number: 00646471

Summary of Call	Locking Error Message
Detail of Fix	Error message updated
Set-up and Configuration	No set-up/configuration required

Log Number: 00644267

Summary of Call	POD email not being sent correctly
Detail of Fix	Additional email addresses added to both epod and portal messages
Set-up and Configuration	No set-up/configuration required

PRODUCT DEVELOPMENT

Log Number: 00586071

Summary of Call	The ISO-3166-1 Alpha-3 code is required for the countries
Detail of Fix	Add new in parameter to the HERE maps call for get_lat_long and get_lat_long_fails, in addition ensure that all http requests are ended regardless of success or failure.
Set-up and Configuration	No set-up/configuration required

Log Number: 00600899

Summary of Call	Country Code not being found in distance and time calculation
Detail of Fix	The new 3 digit country code was not found in the distance and time procedure of the DP_NOKIA_LOC_PLAT package, causing a failure to find the correct values
Set-up and Configuration	No set-up/configuration required

Log Number: 00601913

Summary of Call	Not All overseas addresses return a result form HERE Maps
Detail of Fix	Corrected URL for overseas addresses to include an '&' where required
Set-up and Configuration	No set-up/configuration required

Log Number: 00629930

Summary of Call	Here Maps returning incorrect time / distance
Detail of Fix	Changes made to distance and time calculations when multiple legs returned from NOKIA
Set-up and Configuration	No set-up/configuration required

Log Number: 00565471

Summary of Call	Errors in ADM_LOG on live system
Detail of Fix	Only stores 50 characters for the customer's name from the CUST_NAME order sub-reference. An API message for the new trailer type for a trip stop will be generated. Auditing messages have been removed from the interface for Webfleet.
Set-up and Configuration	No set-up/configuration required

Log Number: 00571999

Summary of Call	ORS inconsistencies
Detail of Fix	Script created to correct issues
Set-up and Configuration	No set-up/configuration required

Log Number: 00608993

Summary of Call	Layout issues in ORDERS_WIDE screen
Detail of Fix	Cosmetic Layout issues corrected
Set-up and Configuration	No set-up/configuration required

MODULES DELIVERED

Module Name	Version No	Description	Log Number
AT_GEO_COUNTRY_586071.sql	1.2	Data Script	00586071
AT_GEO_LOCATION_02756193.sql	1.1	Data Script	02756193
AT_ORG_CUSTOMER_02756193.sql	1.1	Data Script	02756193
AT_REV_COST_CENTRE_02756193.sql	1.1	Data Script	02756193
AT_TES_EDI_ORDER_HEADER_543347.sql	1.1	Data Script	00543347
AT_TES_EDI_ORDER_HEADER_6130005.sql	1.1	Data Script	00613005
AT_TES_EDI_ORDER_HEADER_632041.sql	1.1	Data Script	00632041
BDM.fmx	2.111	Business Data Form	00585183
CT_1_TES_EDI_ORDER_HEADER_543347.sql	1.1	Data Script	00543347
CT_RES_VEHICLE_INFORMATION_02756193.sql	1.1	Data Script	02756193
CT_SEQ_TES_EDI_ORDER_DETAILS__543347.sql	1.1	Data Script	00543347
CT_SEQ_TES_EDI_ORDER_HEADER__543347.sql	1.1	Data Script	00543347
CT_TES_EDI_ORDER_DETAILS_543347.sql	1.1	Data Script	00543347
CUST_COST.fmx	2.146	Customer Maintenance form	02756193
DATA_ADM_FORM_TAB_02756193.sql	1.1	Data Script	02756193
DATA_ADM_FORM_TAB_543347.sql	1.1	Data Script	00543347
DATA_ADM_FORM_TAB_585190.sql	1.1	Data Script	00585190
DATA_ADM_LOG_PROG_NAME_586071.sql	1.1	Data Script	00586071
DATA_ADM_MSEL_FORM_PARAM_528798.sql	1.2	Data Script	00528798
DATA_ADM_SYSTEM_PARAM_02730386.sql	1.1	Data Script	02730386
DATA_ADM_SYSTEM_PARAM_543347.sql	1.1	Data Script	00543347
DATA_ADM_SYSTEM_PARAM_585191.sql	1.1	Data Script	00585191
DATA_ADM_SYSTEM_PARAM_586071.sql	1.1	Data Script	00586071
DATA_ADM_SYSTEM_PARAM_638199.sql	1.2	Data Script	00638199
DATA_ADM_SYSTEM_PARAM_CONFIG_02730386.sql	1.1	Data Script	02730386
DATA_ADM_SYSTEM_PARAM_CONFIG_543347.sql	1.1	Data Script	00543347
DATA_ADM_SYSTEM_PARAM_CONFIG_585187.sql	1.1	Data Script	00585187
DATA_ADM_SYSTEM_PARAM_CONFIG_638199.sql	1.2	Data Script	00638199
DATA_GEO_CONTACT_581531.sql	1.1	Data Script	00581531
DATA_GEO_COUNTRY_00586071.sql	1.2	Data Script	00586071
DATA_GEO_COUNTRY_ALIAS_600899.sql	1.1	Data Script	00600899
DATA_GEO_LOCATION_02756193.sql	1.1	Data Script	02756193
DATA_GEO_LOCATION_02756193.sql	1.2	Data Script	00614444
DATA_IMP_DECODE_543347.sql	1.1	Data Script	00543347
DATA_IMP_DECODE_576827.sql	1.1	Data Script	00576827
DATA_IMP_DECODE_613005.sql	1.1	Data Script	00613005
DATA_IMP_DECODE_ENTRY_528798.sql	1.1	Data Script	00528798
DATA_IMP_DECODE_ENTRY_543347.sql	1.1	Data Script	00543347
DATA_IMP_DECODE_ENTRY_576827.sql	1.1	Data Script	00576827
DATA_IMP_DECODE_ENTRY_613005.sql	1.2	Data Script	00613005
DATA_IMP_DECODE_ENTRY_632041.sql	1.1	Data Script	00632041
DATA_IMP_FIELD_02756193.sql	1.1	Data Script	02756193
DATA_ORD_BOOKING_STATUS_624191.sql	1.1	Data Script	00624191
DATA_ORS_MASTER_DATA_03171309.sql	1.1	Data Script	03171309
DATA_ORS_MASTER_DATA_1_02576193.sql	1.1	Data Script	02756193
DATA_ORS_MASTER_DATA_2_02576193.sql	1.2	Data Script	02756193
DATA_ORS_MASTER_DATA_3_02576193.sql	1.3	Data Script	02756193
DATA_ORS_MASTER_DATA_528798.sql	1.2	Data Script	00528798
DATA_ORS_MASTER_DATA_571999.sql	1.1	Data Script	00571999
DATA_ORS_MASTER_DATA_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_ACC_ACCNT_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_ACC_SRVCS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_ALL_ORDER_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_CARRIERS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_DRIVERS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_DU_TYPES_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_EX_TRAILER_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_HAUL_CHG_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_SRVCS_CAP_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_STD_ORDS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_STD_TRIPS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_TRACTORS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_TRAILERS_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_UNSCHED_585198.sql	1.1	Data Script	00585198
DATA_ORS_MASTER_DATA_ZONE_585198.sql	1.1	Data Script	00585198
DATA_ORS_SQL_03171309.sql	1.1	Data Script	03171309
DATA_ORS_SQL_1_02756193.sql	1.1	Data Script	02756193
DATA_ORS_SQL_2_02756193.sql	1.1	Data Script	02756193
DATA_ORS_SQL_3_02756193.sql	1.2	Data Script	02756193
DATA_ORS_SQL_528798.sql	1.2	Data Script	00528798
DP_3PL_SCHED.sql	5.17	3PL Scheduling Engine Database Package	00585174
DP_3PL_SCHED.sql	5.18	3PL Scheduling Engine Database Package	00585205
DP_CTMS_IMPORT.sql	5.51	API Import Database Package	00582177
DP_CUST_SERV.sql	1.100	Customer Service Package	00622372
DP_CUST_SERV.sql	1.101	Customer Service Package	00641104
DP_CUST_SERV.sql	1.102	Customer Service Package	00646471
DP_CUST_SERV.sql	1.92	Customer Service Package	00576827
DP_CUST_SERV.sql	1.93	Customer Service Package	00581531
DP_CUST_SERV.sql	1.94	Customer Service Package	00589819
DP_CUST_SERV.sql	1.95	Customer Service Package	00591939
DP_CUST_SERV.sql	1.96	Customer Service Package	00601011
DP_CUST_SERV.sql	1.97	Customer Service Package	00611084
DP_CUST_SERV.sql	1.98	Customer Service Package	00611272
DP_CUST_SERV.sql	1.99	Customer Service Package	00627741
DP_EPOD_WEB_SERVICE.sql	1.253	EPOD Web Service	00576827
DP_EPOD_WEB_SERVICE.sql	1.254	EPOD Web Service	00581533
DP_EPOD_WEB_SERVICE.sql	1.255	EPOD Web Service	00583217
DP_EPOD_WEB_SERVICE.sql	1.256	EPOD Web Service	00590646
DP_EPOD_WEB_SERVICE.sql	1.258	EPOD Web Service	00588541
DP_EPOD_WEB_SERVICE.sql	1.259	EPOD Web Service	00589803
DP_EPOD_WEB_SERVICE.sql	1.260	EPOD Web Service	00601998
DP_EPOD_WEB_SERVICE.sql	1.261	EPOD Web Service	00614441
DP_EPOD_WEB_SERVICE.sql	1.262	EPOD Web Service	00619005
DP_EPOD_WEB_SERVICE.sql	1.263	EPOD Web Service	00596532
DP_EPOD_WEB_SERVICE.sql	1.264	EPOD Web Service	00625686
DP_EPOD_WEB_SERVICE.sql	1.265	EPOD Web Service	00626445
DP_EPOD_WEB_SERVICE.sql	1.266	EPOD Web Service	00632231
DP_EPOD_WEB_SERVICE.sql	1.267	EPOD Web Service	00632457
DP_EPOD_WEB_SERVICE.sql	1.269	EPOD Web Service	00641104
DP_EPOD_WEB_SERVICE.sql	1.270	EPOD Web Service	00642165
DP_EPOD_WEB_SERVICE.sql	1.271	EPOD Web Service	00644267
DP_IMP_4.sql	4.4	Imports Package	02756193
DP_NOKIA_LOC_PLAT.sql	1.44	Nokia Location Platform Interface	00586071
DP_NOKIA_LOC_PLAT.sql	1.47	Nokia Location Platform Interface	00600899
DP_NOKIA_LOC_PLAT.sql	1.48	Nokia Location Platform Interface	00601913
DP_NOKIA_LOC_PLAT.sql	1.49	Nokia Location Platform Interface	00585176
DP_NOKIA_LOC_PLAT.sql	1.50	Nokia Location Platform Interface	00629930
DP_ORS_FUNCS.sql	5.33	Change to DOOD status function	02756193
DP_TES_EDI_IN.sql	1.10	Order Interface	00628135
DP_TES_EDI_IN.sql	1.11	Order Interface	00630454
DP_TES_EDI_IN.sql	1.12	Order Interface	00631428
DP_TES_EDI_IN.sql	1.13	Order Interface	00632041
DP_TES_EDI_IN.sql	1.14	Order Interface	00645781
DP_TES_EDI_IN.sql	1.16	Order Interface	00647837
DP_TES_EDI_IN.sql	1.3	Order Interface	00543347
DP_TES_EDI_IN.sql	1.4	Order Interface	00606761
DP_TES_EDI_IN.sql	1.5	Order Interface	00613005
DP_TES_EDI_IN.sql	1.6	Order Interface	00623186
DP_TES_EDI_IN.sql	1.7	Order Interface	00624902
DP_TES_EDI_IN.sql	1.9	Order Interface	00625942
DP_TOMTOM.sql	1.48	TomTom Package	00565471
DP_TOMTOM.sql	1.49	TomTom Package	02730386
GEOGRAPHY.fmx	2.24	Geography Screen	00586071
INT_ERR.fmx	1.114	Interface Errors	00543347
INT_ERR.fmx	1.115	Interface Errors	00623186
INT_XML_OUT2.sql	5.341	Outbound XML Package	02428249
INT_XML_OUT2.sql	5.342	Outbound XML Package	00605864
INT_XML_OUT2.sql	5.343	Outbound XML Package	03755459
INT_XML_OUT2.sql	5.344	Outbound XML Package	00638199
INT_XML_OUT2.sql	5.345	Outbound XML Package	00644267
LOCATION.fmx	2.215	Location Maintenance	00585191
LOCATION.fmx	2.216	Location Maintenance	00585190
LOCATION.fmx	2.217	Location Maintenance	02756193
LOCATION.fmx	2.218	Location Maintenance	00585193
LOCATION.fmx	2.219	Location Maintenance	00614901
OMS.sql	5.335	Order package	03719814
OMS.sql	5.336	Order package	00609264
ORDERS.fmx	2.457	Order Screen	00528798
ORDERS.fmx	2.458	Order Screen	00543347
ORDERS_WIDE.fmx	1.54	Orders Screen	00528798
ORDERS_WIDE.fmx	1.55	Orders Screen	00543347
ORDERS_WIDE.fmx	1.59	Orders Screen	00591663
ORDERS_WIDE.fmx	1.62	Orders Screen	00608993
ORS.fmx	1.39	Oracle Reporting suite	02756193
PAR.sql	5.117	Paragon Interface	00609264
PLANNING.fmx	1.152	Planning Screen	03010528
PLANNING.fmx	1.153	Planning Screen	00587165
RES_PERSON_CARRIER_UID.sql	5.5	Trigger	00632457
RES_PERSON_UID.sql	5.9	Trigger	00632457
RESOURCE.fmx	2.206	Resource Maintenance form	02756193
RESOURCE.fmx	2.207	Resource Maintenance form	00585182
RESOURCE.fmx	2.208	Resource Maintenance form	00586888
RESOURCE.fmx	2.209	Resource Maintenance form	00610089
RESOURCE.fmx	2.210	Resource Maintenance form	00585193
ROUTES_MAINT.fmx	2.57	Fixed Routes Maintenance	00585210
T_SCH_ORD_AUDIT.sql	5.21	Trigger for SCH_ORD_AUDIT	03549900
TRG_SCH_ORD_REFERENCE_AI.sql	1.6	Trigger on SCH_ORD_REFERENCE	00565471
TRG_SCH_ORD_SHIPMENT.sql	5.6	Trigger	03549900
TRG_SCH_ORD_VEHICLE_UID.sql	1.2	Trigger	00591914
TRG_SCH_ORD_XML_INT.sql	5.19	Trigger	02428249
TRG_SCH_TRIP_XML_INT.sql	5.41	Trigger	00617056
TRG_SOI_XML.sql	5.25	Trigger	02428249
TRG_SOL_XML.sql	5.54	Trigger	02428249
TRG_SOL_XML.sql	5.56	Trigger	00606083
TRG_STS_XML.sql	5.26	Trigger	00565471
TRG_STS_XML_OUT.sql	5.38	Trip Stop Trigger	02428249
TRG_STS_XML_OUT.sql	5.39	Trip Stop Trigger	00623640
TRG_TOMTOM_STOP_EVENTS_INSERT.sql	1.3	Trigger	02730386
TRG_TT_EVENTS_STORE.sql	1.10	Trigger	02767706
TRIP_OVERVIEW.fmx	1.77	Trip Waterfall	00585234
TRIP_OVERVIEW.fmx	1.78	Trip Waterfall	00585177
TRIP_RES_DIARY.fmx	1.34	Resource Allocation	00585186
TRIPSUM.fmx	2.451	Trip Manipulation screen	00587165
TRM.sql	5.231	Trip manipulation package	00600347
V_VEHICLE_DETAILS.sql	5.9	View	00618294

ADDITIONAL CHANGES

EPOD/T2A

An ePOD change is required for the following logs:

• Log 590646 (Epod Server v4.5.1.26)

CTL

A CTL change is required for the following logs:

• Log 581531 (CTL v3.1.34)
• Log 601011 (CTL v3.1.38)
• Log 618294 (CTL v3.1.39)