PATCH C-TMS P045: Difference between revisions

From Calidus HUB
No edit summary
No edit summary
Line 723: Line 723:
|width="30%"|'''Summary of Call'''|| TI Order Import - Validate Date Formats
|width="30%"|'''Summary of Call'''|| TI Order Import - Validate Date Formats
|-
|-
|'''Detail of Fix''' || The package is modified. So, when an invalid date format is imported, it’s been reported with a valid error message.
|'''Detail of Fix''' || The package is modified. So, when an invalid date format is imported, it's been reported with a valid error message.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 769: Line 769:
|'''Detail of Fix''' || Main version 1.45 of the TomTom/Webfleet process for the branched version 1.37.1.4.
|'''Detail of Fix''' || Main version 1.45 of the TomTom/Webfleet process for the branched version 1.37.1.4.
|-
|-
|'''Set-up and Configuration''' ||
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}



Revision as of 00:35, 18 October 2023




Aptean Logo.png










Release Notes


CALIDUS TMS

17th Oct 2023 - 1.0
Reference: P045












































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

Summary of Call REF: 19874 - 3PL Scheduling Engine failing with a null stop number
Detail of Fix

1. Any depot that is listed in the system parameter 'AUTO_SCHED_INACTIVE_DEPOTS' will not be processing its orders in the 3PL scheduling engine. These orders will be marked for manual scheduling and they will have an audit message 'The depot is inactive for scheduling, order cannot be scheduled'.

2. If a drop number cannot be derived for the location for the route, then an order for that location will not be scheduled. A default drop number cannot be applied for the position of the trip stop. These orders will be marked for manual scheduling and they will have an audit message 'Cannot pre-plan no drop number available'.

Set-up and Configuration No set-up/configuration required


Log Number: 00480177

Summary of Call REF: 19538 - API orders timing out and taking too long to process
Detail of Fix An index has been added to the order import process for the customer reference.
Set-up and Configuration No set-up/configuration required


Log Number: 02595605

Summary of Call Tractor Information for BI
Detail of Fix Scripts prepared for MIS_EXTRACT data to include RES_TRACTOR
Set-up and Configuration No set-up/configuration required


Log Number: 00474273

Summary of Call REF: 19873 - Failures in STP API orders and 3PL scheduling
Detail of Fix The orders are assigned by the 3PL scheduling engine to trip stops based on their activity at those stops.

The orders will be loaded or unloaded at a stop.

DP_CTMS_IMPORT is modified the error message where it said DEP/DEL address cannot be NULL when ext_ref is not found be reported with a better message. Corrected the logic which caused unique constraint violated error.

The API for the orders will prevent an attempt to create duplicate locations.

Set-up and Configuration No set-up/configuration required


Log Number: 00464750

Summary of Call SCR 05: Show vehicle and technician
Detail of Fix Display driver name in CTL
Set-up and Configuration No set-up/configuration required


Log Number: 00464795

Summary of Call SCR 44: Job Ticket to display a free-text field to add to service report to add "Actual Customer"
Detail of Fix Development to display the 'Actual Customer' in CTL and on the epod pod note.
Set-up and Configuration No set-up/configuration required


Log Number: 02592042

Summary of Call SCR 13: Add Default Vehicle to Driver
Detail of Fix A new column is added to RES_PERSON to store Default vehicle ID.

The CTMS system is modified to allow the technicians to have a default vehicle.

The CTL Call Logging screen will use this information to default the vehicle for the driver, if that driver has no current trip.

Set-up and Configuration No set-up/configuration required


Log Number: 00479896

Summary of Call SCR 21: Top-Up Transfers
Detail of Fix Development for Top-up transfers. Allows the creation of Top-up transfer orders.
Set-up and Configuration No set-up/configuration required


Log Number: 00477098

Summary of Call Generate Warehouse Charges from Contracts
Detail of Fix The 'WAREHOUSE' non-standard tariffs will depend on a condition of 'MANUAL' or 'MONTHLY FEE'.

A 'MANUAL' condition means that the charge will apply only in the 'Warehouse' screen. A 'MONTHLY FEE' condition means that the charge will apply only in the monthly generation of the charges.

Set-up and Configuration No set-up/configuration required


Log Number: 00487971

Summary of Call Ref: 20145 - Mismatches in Waterfall Screen
Detail of Fix The orders on the TMP trips for the routes that are being planned by the Paragon API for version STP will be reset to UNSCHEDULED status before they are replanned or not planned.
Set-up and Configuration No set-up/configuration required


Log Number: 00467382

Summary of Call SCR 20: New Vehicle - don't specify type
Detail of Fix CTMS will create the vehicle axles and tyres when the job is completed and create the inspections based on the callout.
Set-up and Configuration No set-up/configuration required


Log Number: 00469939

Summary of Call SCR 16: Allow searching for local tyres when offline.
Detail of Fix The CTMS part master data will be updated whenever the parts are selected or used in CTMS and EPOD.
Set-up and Configuration No set-up/configuration required


Log Number: 00479895

Summary of Call SCR 17: Add Vehicle ODO details to send to Elucid
Detail of Fix This change will change the way that the CTL books jobs for adding taking stock to a technician whilst on a job.

Link with SCR-17 & 28

Set-up and Configuration No set-up/configuration required


Log Number: 00479887

Summary of Call SCR: 28 Vehicles Unique per Customer
Detail of Fix This change will change the way that customer vehicle data is stored. This will now be by customer.

Link this with SCR-17 - 479895 and SCR-21 - 479896 and SCR- 20 - 467382 and SCR- 16 - 469939

Set-up and Configuration No set-up/configuration required


Log Number: 00479899

Summary of Call SCR: 35 Services Supplied at Job Level
Detail of Fix This change will change the way that CTMS stores and generates services supplied.

Currently, the EPOD device has been configured to prompt for some services supplied at a vehicle level, as opposed to at the tyre position level (i.e. Installation or Other Work). CTMS will recognise this and add the services supplied from vehicle-level entries.

Set-up and Configuration No set-up/configuration required


Log Number: 00484535

Summary of Call EDI Parameter PREVENT_RESEND_ORDER
Detail of Fix EDI parameter used to prevent rebooked order being sent if the original order has already been sent
Set-up and Configuration No set-up/configuration required


Log Number: 00491708

Summary of Call Release task to for SCR-28 and 17
Detail of Fix Amendments to SCR 17 & 28
Set-up and Configuration No set-up/configuration required


Log Number: 00479894

