PATCH C-TMS P042

Release Notes

CALIDUS TMS

13th July 2022 - 1.0
Reference: P042

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: 00239646

Summary of Call	SCR-CTMS-440451-03 CTMS Database Changes
Detail of Fix	Database scripts to modify the database for the new items.
Set-up and Configuration	No set-up/configuration required

Log Number: 00249891

Summary of Call	SCR-CTMS-440451-08 Screen changes - fleet inspection periods
Detail of Fix	Added new tab page 'Fleet Inspection' to the LOCATION form. Database script for enabling 'Fleet Inspection' tab page in Access Groups screen.
Set-up and Configuration	No set-up/configuration required

Log Number: 00260058

Summary of Call	SCR-CTL-440451-32A Calidus Reporting Hub
Detail of Fix	The ORS extract can be run from CTL
Set-up and Configuration	No set-up/configuration required

Log Number: 00260047

Summary of Call	SCR-CTL-440451-09 CTL Call Logging Screen
Detail of Fix	CTL changes - New development: Call logging screen
Set-up and Configuration	No set-up/configuration required

Log Number: 00244856

Summary of Call	SCR-CTMS-440451-13 CTMS Generation of service jobs by job (delivery)
Detail of Fix	Updated the description of the 'POD_ITEM_LEVEL' and 'EPOD_WS_MESSAGE_FORMAT' system parameters. The 'EPOD_ITEM_LEVEL' parameter will include 'IC', 'IP', 'LC' and 'LP' values to include item and product information to be included for item or line level for the 'EPOD_CONTAINERS'. Added 'Epod Mode' as a dropdown list to the delivery types in the 'Business Data Maintenance' screen. The 'Epod Mode' will include 'MODE1', 'MODE2', 'CALLOUT' and 'INSPECT'. The outbound EPOD message will assess the 'Epod Mode' for the delivery type of the order. The 'CALLOUT' mode will include 'EPOD_SERVICES' for the delivery jobs for the orders.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_ITEM_LEVEL	SYSTEM	IC	Send Containers for items
EPOD_ITEM_LEVEL	SYSTEM	IP	Send Containers for item products
EPOD_ITEM_LEVEL	SYSTEM	LC	Send Containers for lines
EPOD_ITEM_LEVEL	SYSTEM	LP	Send Containers for line products
EPOD_WS_MESSAGE_FORMAT	SYSTEM	PARCEL	EPOD message format
EPOD_WS_MESSAGE_FORMAT	SYSTEM	BULK	EPOD message format
EPOD_WS_MESSAGE_FORMAT	SYSTEM	RETAIL	EPOD message format
EPOD_WS_MESSAGE_FORMAT	SYSTEM	MODE1	EPOD message format
EPOD_WS_MESSAGE_FORMAT	SYSTEM	MODE2	EPOD message format
EPOD_WS_MESSAGE_FORMAT	SYSTEM	DELTYPE	EPOD message format - can be MODE1, MODE2 (default), CALLOUT or INSPECT mode for the delivery type to define where fields are sent in the web service message.

Log Number: 00252522

Summary of Call	SCR-CTMS-440451-20 CTMS Customer Vehicle Search webservice
Detail of Fix	New inbound CUSTOMER_VEHICLE_SEARCH
Set-up and Configuration	No set-up/configuration required

Log Number: 00274077

Summary of Call	Https calls for lat/long calcs
Detail of Fix	The wallet file and its password can be specified in system parameters 'HTTPS_WALLET_FILE' and 'HTTPS_PASSWORD' for the database when using 'https' url commands.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
HTTPS_WALLET_FILE	SYSTEM	Populated	The wallet file will be used for the 'https' url commands in the database.
HTTPS_WALLET_FILE	SYSTEM	Null	The wallet file will not be used for the 'https' url commands in the database.
HTTPS_PASSWORD	SYSTEM	Populated	The password will be used with the wallet file for the 'https' url commands in the database.
HTTPS_PASSWORD	SYSTEM	Null	The password will not be used with the wallet file for the 'https' url commands in the database.

Log Number: 01899265

Summary of Call	New API for external carrier
Detail of Fix	Changes to use a new Carrier API to send manifests and retrieve labels in json format.
Set-up and Configuration	No set-up/configuration required

Log Number: 01909696

Summary of Call	Mixmove development
Detail of Fix	A new interface for MIXMOVE to send manifests and receive scans
Set-up and Configuration	No set-up/configuration required

Log Number: 00260441

Summary of Call	SCR-CTL-440451-34 CTL Customer Reports
Detail of Fix	Added scripts to insert new ORS_TYPE named "TYRE_ORDS" to replicate STD_ORDS Added new ORS type 'TYRE_INSP' with levels 'ORDER AND TRIP', 'VEHICLE_TYRES', 'INSPECTIONS'.
Set-up and Configuration	No set-up/configuration required

Log Number: 01967222

Summary of Call	Carrier API Testing Incident
Detail of Fix	Amendment to Carrier API to allow continued tracking and audit for non API packs
Set-up and Configuration	No set-up/configuration required

Log Number: 01970111

Summary of Call	Changes to the Carrier API
Detail of Fix	Prevent the un pack message being displayed for LFE trips where the carrier only sends a single tracking record and the tracking records do not match the number of packed items
Set-up and Configuration	No set-up/configuration required

Log Number: 01969607

Summary of Call	Received Order Status tag and generate a reference record
Detail of Fix	Create audit records for ORDER_STATUS as received in AX. Include the VEHCILE_CODE in the outbound event back to AX.
Set-up and Configuration	No set-up/configuration required

Log Number: 00256955

Summary of Call	SCR29 - Oracle Development
Detail of Fix	Modified 'IMP' package to include the new import types 'TYRES' and 'CUST_FLEET'
Set-up and Configuration	No set-up/configuration required

Log Number: 01969399

Summary of Call	Status change on IF054 to include Tendered
Detail of Fix	Changes to inbound files to set to status ACCEPTED if currently at status PLANNED or TENDERED
Set-up and Configuration	No set-up/configuration required

Log Number: 00250543

Summary of Call	SCR-CTL-440451-32B CTL Fleet Inspection Analysis Report
Detail of Fix	Corrected system parameters which had hardcoded value
Set-up and Configuration	No set-up/configuration required

Log Number: 00284500

Summary of Call	Carrier API changes to the label
Detail of Fix	Carrier API changes to the label details
Set-up and Configuration	No set-up/configuration required

Log Number: 00261979

Summary of Call	CTMS Development with EPOD for 261925 440451-26.
Detail of Fix	Updates from EPOD: A new system parameter called 'EPOD_COMPLETE_ON_LOAD_UPDATE' can be configured by cost centre to enable the trips to be set to status 'COMPLETED' for a load update. The system parameter 'EPOD_COMPLETE_ON_RTD' should be set to 'N' when 'EPOD_COMPLETE_ON_LOAD_UPDATE' is set to 'Y'. The trip status will not be updated to 'COMPLETED' except when updating loads when 'EPOD_COMPLETE_ON_LOAD_UPDATE' is set to 'Y'. Trip planning from CTL: The orders will be added to the trips for delivery. The driver, carrier and vehicle will be validated that they are active and for their combination. Any advised trips for the order must have the same driver, carrier and vehicle for the order to be added to that trip. The trips will have a shift for the driver if the order is being delivered within that shift and the driver does not have a planned diary exception for that time (e.g. for annual leave or sickness). These trips will have start and end times for the times for the shift. The trips will have a diary exception for the driver outside of the shift for the driver (e.g. overtime). These trips will have start and end times for the times for the diary exception. If an order is being planned outside of a shift for the driver and without a diary exception (e.g. overtime), the trip will have start and end times based on the standard distance and time calculations based on the time windows for the order.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_COMPLETE_ON_LOAD_UPDATE	COST_CENTRE	Y	The trips will be set to status 'COMPLETED' for a load update.
EPOD_COMPLETE_ON_LOAD_UPDATE	COST_CENTRE	N	The trips will not be set to status 'COMPLETED' for a load update.

Log Number: 00287229

Summary of Call	3pl carrier configuration
Detail of Fix	Changes to the 3PL carrier rating to take into account the number of trips a carrier can be assigned per day. Additional changes to the rating card to include a new condition type TRAILER_GRP
Set-up and Configuration	No set-up/configuration required

Log Number: 00265284

Summary of Call	SCR-CTMS-440451-14 CTMS Update of service jobs by job (delivery) type
Detail of Fix	The driver assignment for shifts will allow a vehicle to be optional
Set-up and Configuration	No set-up/configuration required

Log Number: 00287039

