PATCH C-TMS P043

Release Notes

CALIDUS TMS

12th December 2022 - 1.0
Reference: P043

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

DEVELOPMENT

Log Number: 00320472

Summary of Call	Create location ID
Detail of Fix	Location ID is modified to create from Recipient address reference instead of postcode which was in use until now, based on the maximum length location is appended with the subsequent suffix to keep it unique or truncated to add suffix so that it doesn't violate the maximum length.
Set-up and Configuration	No set-up/configuration required

Log Number: 00327516

Summary of Call	Emails not received when trip deleted
Detail of Fix	There aren't any recipients for CANCEL_3PL messages for carrier RBT for trip TQK-00046583. The carrier was N113780 until it was changed at 2022/07/20 12:52:44. The message was generated at this time so RBT was used. RBT was used for the carrier on the trip when its schedule was switched from 220719 to 220721. The carrier is reset for the owning depot ready for the carrier to be confirmed and updated for the new schedule. A new system parameter called 'TRM_RETAIN_CARRIER_NEW_SCHED' can be used to retain the carrier on the trip when the schedule is changed in the 'Planning' screen.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
TRM_RETAIN_CARRIER_NEW_SCHED	COST_CENTRE	Y/N	It is to retain a carrier when the schedule of the trip is updated. Otherwise, the carrier is reset to the carrier for the owning depot.

Log Number: 00326413

Summary of Call	Trunking Specification
Detail of Fix	New Fixed routes trunking engine.
Set-up and Configuration	No set-up/configuration required

Log Number: 00315981

Summary of Call	Calidus CTL Build
Detail of Fix	Various changes for CTL call logging.
Set-up and Configuration	No set-up/configuration required

Log Number: 00322438

Summary of Call	Orders Interface
Detail of Fix	New system parameters are available to store the start and end times for the orders, for example: ORD_START_TIME = 08:00 ORD_END_TIME = 18:00 Other system parameters should be set: CREATE_UNKNOWN_LOCS = Y CREATE_UNKNOWN_ORDER = N MATCH_FULL_LOC = Y The EDI process called 'API' will have new parameters to set for the new functionality: DEFAULT_COLLECTION = Y LOCATION_EXT_REF = Y ORD_INVOICED = Y ROUTE_DELIVERY = Y RUN_NUMBER_VALID = Y Other EDI parameters should be set: CUST_UPDATE_ORDER_LINES = N INTERFACE_FORMAT = NONE ORD_LINK_CONTENTS = N The 'End' time for the fixed route can be maintained in the 'Route Detail' screen.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
ORD_START_TIME	SYSTEM	NULL	Not used for the default early delivery time.
ORD_START_TIME	SYSTEM	TIME	The default early delivery time when a route is not provided for an API order (HH:MM).
ORD_END_TIME	SYSTEM	NULL	Not used for the default late delivery time.
ORD_END_TIME	SYSTEM	TIME	The default late delivery time when a route is not provided for an API order (HH:MM).

Log Number: 00335523

Summary of Call	ParentCustomer Relationships
Detail of Fix	Amendments to parent and child customers and groups for creation and updating. Address lines will be limited to 50 characters.
Set-up and Configuration	No set-up/configuration required

Log Number: 00336332

Summary of Call	Tyre removal order line is showing on device for collection
Detail of Fix	Order items for REMOVAL service types will not be included for Loading stops when the job is sent to EPOD.
Set-up and Configuration	No set-up/configuration required

Log Number: 00339287

Summary of Call	API Export Events not auditing all messages
Detail of Fix	The temporary variables which are accessing EDI_PROCESS_TRIGGER for AUDIT_METHOD and AUDIT_STATUS are made to be populated at the start of the 2 procedures (process_xml_outbound_api, process_xml_outbound_api_ord) so that they can be assessed for each type of message.
Set-up and Configuration	No set-up/configuration required

Log Number: 00340343

Summary of Call	Service update issue between EPOD & CTMS
Detail of Fix	The EPL_UDF item will be accepted with a null value.
Set-up and Configuration	No set-up/configuration required

Log Number: 00340339

Summary of Call	Export Work Type
Detail of Fix	EPL_DIRECTION is based on the work type for the order item. It will be R for Removal or I for Installation.
Set-up and Configuration	No set-up/configuration required

Log Number: 00341214

Summary of Call	Order Item Reason Codes
Detail of Fix	Trip stops will be updated with actual times for a service job as well as a collection job or a delivery job. Order lines and items will be maintained for the deliveries and services. The format 'OMS-SEQ' will be used for new items with the next sequence number being obtained for that format.
Set-up and Configuration	No set-up/configuration required

Log Number: 00342094

Summary of Call	CTL Order Items
Detail of Fix	Fixed the generation of sch_order_line records when creating an order in CTL.
Set-up and Configuration	No set-up/configuration required

Log Number: 00325239

Summary of Call	Cleanse data in outbound API
Detail of Fix	Modified the packages DP_EXPORT_EVENTS and DP_XML_EPOD to remove the special characters that are getting generated in the output file.
Set-up and Configuration	No set-up/configuration required

Log Number: 00344579

Summary of Call	Add On Products and Services
Detail of Fix	New Interface to upload items onto pre-existing orders.
Set-up and Configuration	No set-up/configuration required

Log Number: 00340340

Summary of Call	Update fails into Elucid from CTMS
Detail of Fix	A new EDI parameter called 'SEND_DEL_TYPE_CODE' can be set to 'Y' to send the code for the delivery type as 'TMS_DELIVERY_TYPE'. The EDI parameter 'DEL_ALL_ACT_QTY' can be used to assess the delivered quantities for the order items. The system parameter 'LOTS_DEL_CUST_SIGNATORY' can be used to assess the signatory for the orders. An amendment has been made to the 'DEL' messages for a trip to assess the quantities separately to the signatory. An appropriate message will be generated for when a 'DEL' message cannot be sent with respect to those parameters. Auditing has been reinstated for trip and order events.
Set-up and Configuration	No set-up/configuration required

Log Number: 00345032

Summary of Call	The CAN messages are being re-sent.
Detail of Fix	'CAN' messages will be sent once.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
OMS_SEQ_CTL_ITEM_FORMAT	SYSTEM	Y	The OMS reference plus a sequential count of the items on the order will be used for the next item.
OMS_SEQ_CTL_ITEM_FORMAT	SYSTEM	N	A sequential number will be used for the next item.

Log Number: 00344924

Summary of Call	Interface to Portal
Detail of Fix	The 'LAST_INSPECTION_DATE' will not be sent to 'LOTS' when a date has not been recorded.
Set-up and Configuration	No set-up/configuration required

Log Number: 00344993

Summary of Call	Convert CTL items to format OMS-SEQ to match EPOD item
Detail of Fix	A new system parameter called 'OMS_SEQ_CTL_ITEM_FORMAT' will be used to identify the format of the order items when they are created in CTL. The format 'OMS-SEQ' will be used when the system parameter is 'Y'.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
OMS_SEQ_CTL_ITEM_FORMAT	SYSTEM	Y	The OMS reference plus a sequential count of the items on the order will be used for the next item.
OMS_SEQ_CTL_ITEM_FORMAT	SYSTEM	N	A sequential number will be used for the next item.

Log Number: 00345010

Summary of Call	EPOD Services and Prices
Detail of Fix	Removed default start and end times of '00' to send to EPOD. Sends price to EPOD with a default value of 0.00. Sends services to EPOD for INSPECT delivery type orders as well as CALLOUT orders. Includes decimal places from EPOD for: EPL_MILEAGE EPL_PRESSURE EPL_TREAD_DEPTH EPL_PRICE Updates stop times from EPOD for service jobs. Stores classification and category for WMS products. Updates order items, actual despatched and delivered quantities once when EPOD sends multiple updates. Uses default DU type and product type for new order lines for products from EPOD. Creates services based on the delivery type and the vehicle type for CALLOUT orders.
Set-up and Configuration	No set-up/configuration required