Summary of Call SCR:42 Outside Stores/Depot Hubs to be used
Detail of Fix This change will change the CTL Call Logging screen to identify the start of the technician's trip based on their own defined hub location, and to identify the pickup location of the order based on the product selected.
Set-up and Configuration No set-up/configuration required


Log Number: 00479897

Summary of Call SCR: 29 Enter Van Stock
Detail of Fix Change to add new Item types for Van Stock, Fit Other and Services only etc.
Set-up and Configuration No set-up/configuration required


Log Number: 00493457

Summary of Call Release task for additional changes to SCR 28
Detail of Fix Created for re-release of SCR-28 for the issue reported of missing location in RTC which needs a fix in DP_CUST_SERV.pck and DP_EPOD_WEB_SERVICE to update the current_location_id on RTC
Set-up and Configuration No set-up/configuration required


Log Number: 02665941

Summary of Call Set system parameter CFX_CARRIER so it can be configured at a cost centre level
Detail of Fix CFX_CARRIER is changed to make it configurable by CARRIER instead of SYSTEM. The programs using the parameter are also changed accordingly.

User can configure CARRIER level data instead of SYSTEM level.

Set-up and Configuration No set-up/configuration required


Log Number: 00499175

Summary of Call CTL Top-up transfers
Detail of Fix Release views for ctl Top-up transfers
Set-up and Configuration No set-up/configuration required


Log Number: 00498787

Summary of Call Amendment to TYRE_INSP for SCR-28
Detail of Fix The ORS type TYRE_INSP has been amended to join the tractor specifically to the tractor for the customer of the order at all levels of the report.
Set-up and Configuration No set-up/configuration required


Log Number: 00467514

Summary of Call Report required in ORS for trips. Need to be able to stipulate start location and end location.
Detail of Fix New ORS type has been created called 'TRIP_LOCS' which has 5 columns

SCHED_NAME - Range - Required

TRIP_ID

LOAD_LOC - Value - Required

UNLOAD_LOC - Value - Required

ROUTE_CODE


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

User Notes :In order to get unique records, user can use the sort and group_by tick box in the screen. As Load and Unload locations are the selection criteria they can be discarded from the report by not including them, it can be done by unticking the Inc tick box.

Set-up and Configuration No set-up/configuration required


Log Number: 00504598

Summary of Call SCR29 Fix for 479897
Detail of Fix Fix to send ePod collections correctly.
Set-up and Configuration No set-up/configuration required


Log Number: 00497703

Summary of Call Release for DEV-20 for 02592042
Detail of Fix CTMS will create the vehicle axles and tyres when the job is completed and create the inspections based on the callout.

The CTMS part master data will be updated whenever the parts are selected or used in CTMS and EPOD. EDI Jobs creation is needed for the triggers.

Set-up and Configuration No set-up/configuration required


Log Number: 00495690

Summary of Call WREQ0087544: Finance File Interfaced to Oracle v1.00
Detail of Fix Program change, new fields added to extract
Set-up and Configuration No set-up/configuration required


Log Number: 00512651

Summary of Call The Paragon ID is not updated for the locations via the API
Detail of Fix New EDI parameter called UPDATE_PARAGON_ID is created for API process when set to Y will update the Pargon_ID for geo_location as per the creation of new location.
Set-up and Configuration No set-up/configuration required


Log Number: 00510378

Summary of Call Add all the preferences at the order level to the Trip Waterfall screen
Detail of Fix The preferences in order level is made available for configuration. 10 order status are added to PREFERENCE_STATUS table if not already present before.
Set-up and Configuration No set-up/configuration required


Log Number: 00515979

Summary of Call Ref: 20978: Paragon inactive depots
Detail of Fix The ORD and LOC records will not be sent to Paragon when they are for an inactive depot.
Set-up and Configuration No set-up/configuration required


Log Number: 00481577

Summary of Call Management of the Hub Locations and the Empty Trip Stops
Detail of Fix New functionality added to prevent the deletion of empty stops and depot locations
Set-up and Configuration No set-up/configuration required


Log Number: 00517175

Summary of Call INT_XML_CONTROL
Detail of Fix Add new index to table
Set-up and Configuration No set-up/configuration required


Log Number: 00515770

Summary of Call Audit customers in import
Detail of Fix The customer and order import processes via the API will include a message in the audit log when a process starts and when some data has been extracted.
Set-up and Configuration No set-up/configuration required


Log Number: 00516754

Summary of Call Update the PARAGON_ID for the main location for a customer
Detail of Fix The 'PARAGON_ID' for the location can be set when the customer itself is updated without any address information being provided via the customer API.

This functionality requires the EDI parameter 'UPDATE_PARAGON_ID' to be set to 'Y' for the 'API' process.

Set-up and Configuration No set-up/configuration required


Log Number: 00507384

Summary of Call Provide authorisation for the required field for the ORS
Detail of Fix Removed the existing Req All and Req None buttons. Created a new function called 'Ors_Edit_Req_field' which can be made accessible by user groups to enable the user to edit the 'Req' field. When an authorized user tries to edit the 'Req' field then a warning will appear to the unauthorised user of the possible consequences and advise the user to confirm the amendment of report with the system manager.
Set-up and Configuration No set-up/configuration required


Log Number: 00517964

Summary of Call Paragon API updates
Detail of Fix The tractor will be updated for an existing trip without restriction based on the end time of the shift.
Set-up and Configuration No set-up/configuration required


Log Number: 00517796

Summary of Call Include decode STOP_TYPE in Trip Waterfall
Detail of Fix The decoded values of 'STOP_TYPE' will be used in the Trip Waterfall screen to replace the codes for the stop types with descriptions, for example, 'Start Up' for 'SU'.

The codes will be used by default when the decoded values do not exist.

Set-up and Configuration No set-up/configuration required


Log Number: 00518000

Summary of Call Amend Trip Locations in Trip Waterfall
Detail of Fix Trip Locations in waterfall is amended to use Location when stop is RDC or town when others.

Stop Type is removed from Trip Locations as its already present in Trip Stops.

Set-up and Configuration No set-up/configuration required


Log Number: 00516565

Summary of Call Post Trigger error in Planning
Detail of Fix Delivery_type_id is updated to length 35 in Orders and Planning screen to avoid the POST-QUERY trigger error.
Set-up and Configuration No set-up/configuration required


Log Number: 00492872

Summary of Call Development for Supporting Documentation
Detail of Fix New columns for consumer and carton packaging are added for the Supporting Documentation for the invoicing.

These documents will include the new columns:

Added the 'Pick Qty' to these formats and the export file:

Cargowise Detail SD1

Cargowise Detail SD2

Cargowise Detail SD3