Summary of Call	SCR-CTL-440451-34 CTL Customer Reports - Amendments to TYRE_ORDS extract
Detail of Fix	TYRE_ORDS is amended to contain two new fields called Rejection Reason Code and Rejection Reason from the late reason codes for the order.
Set-up and Configuration	No set-up/configuration required

Log Number: 00287384

Summary of Call	Trip ID Development
Detail of Fix	Changes to the trip id format to use the owning depot to set trip id prefix. Controlled by new system Parameter SCH_TRIP_ID_DEPOT.
Set-up and Configuration	No set-up/configuration required

Log Number: 00287950

Summary of Call	SCR-CTL-440451-29 Additional Requirements for the CUST_FLEET import.
Detail of Fix	The 'CUST_FLEET' import type has been modified to include a new field and to create new vehicles. The field 'REG_FLEET_NUMBER' will be mandatory but a valid tractor code for the vehicle need not be provided. The vehicle will be created when a new registration number is provided. A new optional field called 'CUSTOMER_ID' is available. If a customer is provided it must contain a valid customer code. The customer will be used to make the vehicle available in the advised 'BRANCH' location.
Set-up and Configuration	No set-up/configuration required

Log Number: 00287894

Summary of Call	SCR-CTL-440451-32D Additional Requirements to the ORS screen
Detail of Fix	Req filed is made editable and Added buttons called 'Req All' and 'Req None' , which can be saved and extract can be created
Set-up and Configuration	No set-up/configuration required

Log Number: 00287638

Summary of Call	SCR-CTL-440451 Additional Requirements
Detail of Fix	System parameter 'EPOD_SEND_EPL_LAT_LONG' will be available to configure by cost centre to send the 'EPL_LAT' and 'EPL_LONG' elements for jobs to EPOD. System parameter 'EPOD_SEND_ITEM_AKA_CODE' will be available to configure by cost centre to send the item AKA code instead of the item identifier in the 'EPL_PRODUCT_CODE' element for jobs to EPOD. Sends element 'EPL_UNIT_TYPE' for the service with the vehicle configuration ID. Sends the ordered quantity instead of 0 when the quantity to deliver is not set for the order item as the 'EPL_QUANTITY'. Amendments to inbound jobs from EPOD with service updates to use the product code from the service activities as well as the service products.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_SEND_EPL_LAT_LONG	COST_CENTRE	Y	Sends EPL_LAT or EPL_LONG for EPOD_JOB_ADDRESS
EPOD_SEND_EPL_LAT_LONG	COST_CENTRE	N	Does not send EPL_LAT or EPL_LONG for EPOD_JOB_ADDRESS
EPOD_SEND_ITEM_AKA_CODE	COST_CENTRE	Y	Sends item AKA code for EPL_PRODUCT_CODE instead of item identifier but not instead of DU type for container products
EPOD_SEND_ITEM_AKA_CODE	COST_CENTRE	N	Does send item AKA code for EPL_PRODUCT_CODE instead of item identifier but not instead of DU type for container products

Log Number: 00293881

Summary of Call	SCR-CTMS-Issue 31 Send reason codes to EPOD for the RVC
Detail of Fix	Created trigger on RES_VEHICLE_CONFIG which sends EPOD_REASON_CODE for insert, update (with action 'A') or delete (with action 'X') as configured for the carriers or the cost centres.
Set-up and Configuration	No set-up/configuration required

Log Number: 00266101

Summary of Call	API release
Detail of Fix	New API method for receiving Orders and sending Trip events from and to source systems
Set-up and Configuration	No set-up/configuration required

Log Number: 00294849

Summary of Call	SCR-CTL-440451-29 Additional Requirements for the CUST_FLEET import
Detail of Fix	The 'CUST_FLEET' import type has been modified to include a new field and to create new vehicles. The field 'REG_FLEET_NUMBER' will be mandatory but a valid tractor code for the vehicle need not be provided. The vehicle will be created when a new registration number is provided. A new optional field called 'CUSTOMER_ID' is available. If a customer is provided it must contain a valid customer code. The customer will be used to make the vehicle available in the advised 'BRANCH' location. This case is linked to 287950 for 440451-29.
Set-up and Configuration	No set-up/configuration required

Log Number: 00294874

Summary of Call	SCR-CTMS-Issue 37 Send Removal items to EPOD after creation in CTL
Detail of Fix	EPOD_SERVICE_PRODUCT is modified to include EPL_DIRECTION to 'R', and EPL_QUANTITY = 1 when service_type is 'REMOVAL', other values are as generated for the original tyre. Altered SCH_ORD_ITEMS to include new column SERVICE_TYPE (eg: REMOVAL).
Set-up and Configuration	No set-up/configuration required

Log Number: 00295843

Summary of Call	CTY Issue 38 - 440451-20 Vehicle Searches
Detail of Fix	Modified DP_EPOD_WEB_SERVICE.EPOD_VEHICLE_SEARCH_IN So that the vehicle searches for the web service will not refer to the location usage directly to obtain the customer, they will use the customer locations for the vehicle themselves.
Set-up and Configuration	No set-up/configuration required

Log Number: 00279282

Summary of Call	TTM Interface changes
Detail of Fix	New sections for LOTS for tyres and order vehicles. See LOTS_EXPORT_TYRE for the sections for the tyres for the order and its items.
Set-up and Configuration	No set-up/configuration required

Log Number: 02030242

Summary of Call	Manually send orders via API
Detail of Fix	New menu items available in Orders screens to push orders out
Set-up and Configuration	No set-up/configuration required

Log Number: 00301397

Summary of Call	Release of V_VEHICLE_DETAILS on CTMS
Detail of Fix	New view for CTL.
Set-up and Configuration	No set-up/configuration required

Log Number: 00301831

Summary of Call	CTY - 440451-20 Amend format of the results for the Vehicle Searches
Detail of Fix	The Vehicle Searches will contain the results with the customer and location within the vehicle section.
Set-up and Configuration	No set-up/configuration required

Log Number: 00308136

Summary of Call	Enable Collection and delivery offsets
Detail of Fix	A new system parameter called 'CNT_SERVICE_LEVEL_OFFSETS' can be used to enable collection and delivery offsets for service levels 'Business Data Maintenance' screen. When its value is 'Y', the 6 new offset fields will be displayed for each service level. Coll/Del Offset field will contain a number of days between 0 and 999. Early/Late Col/Del offset fields will contain a number of minutes between 0 and 999999. Collection offsets cannot be greater than delivery offsets. The set of Coll/Del Offset and Early/Late Col/Del fields must be present to save the data.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
CNT_SERVICE_LEVEL_OFFSETS	SYSTEM	Y	Enables collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.
CNT_SERVICE_LEVEL_OFFSETS	SYSTEM	N	Does not enable collection and delivery offsets for service levels in the 'Business Data Maintenance' screen.

Log Number: 02064763

Summary of Call	MixMove development request
Detail of Fix	Outbound 'MIXMOVE' will contain EDI parameters to send DU types and reusable assets. 'SEND_DU_TYPE' will include the 'DU_TYPE' tag for the order items when it is set to 'Y'. 'SEND_REUSABLE_ASSET' will remove the suffix for any reusable assets in the 'ITEM_IDENTIFIER' tag when it is set to 'Y'. Inbound 'MIXMOVE_SCNS' will contain an EDI parameter to receive reusable assets. 'SEND_REUSABLE_ASSET' will reattach the suffix for any reusable assets on the order from the 'ITEM_IDENTIFIER' tag when it is set to 'Y'.
Set-up and Configuration	No set-up/configuration required

Log Number: 00310665

Summary of Call	CTY Issue 52 - Service jobs should not have Linked ID set against them when sent from CTMS to EPOD
Detail of Fix	When EPL_JOB_TYPE is set to 'S' then service jobs should not have Linked ID set against them when sent from CTMS to EPOD
Set-up and Configuration	No set-up/configuration required

Log Number: 02023242

Summary of Call	LFE POD Format Update
Detail of Fix	The creation of a tracking reference is audited when a label is printed for the order, and the deletion of a tracking reference is audited for the order. The 'CARRIER_POD' type of import will include new columns of data to extract from the file for the format that is being used: - POD_NAME - TRIP_ID - REASON_TEXT The 'DELIVERED' field should be 'FIXED' to 'Y' to enable only the 'Delivered' events to be processed in the message. The 'LFE POD' message contains validation of the size and type of the data. The delivered tracking reference must exist for the advised order reference. The order lines will be updated as delivered as they have been packed and despatched. The orders will be updated with information about the signatory and the reason code for the delivery.
Set-up and Configuration	No set-up/configuration required

Log Number: 02069048

