PATCH C-TMS P035
OBS Logistics Ltd
Release Notes
CALIDUS TMS
12th Nov 2019 - 1.0
Reference: P035
SUMMARY INTRODUCTION
INTRODUCTION
The main aim of this document is to provide CALIDUS TMS users with the level of detail required to accurately test all software included in the patch. The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.
GLOSSARY OF TERMS
| Term | Meaning |
|---|---|
| C-TMS | Transport Management System |
| C-WMS | Warehouse Management System |
| CR | Change Request |
| C-WCS | Warehouse Control System |
| C-ePOD | Electronic Proof of Delivery |
| C-MCS | Mobile Control System |
| C-TTM | Track and Trace Management |
| EDI | Electronic Data Interchange |
| TID | Testing Issue Development, or Log |
TESTING PROCESS
TIDs AND RESOLUTION
If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.
FINAL 'END TO END' TESTING
Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.
AUTHORISATION
Authorisation from nominated release personnel only will be required when requesting a release to a production environment
CHANGE REQUESTS
Customer Ref: Actuals
| OBS Log Number: | 359621 |
| Summary of Call | Ensure all actuals are debriefed |
| Detail of Fix | Ensure all actual weights and volumes are populated before a trip can be set to COMPLETED |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Despatch
| OBS Log Number: | 362667 |
| Summary of Call | Vehicle Despatch Report |
| Detail of Fix | Add depot to parameters |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0030580
| OBS Log Number: | 358425 |
| Summary of Call | GSN: Create a new report |
| Detail of Fix | The new export Inventory Transactions will need authorisation for the appropriate user groups. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0030824
| OBS Log Number: | 358506 |
| Summary of Call | GSN: Modify ASN interface |
| Detail of Fix | Override collection location on ASN1 dependant on new WS_COLLECT_LOCATION parameter and partnership setting for store. |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| WS_COLLECT_LOCATION | 9576 | Collection location to override the supplier partnership at customer level |
Customer Ref: WREQ0031664
| OBS Log Number: | 359252 |
| Summary of Call | GSN: Retain FORECAST Value from ASN2 |
| Detail of Fix | Set new forecast figures on ASN1 only and send to paragon in preference to planned. |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| PAR_EXPORT_FORECAST | Y | Send forecast rather than actual values to paragon |
Customer Ref: WREQ0031943
| OBS Log Number: | 359656 |
| Summary of Call | HAM - Microlise Interface |
| Detail of Fix | Changes to the Microlise interface |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359660 |
| Summary of Call | HAM - Changes to WMS Despatch (CITD) |
| Detail of Fix | The EDI processes for LOAD and CITD messages will need to have a new EDI parameter called OUTBASE_INDICATOR set to Y to enable the new functionality.
When the parameter is Y, the LOAD and CITD messages will be split by outbase for the same TMS trip to create separate WMS loads based on the outbase indicator. Note that any orders that are not going to an outbase for a customer that is using the van fleet will not be included in a file for the outbase and these orders will be included in a file for the TMS trip itself without an outbase indicator. The customers and fixed routes will need to have the new 'Van Fleet' flag set to Y to enable the new functionality. The outbases will be identified as RDC locations that exist with an 'OUTBASE_INDICATOR' decoded value for 'REFERENCE'. This outbase indicator will be a single character to be included in the TMS trip to replace the first digit of the trip number (e.g. MAN-A0123456 instead of MAN-00123456). This decoded value must exist to enable the new functionality. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 358670 |
| Summary of Call | HAM - Connected View Interfaces |
| Detail of Fix |
ORD: Flow Type: ORD_XML_OUT Trigger STATUS: UNSCHEDULED Parameters: ALLOW_MULTI_CUSTOMER = Y INCLUDE_ORDER_STATUS = Y SEND_HEADER_UPDATES = Y SEND_LINE_ITEMS = Y
PACK: Flow Type: ORD_XML_OUT Parameters: PACK_EVENT = Y SEND_LINE_ITEMS = Y
POCPOD: Flow Type: TRIP_XML Parameters: ALLOW_MULTI_CUSTOMER = Y INCLUDE_ITEM_DELIVER = Y INCLUDE_NONCON_CODES = Y INCLUDE_REASON_CODES = Y INCLUDE_REASON_TYPE = Y INCLUDE_SIGNATURE = Y PODS_POCS = Y SEND_LINE_ITEMS = Y
The POD messages will be sent for the unloading at the delivery location for the delivery orders. This trip may be for a depot that may be an outbase for the van fleet. The EDI processes also should exist for the LOAD, CITD and electronic manifest messages. The load message will be sent for the despatching source depot. The CITD message will be sent for the despatching source depot. An electronic manifest message will be sent for the despatching delivery depot for the parcel carrier. This depot may be an outbase for the van fleet. These EDI parameters can be configured to match the mapping of the files by any external processing for transfer to the source systems for the orders and carriers. New version 2.43 of TripOrder.xsd will be required for the messages for ConnectedView to be mapped. This version contains the ORDER_STATUS element at the end of the ORDER_HEADER segment.
|
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359661 |
| Summary of Call | HAM - Item & Master Pallet Labels |
| Detail of Fix | The new package label format will be available for configuration
The new pallet label format will be available for configuration. The pallet label printing will be to a laser printer for a PDF document or to a label printer for a Zebra label format. The new MCS_PALLET_LABEL_FORMAT system parameter will be used to store the Zebra pallet label format. If this system parameter is not specified, the existing PDF pallet label format will be used. The supporting information of the new package label will need to be implemented for the carrier tracking and routing. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359663 |
| Summary of Call | HAM - Create Items when order packed |
| Detail of Fix | Order items will be created for the tracking references when the carrier labels are printed for the van fleet routes.
These order items will be made available as trip items for scanning using MCS in the active depots. The deletion of tracking references will delete the corresponding order items when the order is unpacked, repacked or unscheduled without retaining pack data. The corresponding trip items will also be deleted when the order items are deleted. Any trip items that have been palletised or added to AWB/Consignments in the depots will be removed from the pallets and AWB/Consignments. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359664 |
| Summary of Call | HAM - Scheduling Engine |
| Detail of Fix | Changes to the Scheduling Engine and Paragon |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359667 |
| Summary of Call | HAM - MCS Control Parameters |
| Detail of Fix | Changed the location screen to display the mcs parameters in a new tab. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359668 |
| Summary of Call | HAM - Trip Barcode on Reports |
| Detail of Fix | The HC Shunt Sheet, HC Trip Sheet and HCR Loading Sheet reports will include a barcode for the TRIP ID in format 39 for scanning using MCS. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359670 |
| Summary of Call | HAM - MCS General Changes |
| Detail of Fix | Read system params into MCS and hide AWB number. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359671 |
| Summary of Call | HAM - MCS Project specific changes |
| Detail of Fix | Pallet Building and Pallet Closure changes. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 359674 |
| Summary of Call | HAM - MCS Trans-Ship |
| Detail of Fix | Added Trans Ship functionality for MCS. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031943
| OBS Log Number: | 362625 |
| Summary of Call | HAM - Item & Master Pallet Label 2 |
| Detail of Fix | Amended the reprinting of the label format.
The Service Type will display the carrier service level or the order service level to ensure that a service is displayed depending on the type of routing that has been performed to schedule the order. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Inventory Transactions
| OBS Log Number: | 364431 |
| Summary of Call | Inventory Transactions Store Scan Change |
| Detail of Fix | The StoreScan section included extra columns as per the other scan sections. The depot and user columns have been removed from the extract. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: PO 44010884813
| OBS Log Number: | 362811 |
| Summary of Call | Webservice Label Change |
| Detail of Fix | Changes to Labels |
| Set-up and Configuration | No set-up/configuration required |
SUPPORT INCIDENTS
Customer Ref: 360403
| OBS Log Number: | 360403 |
| Summary of Call | VDA4933 and VDA4933 additional matches |
| Detail of Fix | When a 4987 matches to more than one 4933 on the same delivery stop, replace the orders on the trip |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: LOTS
| OBS Log Number: | 360459 |
| Summary of Call | Send address to LOTS in ORD event |
| Detail of Fix | Change to allow address details and contacts to be sent to LOTS |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Reason Code
| OBS Log Number: | 361188 |
| Summary of Call | Cancelled Item - Reason Code |
| Detail of Fix | Only create SD reason codes for all items on an order when no items sent and none returned. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Encrypted sources
| OBS Log Number: | 361652 |
| Summary of Call | Release PL_VERSION |
| Detail of Fix | Release package to assist with version control checks. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: 362482
| OBS Log Number: | 362482 |
| Summary of Call | Email Information - populated fields |
| Detail of Fix | Amendment to XML outbound generation so contact details not based on comments being null but on email address being populated. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Performance Improvements
| OBS Log Number: | 362723 |
| Summary of Call | Performance Improvements |
| Detail of Fix | Reduced the number of times that the standard journeys are assessed for the 'from' location of the orders when calculating payments. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Invoice Format
| OBS Log Number: | 363373 |
| Summary of Call | Incorrect Invoice format |
| Detail of Fix | Changes to the BL numbers and the frequency reported- no longer at order level but at gate level within the shipment and invoice |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: INC30189216
| OBS Log Number: | 363421 |
| Summary of Call | File has order header but no details |
| Detail of Fix | When determining if an order is to be included in Zetes file extend test for 'SL' reason code items to exclude the 'X' items that have been split off |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: INC30418115
| OBS Log Number: | 364473 |
| Summary of Call | Report showing wrong data |
| Detail of Fix | Amendment to ITEM_MOVEMENTS_EXTRACT_2 to correct to population of POD confirmed date (column T) on so uses scan date |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Decode Amendment
| OBS Log Number: | 364696 |
| Summary of Call | Change decode names |
| Detail of Fix | Amendment to shipment extract to use Parts decode where appropriate |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Scheduling Engine
| OBS Log Number: | 359457 |
| Summary of Call | Scheduling Engine Single Network |
| Detail of Fix | Ensure when roll back performed inside of loop that it is not then also performed outside of the loop. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Portal
| OBS Log Number: | 359518 |
| Summary of Call | Portal not reporting shortages |
| Detail of Fix | Changed EPOD interface to ensure quantity set before reason added and also ensure order details sent to LOTS on delivery message. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Empties Changes
| OBS Log Number: | 362440 |
| Summary of Call | Rqmts change for Credit acc on empties |
| Detail of Fix | Changes to the finance functionality based on the Empties not providing the references we expected |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Split Order scanning
| OBS Log Number: | 362828 |
| Summary of Call | Split order scanning delivery trips |
| Detail of Fix | Change to split scanning, to prevent orders being planned on empty stops |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Support
| OBS Log Number: | 364191 |
| Summary of Call | Debrief issue |
| Detail of Fix | Changes to the shipment extract and removal of validate order when rating a completed trip |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trunk Scripts Main
| OBS Log Number: | 364910 |
| Summary of Call | Trunk Scripts added into main stream |
| Detail of Fix | Trunk scripts for Paragon added into main code stream |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Collection dates/times
| OBS Log Number: | 365051 |
| Summary of Call | Validate order collection dates/times |
| Detail of Fix | The just in time orders will only have their collection date/time windows assessed when the order status is INVALID, VALID or UNSCHEDULED.
A user context will be set when validating the just in time orders for the cost centre of the order unless the calling process has already done so (e.g. Paragon planning). |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Packaging and Service
| OBS Log Number: | 359779 |
| Summary of Call | Current packaging and Service charge ext |
| Detail of Fix | Report type OWN_CHRGS already in Oracle reporting suite for the packaging charges. Options added to ORS for
1) Service Capture (SRVCS_CAPT) 2) Services including sliding charges (ACC_SRVCS) 3) Accounts (ACC_ACCOUNT). |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: 361243
| OBS Log Number: | 361243 |
| Summary of Call | Export the cost per route |
| Detail of Fix | Add the fields for business data 'Fixed costs by route' to extract suite under type RTE_COSTS. |
| Set-up and Configuration | No set-up/configuration required |
TID CHANGES
OBS Log Number: 361291
| Customer Ref: | Invoice Formats |
| Summary of Call | Amend Invoice report and extract |
| Detail of Fix | Changes to the invoice report to include invoice number and Rating to update the order revenue total |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 362508
| Customer Ref: | INC29954448 - Main |
| Summary of Call | Interface from CTMS to ZETES are failing |
| Detail of Fix | Fixes for OUT2 and CSV. You will need to switch on 'SEND_PALLET_ID_XML' paramater if required in XML. |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| SEND_PALLET_ID_XML | 'N' | Send the pallet ID tag in the XML flows |
OBS Log Number: 365003
| Customer Ref: | Remove sum from sql |
| Summary of Call | Remove sum |
| Detail of Fix | Amend the shipment cursor to remove Sum from invoice amount |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 360756
| Customer Ref: | Invoicing |
| Summary of Call | Testing - Invoicing |
| Detail of Fix | Changes to the outbound Interface file format. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 352903
| Customer Ref: | No Ref |
| Summary of Call | Carrier manifest reports |
| Detail of Fix | Added new parameter into Function call on reports to allow reports to run |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 360150
| Customer Ref: | No Ref |
| Summary of Call | Paragon Import fails |
| Detail of Fix | Fix issue with trunk flag on directs from paragon. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 361329
| Customer Ref: | P34 - 1.3 & 5.5 |
| Summary of Call | Patch Test - P34 - Manual Orders |
| Detail of Fix | Ensure line data block cleared based on correct product type. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 363499
| Customer Ref: | Validate order sched |
| Summary of Call | Validate order before scheduling van |
| Detail of Fix | Include a validate order at the start of the scheduling engine for van fleet |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 363681
| Customer Ref: | No Ref |
| Summary of Call | Orders not being packed via CIPD in CTMS |
| Detail of Fix | The trip for the delivery of the order will be found for the printing of the carrier labels via CIPD files.
Any shunt and trunk trips will not be used to assess the label format for the carrier. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 363801
| Customer Ref: | Just In Time Orders |
| Summary of Call | Just In Time orders set available date |
| Detail of Fix | Changes to prevent available date from being set until the order has been validated |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 363855
| Customer Ref: | EDI Amendments |
| Summary of Call | HAM - Amendments to EDI files for CV |
| Detail of Fix | 1. The EVENT_TYPE for trip files will be TRP unless the file is for POC or POD for Connected View interfaces. Then the event type will be POC or POD as required.
2. Microlise - New system Parameter MIC_SHIPMENT_SO_REF to control if the external_ref is included in the shipment details tag |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 363974
| Customer Ref: | Invoicing |
| Summary of Call | Main release of branch 362111 |
| Detail of Fix | Changes to Invoicing to select customers who have outstanding payments |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 364523
| Customer Ref: | Paragon |
| Summary of Call | HAM - Filters on Paragon Export |
| Detail of Fix | Changes to the Paragon expotrt to segregate Van fleet from other fleets |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 364556
| Customer Ref: | Paragon |
| Summary of Call | HAM - Fix to NEW trips from Paragon expt |
| Detail of Fix | Changes to the export code to update NEW trips |
| Set-up and Configuration | No set-up/configuration required |
OBSL PRODUCT DEVELOPMENT
OBS Log Number: 363082
| Summary of Call | Performance improvements to finance |
| Detail of Fix | Improvements to performance times based on 2 new parameters ACC_SUPPRESS_RATING and ACC_KNOWN_ZONE |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| ACC_SUPRESS_RATING | Y | Stops orders from rating |
| ACC_KNOWN_ZONE | Y | Pass in a zone format COUNTRY CODE and POSTAL REGION |
OBS Log Number: 363185
| Summary of Call | Incompatibility with invoice and Reports |
| Detail of Fix | Amended parameter to display shipment file |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 359601
| Summary of Call | Context for PARINT / webservices 359072 |
| Detail of Fix | New clear context to be called at start of web service just in case a previous call has set a context in the session that is not applicable to the new order.
Session remains after web service call end and is re-connected too by later web service calls. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number: 362654
| Summary of Call | Fix MCS Site view |
| Detail of Fix | Fix to mcs sites scipt. |
| Set-up and Configuration | No set-up/configuration required |
MODULES DELIVERED
| Module Name | Version No | Description | Log Number |
|---|---|---|---|
| ACC.sql | 5.77 | Accounts package | 360756 |
| ACC.sql | 5.79 | Accounts package | 362440 |
| AT_GEO_LOCATION_359667.sql | 1.1 | AT Script | 359667 |
| AT_ORG_CUSTOMER_359664.sql | 1.1 | AT Script | 359660 |
| AT_RES_CARRIER_359664.sql | 1.1 | AT Script | 359664 |
| AT_RTE_ROUTE_359664.sql | 1.1 | AT Script | 359660 |
| AT_SCH_ORD_359252.sql | 1.1 | AT Script | 359252 |
| AT_SCH_ORD_359664.sql | 1.2 | AT Script | 359664 |
| AT_SCH_SHIP_PALL_359661.sql | 1.1 | AT Script | 359661 |
| CARRIER_MANIFEST_DHLEXP.rep | 1.17 | Carrier Manifest | 352903 |
| CARRIER_MANIFEST_UKMAIL.rep | 1.5 | Carrier Manifest | 352903 |
| CARRIER_MANIFEST_YODEL.rep | 1.12 | Carrier Manifest Report | 352903 |
| CNT.sql | 5.52 | Contracts package | 362723 |
| CNT.sql | 5.53 | Contracts package | 363082 |
| CSV.sql | 5.113 | CSV extract package | 359252 |
| CSV.sql | 5.114 | CSV extract package | 359664 |
| CSV.sql | 5.115 | CSV extract package | 362508 |
| CSV.sql | 5.116 | CSV extract package | 364523 |
| CSV.sql | 5.117 | CSV extract package | 364556 |
| CT_T_PALLET_LIST_359671.sql | 1.1 | CT Script | 359671 |
| CUST_COST.fmx | 2.133 | Customer Maintenance form | 359664 |
| DATA_1_REP_PARAM_TYPE_358425.sql | 1.1 | Data Script | 358425 |
| DATA_2_REP_REPORT_358425.sql | 1.1 | Data Script | 358425 |
| DATA_3_REP_REPORT_PARAM_358425.sql | 1.1 | Data Script | 358425 |
| DATA_4_REP_PARAM_VALUE_358425.sql | 1.1 | Data Script | 358425 |
| DATA_ADM_FORM_TAB_359667.sql | 1.1 | Data Script | 359667 |
| DATA_ADM_SYSTEM_PARAM_358506.sql | 1.1 | Data Script | 358506 |
| DATA_ADM_SYSTEM_PARAM_359252.sql | 1.1 | Data Script | 359252 |
| DATA_ADM_SYSTEM_PARAM_359656.sql | 1.1 | Data Script | 359656 |
| DATA_ADM_SYSTEM_PARAM_359664.sql | 1.1 | Data Script | 359664 |
| DATA_ADM_SYSTEM_PARAM_359667.sql | 1.4 | Data Script | 359667 |
| DATA_ADM_SYSTEM_PARAM_362508.sql | 1.3 | Data Script | 362508 |
| DATA_ADM_SYSTEM_PARAM_363082.sql | 1.2 | Data Script | 363082 |
| DATA_ADM_SYSTEM_PARAM_363499.sql | 1.1 | Data Script | 363499 |
| DATA_ADM_SYSTEM_PARAM_363855.sql | 1.1 | Data Script | 363855 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_358506.sql | 1.1 | Data Script | 358506 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_359252.sql | 1.1 | Data Script | 359252 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_359656.sql | 1.2 | Data Script | 359656 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_359664.sql | 1.1 | Data Script | 359664 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_362508.sql | 1.3 | Data Script | 362508 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_363082.sql | 1.1 | Data Script | 363082 |
| DATA_AUTO_SCHEDULING_ENGINE_359664.sql | 1.1 | Data Script | 359664 |
| DATA_IMP_DECODE_359667.sql | 1.1 | Data Script | 359667 |
| DATA_IMP_DECODE_ENTRY_359667.sql | 1.1 | Data Script | 359667 |
| DATA_ORS_MASTER_DATA_359779.sql | 1.1 | Data Script | 359779 |
| DATA_ORS_MASTER_DATA_361243.sql | 1.1 | Data Script | 361243 |
| DATA_ORS_SQL_359779.sql | 1.1 | Data Script | 359779 |
| DATA_ORS_SQL_361243.sql | 1.1 | Data Script | 361243 |
| DATA_REP_REPORT_PARAM_362667.sql | 1.1 | Data Script | 362667 |
| DATA_RES_CARRIER_FORMATS_359661.sql | 1.1 | Data Script | 359661 |
| DATA_RES_CARRIER_FORMATS_MAP_359661.sql | 1.1 | Data Script | 359661 |
| DATA_RES_LABEL_FORMATS_359661.sql | 1.1 | Data Script | 359661 |
| DATA_RES_LABEL_FORMATS_362811.sql | 1.1 | Data Script | 362811 |
| DP_CARRIER.sql | 1.84 | Carrier Management | 359661 |
| DP_CARRIER.sql | 1.86 | Carrier Management | 362625 |
| DP_CARRIER.sql | 1.87 | Carrier Management | 359663 |
| DP_CARRIER.sql | 1.88 | Carrier Management | 363681 |
| DP_CARRIER.sql | 1.89 | Carrier Management | 362811 |
| DP_CSV_DUN.sql | 5.48 | Client specific CSV extracts | 358425 |
| DP_CSV_DUN.sql | 5.49 | Client specific CSV extracts | 364431 |
| DP_CSV_DUN.sql | 5.50 | Client specific CSV extracts | 364473 |
| DP_EPOD_WEB_SERVICE.sql | 1.122 | EPOD Web Service | 359518 |
| DP_EPOD_WEB_SERVICE.sql | 1.124 | EPOD Web Service | 361188 |
| DP_IMP.sql | 5.38 | Imports Package | 363681 |
| DP_MCS_SCANNING.sql | 5.42 | MCS Scanning Package | 359670 |
| DP_MCS_SCANNING.sql | 5.43 | MCS Scanning Package | 359661 |
| DP_MCS_SCANNING.sql | 5.44 | MCS Scanning Package | 359674 |
| DP_MCS_SCANNING.sql | 5.45 | MCS Scanning Package | 359663 |
| DP_MCS_SCANNING.sql | 5.48 | MCS Scanning Package | 359671 |
| DP_RDT_FAST_UNLOAD.sql | 5.44 | RF Unload Package | 362828 |
| DP_SCHEDULING_ENGINE.sql | 5.150 | Scheduling Package | 359457 |
| DP_SCHEDULING_ENGINE.sql | 5.153 | Scheduling Package | 359664 |
| DP_SCHEDULING_ENGINE.sql | 5.155 | Scheduling Package | 363499 |
| DP_SCHEDULING_ENGINE.sql | 5.156 | Scheduling Package | 363801 |
| DP_SHIPMENT.sql | 5.19 | Shipment Code package | 360403 |
| DP_SHIPMENT.sql | 5.21 | Shipment Code package | 362440 |
| DP_SHIPMENT.sql | 5.22 | Shipment Code package | 363082 |
| DP_WEB_SERVICE_ORD.sql | 1.22 | Web Service Package | 359252 |
| DP_WEB_SERVICE_ORD.sql | 1.23 | Web Service Package | 358506 |
| DP_WEB_SERVICE_ORD.sql | 1.25 | Web Service Package | 359601 |
| DUNELM_VEHICLE_DESPATCH.rep | 1.6 | Vehicle Despatch report | 362667 |
| EXPORTS.fmx | 2.36 | Exports screen | 358425 |
| HC_SHUNT_SHEET.rep | 1.5 | HC Shunt Sheet Report | 359668 |
| HC_TRIP_SHEET.rep | 1.13 | HC Trip Sheet Report | 359668 |
| HCR_LOADING_SHEET.rep | 1.4 | Customer Loading Sheet | 359668 |
| IMP.sql | 5.194 | CSV Imports Package | 360150 |
| INT_XML_MIC.sql | 5.145 | MIC interface | 359656 |
| INT_XML_MIC.sql | 5.146 | MIC interface | 363855 |
| INT_XML_OUT2.sql | 5.292 | Outbound XML Package | 360459 |
| INT_XML_OUT2.sql | 5.293 | Outbound XML Package | 359518 |
| INT_XML_OUT2.sql | 5.294 | Outbound XML Package | 359660 |
| INT_XML_OUT2.sql | 5.295 | Outbound XML Package | 358670 |
| INT_XML_OUT2.sql | 5.296 | Outbound XML Package | 362508 |
| INT_XML_OUT2.sql | 5.297 | Outbound XML Package | 362482 |
| INT_XML_OUT2.sql | 5.298 | Outbound XML Package | 363421 |
| INT_XML_OUT2.sql | 5.299 | Outbound XML Package | 363855 |
| INV.sql | 5.44 | Invoice Package | 360403 |
| INV.sql | 5.45 | Invoice Package | 363974 |
| INV.sql | 5.46 | Invoice Package | 363185 |
| INVOICES.fmx | 2.61 | Invoices Screen | 363185 |
| LOCATION.fmx | 2.191 | Location Maintenance | 359667 |
| OF_INT.sql | 5.52 | Oracle Financials interface | 360756 |
| OF_INT.sql | 5.54 | Oracle Financials interface | 362440 |
| OF_INT.sql | 5.55 | Oracle Financials interface | 363373 |
| OF_INT.sql | 5.56 | Oracle Financials interface | 364191 |
| OF_INT.sql | 5.57 | Oracle Financials interface | 364696 |
| OF_INT.sql | 5.58 | Oracle Financials interface | 365003 |
| OMS.sql | 5.223 | Order package | 359664 |
| OMS.sql | 5.224 | Order package | 359663 |
| OMS.sql | 5.225 | Order package | 363801 |
| OMS.sql | 5.226 | Order package | 363082 |
| OMS.sql | 5.227 | Order package | 365051 |
| ORDERS.fmx | 2.422 | Order Screen | 361329 |
| ORDERS.fmx | 2.423 | Order Screen | 359664 |
| ORDERS.fmx | 2.426 | Order Screen | 359663 |
| ORDERS_WIDE.fmx | 1.24 | Orders Screen | 359664 |
| ORDERS_WIDE.fmx | 1.25 | Orders Screen | 359663 |
| PAR.sql | 5.105 | Paragon Interface | 359664 |
| PAR.sql | 5.106 | Paragon Interface | 364910 |
| PAR_INT.fmx | 10.40 | Paragon Interface form | 364523 |
| PL_VERSION.sql | 4.1 | Version, Date and Author Package | 361652 |
| PLANNING.fmx | 1.108 | Planning Screen | 359621 |
| RATE.sql | 5.154 | Rates Tariff database package | 360756 |
| RATE.sql | 5.155 | Rates Tariff database package | 361291 |
| RATE.sql | 5.156 | Rates Tariff database package | 364191 |
| REPORTS.fmx | 2.35 | Reports Screen | 358425 |
| RESOURCE.fmx | 2.193 | Resource Maintenance form | 359664 |
| ROUTES_MAINT.fmx | 2.49 | Fixed Routes Maintenance | 359664 |
| SHIPMENT_INVOICE.rep | 1.3 | Shipment Invoice Report | 361291 |
| SHIPMENT_PALLETS.fmx | 5.3 | Shipment Pallets Form | 359661 |
| SHIPMENT_PALLETS.fmx | 5.4 | Shipment Pallets Form | 359663 |
| SHIPMENT_PALLETS.fmx | 5.5 | Shipment Pallets Form | 359671 |
| T_SCH_ORD_PNL.sql | 5.15 | Trigger | 360756 |
| TIU_TRIP_STATUS.sql | 5.54 | Trigger on SCH_TRIP for status change | 359660 |
| TRG_MCS_REQUEST_BU.sql | 1.3 | Trigger | 359670 |
| TRG_SCH_ORD_XML_INT.sql | 5.18 | Trigger | 358670 |
| TRG_SHA_XML_OUT.sql | 1.15 | Haulage Activity Trigger | 359660 |
| TRIPDTL.fmx | 2.225 | Trip Debrief | 359621 |
| TRM.sql | 5.191 | Trip manipulation package | 360756 |
| TRM.sql | 5.193 | Trip manipulation package | 362440 |
| TRM.sql | 5.194 | Trip manipulation package | 359663 |
| TRM.sql | 5.195 | Trip manipulation package | 363082 |
| USER_CONTEXT_PKG.sql | 5.3 | User Context Database Package | 359601 |
| USER_CONTEXT_PKG.sql | 5.4 | User Context Database Package | 365051 |
| V_MCS_MENU_ITEM.sql | 1.1 | View | 359670 |
| V_MCS_MENU_ITEM.sql | 1.2 | View | 359671 |
| V_MCS_PALLET.sql | 1.1 | View | 359671 |
| V_MCS_SITE.sql | 1.2 | View | 359670 |
| V_MCS_SITE.sql | 1.3 | View | 362654 |
| V_MCS_SYSTEM_STATUS.sql | 1.1 | View | 359670 |
| V_MCS_TRIP_ITEM.sql | 1.14 | Trip Items View | 359674 |
ADDITIONAL CHANGES
WCS
There are no WCS changes required.
EPOD/T2A
There are no EPOD changes required.
MCS
An MCS change is required for the following logs:
- 359670
- 359674
- 359671
Note: MCS Patch Version 2.00.03.002 to be installed
PORTAL/TTM
A Portal change is required for the following logs:
- 362811
Note: Patch version 8.01.065 (Manifest Label changes) to be installed
EDI
An EDI change is required for the following logs:
- 358670
Note: A new version 2.43 of TripOrder.xsd will need to be installed for the EDI files for messages for the new ConnectedView interface.