Cargowise Detail SD5

Cargowise Detail SD6

Payment Details


Added the 'Consumable Charges' to these formats and the export file:

Cargowise Detail SD1

Cargowise Detail SD2

Cargowise Detail SD6

Payment Details

Set-up and Configuration No set-up/configuration required


Log Number: 00346696

Summary of Call Inspection Required Issue
Detail of Fix Updated f_last_inspection function to set a default date when it is NULL.
Set-up and Configuration No set-up/configuration required


Log Number: 00521650

Summary of Call Additional changes for 492872 - Development for Supporting Documentation
Detail of Fix PAYMENT_DTLS export type has been modified to display SCREENING Charge as last column with corresponding value which was missing in previous version.
Set-up and Configuration No set-up/configuration required


Log Number: 00516019

Summary of Call Update Paragon keys
Detail of Fix Keys updated with correct dates and master key values
Set-up and Configuration No set-up/configuration required


Log Number: 00501535

Summary of Call Include auditing for Paragon API
Detail of Fix Added auditing to packages to know what's been sent to paragon through API and also when the RUN_NUMBER is changed.
Set-up and Configuration No set-up/configuration required


Log Number: 00488390

Summary of Call Rating-Invoicing Requirements
Detail of Fix

Invoice Screen:

Refreshes the data for the Adhocs tick box.

Warehouse Screen:

Commits the changes when the New button is pressed like the Save button for the ad-hoc services. Uses the condition of MANUAL for Warehouse charges. Accounts for multiple valid non-standard tariffs by condition.

Customers Screen:

Introduces Consumable Service Charges and Carton Service Charges for the customer.

Contracts Screen:

Adds SERVICE conditions for CONSUMPAK and CTNPAK. Charges and payments will use these conditions when the Consumable Service Charges and Carton Service Charges are active for the customer.

Rating Process:

Sets the status of the payments to A not F. Retains ORD_LINE payments not PICK_PACK for the PICKPACK tariff. Activates the system parameter ACC_CONTRACT_SERVICES for the SERVICES tariff for the CONSUMPAK and CTNPAK payments.

Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Log Number: 00470712

Summary of Call Invoice Generation for Parties
Detail of Fix Invoices can be created for payments that have been created for orders for customers for rating parties.
Set-up and Configuration No set-up/configuration required


Log Number: 02588754

Summary of Call Trip Tree Data Loading
Detail of Fix The PLANNING screen has been modified to include the user's time zone instead of the default system date
Set-up and Configuration No set-up/configuration required


Log Number: 00464118

Summary of Call TI Order Import - Validate Date Formats
Detail of Fix The package is modified. So, when an invalid date format is imported, it's been reported with a valid error message.
Set-up and Configuration No set-up/configuration required


Log Number: 02660730

Summary of Call Unable to set order back to planned
Detail of Fix Trip header update for external cost value
Set-up and Configuration No set-up/configuration required


Log Number: 02595529

Summary of Call Routes pulling through to AX as Manual carriers and open not 'firm-planned'
Detail of Fix Routes pulling through to AX as Manual carriers and open not 'firm-planned' HAULIER fields > 6 and last 3 are a depot code then trim so passes 6 char code to AX.
Set-up and Configuration No set-up/configuration required


Log Number: 00340478

Summary of Call Include a locking strategy and error handling in the Paragon import API process
Detail of Fix Added locking to the paragon packages to allow records to be skipped if locked.
Set-up and Configuration No set-up/configuration required


Log Number: 00375203

Summary of Call Main version for Webfleet
Detail of Fix Main version 1.45 of the TomTom/Webfleet process for the branched version 1.37.1.4.
Set-up and Configuration No set-up/configuration required



BUGS

Log Number: 02657296

Summary of Call Unable to copy tariff
Detail of Fix Change is made to Contract’s copy functions to display the currency dropdown to enable copying.
Set-up and Configuration No set-up/configuration required


Log Number: 00481350

Summary of Call Encountered error in planning, missing Unload activities (no cl and no date/times)
Detail of Fix Various changes to set the stop IDs and the stop numbers, to account for missing SU and empty stops.

Control records will be created for 'PAR_API' when the order is scheduled to 'DSK' or 'PCL' trips.

Set-up and Configuration No set-up/configuration required


Log Number: 00482360

Summary of Call Ref: 19909: Invalid orders sent from TMS to Paragon
Detail of Fix Any new order lines should trigger an update to the Paragon API when the order is UNSCHEDULED not INVALID.
Set-up and Configuration No set-up/configuration required


Log Number: 00490822

Summary of Call 3PL trips not rating
Detail of Fix Improve efficiency of rating for 3PL carriers
Set-up and Configuration No set-up/configuration required


Log Number: 00484500

Summary of Call Fixed Route Template
Detail of Fix All fields added to the Import
Set-up and Configuration No set-up/configuration required


Log Number: 02680480

Summary of Call CTMS- On time items (Assets) report is displaying 'DG' exception code incorrectly
Detail of Fix The 'On Time Items', 'On Time Items (Assets)' and 'On Time Returns' exports have been changed because they include the reason code for the item itself.

The 'On Time Arrivals' and 'On Time Drops' exports have not been changed because they include a reason code for an item for the order.

The selected item may not have one of the reason codes that are included for the order itself.

Set-up and Configuration No set-up/configuration required


Log Number: 00496683

Summary of Call Set system parameter CFX_CARRIER so it can be configured at a carrier level
Detail of Fix CFX_CARRIER is changed to make it configurable by CARRIER instead of SYSTEM, The programs using the parameter are also changed accordingly.

User can configure CARRIER level data instead of SYSTEM.

Set-up and Configuration No set-up/configuration required


Log Number: 00495952

Summary of Call Payment Type Testing
Detail of Fix The 'CTNPAK' and 'CONSUMPAK' charge conditions can be assessed independently of each other for the 'SERVICE' tariff.

'Consignee' is included as the column heading on the extract for Cargowise.

Set-up and Configuration


Log Number: 00495483

Summary of Call Unschedule orders for new run numbers for STS
Detail of Fix Change is made so that the orders should be unscheduled from the trips for the route when the run number is readvised, and scheduled back to another trip or create new when scheduling engine is running.
Set-up and Configuration No set-up/configuration required


Log Number: 00498233

Summary of Call Testing issues
Detail of Fix Correction to the following ORS reports HAULIER, INTERFACE, CARR_ALLOC and ORD_STATS.
Set-up and Configuration No set-up/configuration required


Log Number: 00481913

Summary of Call Paragon - Run Keys
Detail of Fix New process added to procedure to allow the keys to be manually updated
Set-up and Configuration No set-up/configuration required