Summary of Call	Services case 02069048
Detail of Fix	The ‘On Time Items (Assets)’ extract does not include the ‘Child Asset’ column of data. The ‘On Time Items’ extract continues to include the ‘Child Asset’ column of data.
Set-up and Configuration	No set-up/configuration required

Log Number: 02064838

Summary of Call	BOBS Extract
Detail of Fix	A new database view called V_SCH_TRIP_STATUS has been created to select records from the auditing of the trips. The following columns will be available to query: STA_SCHED_NAME STA_TRIP_ID STA_TRIP_STATUS STA_ACTION_DATE STA_ACTIONED_BY The data will be selected in the following sequence: STA_SCHED_NAME STA_TRIP_ID And then by an audit number which will correspond to the STA_ACTION_DATE. Access has been granted to MTS_USER and BOBS_ROLE.
Set-up and Configuration	No set-up/configuration required

Log Number: 02011793

Summary of Call	Amend and Cancel Carrier API calls
Detail of Fix	Carrier API changes to call the amendment process when an order is re-packed and the cancel process when an order is UNSCHEDULED.
Set-up and Configuration	No set-up/configuration required

Log Number: 00274074

Summary of Call	Change https calls to include a system param for a wallet and password
Detail of Fix	https has to be used in 19c databases – change is to use the wallet file. Changed https calls to include system parameters called HTTPS_WALLET_FILE and HTTPS_PASSWORD for secure call. Any databases that make calls to TOMTOM will need to implement these new system parameters to replace the system parameter called HTTP_WALLET_TOMTOM.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
HTTPS_WALLET_FILE	SYSTEM	NONE	The HTTP calls will continue.
HTTPS_WALLET_FILE	SYSTEM	Wallet File Name	The HTTPS calls will refer to this wallet file on the server for secure calls.
HTTPS_PASSWORD	SYSTEM	NONE	The HTTP calls will continue.
HTTPS_PASSWORD	SYSTEM	Password	The HTTPS calls will refer to this password for the wallet file on the server for secure calls.

Log Number: 00273451

Summary of Call	SCR-CTMS-440451-06 CTMS Internal Integration
Detail of Fix	System parameter 'API_WS_ELUCID_ADDRESS' can be used to specify the address for the Elucid interface. System parameters 'API_WS_ELUCID_USER' and 'API_WS_ELUCID_PASSWD' can be used to specify access for the Elucid interface. This address will be used in preference to the generic 'API_WS_ADDRESS' when the EDI parameter 'API_USE_WS_ELUCID' is 'Y'. The EDI parameter 'API_INC_CANCELLED' can be set to 'Y' to include orders that are 'CANCELLED' as well as 'FAILED'. Customer imports can be run by calling the 'DP_CTMS_IMPORT.IMPORT_CUSTOMER' function."
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
API_WS_ELUCID_ADDRESS	SYSTEM	Populated	This address will be used in preference to the generic 'API_WS_ADDRESS' when the EDI parameter 'API_USE_WS_ELUCID' is 'Y'.
API_WS_ELUCID_ADDRESS	SYSTEM	Null	This address will not be used in preference to the generic 'API_WS_ADDRESS' when it is null or the EDI parameter 'API_USE_WS_ELUCID' is not 'Y'.
API_WS_ELUCID_USER	SYSTEM	Populated	This user will be used to access the Elucid interface.
API_WS_ELUCID_USER	SYSTEM	Null	There will not be access to the Elucid interface.
API_WS_ELUCID_PASSWD	SYSTEM	Populated	This password will be used to access the Elucid interface.
API_WS_ELUCID_PASSWD	SYSTEM	Null	There will not be access to the Elucid interface.

Log Number: 00310663

Summary of Call	CTY Issue 42 - Sending activity records across to EPOD from CTMS
Detail of Fix	Sending activity records across to EPOD from CTMS. RVT table is altered to add two new columns RVT_NEW_REMOULD and RVT_REGROOVED. EPOD_JOB_IN is modified to update RVT with OTI/SOI EPOD_OUT is changed to use RVT in EPOD_SERVICE_ACTIVITY PRESSURE and SIZE are populated as per requirement in a cascade of levels
Set-up and Configuration	No set-up/configuration required

Log Number: 02108659

Summary of Call	Provide Planners with AX status
Detail of Fix	A new system parameter called 'TRM_SOURCE_SYSTEM' will be used to display a new field called 'Source System Status' in the 'Trip Details' tab page in the 'Planning' screen. When this parameter is set to 'Y' and the source system status for the trip is either 'IN PROGRESS' or 'CLOSED', then the fields on the 'Trip Details' and 'Stops' tab pages will be displayed in white text on a red background to advise the user that that trip is active in the WMS source system and that it should not be amended manually. The order will store a reference called 'ORDER_WMS_STATUS' from the 'ORDER_STATUS' tag in the 'ORDER_HEADER' section of the order message from the API. This WMS order status will update the source system status of the relevant trip for the order. A 'STAGED' WMS order status will update any trunk trips for the order, otherwise the delivery trip will be updated for the order. Note that the source system status of the trip will not revert to a previous status should one of its orders be advised with a new WMS order status out of sequence; the sequence 'OPEN' to 'IN PROGRESS' to 'CLOSED' will be followed.
Set-up and Configuration	No set-up/configuration required

Log Number: 02112078

Summary of Call	Add additional text to the supplier manifest
Detail of Fix	Carrier 3PL Emails - Generate Tender, Tender amendment and cancel emails to Carriers
Set-up and Configuration	No set-up/configuration required

Log Number: 00296022

Summary of Call	Auditing API
Detail of Fix	DP_EXPORT_EVENTS is modified to use two edi_process_triggers AUDIT_STATUS for the status from EVENTS_OUT.And AUDIT_METHOD for the storage option. Then audit the NAK/ACK responses and store them in audit records or text FILE accordingly. DP_CTMS_IMPORT- (import_order and import_customer functions) are modified to use two edi_process_triggers AUDIT_STATUS for the status and AUDIT_METHOD for the storage option. To choose the audit responses as NAK/ACK/NAK,WAK/ALL and store them in audit records or text FILE accordingly.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
AUDIT_STATUS	-	ALL	EDI parameter AUDIT_STATUS default value is set to 'ALL'
AUDIT_METHOD	-	WS	EDI parameter AUDIT_METHOD default value is set to 'WS'

Log Number: 02108654

Summary of Call	Create a new NAK email event
Detail of Fix	New email messages for NAK events. Setup: The new system parameter called 'MSG_NAKS' can be set to 'Y' to trigger email messages for 'NAK' events. The new system parameter called 'MSG_NAKS_EMAIL' can be used to store email addresses for 'NAK' events (delimited by semi-colons). The new system parameter called 'MSG_NAKS_TYPE' to list the types of processes for 'NAK' events (delimited by commas). A new message type called 'NAK_MSG' is present to enable the email messages to be processed for 'NAK' events’. A new import decode type called 'MSG_NAK_EVENTS' is available to configure the text for the emails for the type of messages being generated, for example: 'INBOUND' as 'Inbound from EPOD' 'IN_API_ORD' as 'Inbound order from AX' 'IN_API_CUST' as 'Inbound customer from Elucid' 'OUT_API' as 'Outbound to AX' 'OUTBOUND' as 'Outbound to EPOD'
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
MSG_NAKS	SYSTEM	Y	Triggers the emails for NAK events in the EPOD web service auditing.
MSG_NAKS	SYSTEM	N	Does not send an email to a recipient for a message for NAK responses.
MSG_NAKS_EMAIL	SYSTEM	Populated	Sends an email to the recipient(s) for a message for NAK responses.
MSG_NAKS_EMAIL	SYSTEM	Null	Does not send an email to a recipient for a message for NAK responses.
MSG_NAKS_TYPE	SYSTEM	Populated	Lists the type of processes to trigger the emails for NAK events in the EPOD web service auditing.
MSG_NAKS_TYPE	SYSTEM	Null	Does not send an email to a recipient for a message for NAK responses.

Log Number: 00530144

Summary of Call	Webfleet Change
Detail of Fix	Changes to the outbound Webfleet interface to send different OrderNo data and drip feed stops. Changes to the inbound interface to store in 3 new tables
Set-up and Configuration	No set-up/configuration required

Log Number: 00530148

Summary of Call	Customer Enquiry API and Text Messages
Detail of Fix	New Customer Enquiry API to receive an external reference and respond with the ETA. New TEXT API to send information to external system for generating text messages
Set-up and Configuration	No set-up/configuration required

Log Number: 00278514