Log Number: 02111893

Summary of Call	Secure FTP
Detail of Fix	Code has been added to the package DP_INT_XML_MIC2 to enable SFTP in TMSDEV, able to do SFTP now. A record will need to be added as a known host in the database to enable SFTP.
Set-up and Configuration	No set-up/configuration required

Log Number: 02227349

Summary of Call	Changes to EDI to accomodate Microlise interface
Detail of Fix	Set despatched quantity to send messages to Microlise
Set-up and Configuration	No set-up/configuration required

Log Number: 01935522

Summary of Call	Inbound Scanning Loose Items
Detail of Fix	The order items can be reused on later orders once they have been scanned through cross-docking. Checks whether the scanned item exists on the same order on which it was planned before checking to see if the item has been seen in the network before - these items can be scanned on their current planned orders. If the item has been scanned on a different order, checks if the item is found to have been through the network on other orders. These items cannot be scanned. If the item is only planned onto one other order, the item will be moved from that order to the order indicated by the scan as normal. This validation will apply to the 831 and 835 messages from WCS, the standard and the faster scanning processes will include this validation.
Set-up and Configuration	No set-up/configuration required

Log Number: 00342485

Summary of Call	CTL Trip Order Assignment
Detail of Fix	Retains the stop times when the driver of the trip does not have any times to set from a shift for planning in CTL.
Set-up and Configuration	No set-up/configuration required

Log Number: 02231368

Summary of Call	Additional Changes Required
Detail of Fix	New fields added to the Configurable layout in Waterfall screen, changes to the Order Well in the planning screen
Set-up and Configuration	No set-up/configuration required

Log Number: 02165959

Summary of Call	LFE Carrier Change
Detail of Fix	Service levels will be decoded using 'CARRIER_API_SERVICE_LEVEL' for the carrier of the trip and they will be added to the Carrier API message. A new system parameter called 'CARRIER_API_MANIFEST_READY_TIME' for the system will be used to set the cut-off time in format 'HH24:MI' to assess the ready times. A default value of '18:00' will be used should the system parameter not be set or if it is set with an invalid format for the time. The Ready Time will be adjusted to account for the cut-off time when the order is packed in advance of the delivery date of the order.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
CARRIER_API_MANIFEST_READY_TIME	SYSTEM	NONE	The cut-off time for the ready time will be set to 18:00 by default.
CARRIER_API_MANIFEST_READY_TIME	SYSTEM	POPULATED	The cut-off time for the ready time will be set to this time in format HH24:MI.

Log Number: 00350325

Summary of Call	Waterfall screen amendments
Detail of Fix	Amendments following UAT, TAB BLOCKS configured, EN-ROUTE status set based on DL and PK stops and not SU. Prevent Carrier trips from moving schedules in the overnight process.
Set-up and Configuration	No set-up/configuration required

Log Number: 00323035

Summary of Call	Scheduling Engine
Detail of Fix	New scheduling process for customer, covering delivery routes, replen orders and collection desk orders
Set-up and Configuration	No set-up/configuration required

Log Number: 00322441

Summary of Call	Customer Onboarding Interface
Detail of Fix	New API standard customer import.
Set-up and Configuration	No set-up/configuration required

Log Number: 00349335

Summary of Call	CTL menu items for ORS
Detail of Fix	Modified the form and package so that any unauthorized user group cannot access that menu. This depends on the 'ADM_NO_DISPLAY_MENU' system parameter i.e, set to 'CTL'
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
ADM_NO_DISPLAY_MENU	SYSTEM	CTL

Log Number: 00351008

Summary of Call	Load Index to be changed to 20 character field from numeric field
Detail of Fix	Alters the database table to store a larger load index up to 20 digits for the WMS products references.
Set-up and Configuration	No set-up/configuration required

Log Number: 00353959

Summary of Call	LFE Carrier Amendment
Detail of Fix	Amendment to switch the serviceCode to use the customer of the order not the carrier of the trip.
Set-up and Configuration	No set-up/configuration required

Log Number: 00349336

Summary of Call	On inspection update
Detail of Fix	Added EPL_WORK_COMPLETE for the service status. The service status is C when there is no action or the work is complete, otherwise it is P.
Set-up and Configuration	No set-up/configuration required

Log Number: 00350925

Summary of Call	No delivered item in Elucid
Detail of Fix	Update items as delivered for EPOD level IP based on the AKA, direction and position.
Set-up and Configuration	No set-up/configuration required

Log Number: 00349283

Summary of Call	Amend driver shift patterns screen
Detail of Fix	Adding new shift manually instead of via display shifts. Default database parameters such as depot in the detail screen. Update message 'all drivers' should read 'all selected drivers'.
Set-up and Configuration	No set-up/configuration required

Log Number: 00355355

Summary of Call	Failure Notifications for Customer Imports
Detail of Fix	Reports separately these items for the API customer import from Elucid: RecipientAddress RecipientCompany InvoiceCompany
Set-up and Configuration	No set-up/configuration required

Log Number: 00355573

Summary of Call	Inbound Job
Detail of Fix	Alters the database table to store a larger load index up to 20 digits for the WMS products references.
Set-up and Configuration	No set-up/configuration required

Log Number: 00350912

Summary of Call	PSI pressure set to 2 characters in epod and TMS
Detail of Fix	The pressure and the tread depth have been increased in length to store 4 numbers plus a decimal place.
Set-up and Configuration	No set-up/configuration required

Log Number: 00355519

Summary of Call	LOTS Installation for Customer Imports
Detail of Fix	The customers will be stored with a LOTS customer based on the buyer from Elucid when LOTS is active when the EDI parameter CUST_LOTS_ID is Y. The customers will be stored with a LOTS customer based on the customer in the standard import process when LOTS is active when the EDI parameter CUST_LOTS_ID is Y.
Set-up and Configuration	No set-up/configuration required

Log Number: 00355562

Summary of Call	Order Auditing
Detail of Fix	The auditing is not being triggered by CTL orders. The booking process has been changed to perform the auditing instead to create the vehicle record for the order.
Set-up and Configuration	No set-up/configuration required

Log Number: 00356803

Summary of Call	Service Report
Detail of Fix	The EPL_OFFICE_INSTRUCTIONS item in the EPOD_JOB section is included when the order on the trip has an order to action.
Set-up and Configuration	No set-up/configuration required

Log Number: 00364252

Summary of Call	No vehicle search found
Detail of Fix	The vehicle search will be case sensitive for the reg/fleet number.
Set-up and Configuration	No set-up/configuration required

Log Number: 00356212

Summary of Call	Number of tyres
Detail of Fix	The order line quantity will be incremented or decremented when the quantities for the order items is added or adjusted. These quantities will be for the ordered quantity or the despatched quantity as appropriate.
Set-up and Configuration	No set-up/configuration required

Log Number: 00365467

Summary of Call	Service Report
Detail of Fix	Uses EPL_OFFICE_INSTRUCTION.
Set-up and Configuration	No set-up/configuration required

Log Number: 00365797

Summary of Call	Sending loading jobs to EPOD
Detail of Fix	Includes the item description instead of the DU type description in EPL_DESCRIPTION for level IP.
Set-up and Configuration	No set-up/configuration required

Log Number: 00366524

Summary of Call	Actions not completing
Detail of Fix	The Pending tyre inspections will be updated for a position on a vehicle based on the EPL_CODE_2.
Set-up and Configuration	No set-up/configuration required

Log Number: 00366230