Log Number: 00305414

Summary of Call Cancellation emails not showing in message monitoring
Detail of Fix The database script will remove the constraint and replace it as a normal index.

To resolve issue with cancellation emails not showing in the message monitoring

Set-up and Configuration No set-up/configuration required


Log Number: 00499449

Summary of Call Autorefresh in TMS not working
Detail of Fix Some logic has been added to Waterfall screen to make it more dynamic when Auto refresh functionality has been made enabled for the user group.
Set-up and Configuration No set-up/configuration required


Log Number: 00505522

Summary of Call Drop the constraint for the audit messages
Detail of Fix The constraint by created date and time that exists for the audit messages will be removed.
Set-up and Configuration No set-up/configuration required


Log Number: 00505975

Summary of Call Missing drop numbers
Detail of Fix The locations for the routes will be uploaded from Paragon.
Set-up and Configuration No set-up/configuration required


Log Number: 00506725

Summary of Call SCR29 Issues.
Detail of Fix Fixed CTMS package to set line/item qtys differently. Retrieve product description when using default products.
Set-up and Configuration No set-up/configuration required


Log Number: 00508400

Summary of Call Add new vehicle failure for Fleet Inspection
Detail of Fix Fixed the issue of the addition of new vehicles to the fleet inspections.
Set-up and Configuration No set-up/configuration required


Log Number: 00469910

Summary of Call Webfleet Integration
Detail of Fix Various fixes for the TomTom interface.
Set-up and Configuration No set-up/configuration required


Log Number: 00505586

Summary of Call Actual times being overwritten
Detail of Fix Only populate actual time if not currently set in the TomTom interface
Set-up and Configuration No set-up/configuration required


Log Number: 00510701

Summary of Call EDI Failure Notification
Detail of Fix Changes made to in_xml_in package to build the location id using an alpha/numeric suffix.
Set-up and Configuration No set-up/configuration required


Log Number: 00512122

Summary of Call Fix for SCR - 29
Detail of Fix The CTMS package is fixed to mitigate the change in work type and prevent collection jobs from being sent to ePod when the store location and job's destination location match.
Set-up and Configuration No set-up/configuration required


Log Number: 00512100

Summary of Call Validation error
Detail of Fix The problem relates to the lat-long calculation failing for an address in Jersey.

The country code was GB not the required JE. Once the country code had been amended, the lat-long could be calculated.

Set-up and Configuration


Log Number: 00510599

Summary of Call Duplicate unload records in trip PAR-00013894
Detail of Fix Prevents the order being added to the trip multiple times by the STP Paragon API.
Set-up and Configuration No set-up/configuration required


Log Number: 00512119

Summary of Call Unschedule orders for new delivery date
Detail of Fix A new EDI parameter called 'UNSCHED_NEW_DATE' has been introduced for the 'API' process to import the order.

When it is set to 'Y', the order will be unscheduled from any incomplete trips when the order has a new schedule.

It will work for earlier and later schedules for the order.

Set-up and Configuration No set-up/configuration required


Log Number: 02694314

Summary of Call Planning screen error
Detail of Fix When user has a specific cost centre set then the schedule from trip tree is defaulted to from schedule of the order well screen.
Set-up and Configuration No set-up/configuration required


Log Number: 00516061

Summary of Call Ref: 21507: Trip resource not updating
Detail of Fix The tractor as well as the driver for the trip will be stored as advised by Paragon via the API.
Set-up and Configuration No set-up/configuration required


Log Number: 00510181

Summary of Call Ref: 20978: Scheduling engine performance
Detail of Fix Queries changes to have better execution paths, removing full table scans
Set-up and Configuration


Log Number: 02722382

Summary of Call Order API interface
Detail of Fix Fix has been made as the main version 5.25 had a flaw while inserting the value into CLOB after trimming the carrier ID to 6 when it’s a 3PL carrier.
Set-up and Configuration


Log Number: 00499590

Summary of Call Waterfall Screen Updates - following release of 495483
Detail of Fix If there are less than 2 stops for a trip then the distance of the trip is made to zero, which can be viewed in waterfall screen.
Set-up and Configuration


Log Number: 00517612

Summary of Call Can't enter default vehicle for a driver
Detail of Fix Issue with Resource Form versions 2.196-2.197, corrected in version 2.198.
Set-up and Configuration


Log Number: 00517795

Summary of Call Services supplied from Other Work and Vehicle lines have not been added to the order
Detail of Fix Added the qty_to_deliver - will be updated for the order items when null.

Prevented the creation of VEHICLE/INSPECT items.

Omited WPX_PRODUCT_ID from the update of the order items.

Set-up and Configuration


Log Number: 00517913

Summary of Call Not including TO_DELIVER quantities
Detail of Fix The COL message will be generated for the API events.

Updates the despatched quantity for a product when an item is collected

Set-up and Configuration


Log Number: 00517899

Summary of Call CTL Call Logging - No services displayed in Services Only table
Detail of Fix Includes RIGID and VEHICLE types of vehicles.

Excludes 'CANCELLED', 'DELETED', 'ABANDONED', 'REJECTED' trips.

Set-up and Configuration


Log Number: 00517783

Summary of Call Order Vehicles section not exported to Elucid.
Detail of Fix The messages for the API events will include the <ORDER_VEHICLES> section when a vehicle exists for an order.
Set-up and Configuration


Log Number: 00517813

Summary of Call Services Supplied not populated on order items
Detail of Fix The services for the order will be created when the item for the VEHICLE SERVICE is added as well as when it is updated.

EPOD will provide the service for the vehicle in the EPL_FAULT item for this purpose.

Set-up and Configuration


Log Number: 00518292

Summary of Call Vehicle Search - Customer Vehicles are showing NOT INSPECTED when they are.
Detail of Fix Modified the code so that, Vehicle Inspection will now show the correct status.
Set-up and Configuration


Log Number: 00519173

Summary of Call EPOD Interface - Adding installs to fleet inspection is missing customer vehicle
Detail of Fix The customer vehicle will be stored for the order items when the item is created for the serviced product based on the EPL_CODE_2 when the EPL_CUST_VEHICLE is not provided.

Separate items will be created for VEHICLE-SERVICE by customer vehicle.

Set-up and Configuration


Log Number: 00518660

Summary of Call CTMS Import - Tyres import fails.
Detail of Fix Amended IMP package to process LOAD_INDEX as a character value
Set-up and Configuration


Log Number: 00519909

