PATCH C-TMS P043: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 67: Line 67:




= CHANGE REQUESTS =
= DEVELOPMENT =
<!--
<!--
== Customer Ref:  ==
== Customer Ref:  ==
Line 81: Line 81:
|}
|}
-->
-->
== Customer Ref:  ==
 
{| width="100%"
== Log Number: 00320472 ==
|-  
{| width="100%"
|width="30%"|'''OBS Log Number:'''  || '''Reporter:'''  
|-
|-
|width="30%"|'''Summary of Call'''|| Create location ID
|'''Summary of Call'''||  
|-
|-
|'''Detail of Fix''' || "Location ID is modified to create from Recipient address reference instead of postcode which was in use until now,
|'''Detail of Fix''' ||
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
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
<!-- NEW PAGE -->
== Customer Ref:  ==
{| width="100%"
== Log Number: 00327516 ==
|-  
{| width="100%"
|width="30%"|'''OBS Log Number:'''  || '''Reporter:'''  
|-
|-
|width="30%"|'''Summary of Call'''|| Emails not received when trip deleted
|'''Summary of Call'''||  
|-
|-
|'''Detail of Fix''' || "There aren’t any recipients for CANCEL_3PL messages for carrier RBT for trip TQK-00046583.
|'''Detail of Fix''' ||
|-
The carrier was N113780 until it was changed at 2022/07/20 12:52:44.
|'''Set-up and Configuration''' || No set-up/configuration required
 
|}
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''' || No set-up/configuration required
|}
== Log Number: 00326413 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
== Log Number: 00335523 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| The CAN messages are being re-sent.
|-
|'''Detail of Fix''' || ‘CAN’ messages will be sent once.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Log Number: 00344924 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
== Log Number: 00345010 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
== Log Number: 00350325 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
== Log Number: 00351008 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Service Report
|-
|'''Detail of Fix''' || Uses EPL_OFFICE_INSTRUCTION.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Log Number: 00365797 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
== Log Number: 02166754 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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
|}
 




Revision as of 13:17, 13 January 2023




Aptean Logo.png










Release Notes

CALIDUS TMS

12th December 2023 - 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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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



SUPPORT INCIDENTS

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number:

Cust Ref: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration


PRODUCT DEVELOPMENT

OBS Log Number:

Reporter:
Summary of Call
Detail of Fix
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

A WCS change is required for the following logs:

  • Log

OR

There are no WCS changes required.

EPOD/T2A

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

  • Log

OR

There are no ePOD/T2A changes required.

MCS

An MCS change is required for the following logs:

  • Log

OR

There are no MCS changes required.

PORTAL/TTM

A Portal change is required for the following logs:

  • Log

OR

There are no Portal changes required.

EDI

An EDI change is required for the following logs:

  • Log

OR

There are no EDI changes required.


Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=PATCH_C-TMS_P043&oldid=10407’