Summary of Call	Some completed jobs are showing as part delivered
Detail of Fix	Sends an ORDER_VEHICLES section per order to LOTS.
Set-up and Configuration	No set-up/configuration required

Log Number: 02254409

Summary of Call	Cross Dock Scanning
Detail of Fix	Added new EDI_PROCESS for customer, which calls the new function - fn_load_trunks to avoid ford scanning. Setup: Create a new EDI Process for that particular customer along with its cost center. Add the function (TRM.fn_load_trunks) in the report values and run the EDI process every 5 minutes.
Set-up and Configuration	No set-up/configuration required

Log Number: 00367465

Summary of Call	RVA_PRESSURE needs increasing in size
Detail of Fix	RES_VEHICLE_CONFIG_AXLE.RVA_PRESSURE is NUMBER(5,1) to match RES_VEHICLE_AXLE.RVA_PRESSURE.
Set-up and Configuration	No set-up/configuration required

Log Number: 00366787

Summary of Call	Vehicle Fleet Maintenance
Detail of Fix	An inspection is not required in CTL for a location that does not have a period setup.
Set-up and Configuration	No set-up/configuration required

Log Number: 00366861

Summary of Call	Epod MODE 2
Detail of Fix	Standard orders will update the order items when a position and a direction/work type are not known.
Set-up and Configuration	No set-up/configuration required

Log Number: 00368176

Summary of Call	COL-VUI messages
Detail of Fix	The COL-VUI messages will include the ORDER_VEHICLE section once per vehicle.
Set-up and Configuration	No set-up/configuration required

Log Number: 00368493

Summary of Call	Customer Load Sheets
Detail of Fix	Runs a new Loading Sheet based on new parameters
Set-up and Configuration	No set-up/configuration required

Log Number: 00368621

Summary of Call	STS Auditing for the Customer Import API
Detail of Fix	Amendments to auditing for the RESPONSE and for UAT.
Set-up and Configuration	No set-up/configuration required

Log Number: 00371961

Summary of Call	Change for fleet inspections for EPOD
Detail of Fix	Services are only sent to EPOD for a CALLOUT. Customer vehicles are only stored as order vehicles for a CALLOUT.
Set-up and Configuration	No set-up/configuration required

Log Number: 00368184

Summary of Call	Order with tyre value of 0
Detail of Fix	Does not update DELIVERED or FAILED orders to be ON-HOLD, when an order is validated when the customer account is on hold. Does not update ON-HOLD, DELIVERED or FAILED orders to be SCHEDULED or UNSCHEDULED when a service is added to the order.
Set-up and Configuration	No set-up/configuration required

Log Number: 00364162

Summary of Call	Copy and split order functions
Detail of Fix	Copy_order ,split_order and duplicate_order functions in OMS are updated to insert the newly added columns for SCH_ORD and SCH_ORD_ITEMS tables.
Set-up and Configuration	No set-up/configuration required

Log Number: 00371509

Summary of Call	Change to addresses
Detail of Fix	Includes an EPOD_CUSTOMER_INVOICE section within the EPOD_CUSTOMER section in the EPOD_JOB SECTION for the service jobs when the new system parameter called EPOD_CUSTOMER_INVOICE is set to Y. For release with issue 301 for EPOD.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_CUSTOMER_INVOICE	SYSTEM	Y	Includes an EPOD_CUSTOMER_INVOICE section within the EPOD_CUSTOMER section in the EPOD_JOB SECTION for the service jobs.
EPOD_CUSTOMER_INVOICE	SYSTEM	N	Does not include an EPOD_CUSTOMER_INVOICE section within the EPOD_CUSTOMER section in the EPOD_JOB SECTION for the service jobs.

Log Number: 02166754

Summary of Call	Driver Sheet
Detail of Fix	The customer Trip Sheet for the drivers has been converted to a portrait format.
Set-up and Configuration	No set-up/configuration required

Log Number: 00372699

Summary of Call	Trips showing as Part Delivered
Detail of Fix	The new order items will be created with a planned quantity and a despatched quantity to match the advised delivered quantity. These items will be for vehicles that have been inspected and that have had parts supplied
Set-up and Configuration	No set-up/configuration required

Log Number: 00372373

Summary of Call	ODO not stored
Detail of Fix	Update statement for RES_TRACTOR has been added to the the package, which will update ODO value by assessing EPL_MILEAGE.
Set-up and Configuration	No set-up/configuration required

Log Number: 00373035

Summary of Call	Remove EPL_SITE_ID
Detail of Fix	Removed EPL_SITE_ID from previous version as it was causing error while uploading the data.
Set-up and Configuration	No set-up/configuration required

INCIDENTS

Log Number: 00325803

Summary of Call	Always send locations to Paragon via API
Detail of Fix	Send Locations to Paragon when manual orders are sent to Paragon
Set-up and Configuration	No set-up/configuration required

Log Number: 00326046

Summary of Call	API export
Detail of Fix	Return NAK from API export when not success.
Set-up and Configuration	No set-up/configuration required

Log Number: 00328694

Summary of Call	Driver not being sent to ePOD
Detail of Fix	System parameter EPOD_SEND_DRIVER can be set to N to send the EPL_USER_ID as a null value instead of the driver's username. A default value of Y will apply to continue to send the driver's username.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_SEND_DRIVER	SYSTEM	Y	The driver's username is included.
EPOD_SEND_DRIVER	SYSTEM	N	The driver's username is not included.

Log Number: 00328687

Summary of Call	Callout orders not getting sent to ePOD
Detail of Fix	Applied NVL to the fields EPL_PRODUCT_QTY_CASE and EPL_MILEAGE so that if the values are blank it'll update to 0. EPL_SIZE will be assessed as a character not a number. Added the trip ID to the audit log for exceptional error handling.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
EPOD_WS_MESSAGE_FORMAT	SYSTEM	NONE	EPOD message format - can either be PARCEL, BULK, RETAIL, MODE1, MODE2 or DELTYPE to define where fields are sent in the web service message.

Log Number: 00330994

Summary of Call	TOMTOM Amendment
Detail of Fix	Amendment to TOMTOM to only look at next days depot for trips.
Set-up and Configuration	No set-up/configuration required

Log Number: 00332107

Summary of Call	ORDER_STATUS in API
Detail of Fix	The 'ORDER_STATUS' will be included in the 'ORDER_HEADER' section for the API messages when the EDI parameter 'INCLUDE_ORDER_STATUS' is 'Y'.
Set-up and Configuration	No set-up/configuration required

Log Number: 00332122

Summary of Call	API Customer Import Amendments for Elucid
Detail of Fix	Amendments to the customer import for Elucid including: 1. Using the Buyer for the location for the MAIN address 2. Creating an account for a new customer. 3. Inserting or updating customers, locations and contacts.
Set-up and Configuration	No set-up/configuration required

Log Number: 00332893

Summary of Call	API Customer Import - Exceptional Error Handling for Elucid
Detail of Fix	The customer group name will be truncated to 35 characters but the customer name will remain at 50 characters. Locations for customers and customer groups will available to use.
Set-up and Configuration	No set-up/configuration required

Log Number: 00338487

Summary of Call	Various Ctl changes.
Detail of Fix	CTL Call Logging Changes. Update Vehicle change. Fix for Contact generation. Generate Axle and Tyres info.
Set-up and Configuration	No set-up/configuration required

Log Number: 00327382

Summary of Call	ORS failing in CTL
Detail of Fix	Changed the datatype of the field t_det_sel to CLOB to mitigate the error in the package. Added storage limit exception to the form and package. So, the user is advised to use limited records to produce the report. Added a new parameter to the CTL procedure DP_REPORT.P_GEN_ORS_SQL_CTL to display the err_msg in CTL. It needs to be tested in CTL as it involves the procedure DP_REPORT.P_GEN_ORS_SQL_CTL. Also, modified the code to mitigate the string concatenation too long error.
Set-up and Configuration	No set-up/configuration required