Summary of Call Reset the Send to Paragon flag in Routes Maintenance
Detail of Fix The 'Send to Paragon' flag in the 'Routes Maintenance' screen will have a default value of 'Y' to send the route to Paragon when Paragon is implemented.

The box may be unticked to prevent the route being used in Paragon.

Set-up and Configuration


Log Number: 00521007

Summary of Call Customer/Cost Centre shows error when entering the screen
Detail of Fix Updated the CUSTOMER_NAME and CONTACT_NAME in form to 50 to match the database column and to stop the error prompt when opened the Customer/cost centre maintenance screen.
Set-up and Configuration


Log Number: 00520185

Summary of Call Customer Vehicle Import fails
Detail of Fix The CUST_FLEET import will use a mandatory CUSTOMER_ID to maintain the vehicle information for the tractors, axles, tyres and locations.

Types of locations may be BRANCH and INV.

Set-up and Configuration


Log Number: 00518002

Summary of Call CTL Call Logging - Subsequent job booked onto already completed stop
Detail of Fix System parameter TRM_PREVENT_ORD_ON_COMP_STOP when set to Y this prevent any order being planned onto a completed stop
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
TRM_PREVENT_ORD_ON_COMP_STOP SYSTEM Y Prevent orders being added to completed stops


Log Number: 00519864

Summary of Call Booking job onto already existing job result sin trip end time being reset
Detail of Fix Add system parameter TRM_SHIFT_TIMES_FOR_TRIP to prevent end time of trip being updated to not be the end of a drivers shift
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
TRM_SHIFT_TIMES_FOR_TRIP SYSTEM Y Use start and end time of shift for start and end times on trip


Log Number: 00518589

Summary of Call CTL Call Logging - Cancel/Delete order does not prompt for reason code
Detail of Fix Development done on CTL and CTMS, reason codes added to order in CTMS and status set to CANCELLED
Set-up and Configuration


Log Number: 00520332

Summary of Call CTMS EPOD Interface - Main address does not include Lat/Long
Detail of Fix Lat/longs added to Job node
Set-up and Configuration


Log Number: 00520335

Summary of Call CTMS-PORTAL TTM Interface - Orders still showing as part-delivered in Order Visibility
Detail of Fix Van stock items debriefed at collection
Set-up and Configuration


Log Number: 00521914

Summary of Call Treat FAILED jobs as a cancellation message to outbound API.
Detail of Fix Update the status of FAILED orders to CANCELLED within the message for outbound API messages
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
INCLUDE_FAILED_ORDERS COST CENTRE Y Send Failed orders to Outbound API and change the status in the message to CANCELLED


Log Number: 00522359

Summary of Call EPOD Device - Vehicle search produced many tyres
Detail of Fix Update cursors to include customer details
Set-up and Configuration


Log Number: 00521338

Summary of Call Lat Longs not created
Detail of Fix Fixed issue which was avoiding the population of Lat/Long.
Set-up and Configuration No set-up/configuration required


Log Number: 00522300

Summary of Call Use actual times if present when determining arrive/depart times when new order applied to trip
Detail of Fix Use actual times from previous stop to calculate arrival at next stop
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
TRM_USE_ACTUALS_FOR_STOP_TIMES SYSTEM Y Use actual times to derive new stop times


Log Number: 00522955

Summary of Call Pass work type and position on all work types to Portal and update order line correctly
Detail of Fix Pass work type and position to portal for all records
Set-up and Configuration No set-up/configuration required


Log Number: 02737619

Summary of Call Waterfall not displaying Weight on RPLS
Detail of Fix Package changed to obtain weights correctly
Set-up and Configuration No set-up/configuration required


Log Number: 00522214

Summary of Call Unable to parse the Load Planning Request
Detail of Fix The address information for the trip stops and the orders will convert an '&' to '& amp;'
Set-up and Configuration No set-up/configuration required


Log Number: 00524609

Summary of Call Generate van stock line for every Fit New install
Detail of Fix Added item identifier to epod message, created new V type record on orders
Set-up and Configuration No set-up/configuration required


Log Number: 00524544

Summary of Call API Export - COL sent after DEL
Detail of Fix Change to trigger to stop second COL message being created
Set-up and Configuration No set-up/configuration required


Log Number: 00525198

Summary of Call CTL Call Logging - Can't raise a top-up transfer against a service-only job
Detail of Fix Fixed refresh of driver list for Top-Up transfers. Filtered out inactive drivers. Filtered out DELIVERED and FAILED orders from the Orders list.
Set-up and Configuration No set-up/configuration required


Log Number: 00525976

Summary of Call Cannot create services only without a product
Detail of Fix Change is made to functionality that will enable to create a service when product is not provided without an error.
Set-up and Configuration No set-up/configuration required


Log Number: 02466153

Summary of Call Release Task
Detail of Fix Performance issue - correct selection criteria
Set-up and Configuration No set-up/configuration required


Log Number: 02719799

Summary of Call Webfleet integration
Detail of Fix Extended the field t_ext_ref length to VARCHAR2(50). Amended the EDI process name to the dp_reports audit message.
Set-up and Configuration No set-up/configuration required



PRODUCT DEVELOPMENT

Log Number: 00474454

Summary of Call Missing auditing for COL export events in the API
Detail of Fix The web service audit records will be created for the COL events as well as the VLI, VLD and VUI events.
Set-up and Configuration No set-up/configuration required


Log Number: 00489063

Summary of Call Revert tier for pallet storage
Detail of Fix The tier for the 'Warehouse' screen will revert to 'WAREHOUSE'.
Set-up and Configuration No set-up/configuration required


Log Number: 00482059

Summary of Call Enable RET orders to be added to PCL trips in the 3PL scheduling engine
Detail of Fix Code change - changed the DP_3PL-SCHED package to allow RET orders to be added to PCL trips
Set-up and Configuration No set-up/configuration required


Log Number: 00489611

Summary of Call Duplication with TMS Orders
Detail of Fix Any orders that are locked will not be submitted to the 3PL scheduling engine until they have been unlocked.
Set-up and Configuration No set-up/configuration required


Log Number: 00481867

Summary of Call Include the Send to Paragon flag in the import process for Fixed Routes
Detail of Fix Send To Paragon flag added to Import

Any new order lines should trigger an update to the Paragon API when the order is UNSCHEDULED not INVALID.

Set-up and Configuration No set-up/configuration required


Log Number: 00497948

Summary of Call Main version for DP_CARRIER_API
Detail of Fix Changes from branched version incorporated into main version

The functionality that is controlled by the system parameter 'CARRIER_API_MANIFEST_READY_TIME': setting it to a time will allow the bookingDate to refer to the packed date or the created date of the order instead of the late delivery date.