Summary of Call	SCR-CTMS-440451-32D Operational Reports
Detail of Fix	New ORS types 'STD_TIMES', 'TYREKEYCUS' and 'TYREKEYGRP' have been created. A new system parameter called 'ORS_TYPE_DEF_GROUP_BY' with description 'List of the ORS types to default group by fields' will be used to identify ORS types that will default the 'Grp By' column from the master data to use in the report when the column itself may not be selected for display. The initial values will be 'TYREKEYCUS,TYREKEYGRP' to default the 'Period', and the 'Customer' and 'Customer Group' fields respectively. The 'TYRE_KEY' reports will have separate types to report by 'Customer' or by 'Customer Group', they will be known as 'TYREKEYCUS' and 'TYREKEYGRP' respectively. The 'Period' should be specified as a range of values in format 'YYYY-MM'. The 'Customer' and the 'Customer Group' should be specified to optimise the production of the respective reports.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
ORS_TYPE_DEF_GROUP_BY	SYSTEM	NOT NULL	The 'Grp By' tick boxes will be populated by default from the master data, for example, 'TYREKEYCUS,TYREKEYGRP'.
ORS_TYPE_DEF_GROUP_BY	SYSTEM	NULL	The 'Grp By' tick boxes will not be populated by default from the master data.

Log Number: 02124442

Summary of Call	Paragon Interface
Detail of Fix	New API to link Paragon and CTMS
Set-up and Configuration	No set-up/configuration required

Log Number: 02133144

Summary of Call	BTO and TOT suppression in MIXMOVE
Detail of Fix	Suppress BTO and TOT media types to MIXMOVE
Set-up and Configuration	No set-up/configuration required

Log Number: 00311975

Summary of Call	Carrier API to take account of Bank Holidays
Detail of Fix	Ready date must not include bank holidays
Set-up and Configuration	No set-up/configuration required

Log Number: 00321455

Summary of Call	Audit API Amendments
Detail of Fix	Included all the changes that are mentioned in the below comments. DP_EXPORT_EVENTS is modified to change the Audit messages so that, ACK includes Only RESPONSE. NAK includes REQUEST/RESPONSE.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
AUDIT_STATUS	-	ALL	EDI parameter AUDIT_STATUS default value is set to 'ALL'
AUDIT_METHOD	-	WS	EDI parameter AUDIT_METHOD default value is set to 'WS'

Log Number: 02116783

Summary of Call	WebFleet amendment to receive text requests and respond
Detail of Fix	WEBFLEET changes to receive text messages from Drivers and respond with itinerary or re-sending orders
Set-up and Configuration	No set-up/configuration required

Log Number: 00323040

Summary of Call	CTMS exports to epod
Detail of Fix	The message to EPOD will contain a new field called EPL_AXLE_TYPE in the EPOD_SERVICE_ACTIVITIES section.
Set-up and Configuration	No set-up/configuration required

Log Number: 02131420

Summary of Call	Changes to WebFleet, Epod truncation, and trip id format
Detail of Fix	Requested amendments to the customer interface
Set-up and Configuration	No set-up/configuration required

BUGS

Log Number: 01584585

Summary of Call	CTL email notification
Detail of Fix	Fixed package to check for from email address etc. Fix view to display email flag correctly.
Set-up and Configuration	No set-up/configuration required

Log Number: 01929119

Summary of Call	Label changes
Detail of Fix	CTMS A new system parameter called 'OMS_INVALID_SAME_LOCS' can be set to 'Y' or 'N' (default). If 'Y', the order status will be 'INVALID' when the 'from' and 'to' locations are the same for master or child locations. The user will be warned when an order is entered in the 'Orders' screen and the locations are the same. Customer labels will account for any contacts for the order when the 'from' and 'to' locations. One label will be printed per item with the first contact included for the 'to' location. Portal Added check to OMS_INVALID_SAME_LOCS - if N then same allowed. If Y then Portal will give an error if user enters same to/from location. Checked printing labels OK with same location selected and multiple contacts. Amended Order Receipt to use Aptean logo instead of OBS.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
OMS_INVALID_SAME_LOCS	SYSTEM	Y	Orders will have a status of 'INVALID' when they have the same 'from' and 'to' locations. This validation will apply to 'master' and 'child' locations.
OMS_INVALID_SAME_LOCS	SYSTEM	N	Orders will not be invalid when they have the same 'from' and 'to' locations.

Log Number: 00279865

Summary of Call	TMS Browserless
Detail of Fix	Omitted Van Fleet, RIT and Carr ID because they are later additions and the current width will then be for those columns not ORDER_ID. Then the default width would be 725 and within the stated limit.
Set-up and Configuration	No set-up/configuration required

Log Number: 00281601

Summary of Call	Planning Screen RIT code
Detail of Fix	Add in DP_PAR_API to resolve RIT source information
Set-up and Configuration	No set-up/configuration required

Log Number: 00260026

Summary of Call	ORS Report - extending use of time zones
Detail of Fix	The ORS extracts should include the time zone for the user for their queries and their columns of data.
Set-up and Configuration	No set-up/configuration required

Log Number: 01976934

Summary of Call	Split Messages
Detail of Fix	Allow message types to be split into 2 jobs
Set-up and Configuration	No set-up/configuration required

Log Number: 01985598

Summary of Call	Code amendment to accommodate labels response greater then 32000
Detail of Fix	Changes to the label format to accommodate large numbers of labels
Set-up and Configuration	No set-up/configuration required

Log Number: 02042658

Summary of Call	LFE POD files not updating orders in CTMS with delivered qty
Detail of Fix	Advised that the setup can be changed to extract the data correctly. Added extra auditing when a tracking reference is not found for the order to update. Any double quotation marks will be removed.
Set-up and Configuration	No set-up/configuration required

Log Number: 02065820

Summary of Call	CTMS to EPOD interface
Detail of Fix	The outbound messages to EPOD will enable transport units of up to 30 characters in length to be included in the 'EPL_CONTAINER_ID' tag for the order items. An audit log will be written for any generic errors that occur during processing.
Set-up and Configuration	No set-up/configuration required

Log Number: 02066885

Summary of Call	Some items when scanned out count twice on the scanner and an item still showing as missing on the scanner after it has been scanned in.
Detail of Fix	The new system parameter called 'WCS_441_CHECK_DAYS' can be set to a number of days in which to assess the prior loading messages for WCS. The default number of days will be 10 days prior to the system date. Assesses if the '441' message should be sent to C-WCS to advise the loading of an item on a trip. An item will not be sent for loading when it has been created for a new order on the same trip as the original order when that item is received into the depot on an unexpected trip. An item will not be sent for loading when it has been created for a new order that has been loaded onto an unexpected trip. An item will be sent for loading when it has been moved into a new despatch bay, or when it has had its previous loading message for the same despatch bay deleted in the meantime.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
RDT_441_CHECK_DAYS	SYSTEM	POPULATED	Sets a number of days in which to assess the prior loading messages for WCS. The default number of days will be 10 days prior to the system date.

Log Number: 02041304

Summary of Call	Order XML not updating lines
Detail of Fix	The DSPD messages will add all the advised tracking references to orders that are being packed and despatched at that time from the warehouse.
Set-up and Configuration	No set-up/configuration required

Log Number: 01984366

Summary of Call	Items flagging as unknown items on the scanner when it comes to outbound scan
Detail of Fix	The system parameter 'TRM_MOVE_ITEM_TO_DESP_BAY' can be used to move an item to the despatch bay when it is added to the order on the trip or its order is assigned to the trip. 'Adding Orders to Trips': The system parameter 'TRM_MOVE_ITEM_TO_DESP_BAY' can be used to move an item without a current location, from the grid, or from another despatch bay in the depot to the despatch bay when its order is added to the trip. It will be moved to the despatch bay for its planned trip out of the depot when 'TRM_MOVE_ITEM_TO_DESP_BAY' is 'Y'. It will not be moved to the despatch bay for its planned trip out of the depot when 'TRM_MOVE_ITEM_TO_DESP_BAY' is 'N'.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
TRM_MOVE_ITEM_TO_DESP_BAY	SYSTEM	Y	Move an item to the despatch bay when it is added to the order on the trip or its order is assigned to the trip.
TRM_MOVE_ITEM_TO_DESP_BAY	SYSTEM	N	Does not move an item to the despatch bay when it is added to the order on the trip or its order is assigned to the trip.

Log Number: 02117529