Log Number: 00340142

Summary of Call	Ctl Call Logging Issues 87/92
Detail of Fix	Changes to update the Time Windows whenever the order changes if it isn't booked or cancelled
Set-up and Configuration	No set-up/configuration required

Log Number: 02139434

Summary of Call	Invalid order lines preventing trips moving to ACCEPTED status
Detail of Fix	A new system parameter called 'WCS_RETAIN_EMPTY_LINES' can be set to 'Y' to retain any empty order lines that have been created after their items have been deleted during the order confirmation process. These order lines will not have a despatched quantity.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
WCS_RETAIN_EMPTY_LINES	SYSTEM	Y	Retains any empty order lines that have been created after their items have been deleted during the order confirmation process.
WCS_RETAIN_EMPTY_LINES	SYSTEM	N	Does not retain any empty order lines that have been created after their items have been deleted during the order confirmation process.

Log Number: 00340479

Summary of Call	Include created and updated auditing for contracts and imports
Detail of Fix	The contracts and import maintenance tables are altered to use CREATED_DATE/BY and UPDATED_DATE/BY to assist analysis.
Set-up and Configuration	No set-up/configuration required

Log Number: 00345853

Summary of Call	Version release control for 02221309
Detail of Fix	The audit message in the import package are updated to avoid filling up the disk space.
Set-up and Configuration	No set-up/configuration required

Log Number: 00345814

Summary of Call	A validation error is occurring for some DSPD messages
Detail of Fix	The DSPD message will enable EN-ROUTE trips to be updated with package information.
Set-up and Configuration	No set-up/configuration required

Log Number: 00345445

Summary of Call	Changes containing trunk version of DP_EPOD_WEB_SERVICE
Detail of Fix	Phase 2 of webfleet integration including free text message requires, working hours request, drive card message, incorrect address, incorrect contact, next delivery. Delete orders not finished in overnight job, move future trips to the correct schedule.
Set-up and Configuration	No set-up/configuration required

Log Number: 02234525

Summary of Call	Cost not pulling through
Detail of Fix	Generates an outbound API event when the trip cost is set for the first time or is changed.
Set-up and Configuration	No set-up/configuration required

Log Number: 00357019

Summary of Call	Additional Changes to Planning and Waterfall screen
Detail of Fix	Changes to Planning and Waterfall screen and allocate resources 2 new parameters SHOW_CARRIER_NAME and ALLOC_RESOURCE to be set to Y
Set-up and Configuration	No set-up/configuration required

Log Number: 00365766

Summary of Call	Additional Changes Part 2
Detail of Fix	Part 2 of additional changes. Parameter CANCEL_STATUS_CHK must be set to Y
Set-up and Configuration	No set-up/configuration required

Log Number: 00366538

Summary of Call	Waterfall Menu
Detail of Fix	Control waterfall menu access
Set-up and Configuration	No set-up/configuration required

Log Number: 00374968

Summary of Call	Release of V_TRIP_OVERVIEW
Detail of Fix	Database view V_TRIP_OVERVIEW will be made available to recompile.
Set-up and Configuration	No set-up/configuration required

Log Number: 00374083

Summary of Call	Indexes for new tables
Detail of Fix	Indexes added for performance optimization
Set-up and Configuration	No set-up/configuration required

Log Number: 00349874

Summary of Call	Display automatically on screen a newly created contract
Detail of Fix	Added new functionality to the contracts form to populate new contract in Contracts screen automatically.
Set-up and Configuration	No set-up/configuration required

BUGS

Log Number: 02129675

Summary of Call	Trip audit missing items
Detail of Fix	The update of the following information for the trip will be audited separately: Owning Depot Route Code Carrier ID Tractor ID Driver ID Shift Code Seal Number Note that the 'Tractor ID' may be set to 'SUB-CONTRACT' when the 'Sub Contractor' box is ticked for the trip.
Set-up and Configuration	No set-up/configuration required

Log Number: 00298173

Summary of Call	LFE Carrier Integration
Detail of Fix	TRG to populate Created_date and Created_by in sch_ord_tracking before inserting a tracking reference record.
Set-up and Configuration	No set-up/configuration required

Log Number: 00325648

Summary of Call	EPL_JOB_ID sent twice
Detail of Fix	Remove duplicate EPL_JOB_ID
Set-up and Configuration	No set-up/configuration required

Log Number: 02140871

Summary of Call	API Processing
Detail of Fix	A TRP message will be sent via the API when an order is deassigned from a trip or assigned to a trip when its status is not PLANNED.
Set-up and Configuration	No set-up/configuration required

Log Number: 02135828

Summary of Call	CTMS Export processing
Detail of Fix	Corrected code so update requests are on the currently open cursor
Set-up and Configuration	No set-up/configuration required

Log Number: 02132813

Summary of Call	Payments - Currency Code not set
Detail of Fix	A new function is available in CTMS: The currency code will be returned to set for the Portal order that is being entered. This currency code will be present to calculate the payments when the order is scheduled.
Set-up and Configuration	No set-up/configuration required

Log Number: 02137857

Summary of Call	Portal Order Entry
Detail of Fix	New function to allow portal to write audit records
Set-up and Configuration	No set-up/configuration required

Log Number: 00320489

Summary of Call	Location Maintenance for SWAP locations
Detail of Fix	A new system parameter called GEO_HIDE_SWAP_LOCATIONS can be used to remove SWAP locations from the location list when set to Y.
Set-up and Configuration

New Parameters
Parameter Name	Config Level	Setting Value	Result
GEO_HIDE_SWAP_LOCATIONS	SYSTEM	Y/N	It is to exclude SWAP locations from list of Location_ID's in location maintenance screen

Log Number: 02128190

Summary of Call	Orders not consolidating on stops
Detail of Fix	Customers that do not allow consolidated orders on delivery trips will assess overlapping available order time windows for their trip stops. A new system parameter called 'TRM_CONSOL_ORDER_AFTER_XDOCK' can be set to 'Y' if the customers do not want to assess these available order time windows against the other orders on the loading trip stop when the order has been collected previously.
Set-up and Configuration	No set-up/configuration required

Log Number: 00333266

Summary of Call	Customer Upload bug
Detail of Fix	Call Logging changes for booking releases, Issue 6 changes etc.
Set-up and Configuration	No set-up/configuration required

Log Number: 02128610

Summary of Call	Access Control - CNT functions
Detail of Fix	Resolved all the issues, Modified the CONTRACT form to use the CNT functions based on the respected access_control functions for the user group. Introduced a new CNT function 'CNT_Delete_Tier_Name' for the Ability to delete tier names.
Set-up and Configuration

New Access
Access Tab	Name	Description
Functions	CNT_Delete_Tier_Name	Access Function to delete Tier names.

Log Number: 02222075

Summary of Call	Batch Order creation, Order reference does not enable Alpha entry on numeric
Detail of Fix	Modified the package OMS.create_order_from_template to mitigate the numeric conversion error which is restricting the user from creating orders in the ORDER TEMPLATE screen. This change also contains the solution for case 02160908.
Set-up and Configuration	No set-up/configuration required

Log Number: 00346821

Summary of Call	Ctl changes for issues 168 and 171
Detail of Fix	Ctl Issues 168 and 171 resolved. Plus a fix for Here maps.
Set-up and Configuration	No set-up/configuration required

Log Number: 02224778

Summary of Call	Incorrect data on actual arrive date POD
Detail of Fix	Amended the CARPOD process for LFE to ensure that the POD_DATE includes the full year in its format to assign to the actual date for the trip stops.
Set-up and Configuration	No set-up/configuration required

Log Number: 02147681