Set-up and Configuration No set-up/configuration required



MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.84 Accounts package 00477098
ACC.sql 5.86 Accounts package 00488390
AT_INT_XML_CONTROL_517175.sql 1.1 AT Script 00517175
AT_INT_XML_ORD_HEADER_480177.sql 1.1 AT Script 00480177
AT_MSG_SMS_AUDIT_305414.sql 1.1 AT Script 00305414
AT_MSG_SMS_AUDIT_505522.sql 1.1 AT Script 00505522
AT_ORG_CUSTOMER_00488390.sql 1.2 AT Script 00488390
AT_PAR_KEYS_481913.sql 1.1 AT Script 00481913
AT_PAR_KEYS_481913_1.sql 1.1 AT Script 00481913
AT_RES_PERSON_02592042.sql 1.1 AT Script 02592042
AT_RES_VEHICLE_AXLE_479887.sql 1.1 AT Script 00479887
AT_RES_VEHICLE_TYRE_479887.sql 1.1 AT Script 00479887
AT_SCH_ORD_464795.sql 1.2 AT Script 00464795
AT_SCH_ORDER_LINE_482360.sql 1.1 AT Script 00482360
BDM.fmx 2.109 Business Data Form 00481913
CNT.sql 5.58 Contracts package 00470712
CNT.sql 5.59 Contracts package 00488390
CONTRACT.fmx 2.83 Contracts Form 02657296
CT_RES_TRACTOR_CUSTOMER_479887 1.1 CT Script 00479887
CT_TOMTOM_DEBUG.sql 5.2 CT Script 00469910
CUST_COST.fmx 2.144 Customer Maintenance form 00488390
CUST_COST.fmx 2.145 Customer Maintenance form 00521007
DATA_1_IMP_DECODE_TYPE_512100.sql 1.1 Data Script 00512100
DATA_1_MIS_EXTRACT_HEADER_02595605.sql 1.1 Data Script 02595605
DATA_2_IMP_DECODE_512100.sql 1.1 Data Script 00512100
DATA_2_MIS_EXTRACT_DETAIL_02595605.sql 1.1 Data Script 02595605
DATA_3_IMP_DECODE_ENTRY_512100.sql 1.1 Data Script 00512100
DATA_ADM_FORM_TAB_481913.sql 1.2 Data Script 00481913
DATA_ADM_FUNCTION_507384.sql 1.1 Data Script 00507384
DATA_ADM_SYSTEM_PARAM_02665941.sql 1.1 Data Script 02665941
DATA_ADM_SYSTEM_PARAM_340478.sql 1.1 Data Script 00340478
DATA_ADM_SYSTEM_PARAM_479897.sql 1.1 Data Script 00479897
DATA_ADM_SYSTEM_PARAM_482059.sql 1.1 Data Script 00482059
DATA_ADM_SYSTEM_PARAM_518002.sql 1.2 Data Script 00518002
DATA_ADM_SYSTEM_PARAM_519864.sql 1.1 Data Script 00519864
DATA_ADM_SYSTEM_PARAM_521914.sql 1.1 Data Script 00521914
DATA_ADM_SYSTEM_PARAM_522300.sql 1.1 Data Script 00522300
DATA_ADM_SYSTEM_PARAM_524609.sql 1.1 Data Script 00524609
DATA_ADM_SYSTEM_PARAM_CONFIG_02665941.sql 1.1 Data Script 02665941
DATA_ADM_SYSTEM_PARAM_CONFIG_482059.sql 1.1 Data Script 00482059
DATA_ADM_SYSTEM_PARAM_CONFIG_521914.sql 1.1 Data Script 00521914
DATA_ADM_SYSTEM_PARAM_CONFIG_524609.sql 1.1 Data Script 00524609
DATA_CNT_CHARGE_PARAM_00488390.sql 1.1 Data Script 00488390
DATA_CNT_CONDITION_00447098.sql 1.1 Data Script 00477098
DATA_CNT_CONDITION_00488390.sql 1.1 Data Script 00488390
DATA_CNT_CONDITION_VALUE_00447098.sql 1.1 Data Script 00477098
DATA_CNT_CONDITION_VALUE_00488390.sql 1.1 Data Script 00488390
DATA_EDI_PROCESS_TRIGGERS_501535.sql 1.1 Data Script 00501535
DATA_EDI_PROCESS_TRIGGERS_512651.sql 1.1 Data Script 00512651
DATA_GEO_LOC_TYPE_479894.sql 1.1 Data Script 00479894
DATA_IMP_FIELD_479887.sql 1.2 Data Script 00479887
DATA_IMP_FIELD_479887.sql 1.2 Data Script 00491708
DATA_IMP_FIELD_479894.sql 1.1 Data Script 00479894
DATA_IMP_FIELD_481867.sql 1.1 Data Script 00481867
DATA_IMP_FIELD_484500.sql 1.2 Data Script 00484500
DATA_ORG_CUST_ORD_REV_CHG_TYPE_521007.sql 1.1 Data Script 00521007
DATA_ORS_MASTER_DATA_467514.sql 1.1 Data Script 00467514
DATA_ORS_MASTER_DATA_479887.sq 1.1 Data Script 00479887
DATA_ORS_MASTER_DATA_479887.sql 1.2 Data Script 00493457
DATA_ORS_MASTER_DATA_498233.sql 1.2 Data Script 00498233
DATA_ORS_MASTER_DATA_498233_1.sql 1.2 Data Script 00498233
DATA_ORS_MASTER_DATA_498233_2.sql 1.2 Data Script 00498233
DATA_ORS_MASTER_DATA_498233_3.sql 1.2 Data Script 00498233
DATA_ORS_MASTER_DATA_498787.sq 1.2 Data Script 00498787
DATA_ORS_SQL_467514.sql 1.1 Data Script 00467514
DATA_ORS_SQL_479887.sql 1.1 Data Script 00479887
DATA_ORS_SQL_498787.sql 1.1 Data Script 00498787
DATA_PREFERENCE_STATUS_510378.sql 1.1 Data Script 00510378
DP_3PL_SCHED.sql 5.10 3PL Scheduling Engine Database Package 00510181
DP_3PL_SCHED.sql 5.5 3PL Scheduling Engine Database Package 00474273
DP_3PL_SCHED.sql 5.6 3PL Scheduling Engine Database Package 00478672
DP_3PL_SCHED.sql 5.7 3PL Scheduling Engine Database Package 00481350
DP_3PL_SCHED.sql 5.8 3PL Scheduling Engine Database Package 00482059
DP_3PL_SCHED.sql 5.9 3PL Scheduling Engine Database Package 00489611
DP_CARRIER_API.sql 5.12 Carrier API Database Package 00497948
DP_CSV6.sql 1.44 CSV Extract package 02680480
DP_CTMS_IMPORT.sql 5.28 API Import Database Package 00474273
DP_CTMS_IMPORT.sql 5.29 API Import Database Package 00480177
DP_CTMS_IMPORT.sql 5.30 API Import Database Package 00512651
DP_CTMS_IMPORT.sql 5.31 API Import Database Package 00512119
DP_CTMS_IMPORT.sql 5.32 API Import Database Package 00515770
DP_CTMS_IMPORT.sql 5.33 API Import Database Package 00516754
DP_CTMS_IMPORT.sql 5.34 API Import Database Package 00501535
DP_CUST_SERV.sql 1.67 Customer Service Package 00464795
DP_CUST_SERV.sql 1.68 Customer Service Package 02592042
DP_CUST_SERV.sql 1.69 Customer Service Package 00479896
DP_CUST_SERV.sql 1.70 Customer Service Package 00479887
DP_CUST_SERV.sql 1.72 Customer Service Package 00479894
DP_CUST_SERV.sql 1.74 Customer Service Package 00493457
DP_CUST_SERV.sql 1.77 Customer Service Package 00479897
DP_CUST_SERV.sql 1.78 Customer Service Package 00506725
DP_CUST_SERV.sql 1.79 Customer Service Package 00517899
DP_CUST_SERV.sql 1.82 Customer Service Package 00518589
DP_CUST_SERV.sql 1.84 Customer Service Package 00524609
DP_CUST_SERV.sql 1.85 Customer Service Package 00525976
DP_EPOD_WEB_SERVICE.sql 1.193 EPOD Web Service 00479887
DP_EPOD_WEB_SERVICE.sql 1.194 EPOD Web Service 00479899
DP_EPOD_WEB_SERVICE.sql 1.195 EPOD Web Service 00479897
DP_EPOD_WEB_SERVICE.sql 1.196 EPOD Web Service 00493457
DP_EPOD_WEB_SERVICE.sql 1.197 EPOD Web Service 00467382
DP_EPOD_WEB_SERVICE.sql 1.197 EPOD Web Service 00469939
DP_EPOD_WEB_SERVICE.sql 1.198 EPOD Web Service 00504598
DP_EPOD_WEB_SERVICE.sql 1.199 EPOD Web Service 00497703
DP_EPOD_WEB_SERVICE.sql 1.201 EPOD Web Service 00508400
DP_EPOD_WEB_SERVICE.sql 1.203 EPOD Web Service 00512122
DP_EPOD_WEB_SERVICE.sql 1.204 EPOD Web Service 00517795
DP_EPOD_WEB_SERVICE.sql 1.205 EPOD Web Service 00517913
DP_EPOD_WEB_SERVICE.sql 1.206 EPOD Web Service 00517813
DP_EPOD_WEB_SERVICE.sql 1.207 EPOD Web Service 00518292
DP_EPOD_WEB_SERVICE.sql 1.208 EPOD Web Service 00519173
DP_EPOD_WEB_SERVICE.sql 1.209 EPOD Web Service 00346696
DP_EPOD_WEB_SERVICE.sql 1.210 EPOD Web Service 00520332
DP_EPOD_WEB_SERVICE.sql 1.211 EPOD Web Service 00520335
DP_EPOD_WEB_SERVICE.sql 1.212 EPOD Web Service 00522359
DP_EPOD_WEB_SERVICE.sql 1.213 EPOD Web Service 00522955
DP_EPOD_WEB_SERVICE.sql 1.215 EPOD Web Service 00524609
DP_EXPORT_EVENTS.sql 5.24 API Export Events Database Package 00474454
DP_EXPORT_EVENTS.sql 5.25 API Export Events Database Package 02595529
DP_EXPORT_EVENTS.sql 5.27 API Export Events Database Package 00479895
DP_EXPORT_EVENTS.sql 5.27 API Export Events Database Package 00491708
DP_EXPORT_EVENTS.sql 5.28 API Export Events Database Package 02722382
DP_EXPORT_EVENTS.sql 5.29 API Export Events Database Package 00517783
DP_EXPORT_EVENTS.sql 5.30 API Export Events Database Package 00521914
DP_EXPORT_EVENTS.sql 5.31 API Export Events Database Package 00522214
DP_EXPORT_EVENTS.sql 5.32 API Export Events Database Package 00524609
DP_NOKIA_LOC_PLAT.sql 1.39 Nokia Location Platform Interface 00512100
DP_NOKIA_LOC_PLAT.sql 1.40 Nokia Location Platform Interface 00521338
DP_PAR_API.sql 5.14 Paragon API Database Package 00481913
DP_PAR_API.sql 5.15 Paragon API Database Package 00340478
DP_PAR_API.sql 5.16 Paragon API Database Package 00481577
DP_PAR_API.sql 5.17 Paragon API Database Package 00516019
DP_PAR_API.sql 5.18 Paragon API Database Package 00501535
DP_PAR_API_STP.sql 5.11 STP Paragon API Database Package 00487971
DP_PAR_API_STP.sql 5.12 STP Paragon API Database Package 00495483
DP_PAR_API_STP.sql 5.13 STP Paragon API Database Package 00505975
DP_PAR_API_STP.sql 5.14 STP Paragon API Database Package 00340478
DP_PAR_API_STP.sql 5.15 STP Paragon API Database Package 00481577
DP_PAR_API_STP.sql 5.16 STP Paragon API Database Package 00510599
DP_PAR_API_STP.sql 5.17 STP Paragon API Database Package 00516061
DP_PAR_API_STP.sql 5.18 STP Paragon API Database Package 00515979
DP_PAR_API_STP.sql 5.19 STP Paragon API Database Package 00517964
DP_PAR_API_STP.sql 5.20 STP Paragon API Database Package 00501535
DP_REPORTS.sql 5.75 Reports package 02719799
DP_TOMTOM.sql 1.42 TomTom Package 00469910
DP_TOMTOM.sql 1.43 TomTom Package 00505586
DP_TOMTOM.sql 1.44 TomTom Package 02719799
DP_TOMTOM.sql 1.45 TomTom Package 00375203
DP_TOMTOM_DEBUG.sql 5.1 TomTom Debug procedure 00469910
DP_WEB_SERVICE_ENQUIRY.sql 1.7 Web service processing 02466153
EPOD_WSA.fmx 1.11 EPOD Web Service Audit Form 00501535
IMP.sql 5.224 CSV Imports Package 00464118
IMP.sql 5.229 CSV Imports Package 00481867
IMP.sql 5.229 CSV Imports Package 00484500
IMP.sql 5.230 CSV Imports Package 00479887
IMP.sql 5.230 CSV Imports Package 00491708
IMP.sql 5.231 CSV Imports Package 00479894
IMP.sql 5.232 CSV Imports Package 00518660
IMP.sql 5.233 CSV Imports Package 00520185
INT_XML_IN.sql 5.240 Order Import Package 00510701
INT_XML_OUT2.sql 5.331 Outbound XML Package 00484535
INT_XML_OUT2.sql 5.332 Outbound XML Package 00479887
INT_XML_OUT2.sql 5.332 Outbound XML Package 00491708
INT_XML_OUT2.sql 5.333 Outbound XML Package 00479897
INT_XML_OUT2.sql 5.334 Outbound XML Package 00522955
INVOICES.fmx 2.65 Invoices Screen 00488390
LOCATION.fmx 2.206 Location Maintenance 00479894
OF_INT.sql 5.65 Oracle Financials interface 00495952
OF_INT.sql 5.69 Oracle Financials interface 00495690
OF_INT.sql 5.70 Oracle Financials interface 00492872
OF_INT.sql 5.71 Oracle Financials interface 00521650
ORDERS.fmx 2.454 Order Screen 00516565
ORDERS_WIDE.fmx 1.50 Orders Screen 00516565
ORS.fmx 1.38 Oracle Reporting suite 00507384
PLANNING.fmx 1.141 Planning Screen 02588754
PLANNING.fmx 1.143 Planning Screen 02665941
PLANNING.fmx 1.144 Planning Screen 02694314
PLANNING.fmx 1.145 Planning Screen 00516565
RATE.sql 5.169 Rates Tariff database package 00488390
RATE.sql 5.170 Rates Tariff database package 00495952
RESOURCE.fmx 2.196 Resource Maintenance form 02592042
RESOURCE.fmx 2.198 Resource Maintenance form 00517612
ROUTES_MAINT.fmx 2.54 Fixed Routes Maintenance 00481867
ROUTES_MAINT.fmx 2.55 Fixed Routes Maintenance 00519909
TI_SCH_ORD_STATUS.sql 1.28 Trigger on SCH_ORD for status change 00521914
TRG_PAR_KEYS_BIU.sql 1.2 Trigger 00481913
TRG_RES_TRACTOR_CUSTOMER_BIU.sql 1.1 Trigger 00479887
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql 1.2 Trigger 00467382
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql 1.3 Trigger 00497703
TRG_RES_VEHICLE_CONF_AXLE_EPOD.sql 1.4 Trigger 00508400
TRG_RES_VEHICLE_CONFIG_EPOD.sql 1.2 Trigger 00497703
TRG_RES_VEHICLE_CONFIG_EPOD.sql 1.3 Trigger 00508400
TRG_SCH_ORD_REFERENCE_RUN.sql 5.2 Trigger 00495483
TRG_SCH_ORD_VEHICLE_UID.sql 1.1 Trigger 00479895
TRG_SCH_ORDER_LINE_PAR.sql 5.3 Trigger 00482360
TRG_SCH_TRIP_MTM_COST.sql 1.2 Trigger 02660730
TRG_SCH_TRIP_STOP_ACPT.sql 5.2 Trigger 00469910
TRG_SCH_TRIP_XML_GEN.sql 5.25 Trigger 02665941
TRG_SHA_TRUNK_TRIP.sql 5.3 Trigger 00481350
TRG_SOL_XML.sql 5.49 Trigger 00517913
TRG_SOL_XML.sql 5.50 Trigger 00524544
TRG_TT_EVENTS_STORE.sql 1.8 Trigger 00469910
TRG_WMS_PRODUCT_XREF_BIU.sql 1.2 Trigger 00469939
TRG_WMS_PRODUCT_XREF_BIU.sql 1.3 Trigger 00497703
TRG_WMS_PRODUCT_XREF_BIU.sql 1.3 Trigger 00508400
TRIP_OVERVIEW.fmx 1.75 Trip Waterfall 00499449
TRIP_OVERVIEW.sql 5.12 Trip Waterfall 00517796
TRIP_OVERVIEW.sql 5.13 Trip Waterfall 00518000
TRIP_OVERVIEW.sql 5.15 Trip Waterfall 02737619
TRIP_PLAN.fmx 1.283 Trip Planning Screen 00496683
TRIPSUM.fmx 2.450 Trip Manipulation screen 00496683
TRM.sql 5.223 Trip manipulation package 00490822
TRM.sql 5.224 Trip manipulation package 00479894
TRM.sql 5.225 Trip manipulation package 00481577
TRM.sql 5.226 Trip manipulation package 00499590
TRM.sql 5.227 Trip manipulation package 00518002
TRM.sql 5.228 Trip manipulation package 00519864
TRM.sql 5.229 Trip manipulation package 00522300
V_CURRENT_DRIVER_LIST.sql 1.1 View 00479895
V_CURRENT_DRIVER_LIST.sql 1.2 View 00499175
V_CURRENT_DRIVER_LIST.sql 1.3 View 00525198
V_DRIVER_ORDERS.sql 1.1 View 00479895
V_DRIVER_ORDERS.sql 1.2 View 00499175
V_DRIVER_ORDERS.sql 1.3 View 00525198
V_ORD_ORDER_HEADER.sql 1.17 View 00464750
V_ORD_ORDER_HEADER.sql 1.18 View 00464795
V_ORD_ORDER_HEADER.sql 1.19 View 00479896
V_ORD_ORDER_HEADER.sql 1.20 View 00479887
V_ORD_ORDER_HEADER.sql 1.21 View 00479894
V_ORD_ORDER_HEADER.sql 1.22 View 00479897
V_PRODUCT_CTL.sql 1.6 View 00479897
V_PRODUCT_CTL.sql 1.7 View 00525976
V_RES_TRACTOR_CUSTOMER.sql 1.1 View 00499175
V_RES_VEHICLE_CUST_LOC.sql 1.3 View 00479887
V_VEHICLE_DETAILS.sql 5.6 View 00479887
WAREHOUSE.fmx 2.18 Warehouse Screen 00477098
WAREHOUSE.fmx 2.19 Warehouse Screen 00489063
WAREHOUSE.fmx 2.20 Warehouse Screen 00488390


ADDITIONAL CHANGES

CTL

A CTL change is required with this release