Summary of Call	Access Control - Resources tab
Detail of Fix	Tab following pages are enabled to authorise for user groups in the 'Resource Maintenance' screen: 1. Carriers 2. Carrier Groups 3. Carrier Lanes 4. Carrier Types 5. Carrier Service Level 6. Service Types 7. Fixed Charges 8. Trailer Types 9. Trailer Group 10. Trailers 11. Drivers 12. Loc Prd Conv 13. Despatch Unit Types 14. Standardised Du's 15. RPE's 16. RPE Cust 17. Load Rates 18. Tractors 19. Vessels 20. Resource Availability 21. Carrier Routing 22. Carrier Routing UKMail 23. Carrier Formats 24. Carrier Tracking 25. Carrier Config 26. Vehicles 27. Carrier Hazard Qty 28. Own Charges 29. Carrier Formats Mapping 30. Prd DU Load 31. Equipment
Set-up and Configuration	No set-up/configuration required

Log Number: 02126440

Summary of Call	Missing ORS Fields
Detail of Fix	Missing ORS fields. Add inactive flag (from 359779) and free text fields (from dev 373170)
Set-up and Configuration	No set-up/configuration required

Log Number: 02112923

Summary of Call	Portal - Order Entry
Detail of Fix	Changed the route query to use a distinct set of values. Added ROLLBACK for when an order fails to auto-plan to a trip.
Set-up and Configuration	No set-up/configuration required

Log Number: 02069996

Summary of Call	Deadlocks between EPOD & TomTom
Detail of Fix	Any changes will be rolled back when an EPOD job detects a locked record or another error has occurred during processing.
Set-up and Configuration	No set-up/configuration required

Log Number: 02123480

Summary of Call	CTMS Orders which should have autoscheduled to trips went on Express
Detail of Fix	Orders will be resubmitted later should an error occur in the standard scheduling engine for parcel carriers due to record locking or unique constraints being detected due to concurrent user activity in the Planning screen. Then the order will not assess the next route for the same carrier or a route for the next carrier.
Set-up and Configuration	No set-up/configuration required

Log Number: 02131348

Summary of Call	API import to check order status
Detail of Fix	Only write PAR record for amendments based on status, RIT, vehicle and manual schedule check
Set-up and Configuration	No set-up/configuration required

Log Number: 02124954

Summary of Call	Reporting suite edi COMMENTS_BIOSTRMEL - contact name
Detail of Fix	The contact name for the orders in the ORS extracts can contain the forename and the surname.
Set-up and Configuration	No set-up/configuration required

Log Number: 02110684

Summary of Call	Order Entry - Delivery Type
Detail of Fix	The standard and fast order entry screens will exclude inactive delivery types and service levels from the lists of values for selection.
Set-up and Configuration	No set-up/configuration required

Log Number: 02121883

Summary of Call	BASED_AT preventing search results
Detail of Fix	The forms(ORDERS and ORDERS_WIDE) are modified to include UNSCHEDULED orders based on FROM and TO locations.
Set-up and Configuration	No set-up/configuration required

Log Number: 00242929

Summary of Call	EDI Maintenance displays a password
Detail of Fix	In EDI_MAINT screen, the text attribute which was holding passwords is concealed so that it's not visible now. Added 'Conceal/Reveal' button to 'FTP_DETAILS' screen. The text attribute which was holding passwords is concealed so that it’s not visible at default state, when the authorized user clicks the reveal button it is displayed and can be concealed again by clicking conceal button. Added 'Save' Button to the 'FTP_DETAILS' screen. Added 'Validation' to both 'FTP_DETAILS' and 'DEVICE_WIN' screens, to check whether the user enters the required info for an FTP connection. Added new amendments should activate both the 'Save and Cancel' buttons on the 'EDI_MAINT' screen.
Set-up and Configuration	No set-up/configuration required

Log Number: 00256553

Summary of Call	REA - Interface Errors - Correction screen not always displaying the extracted data.
Detail of Fix	Temp Combo Field has been modified from Poplist to LOV, thereby Error correction field is able to extract all the data from the record being processed
Set-up and Configuration	No set-up/configuration required

Log Number: 00322735

Summary of Call	ORS report update
Detail of Fix	ORS update for date fields following an update for timezones
Set-up and Configuration	No set-up/configuration required

INCIDENTS

Log Number: 00282311

Summary of Call	ORS screen not always displaying a new report in the list of reports when the list is refreshed
Detail of Fix	Modified 'clear_form_safely' and 'pop_rep_list' in the ORS.fmb Form to mitigate the scrolling problem.
Set-up and Configuration	No set-up/configuration required

Log Number: 01988611

Summary of Call	CTMS - allow SFTP
Detail of Fix	Added general SFTP to product. Added to MIS processing so this can be sent out via SFTP.
Set-up and Configuration	No set-up/configuration required

Log Number: 00319844

Summary of Call	SRV: File failures in MIXMOVE
Detail of Fix	Files will be archived for MIXMOVE failures.
Set-up and Configuration	No set-up/configuration required

PRODUCT DEVELOPMENT

Log Number: 00233816

Summary of Call	Oracle testing
Detail of Fix	System parameter DEFAULT_ORACLE_DIRECTORY can be set to 'TMS_DIR' to activate the new functionality for 19c databases. UTL_FILE has been modified to create a new directory for 19c changes in databases. ​Able to generate both FTP and receive mail for EXPORTS, REPORTS and ORS in individual screens and EDI maintenance screen. Oracle system directories will need to be created for the database.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
DEFAULT_ORACLE_DIRECTORY	SYSTEM	TMP_DIR	The database will use system directories for file handling in 19c databases.
DEFAULT_ORACLE_DIRECTORY	SYSTEM	NONE	The standard file handling will apply.

MODULES DELIVERED