Summary of Call	Warehouse screen
Detail of Fix	The ad-hoc services will be stored as a payment and then it can be updated. The payments, bulk packaging and services will be audited as they are created and updated.
Set-up and Configuration	No set-up/configuration required

Log Number: 00351271

Summary of Call	Control updates in the Waterfall screen
Detail of Fix	Control when updates can be performed in WATERFALL screen
Set-up and Configuration	No set-up/configuration required

Log Number: 00349334

Summary of Call	Ctl System Params
Detail of Fix	Changes for CTL inspections. Added default Del Types and Services.
Set-up and Configuration	No set-up/configuration required

Log Number: 02243017

Summary of Call	Microlise Outbound Interface
Detail of Fix	The maximum length of the direct messages to Microlise has been extended.
Set-up and Configuration	No set-up/configuration required

Log Number: 02232219

Summary of Call	CFX inbound interface incorrect
Detail of Fix	The PLANNED and TENDERED trips will be updated to ACCEPTED. An audit message will be created should the trip status fail to update.
Set-up and Configuration	No set-up/configuration required

Log Number: 00355544

Summary of Call	CTL Changes
Detail of Fix	Various changes for CTL
Set-up and Configuration	No set-up/configuration required

Log Number: 00360149

Summary of Call	Release for Issue 214
Detail of Fix	Set action_id for linked inspections.
Set-up and Configuration	No set-up/configuration required

Log Number: 00365146

Summary of Call	Order Lines
Detail of Fix	Added deletion of order lines.
Set-up and Configuration	No set-up/configuration required

Log Number: 00364940

Summary of Call	Issue 250
Detail of Fix	Only select drivers that are active for the carrier in question.
Set-up and Configuration	No set-up/configuration required

Log Number: 02263060

Summary of Call	Copy Order function
Detail of Fix	Copy order functions in OMS is modified to create the IXC record when EDI trigger INC_COPIED_ORDERS is set to 'Y' to trigger the messages to ConnectedView.
Set-up and Configuration	No set-up/configuration required

Log Number: 00366764

Summary of Call	Tyre size
Detail of Fix	Issue 245 Added tyre size to vehicle view. Issue 247 added check for To Location.
Set-up and Configuration	No set-up/configuration required

Log Number: 00367653

Summary of Call	Cty Vehicle view
Detail of Fix	Added location name and axle config description. CTL release required alongside CTMS release
Set-up and Configuration	No set-up/configuration required

PRODUCT DEVELOPMENT

Log Number: 00318182

Summary of Call	Review inactive flags that are not being referenced - delivery type-service level
Detail of Fix	Inactive flag has been reviewed to make it consistent throughout the database for DEL_TYPE and SERVICE_LEVEL
Set-up and Configuration	No set-up/configuration required

Log Number: 00279440

Summary of Call	Issues In CTMS Locations screen
Detail of Fix	The 'Close' button is modified to mitigate the error. 'Save changes' message will not be displayed without any change in the Form.
Set-up and Configuration	No set-up/configuration required

Log Number: 00314793

Summary of Call	Wait for API response
Detail of Fix	A new EDI parameter should be set up to enable to wait for a response or 'send and forget'. EDI parameter called SEND_AND_FORGET should be set up for process name API, which when set to Y, it will stop waiting for response and vice versa.
Set-up and Configuration	No set-up/configuration required

Log Number: 00323078

Summary of Call	Temperature violation during trip validation
Detail of Fix	The error message regarding temperature violation during trip validation was noted for the case 322452. There is a query (actually more than one) that will not find a record and issue this error message but it can never select a record without the trailer being known. In that sense change is made to display this error message only when trailer type is known and if not then it should be suppressed.
Set-up and Configuration	No set-up/configuration required

Log Number: 00374777

Summary of Call	Wallet File
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.
Set-up and Configuration	No set-up/configuration required

MODULES DELIVERED

Module Name	Version No	Description	Log Number
ACC_CTRL.fmx	2.56	Access control maintenance	00349335
ADM.sql	5.12	Administrator package containing various DB utils	00349335
AT_CNT_CHARGE_CONDITIONS_TRACTOR_340479.sql	1.1	AT Script	00340479
AT_CNT_CHARGE_CONDITIONS_TRLRTYPE_340479.sql	1.1	AT Script	00340479
AT_CNT_CHARGE_MIN_MAX_340479.sql	1.1	AT Script	00340479
AT_CNT_CHARGE_PARAM_340479.sql	1.1	AT Script	00340479
AT_CNT_CHARGE_TYPE_340479.sql	1.1	AT Script	00340479
AT_CNT_CONDITION_340479.sql	1.1	AT Script	00340479
AT_CNT_CONDITION_VALUE_340479..sql	1.1	AT Script	00340479
AT_CNT_CONTRACT_INDEX_340479.sql	1.1	AT Script	00340479
AT_CNT_CUST_LOC_GROUP_340479.sql	1.1	AT Script	00340479
AT_CNT_DEL_TYPE_340479.sql	1.1	AT Script	00340479
AT_CNT_DEL_TYPE_CONV_340479.sql	1.1	AT Script	00340479
AT_CNT_DEL_TYPE_CUST_EXCL_340479.sql	1.1	AT Script	00340479
AT_CNT_DEL_TYPE_USE_340479.sql	1.1	AT Script	00340479
AT_CNT_RHA_CONFIG_340479.sql	1.1	AT Script	00340479
AT_CNT_RHA_INDEX_340479.sql	1.1	AT Script	00340479
AT_CNT_SERVICE_CHARGES_340479.sql	1.1	AT Script	00340479
AT_CNT_SERVICE_CONTRACTS_340479.sql	1.1	AT Script	00340479
AT_CNT_SERVICE_LEVEL_340479.sql	1.1	AT Script	00340479
AT_CNT_STD_JOURNEY_340479.sql	1.1	AT Script	00340479
AT_CNT_TIER_NAME_340479.sql	1.1	AT Script	00340479
AT_GEO_LOCATION_00322441.sql	1.1	AT Script	00322441
AT_IMP_FIELD_340479.sql	1.1	AT Script	00340479
AT_IMP_FIELD_SOURCE_340479.sql	1.1	AT Script	00340479
AT_IMP_FORMULA_340479.sql	1.1	AT Script	00340479
AT_IMP_HIST_DETAIL_340479.sql	1.1	AT Script	00340479
AT_IMP_HIST_HEADER_340479.sql	1.1	AT Script	00340479
AT_IMP_IMPORT_TYPE_340479.sql	1.1	AT Script	00340479
AT_IMP_IMPORT_TYPE_REC_TYPE_340479.sql	1.1	AT Script	00340479
AT_IMP_LOAD_AUDIT_340479.sql	1.1	AT Script	00340479
AT_IMP_ORDERS_340479.sql	1.1	AT Script	00340479
AT_IMP_RECORD_FORMAT_340479.sql	1.1	AT Script	00340479
AT_INT_XML_ORD_HEADER_00368493.sql	1.1	AT Script	00368493
AT_ORD_TYRE_INSPECTIONS_00350912.sql	1.1	AT Script	00350912
AT_ORG_CUSTOMER_00322441.sql	1.1	AT Script	00322441
AT_ORG_CUSTOMER_00368493.sql	1.1	AT Script	00368493
AT_RES_VEHICLE_AXLE_00350912.sql	1.1	AT Script	00350912
AT_RES_VEHICLE_CONFIG_AXLE_00367465.sql	1.1	AT Script	00367465
AT_RES_VEHICLE_TYRE_00350912.sql	1.1	AT Script	00350912
AT_RTE_ROUTE_00322438.sql	1.1	AT Script	00322438
AT_RTE_ROUTE_00323035.sql	1.1	AT Script	00323035
AT_SCH_ORD_ITEMS_00350912.sql	1.1	AT Script	00350912
AT_TOMTOM_ETA_EVENTS_374083.sql	1.1	AT Script	00374083
AT_TRM_CARRIER_COST_374083.sql	1.1	AT Script	00374083
AT_WMS_PRODUCT_XREF_00351008.sql	1.1	AT Script	00351008
BDM.fmx	2.106	Business Data Form	00326413
BDM.fmx	2.108	Business Data Form	00349283
CARRIER_RULES.fmx	1.16	Carrier Rules Maintenance Screen	00318182
CONTRACT.fmx	2.75	Contracts Form	02128610
CONTRACT.fmx	2.76	Contracts Form	00340479
CONTRACT.fmx	2.77	Contracts Form	00349874
CT_GEO_DELIVERY_ROUTE_PRIORITY.sql	1.3	CT Script	00326413
CT_GEO_LOCATION_WINDOW_00322441.sql	1.1	CT Script	00322441
CT_GEO_ROUTE_DTLS.sql	1.3	CT Script	00326413
CT_PAR_API_STAGING_ROUTE.sql	1.2	CT Script	00326413
CT_PAR_JSON_IN_ROUTE.sql	1.3	CT Script	00326413
CT_PAR_KEYS_ROUTE.sql	1.3	CT Script	00326413
CT_SEQ_GEO_LOCATION_WINDOW_00322441.sql	1.1	CT Script	00322441
CT_SEQ_GEO_ROUTE_DTLS.sql	1.2	CT Script	00326413
CT_SEQ_TT_DRIVE_02156578.sql	1.1	CT Script	00345445
CT_SEQ_TT_WORK_02156578.sql	1.1	CT Script	00345445
CT_TOM_DRIVE_02156578.sql	1.1	CT Script	00345445
CT_TOM_WORK_02156578.sql	1.1	CT Script	00345445
CUST_COST.fmx	2.140	Customer Maintenance form	00318182
CUST_COST.fmx	2.141	Customer Maintenance form	00322441
DATA_ADM_FUNCTION_322353.sql	1.1	Data Script	02128610
DATA_ADM_LOG_PROG_NAME_02111893.sql	1.2	Data Script	02111893
DATA_ADM_LOG_PROG_NAME_349283.sql	1.1	Data Script	00349283
DATA_ADM_SYSTEM_PARAM_00322438.sql	1.1	Data Script	00322438
DATA_ADM_SYSTEM_PARAM_00323035.sql	1.2	Data Script	00323035
DATA_ADM_SYSTEM_PARAM_00330994.sql	1.1	Data Script	00330994
DATA_ADM_SYSTEM_PARAM_00351271.sql	1.1	Data Script	00351271
DATA_ADM_SYSTEM_PARAM_00357019.sql	1.1	Data Script	00357019
DATA_ADM_SYSTEM_PARAM_00365766.sql	1.1	Data Script	00365766
DATA_ADM_SYSTEM_PARAM_00368493.sql	1.1	Data Script	00368493
DATA_ADM_SYSTEM_PARAM_00371509.sql	1.1	Data Script	00371509
DATA_ADM_SYSTEM_PARAM_02111893.sql	1.3	Data Script	02111893
DATA_ADM_SYSTEM_PARAM_02124442.sql	1.1	Data Script	00328694
DATA_ADM_SYSTEM_PARAM_02128190.sql	1.1	Data Script	02128190
DATA_ADM_SYSTEM_PARAM_02139434.sql	1.1	Data Script	02139434
DATA_ADM_SYSTEM_PARAM_02156578.sql	1.1	Data Script	00345445
DATA_ADM_SYSTEM_PARAM_02165959.sql	1.1	Data Script	02165959
DATA_ADM_SYSTEM_PARAM_02231368.sql	1.1	Data Script	02231368
DATA_ADM_SYSTEM_PARAM_315981.sql	1.1	Data Script	00315981
DATA_ADM_SYSTEM_PARAM_318182.sql	1.1	Data Script	00318182
DATA_ADM_SYSTEM_PARAM_320489.sql	1.2	Data Script	00320489
DATA_ADM_SYSTEM_PARAM_327516.sql	1.1	Data Script	00327516
DATA_ADM_SYSTEM_PARAM_328687.sql	1.1	Data Script	00328687
DATA_ADM_SYSTEM_PARAM_344993.sql	1.1	Data Script	00344993
DATA_ADM_SYSTEM_PARAM_349335.sql	1.1	Data Script	00349335
DATA_ADM_SYSTEM_PARAM_CONFIG_327516.sql	1.1	Data Script	00327516
DATA_ADM_USER_PARAM_002118515.sql	5.1	Data Script	00333266
DATA_ADM_USER_PARAM_TYPE_002118515.sql	5.1	Data Script	00333266
DATA_ADM_USER_PARAM_TYPE_00349334.sql	1.1	Data Script	00349334
DATA_EDI_FLOW_TYPES_00344579.sql	1.1	Data Script	00344579
DATA_GEO_LOC_TYPE_346821.sql	1.1	Data Script	00346821
DATA_MSG_EVENT_TYPE_00323035.sql	1.1	Data Script	00323035
DATA_REP_REPORT_00368493.sql	1.1	Data Script	00368493
DATA_REP_REPORT_PARAM_00368493.sql	1.1	Data Script	00368493
DP_ASKGEO.sql	1.3	AskGEO Interface	00374777
DP_CARRIER_API.sql	5.10	Database Package	02165959
DP_CARRIER_API.sql	5.11	Carrier API Database Package	00353959
DP_CTMS_IMPORT.sql	5.11	API Import Database Package	00332893
DP_CTMS_IMPORT.sql	5.12	API Import Database Package	00335523
DP_CTMS_IMPORT.sql	5.15	API Import Database Package	00322441
DP_CTMS_IMPORT.sql	5.16	API Import Database Package	00355355
DP_CTMS_IMPORT.sql	5.17	API Import Database Package	00355519
DP_CTMS_IMPORT.sql	5.18	API Import Database Package	00365766
DP_CTMS_IMPORT.sql	5.20	API Import Database Package	00368621
DP_CTMS_IMPORT.sql	5.7	Database Package	00320472
DP_CTMS_IMPORT.sql	5.8	API Import Database Package	00322438
DP_CTMS_IMPORT.sql	5.9	API Import Database Package	00332122
DP_CUST_SERV.sql	1.39	Customer Service Package	00315981
DP_CUST_SERV.sql	1.41	Customer Service Package	00333266
DP_CUST_SERV.sql	1.42	Customer Service Package	00338487
DP_CUST_SERV.sql	1.45	Customer Service Package	00340142
DP_CUST_SERV.sql	1.46	Customer Service Package	00342094
DP_CUST_SERV.sql	1.47	Customer Service Package	00344993
DP_CUST_SERV.sql	1.48	Customer Service Package	00346821
DP_CUST_SERV.sql	1.49	Customer Service Package	00349334
DP_CUST_SERV.sql	1.50	Customer Service Package	00355544
DP_CUST_SERV.sql	1.51	Customer Service Package	00355562
DP_CUST_SERV.sql	1.52	Customer Service Package	00360149
DP_CUST_SERV.sql	1.53	Customer Service Package	00356212
DP_CUST_SERV.sql	1.54	Customer Service Package	00365146
DP_CUST_SERV.sql	1.55	Customer Service Package	00366764
DP_EPOD_WEB_SERVICE.sql	1.151	EPOD Web Service	00325648
DP_EPOD_WEB_SERVICE.sql	1.152	EPOD Web Service	00325803
DP_EPOD_WEB_SERVICE.sql	1.153	EPOD Web Service	00328694
DP_EPOD_WEB_SERVICE.sql	1.156	EPOD Web Service	00328687
DP_EPOD_WEB_SERVICE.sql	1.157	EPOD Web Service	00336332
DP_EPOD_WEB_SERVICE.sql	1.158	EPOD Web Service	00340343
DP_EPOD_WEB_SERVICE.sql	1.159	EPOD Web Service	00340339
DP_EPOD_WEB_SERVICE.sql	1.160	EPOD Web Service	00341214
DP_EPOD_WEB_SERVICE.sql	1.161	EPOD Web Service	00345010
DP_EPOD_WEB_SERVICE.sql	1.162	EPOD Web Service	00345445
DP_EPOD_WEB_SERVICE.sql	1.163	EPOD Web Service	00349336
DP_EPOD_WEB_SERVICE.sql	1.164	EPOD Web Service	00350925
DP_EPOD_WEB_SERVICE.sql	1.165	EPOD Web Service	00355573
DP_EPOD_WEB_SERVICE.sql	1.166	EPOD Web Service	00356803
DP_EPOD_WEB_SERVICE.sql	1.167	EPOD Web Service	00364252
DP_EPOD_WEB_SERVICE.sql	1.168	EPOD Web Service	00365467
DP_EPOD_WEB_SERVICE.sql	1.169	EPOD Web Service	00365797
DP_EPOD_WEB_SERVICE.sql	1.170	EPOD Web Service	00366524
DP_EPOD_WEB_SERVICE.sql	1.171	EPOD Web Service	00366787
DP_EPOD_WEB_SERVICE.sql	1.172	EPOD Web Service	00366861
DP_EPOD_WEB_SERVICE.sql	1.173	EPOD Web Service	00371961
DP_EPOD_WEB_SERVICE.sql	1.174	EPOD Web Service	00371509
DP_EPOD_WEB_SERVICE.sql	1.175	EPOD Web Service	00373035
DP_EPOD_WEB_SERVICE.sql	1.176	EPOD Web Service	00372373
DP_EPOD_WEB_SERVICE.sql	1.177	EPOD Web Service	00372699
DP_EXPORT_EVENTS.sql	5.11	API Export Events Database Package	02135828
DP_EXPORT_EVENTS.sql	5.12	API Export Events Database Package	00326046
DP_EXPORT_EVENTS.sql	5.13	API Export Events Database Package	00332107
DP_EXPORT_EVENTS.sql	5.15	API Export Events Database Package	00339287
DP_EXPORT_EVENTS.sql	5.17	API Export Events Database Package	00314793
DP_EXPORT_EVENTS.sql	5.18	API Export Events Database Package	00325239
DP_EXPORT_EVENTS.sql	5.20	API Export Events Database Package	00340340
DP_EXPORT_EVENTS.sql	5.21	API Export Events Database Package	00345032
DP_EXPORT_EVENTS.sql	5.22	API Export Events Database Package	02231368
DP_FORD_EDI_IN.sql	5.1	Database Package	00344579
DP_FORD_EDI_IN.sql	5.2	Database Package	02227349
DP_IMP_2.sql	1.81	Import Package	00318182
DP_INT_TMS_WMS_IN_STUB.sql	1.23	Inbound WMS/TMS Interface Package	00318182
DP_INT_XML_CFX.sql	1.7	CFX Interface Database Package	02232219
DP_INT_XML_MIC2.sql	1.35	CTMS to MIC Interface	02111893
DP_INT_XML_MIC2.sql	1.36	CTMS to MIC Interface	02243017
DP_LFE_POD.sql	5.6	LFE POD Database Package	02224778
DP_NOKIA_LOC_PLAT.sql	1.37	Nokia Location Platform Interface	00345445
DP_PAR_API.sql	5.8	Database Package	00345445
DP_PAR_API.sql	5.9	Database Package	02231368
DP_PAR_API_STP.sql	5.1	Database Package	00323035
DP_PULSE.sql	1.51	Pulse Interface Package	00318182
DP_RDT_AUTO.sql	5.47	Client specific RDT funtions	02139434
DP_RDT_FAST_UNLOAD.sql	5.48	RF Unload Package	01935522
DP_REPORTS.sql	5.72	Reports package	00327382
DP_REPORTS.sql	5.73	Reports package	00368493
DP_SCHEDULING_ENGINE.sql	5.179	Scheduling Package	00326413
DP_SCHEDULING_ENGINE.sql	5.180	Scheduling Package	00323035
DP_SCHEDULING_ENGINE.sql	5.181	Scheduling Package	00357019
DP_TOMTOM.sql	1.38	TomTom Package	00330994
DP_TOMTOM.sql	1.39	TomTom Package	00345445
DP_TOMTOM.sql	1.40	TomTom Package	02231368
DP_TRM_CHANGE_SCHEDULE.sql	5.1	Database Package	00345445
DP_TRM_CHANGE_SCHEDULE.sql	5.2	Database Package	00350325
DP_WEB_SERVICE_ORD.sql	1.30	Web Service Package	00318182
DP_XML_EPOD.sql	1.4	XML Database Package	00335523
DP_XML_EPOD.sql	1.5	XML Database Package	00325239
EDI_MAINT.fmx	10.17	EDI Maintenance Screen	00357019
EXECUTION.fmx	1.108	Execution screen	00318182
IMP.sql	5.215	CSV Imports Package	00318182
IMP.sql	5.216	CSV Imports Package	00345853
IMP.sql	5.217	CSV Imports Package	00350912
IMPORTS_MAINT.fmx	1.25	Import Maintenance Form	00318182
INT_ERR.fmx	1.111	Interface Errors	00344579
INT_ERR_ORD.fmx	2.10	Interface error correction	00318182
INT_XML_IN.sql	5.238	Order Import Package	00345814
INT_XML_OUT2.sql	5.326	Outbound XML Package	00344924
INT_XML_OUT2.sql	5.327	Outbound XML Package	00366230
INT_XML_OUT2.sql	5.328	Outbound XML Package	00368176
LOCATION.fmx	2.202	Location Maintenance	00279440
LOCATION.fmx	2.203	Location Maintenance	00326413
LOCATION.fmx	2.204	Location Maintenance	00320489
MSG_MAINT.fmx	2.33	Message Maintenance screen	00318182
MSG_PROCESSING.sql	5.75	Message Processing package	00330994
NETWORK.fmx	1.18	Network Maintenance	00318182
OMS.sql	5.252	Order package	00318182
OMS.sql	5.253	Order package	02132813
OMS.sql	5.254	Order package	02137857
OMS.sql	5.255	Order package	02222075
OMS.sql	5.257	Order package	02263060
OMS.sql	5.329	Order package	00368184
OMS.sql	5.330	Order package	00364162
ORD_ENTRY_TARGET.fmx	2.30	Order Entry Target	00318182
ORDERS.fmx	2.453	Order Screen	00320489
ORDERS_WIDE.fmx	1.49	Orders Screen	00320489
ORDTEMPL.fmx	2.51	Order template	00318182
ORS.fmx	1.37	Oracle Reporting suite	00327382
PLANNING.fmx	1.128	Planning Screen	00327516
PLANNING.fmx	1.129	Planning Screen	02231368
PLANNING.fmx	1.130	Planning Screen	00323035
PLANNING.fmx	1.131	Planning Screen	00357019
PLANNING.fmx	1.132	Planning Screen	00368493
RES_PERSON_UID.sql	5.8	Trigger	00357019
RES_TRACTOR_UID.sql	5.9	Trigger	00357019
ROUTES_MAINT.fmx	2.51	Fixed Routes Maintenance	00322438
ROUTES_MAINT.fmx	2.52	Fixed Routes Maintenance	00323035
SCHED_RULES.fmx	1.35	Scheduling Screen	00318182
STAP_LOAD_SHEET.rep	1.1	Report	00368493
T_SCH_ORD_AUDIT.sql	5.20	Trigger for SCH_ORD_AUDIT	00371961
TI_SCH_ORD_STATUS.sql	1.25	Trigger on SCH_ORD for status change	00350325
TI_SCH_TRIP_AUDIT.sql	5.7	Trigger	02129675
TRG_ACC_ADHOC_SERVICES_BIU.sql	1.1	Trigger	02147681
TRG_ACC_BULK_PACK_CHGS_BIU.sql	1.1	Trigger	02147681
TRG_ACC_BULK_PACKAGING_BIU.sql	1.1	Trigger	02147681
TRG_CNT_CHARGE_CONDITIONS_TRACTOR_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CHARGE_CONDITIONS_TRLRTYPE_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CHARGE_MIN_MAX_IUD.sql	1.2	Trigger	00340479
TRG_CNT_CHARGE_PARAM_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CHARGE_TYPE_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CONDITION_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CONDITION_VALUE_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CONTRACT_INDEX_BIU.sql	1.1	Trigger	00340479
TRG_CNT_CUST_LOC_GROUP_BIU.sql	1.1	Trigger	00340479
TRG_CNT_DEL_TYPE_BIU.sql	1.1	Trigger	00340479
TRG_CNT_DEL_TYPE_CONV_BIU.sql	1.1	Trigger	00340479
TRG_CNT_DEL_TYPE_CUST_EXCL_BIU.sql	1.1	Trigger	00340479
TRG_CNT_DEL_TYPE_USE_BIU.sql	1.1	Trigger	00340479
TRG_CNT_RHA_CONFIG_BIU.sql	1.1	Trigger	00340479
TRG_CNT_RHA_INDEX_BIU.sql	1.1	Trigger	00340479
TRG_CNT_SERVICE_CHARGES_BIU.sql	1.1	Trigger	00340479
TRG_CNT_SERVICE_CONTRACTS_BIU.sql	1.1	Trigger	00340479
TRG_CNT_SERVICE_LEVEL_BIU.sql	1.1	Trigger	00340479
TRG_CNT_STD_JOURNEY_BIU.sql	1.1	Trigger	00340479
TRG_CNT_TIER_NAME_BIU.sql	1.1	Trigger	00340479
TRG_GEO_LOC_WIN_BIU.sql	1.1	Trigger	00322441
TRG_GEO_LOCATION_UID.sql	5.3	Trigger	00323035
TRG_GEO_ROUTE_DTLS.sql	1.2	Trigger	00326413
TRG_IMP_FIELD_BIU.sql	1.1	Trigger	00340479
TRG_IMP_FIELD_SOURCE_BIU.sql	1.1	Trigger	00340479
TRG_IMP_FORMULA_BIU.sql	1.1	Trigger	00340479
TRG_IMP_HIST_DETAIL_BIU.sql	1.1	Trigger	00340479
TRG_IMP_HIST_HEADER_BIU.sql	1.1	Trigger	00340479
TRG_IMP_IMPORT_TYPE_BIU.sql	1.1	Trigger	00340479
TRG_IMP_IMPORT_TYPE_REC_TYPE_BIU.sql	1.1	Trigger	00340479
TRG_IMP_LOAD_AUDIT_BIU.sql	1.1	Trigger	00340479
TRG_IMP_ORDERS_BIU.sql	1.1	Trigger	00340479
TRG_IMP_RECORD_FORMAT_BIU.sql	1.1	Trigger	00340479
TRG_SCH_ORD_AUDIT_LOCS.sql	1.2	Trigger	00325803
TRG_SCH_ORD_CURRENT_DEPOT.sql	5.4	Trigger	00323035
TRG_SCH_ORD_REFERENCE_RUN.sql	5.1	Trigger	00323035
TRG_SCH_ORD_SERVICES_BIUDR.sql	5.4	Trigger for SCH_ORD_SERVICES	00368184
TRG_SCH_ORD_TRACKING_BI.sql	1.2	Trigger	00298173
TRG_SHA_LOTS.sql	5.9	Trigger	02140871
TRG_STS_STATUS_CHANGES.sql	1.1	Trigger	02231368
TRG_STS_STATUS_CHANGES.sql	1.2	Trigger	00350325
TRG_TRIP_COST.sql	1.4	Trigger	02234525
TRG_TT_EVENTS_STORE.sql	1.4	Trigger	00325803
TRG_TT_EVENTS_STORE.sql	1.5	Trigger	00345445
TRG_TT_EVENTS_STORE.sql	1.6	Trigger	02231368
TRIP_OVERVIEW.fmx	1.66	Trip Waterfall	02231368
TRIP_OVERVIEW.fmx	1.67	Trip Waterfall	00350325
TRIP_OVERVIEW.fmx	1.68	Trip Waterfall	00351271
TRIP_OVERVIEW.fmx	1.69	Trip Waterfall	00357019
TRIP_OVERVIEW.fmx	1.70	Trip Waterfall	00365766
TRIP_OVERVIEW.fmx	1.71	Trip Waterfall	00366538
TRIP_OVERVIEW.sql	5.8	Trip Waterfall	00350325
TRIP_SHEET_DUN_DETAIL.rep	5.28	Driver Trip Sheet	02166754
TRM.sql	5.211	Trip manipulation package	02128190
TRM.sql	5.212	Trip manipulation package	00323078
TRM.sql	5.213	Trip manipulation package	00345445
TRM.sql	5.214	Trip manipulation package	00342485
TRM.sql	5.215	Trip manipulation package	02231368
TRM.sql	5.216	Trip manipulation package	00350325
TRM.sql	5.217	Trip manipulation package	00365766
TRM.sql	5.219	Trip manipulation package	02254409
UTL_FILE.sql	5.4	UTL_FILE package	02243017
V_CTL_CUSTGROUP.sql	5.1	View	00315981
V_CTL_CUSTGROUP.sql	5.2	View	00346821
V_CTL_CUSTLOC.sql	5.4	View	00333266
V_CTL_CUSTLOC.sql	5.6	View	00355544
V_DRIVER_LIST.sql	5.2	View	00315981
V_DRIVER_LIST.sql	5.4	View	00364940
V_GEO_CONTACT.sql	1.1	View	00338487
V_ORD_ORDER_HEADER.sql	1.13	View	00315981
V_ORD_ORDER_HEADER.sql	1.14	View	00333266
V_ORD_ORDER_HEADER.sql	1.15	View	00355544
V_ORD_ORDER_STATUS.sql	1.4	View	00355544
V_PRODUCT_CTL.sql	1.2	View	00315981
V_PRODUCT_CTL.sql	1.3	View	00333266
V_PRODUCT_CTL.sql	1.5	View	00355544
V_RES_VEHICLE_CUST_LOC.sql	1.2	View	00349334
V_TRIP_OVERVIEW.sql	1.17	Trip View	02231368
V_TRIP_OVERVIEW.sql	1.19	Trip View	00374968
V_VEHICLE_DETAILS.sql	5.2	View	00315981
V_VEHICLE_DETAILS.sql	5.3	View	00366764
V_VEHICLE_DETAILS.sql	5.4	View	00367653
WAREHOUSE.fmx	2.11	Warehouse Screen	02147681

ADDITIONAL CHANGES

WCS

There is no WCS change required.

EPOD/T2A

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

• Log 00340339
• Log 00349334
• Log 00351008
• Log 00350912
• Log 00371509
• Log 00373035

CTL

A CTL change is required for the following logs:

• 00340142
• 00355544
• 00365146
• 00366764
• 00367653
• 00327382
• 00373035

MCS

There is no MCS change required.

PORTAL/TTM

A Portal change is required for the following logs:

• Log 02132813
• Log 02137857

EDI

There is no EDI change required.