Module Name	Version No	Description	Log Number
AT_ACC_SERVICES_00278514.sql	1.1	Data Script	00278514
AT_CNT_DEL_TYPE_239646_440451.sql	1.1	Data Script	00239646
AT_CNT_SERVICE_LEVEL_00308136.sql	1.1	Data Script	00308136
AT_EPOD_WEB_SERVICE_AUDIT_00266101.sql	1.1	Data Script	00266101
AT_GEO_LOCATION_01909696.sql	1.1	Data Script	01909696
AT_GEO_LOCATION_239646_440451.sql	1.1	Data Script	00239646
AT_INT_ORD_XML_DETAILS_0026610	1.1	Data Script	00266101
AT_INT_XML_ORD_HEADER_00266101	1.1	Data Script	00266101
AT_ORD_TYRE_INSPECTION_287638.sql	1.1	Data Script	00287638
AT_ORG_CUSTOMER_00273451.sql	1.1	Data Script	00273451
AT_ORS_SQL_260441.sql	1.1	Data Script	00260441
AT_PAR_API_STAGING_00266101.sq	1.1	Data Script	00266101
AT_RES_CARRIER_01966393.sql	1.1	Data Script	00287229
AT_RES_TRACTOR_239646_440451.sql	1.1	Data Script	00239646
AT_RES_TRAILER_239646_440451.sql	1.2	Data Script	00239646
AT_RES_TRAILER_TYPE_01966393.s	1.1	Data Script	00287229
AT_RES_TRAILER_TYPE_296022.sql	1.1	Data Script	00296022
AT_RES_VEHICLE_TYRE_310663.sql	1.1	Data Script	00310663
AT_SCH_ORD_239646_440451.sql	1.1	Data Script	00239646
AT_SCH_ORD_ITEMS_00266101.sql	1.2	Data Script	00266101
AT_SCH_ORD_ITEMS_239646_440451.sql	1.2	Data Script	00239646
AT_SCH_ORD_ITEMS_265284.sql	1.1	Data Script	00265284
AT_SCH_ORD_ITEMS_294874.sql	1.1	Data Script	00294874
AT_SCH_ORD_TRACKING_01899265.sql	1.1	Data Script	01899265
AT_SCH_ORD_VEHICLE_287638.sql	1.1	Data Script	00287638
AT_SCH_TRIP_00266101.sql	1.1	Data Script	00266101
AT_SCH_TRIP_02108659.sql	1.1	Data Script	02108659
AT_TOMTOM_ETA_EVENTS_00530148.sql	1.1	Data Script	00530148
AT_TOMTOM_STOP_EVENTS_00530148.sql	1.1	Data Script	00530148
AT_WMS_PRODUCT_XREF_00278514.sql	1.1	Data Script	00278514
AT_WMS_PRODUCT_XREF_239646_440451.sql	1.1	Data Script	00239646
AT_WMS_PRODUCT_XREF_265284.sql	1.1	Data Script	00256955
AT_WMS_PRODUCT_XREF_265284.sql	1.1	Data Script	00265284
AT_WMS_PRODUCT_XREF_278514.sql	1.1	Data Script	00256955
BDM.fmx	2.103	Business Data Form	00244856
BDM.fmx	2.104	Business Data Form	00308136
CNT.sql	5.54	Contracts package	00287229
CT_API_LABEL_RESPONSE_01899265.sql	1.1	Data Script	01899265
CT_AUDIT_SEQ_CAR_API_01899265.sql	1.1	Data Script	01899265
CT_INT_XML_CUST_ADDRESS.sql	1.1	Data Script	00266101
CT_ORD_TYPE_INSPECTION_239646_440451.sql	1.2	Data Script	00239646
CT_PAR_API_STAGING_00266101.sql	5.1	Data Script	00266101
CT_PAR_CALL_API_00266101.sql	1.1	Data Script	00266101
CT_PAR_CUST_API_00266101.sql	1.1	Data Script	00266101
CT_PAR_JSON_IN.sql	1.2	Data Script	02124442
CT_PAR_JSON_IN_00266101.sql	1.1	Data Script	00266101
CT_PAR_KEYS_00266101.sql	1.1	Data Script	00266101
CT_PAR_TRIP_API.sql	1.2	Data Script	02124442
CT_RES_VEHICLE_AXLE_239646_440451.sql	1.2	Data Script	00239646
CT_RES_VEHICLE_CONFIG_239646_440451.sql	1.1	Data Script	00239646
CT_RES_VEHICLE_CONFIG_AXLE_239646_440451.sql	1.1	Data Script	00239646
CT_RES_VEHICLE_CUST_LOC_239646_440451.sql	1.3	Data Script	00239646
CT_RES_VEHICLE_TYRE_239646_440451.sql	1.2	Data Script	00239646
CT_SCH_ORD_VEHICLE_265284.sql	1.1	Data Script	00265284
CT_SEQ_API_FILE_IN.sql	1.1	Data Script	00266101
CT_SEQ_ETA_EVENT.sql	1.1	Data Script	00530144
CT_SEQ_ORD_TYRE_INSPECTION_239646.sql	1.1	Data Script	00239646
CT_SEQ_PAR_JSON_IN_00266101.sql	1.1	Data Script	00266101
CT_SEQ_RES_VEHICLE_AXLE_239646.sql	1.1	Data Script	00239646
CT_SEQ_RES_VEHICLE_CONFIG_239646.sql	1.1	Data Script	00239646
CT_SEQ_STOP_EVENT.sql	1.1	Data Script	00530144
CT_SFTP_UNKNOWN_HOSTS_01988611.sql	1.1	Data Script	01988611
CT_TOMTOM_ETA_EVENTS.sql	1.1	Data Script	00530144
CT_TOMTOM_STOP_EVENTS.sql	1.1	Data Script	00530144
CT_TOMTOM_VEHICLES.sql	1.1	Data Script	00530144
CT_TRM_CARRIER_COST.sql	1.1	Data Script	00287229
CT_VEHICLE_SEQ.sql	1.1	Data Script	00530144
DATA_1_IMP_IMPORT_TYPE_256955.sql	1.2	Data Script	00256955
DATA_1_MSG_EVENT_TYPE_02108654.sql	1.1	Data Script	02108654
DATA_1_ORS_MASTER_DATA_260441.sql	1.2	Data Script	00260441
DATA_1_ORS_MASTER_DATA_287039.sql	1.1	Data Script	00287039
DATA_1_ORS_SQL_00278514.sql	1.1	Data Script	00278514
DATA_1_ORS_SQL_260441.sql	1.4	Data Script	00260441
DATA_1_ORS_SQL_287039.sql	1.1	Data Script	00287039
DATA_2_IMP_IMPORT_TYPE_REC_TYPE.sql	1.2	Data Script	00256955
DATA_2_MSG_TYPE_02108654.sql	1.1	Data Script	02108654
DATA_2_ORS_MASTER_DATA_00278514.sql	1.1	Data Script	00278514
DATA_2_ORS_MASTER_DATA_260441.sql	1.2	Data Script	00260441
DATA_2_ORS_MASTER_DATA_287039.sql	1.1	Data Script	00287039
DATA_2_ORS_SQL_260441.sql	1.1	Data Script	00260441
DATA_2_ORS_SQL_287039.sql	1.1	Data Script	00287039
DATA_3_IMP_FIELD_256955.sql	1.3	Data Script	00256955
DATA_3_MSG_REQ_02108654.sql	1.1	Data Script	02108654
DATA_3_ORS_MASTER_DATA_260441.sql	1.3	Data Script	00260441
DATA_3_ORS_MASTER_DATA_287039.sql	1.1	Data Script	00287039
DATA_3_ORS_SQL_260441.sql	1.3	Data Script	00260441
DATA_3_ORS_SQL_287039.sql	1.1	Data Script	00287039
DATA_4_IMP_IMPORT_TYPE_256955.sql	1.2	Data Script	00256955
DATA_4_ORS_MASTER_DATA_260441.sql	1.3	Data Script	00260441
DATA_4_ORS_SQL_260441.sql	1.2	Data Script	00260441
DATA_5_IMP_IMPORT_TYPE_REC_TYPE.sql	1.2	Data Script	00256955
DATA_5_ORS_MASTER_DATA_260441.sql	1.2	Data Script	00260441
DATA_5_ORS_SQL_260441.sql	1.2	Data Script	00260441
DATA_6_IMP_FIELD_256955.sql	1.2	Data Script	00256955
DATA_6_ORS_MASTER_DATA_260441.sql	1.5	Data Script	00260441
DATA_6_ORS_SQL_260441.sql	1.2	Data Script	00260441
DATA_ADM_FORM_TAB_02117529.sql	1.1	Data Script	02117529
DATA_ADM_FORM_TAB_249891.sql	1.2	Data Script	00249891
DATA_ADM_FUNCTION_02030242.sql	1.1	Data Script	02030242
DATA_ADM_FUNCTION_242929.sql	1.1	Data Script	00242929
DATA_ADM_LOG_PROG_NAME_0198861.sql	1.1	Data Script	01988611
DATA_ADM_SYSTEM_PARAM_00244856.sql	1.1	Data Script	00244856
DATA_ADM_SYSTEM_PARAM_00266101.sql	1.1	Data Script	00266101
DATA_ADM_SYSTEM_PARAM_00273451	1.1	Data Script	00273451
DATA_ADM_SYSTEM_PARAM_00278514.sql	1.1	Data Script	00278514
DATA_ADM_SYSTEM_PARAM_00308136.sql	1.1	Data Script	00308136
DATA_ADM_SYSTEM_PARAM_00530144.sql	1.1	Data Script	00530144
DATA_ADM_SYSTEM_PARAM_00530148.sql	1.1	Data Script	00530148
DATA_ADM_SYSTEM_PARAM_01826171.sql	1.1	Data Script	00308136
DATA_ADM_SYSTEM_PARAM_01899265.sql	1.1	Data Script	01899265
DATA_ADM_SYSTEM_PARAM_01909696.sql	1.1	Data Script	01909696
DATA_ADM_SYSTEM_PARAM_01929119.sql	1.1	Data Script	01929119
DATA_ADM_SYSTEM_PARAM_01968623.sql	1.2	Data Script	00287384
DATA_ADM_SYSTEM_PARAM_01984366.sql	1.1	Data Script	01984366
DATA_ADM_SYSTEM_PARAM_01988611.sql	1.1	Data Script	01988611
DATA_ADM_SYSTEM_PARAM_02011793.sql	1.1	Data Script	02011793
DATA_ADM_SYSTEM_PARAM_02066885.sql	1.1	Data Script	02066885
DATA_ADM_SYSTEM_PARAM_02108654.sql	1.1	Data Script	02108654
DATA_ADM_SYSTEM_PARAM_02108659.sql	1.1	Data Script	02108659
DATA_ADM_SYSTEM_PARAM_02112078.sql	1.1	Data Script	02112078
DATA_ADM_SYSTEM_PARAM_233816.sql	1.1	Data Script	00233816
DATA_ADM_SYSTEM_PARAM_250543.sql	1.1	Data Script	00250543
DATA_ADM_SYSTEM_PARAM_261979.sql	1.1	Data Script	00261979
DATA_ADM_SYSTEM_PARAM_274077.sql	1.1	Data Script	00274077
DATA_ADM_SYSTEM_PARAM_279282.sql	1.1	Data Script	00279282
DATA_ADM_SYSTEM_PARAM_287638.sql	1.1	Data Script	00287638
DATA_ADM_SYSTEM_PARAM_CONFIG_261979.sql	1.1	Data Script	00261979
DATA_ADM_SYSTEM_PARAM_CONFIG_279282.sql	1.1	Data Script	00279282
DATA_ADM_SYSTEM_PARAM_CONFIG_287638.sql	1.1	Data Script	00287638
DATA_CNT_CONDITION_01966393.sq	1.1	Data Script	00287229
DATA_CNT_CONDITION_VALUE_01966	1.1	Data Script	00287229
DATA_EDI_FLOW_TYPES_01909696.sql	1.1	Data Script	01909696
DATA_EDI_PROCESS_TRIGGERS_296022.sql	1.1	Data Script	00296022
DATA_IMP_DECODE_02108654.sql	1.1	Data Script	02108654
DATA_IMP_FIELD_01899265.sql	1.1	Data Script	01899265
DATA_IMP_FIELD_02023242.sql	1.1	Data Script	02023242
DATA_IMP_FIELD_287950.sql	1.1	Data Script	00287950
DATA_IMP_IMPORT_TYPE_01899265.sql	1.1	Data Script	01899265
DATA_ORS_MASTER_DATA_02126440.sql	1.1	Data Script	02126440
DATA_ORS_MASTER_DATA_260026.sql	1.3	Data Script	00260026
DATA_ORS_MASTER_DATA_322735.sql	1.1	Data Script	00322735
DATA_ORS_USER_DETAILS_322735.sql	1.1	Data Script	00322735
DATA_REP_REPORT_02069048.sql	1.1	Data Script	02069048
DATA_REP_REPORT_PARAM_02069048	1.1	Data Script	02069048
DP_ASKGEO.sql	1.2	AskGEO Interface	00274074
DP_CARRIER.sql	1.95	Carrier Management	01929119
DP_CARRIER_API.sql	5.1	Carrier API	01899265
DP_CARRIER_API.sql	5.2	Carrier API	01970111
DP_CARRIER_API.sql	5.3	Carrier API	00284500
DP_CARRIER_API.sql	5.5	Carrier API	01985598
DP_CARRIER_API.sql	5.6	Carrier API	02011793
DP_CARRIER_API.sql	5.7	Carrier API	00274074
DP_CARRIER_API.sql	5.8	Carrier API	00311975
DP_CARRIER_API_JSON_stub.sql	1.1	Carrier API	01899265
DP_CSV6.sql	1.43	CSV Extract package	02069048
DP_CTMS_IMPORT.sql	5.1	API Import Database Package	00266101
DP_CTMS_IMPORT.sql	5.2	API Import Database Package	00273451
DP_CTMS_IMPORT.sql	5.4	API Import Database Package	00296022
DP_CTMS_IMPORT.sql	5.5	API Import Database Package	02131348
DP_CUST_SERV.sql	1.35	Customer Service Package	01584585
DP_CUST_SERV.sql	1.37	Customer Service Package	00260047
DP_CUST_SERV.sql	1.38	Customer Service Package	00308136
DP_EPOD_WEB_SERVICE.sql	1.135	EPOD Web Service	00244856
DP_EPOD_WEB_SERVICE.sql	1.136	EPOD Web Service	00252522
DP_EPOD_WEB_SERVICE.sql	1.137	EPOD Web Service	00261979
DP_EPOD_WEB_SERVICE.sql	1.138	EPOD Web Service	00265284
DP_EPOD_WEB_SERVICE.sql	1.139	EPOD Web Service	00287638
DP_EPOD_WEB_SERVICE.sql	1.140	EPOD Web Service	00294874
DP_EPOD_WEB_SERVICE.sql	1.141	EPOD Web Service	00295843
DP_EPOD_WEB_SERVICE.sql	1.142	EPOD Web Service	00301831
DP_EPOD_WEB_SERVICE.sql	1.143	EPOD Web Service	02065820
DP_EPOD_WEB_SERVICE.sql	1.144	EPOD Web Service	00310665
DP_EPOD_WEB_SERVICE.sql	1.145	EPOD Web Service	00310663
DP_EPOD_WEB_SERVICE.sql	1.146	EPOD Web Service	02124442
DP_EPOD_WEB_SERVICE.sql	1.147	EPOD Web Service	02069996
DP_EPOD_WEB_SERVICE.sql	1.149	EPOD Web Service	00323040
DP_EPOD_WEB_SERVICE.sql	1.150	EPOD Web Service	02131420
DP_EXPORT_EVENTS.sql	5.10	API Export Database Package	02131420
DP_EXPORT_EVENTS.sql	5.2	API Export Database Package	01969607
DP_EXPORT_EVENTS.sql	5.3	API Export Database Package	00266101
DP_EXPORT_EVENTS.sql	5.4	API Export Database Package	00274074
DP_EXPORT_EVENTS.sql	5.5	API Export Database Package	00273451
DP_EXPORT_EVENTS.sql	5.7	API Export Database Package	00296022
DP_EXPORT_EVENTS.sql	5.9	API Export Database Package	00321455
DP_IMP.sql	5.42	Imports Package	01899265
DP_INT_XML_CFX.sql	1.6	Database Package	01969399
DP_LFE_POD.sql	5.1	LFE POD Database package	01899265
DP_LFE_POD.sql	5.2	LFE POD Database package	01970111
DP_LFE_POD.sql	5.4	LFE POD Database package	02042658
DP_LFE_POD.sql	5.5	LFE POD Database package	02023242
DP_MIS.sql	5.7	MIS Interface Package	01988611
DP_NOKIA_LOC_PLAT.sql	1.36	Nokia Location Platform Interface	00274077
DP_ORS_FUNCS.sql	5.27	Change to DOOD status function	00287039
DP_ORS_FUNCS.sql	5.28	Change to DOOD status function	00278514
DP_PAR_API.sql	5.1	Database Package	00281601
DP_PAR_API.sql	5.3	Database Package	02124442
DP_PAR_API.sql	5.7	Database Package	02131420
DP_PORTAL.sql	5.19	Portal Package	02112923
DP_RDT_FAST_LOAD.sql	5.32	Load confirmation message procedure	02066885
DP_REPORTS.sql	5.65	Reports package	00260058
DP_REPORTS.sql	5.66	Reports package	00278514
DP_REPORTS.sql	5.68	Reports package	02124442
DP_SCHEDULING_ENGINE.sql	5.178	Scheduling Package	02123480
DP_SFTP.sql	5.1	SFTP processing	01988611
DP_TOMTOM.sql	1.34	TomTom Package	00274074
DP_TOMTOM.sql	1.35	TomTom Package	00530144
DP_TOMTOM.sql	1.36	TomTom Package	02116783
DP_TOMTOM.sql	1.37	TomTom Package	02131420
DP_WEB_SERVICE_ENQUIRY.sql	1.6	Web Service Package	00530148
DP_WEB_SERVICE_ORD.sql	1.29	Web Service Package	01984366
DP_XML_EPOD.sql	1.2	XML Database Package	00265284
DP_XML_EPOD.sql	1.3	XML Database Package	00273451
EDI_MAINT.fmx	10.16	EDI Maintenance Screen	00242929
EPOD_WSA.fmx	1.8	EPOD Web Service Audit Form	00273451
EPOD_WSA.fmx	1.9	EPOD Web Service Audit Form	02108654
IMP.sql	5.210	CSV Imports Package	00256955
IMP.sql	5.212	CSV Imports Package	00287950
IMP.sql	5.213	CSV Imports Package	00266101
IMP.sql	5.214	CSV Imports Package	00294849
INT_ERR_ORD.fmx	2.9	Interface error correction	00256553
INT_XML_IN.sql	5.232	Order Import Package	01899265
INT_XML_IN.sql	5.234	Order Import Package	01909696
INT_XML_IN.sql	5.235	Order Import Package	02041304
INT_XML_IN.sql	5.236	Order Import Package	02064763
INT_XML_IN.sql	5.237	Order Import Package	00319844
INT_XML_IN_REFS.sql	1.14	Openfield Order upload procedures	02108659
INT_XML_OUT2.sql	5.321	Outbound XML Package	01909696
INT_XML_OUT2.sql	5.323	Outbound XML Package	00279282
INT_XML_OUT2.sql	5.324	Outbound XML Package	02064763
INT_XML_OUT2.sql	5.325	Outbound XML Package	02133144
LFS_LABEL.rep	1.24	Label Report	01929119
LFS_LABEL_MULTI.rep	1.12	Label Report	01929119
LOAD_MAN.fmx	1.28	Load Management Form	01984366
LOCATION.fmx	2.200	Location Maintenance	00249891
LOCATION.fmx	2.201	Location Maintenance	01909696
MSG_CONSTRUCTOR.sql	5.20	E-mail construction	02112078
MSG_CONSTRUCTOR.sql	5.21	E-mail construction	02131420
MSG_JOB.sql	5.12	Message job functionality	01976934
MSG_PROCESSING.sql	5.72	Message Processing package	02112078
MSG_PROCESSING.sql	5.73	Message Processing package	02108654
MSG_PROCESSING.sql	5.74	Message Processing package	02131420
OMS.sql	5.248	Order package	01929119
OMS.sql	5.249	Order package	00266101
OMS.sql	5.250	Order package	02124954
ORDERS.fmx	2.446	Order Screen	01929119
ORDERS.fmx	2.447	Order Screen	01899265
ORDERS.fmx	2.448	Order Screen	01967222
ORDERS.fmx	2.449	Order Screen	02030242
ORDERS.fmx	2.450	Order Screen	02110684
ORDERS.fmx	2.451	Order Screen	02121883
ORDERS_WIDE.fmx	1.42	Orders Screen	01929119
ORDERS_WIDE.fmx	1.43	Orders Screen	01899265
ORDERS_WIDE.fmx	1.44	Orders Screen	01967222
ORDERS_WIDE.fmx	1.45	Orders Screen	02030242
ORDERS_WIDE.fmx	1.46	Orders Screen	02110684
ORDERS_WIDE.fmx	1.47	Orders Screen	02121883
ORS.fmx	1.32	Oracle Reporting suite	00282311
ORS.fmx	1.34	Oracle Reporting suite	00287894
ORS.fmx	1.35	Oracle Reporting suite	00278514
ORS.sql	5.11	Oracle Reporting suite	02124442
PLANNING.fmx	1.123	Planning Screen	00287229
PLANNING.fmx	1.124	Planning Screen	00287384
PLANNING.fmx	1.125	Planning Screen	01970111
PLANNING.fmx	1.126	Planning Screen	00279865
PLANNING.fmx	1.127	Planning Screen	02108659
RATE.sql	5.162	Rates Tariff database package	00287229
RATE.sql	5.163	Rates Tariff database package	00266101
RATE.sql	5.164	Rates Tariff database package	02124442
RESOURCE.fmx	2.195	Resource Maintenance form	00287229
T_SCH_ORD_AUDIT.sql	5.19	Trigger for SCH_ORD_AUDIT	00265284
TI_SCH_ORD_STATUS.sql	1.22	Trigger on SCH_ORD for status change	00266101
TI_SCH_ORD_STATUS.sql	1.23	Trigger on SCH_ORD for status change	00273451
TI_SCH_ORD_STATUS.sql	1.24	Trigger on SCH_ORD for status change	02124442
TRG_EPOD_WEB_SERVICE_AUDIT.sql	1.4	Trigger	02108654
TRG_EPOD_WEB_SERVICE_AUDIT.sql	1.5	Trigger	02131420
TRG_GEO_LOCATION_UID.sql	5.2	Trigger	00266101
TRG_LOCATIONS_UID.sql	5.1	Trigger	02124442
TRG_ORD_TYRE_INSPECTION_BIU.sql	1.1	Trigger	00239646
TRG_ORD_TYRE_INSPECTION_BIU.sql	1.2	Trigger	00265284
TRG_ORD_TYRE_INSPECTION_BIU.sql	1.3	Trigger	00287638
TRG_RES_VEHICLE_AXLE_BIU.sql	1.1	Database Trigger	00239646
TRG_RES_VEHICLE_CONFIG_AXLE_BIU.sql	1.1	Database Trigger	00239646
TRG_RES_VEHICLE_CONFIG_BIU.sql	1.1	Database Trigger	00239646
TRG_RES_VEHICLE_CONFIG_EPOD.sql	1.1	Trigger	00293881
TRG_RES_VEHICLE_CUST_LOC_BIU.sql	1.1	Database Trigger	00239646
TRG_RES_VEHICLE_TYRE_BIU.sql	1.1	Database Trigger	00239646
TRG_SCH_ORD_CURRENT_DEPOT.sql	5.2	Trigger	00266101
TRG_SCH_ORD_CURRENT_DEPOT.sql	5.3	Trigger	02124442
TRG_SCH_ORD_INFORMATION_IU.sql	1.6	Trigger	00266101
TRG_SCH_ORD_ITEMS_REASONS.sql	5.15	Trigger	00266101
TRG_SCH_ORD_REFERENCE_AI.sql	1.4	Trigger on SCH_ORD_REFERENCE	01969607
TRG_SCH_ORD_REFERENCE_AI.sql	1.5	Trigger on SCH_ORD_REFERENCE	02108659
TRG_SCH_ORD_TRACKING.sql	1.1	Trigger	01970111
TRG_SCH_ORD_TRACKING.sql	1.2	Trigger	02023242
TRG_SCH_ORD_VEHICLE_BIU.sql	1.1	Trigger	00265284
TRG_SCH_ORD_VEHICLE_PAR.sql	5.2	Trigger	02124442
TRG_SCH_ORDER_LINE_PAR.sql	5.1	Trigger	02124442
TRG_SCH_TRIP_CARRIER_ID_U.sql	5.3	Trigger	02112078
TRG_SCH_TRIP_CARRIER_ID_U.sql	5.4	Trigger	02131420
TRG_SCH_TRIP_MTM_COST.sql	1.1	Trigger	00266101
TRG_SCH_TRIP_STOP_ACPT.sql	5.1	Trigger	02124442
TRG_SCH_TRIP_XML_INT.sql	5.36	Trigger	00266101
TRG_SCH_TRIP_XML_INT.sql	5.37	Trigger	00273451
TRG_SCH_TRIP_XML_INT.sql	5.38	Trigger	02112078
TRG_SCH_TRIP_XML_INT.sql	5.39	Trigger	02131420
TRG_SCH_TRIP_XML_MX.sql	1.1	Trigger	01909696
TRG_SHA_LOTS.sql	5.8	Trigger	00266101
TRG_SOI_XML.sql	5.23	Trigger	00273451
TRG_SOL_XML.sql	5.47	Trigger	00266101
TRG_SOL_XML.sql	5.48	Trigger	00273451
TRG_SONC_DELETE_MIS.sql	5.7	Trigger	00266101
TRG_STS_AI.sql	1.2	Trigger	00530144
TRG_STS_XML.sql	5.24	Trigger	00266101
TRG_STS_XML.sql	5.25	Trigger	00530144
TRG_STS_XML_OUT.sql	5.36	Trip Stop Trigger	00266101
TRG_TOMTOM_ETA_EVENTS_INSERT.sql	1.1	Trigger	00530148
TRG_TOMTOM_STOP_EVENTS_INSERT.sql	1.1	Trigger	00530144
TRG_TRIP_COST.sql	1.3	Trigger	02124442
TRG_TT_EVENTS_STORE.sql	1.1	Trigger	00530144
TRG_TT_EVENTS_STORE.sql	1.2	Trigger	00530148
TRG_TT_EVENTS_STORE.sql	1.3	Trigger	02124442
TRM.sql	5.204	Trip manipulation package	00261979
TRM.sql	5.205	Trip manipulation package	00287229
TRM.sql	5.206	Trip manipulation package	00265284
TRM.sql	5.207	Trip manipulation package	00287384
TRM.sql	5.208	Trip manipulation package	01984366
TRM.sql	5.209	Trip manipulation package	02011793
TRM.sql	5.210	Trip manipulation package	02124442
UTL_FILE.sql	5.3	UTL File Package	00233816
V_CTL_CUSTLOC.sql	5.3	View	00260047
V_CTL_MENUS.sql	5.2	View	00260047
V_DRIVER_LIST.sql	5.1	View	00308136
V_JOB_TYPE.sql	5.3	View	00260047
V_JOB_TYPE.sql	5.4	View	00308136
V_ORD_ORDER_CONTACT.sql	1.4	View	00308136
V_ORD_ORDER_HEADER.sql	1.11	View	00260047
V_ORD_ORDER_HEADER.sql	1.12	View	00308136
V_ORD_REQUIREMENT.sql	1.8	View	01584585
V_PRODUCT_CTL.sql	1.1	View	00308136
V_SCH_TRIP_AUDIT.sql	1.1	View	02064838
V_TRP_TRIP_STOP.sql	1.3	View	00260047
V_TRP_TRIP_STOP.sql	1.4	View	00308136
V_VEHICLE_DETAILS.sql	5.1	View	00301397
XML.sql	5.15	XML file upload	00266101

ADDITIONAL CHANGES

WCS

There are no WCS changes required.

EPOD/T2A

An ePOD/T2A change is required for the following logs:

• 00244856
• 00252522
• 00261979
• 00265284
• 00287638
• 00293881
• 00301831
• 02131420
• 02065820

CTL

A CTL change is required for the following logs:

• 00260058
• 01584585
• 00244856
• 00250543
• 00261979
• 00265284
• 00308136

MCS

There are no MCS changes required.

PORTAL/TTM

A Portal change is required for the following logs:

• 01929119
• 02112923

EDI

There are no EDI changes required.