PATCH CTMS 11.0 P029: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 304: Line 304:
|'''Detail of Fix''' || Updates to Loading process
|'''Detail of Fix''' || Updates to Loading process
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Path &amp; Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>WCS_SET_BAY_GRID_ITEMS_ONLY</td>
<td>Y/N</td>
<td>Only update item locations that are on the grid</td>
</tr>
</table>




Revision as of 16:00, 28 August 2018





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

8th May 2016 - 1.0
Reference: PPatch without the P e.g. 091











































SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS WMS 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:

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

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
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: 349586

Customer Ref:
Summary of Call CTMS overwrites order dates & times
Detail of Fix Amendments to the OMS package to prevent dates from being overwitten when orders are validated
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349714

Customer Ref:
Summary of Call DS - AVJL3R
Detail of Fix Changes to the Carrier Manifest to identify if single package tracking has been applied and use the correct config record
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348732

Customer Ref: Test
Summary of Call CTMS File from PRL
Detail of Fix Changes to the PRL ontime interface to remove the location id from the trip check
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350049

Customer Ref:
Summary of Call DS - ASMLCP
Detail of Fix Add town to HCR loading sheet extract and report
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350095

Customer Ref: 341870
Summary of Call Messages from CTMS to PRL
Detail of Fix Correct status of successful records
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350371

Customer Ref:
Summary of Call Customer set up (Alternative item ID)
Detail of Fix Amendment to look at alternative ID when customer has been set up to use alternative ID
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350234

Customer Ref: Trip Validation
Summary of Call Issue with trip validation - missed windows
Detail of Fix Issue when validating overlapping windows between orders and stops
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350763

Customer Ref:
Summary of Call Microlise - Inbound Error
Detail of Fix When a microlise message for a trip which has been deleted in C-TMS was processed, the code tried to commit the change within the loop, causing the code to fall over and leave all records un processed, Commit has been moved.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350690

Customer Ref:
Summary of Call Export Name Format to be changed
Detail of Fix Make filename format consistent in store PVA and compliance extracts
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350772

Customer Ref:
Summary of Call PVA Export - Changes
Detail of Fix Changes to Store PVA and Compliance Reports following UAT
Set-up and Configuration No set-up/configuration required


OBS Log Number: 351033

Customer Ref:
Summary of Call 350682 - Amend order ID generation
Detail of Fix Release of TRIP_PLAN screen
Set-up and Configuration No set-up/configuration required


OBS Log Number: 351235

Customer Ref:
Summary of Call Loading Fixes
Detail of Fix Updates to Loading process
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
WCS_SET_BAY_GRID_ITEMS_ONLY Y/N Only update item locations that are on the grid


OBS Log Number: 351381

Customer Ref: Quote 351381/JAT
Summary of Call Trip Sheet to be amended
Detail of Fix Changes to trip sheet layout after UAT
Set-up and Configuration No set-up/configuration required


OBS Log Number: 351370

Customer Ref: CS-009
Summary of Call Tramping: Waterfall visibility updates
Detail of Fix Add tramp trip selection when based_at is set.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352012

Customer Ref: 325932
Summary of Call Display of closing time
Detail of Fix Display of closing time in location tab of orders screen
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352038

Customer Ref: 351880
Summary of Call New data extract -spelling mistake
Detail of Fix Changes to correct a spelling mistake in the extract
Set-up and Configuration No set-up/configuration required


OBS Log Number: 351997

Customer Ref:
Summary of Call CR: Invoicing - Updates
Detail of Fix Changes to the XML format of the Invoice file
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352036

Customer Ref: 325932(main)
Summary of Call Closing time/epod
Detail of Fix Don't send closing time to epod if null
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352300

Customer Ref:
Summary of Call PVA Export - Changes
Detail of Fix Amend the Store PVA repot to show unscanned items
Set-up and Configuration No set-up/configuration required


OBS Log Number: 352263

Customer Ref:
Summary of Call Fix update of despatch bay on historic
Detail of Fix Prevent despatch bay being updated for historic items
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349373

Customer Ref: EPOD Web Service Exp
Summary of Call Web service issue
Detail of Fix If an Ad-hoc delivery message is received before the collection, hold the delivery message to be re-processed after the collection
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349589

Customer Ref: TID BOOKING
Summary of Call Issues found in Booking Pages CR-35
Detail of Fix Restrict T2A view based on users owning depot
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349715

Customer Ref: CR-36
Summary of Call Handling of empty assets (tst1)
Detail of Fix Changes after secondary testing of 346767
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349793

Customer Ref: Additions to view
Summary of Call Add num tags value to view
Detail of Fix Add num tags scanned to T2A view
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349616

Customer Ref: TID CREATE OMS
Summary of Call Issue in PLANNING Create_PK_DL
Detail of Fix When adding adhoc orders in PLANNING ensure orders plan onto selected stops, if the delivery stop appears more than once on the trip
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349781

Customer Ref: CR-37 menu
Summary of Call PTV Route Optimiser Integration Updated
Detail of Fix Add PTV Config screen to menu
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349945

Customer Ref: 345863- testing
Summary of Call Testing of 345863
Detail of Fix Changes after secondary testing of 348863
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350280

Customer Ref: PTV CONFIG change
Summary of Call PTV Config screen error
Detail of Fix PTV Config screen update error
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350757

Customer Ref:
Summary of Call WebService - Changes from secondary test
Detail of Fix Web service label changes from secondary test
Set-up and Configuration No set-up/configuration required


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 348304

Summary of Call TID: MAR/PACK to set Asset Id
Detail of Fix Set pallet id when creating order items
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348301

Summary of Call ORD Message - no weight
Detail of Fix Pack message wipes out the planned weight, ensure the line weight is not removed if it has been populated
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348405

Summary of Call Relay emails via client server.
Detail of Fix Add Login Credentials for Email
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348245

Summary of Call PRECALL Issue with release
Detail of Fix Retain booking status on orders
Set-up and Configuration No set-up/configuration required


OBS Log Number: 349914

Summary of Call Issue with resource allocation
Detail of Fix Correct issue with drivers available times
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350258

Summary of Call TomTom WEBFLEET: Data not sent
Detail of Fix Change from using trailer to tractor as more generic.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350198

Summary of Call Issue with directs
Detail of Fix Allow directs to be sent to PTV based on group name.
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
PTV_RO_GROUP_NAME 'N' Flag to indicate that unscheduled orders are to be selected by group name


OBS Log Number: 350364

Summary of Call PTV Route Optimiser Import Issues
Detail of Fix Half file upload error count when using pairs. Also fix trip schedule.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350414

Summary of Call PTV RO: Plan opening times over midnight
Detail of Fix Set second opening and closing times when over midnight.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350197

Summary of Call Issue with breaks and Off Duty
Detail of Fix Correct layover time on trip stops
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350476

Summary of Call TMS/WMS Interface STD Pallet Qty Error
Detail of Fix Standard pallet qty calculation fix
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350332

Summary of Call Error on Orders Screen
Detail of Fix Changes to the Orders screen to prevent an error occuring in the fast screen when the system tries to update the packing quantity on the order line.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350632

Summary of Call TMS / WCS Loading
Detail of Fix The WMS-TMS interface will set the current location of the order items when the corresponding sales order is pick confirmed and/or pack confirmed.

The current location will be obtained from the bay number of the despatching trip or by default from the WMS parameters called DEFAULT_BAY_LOCATION.

This default parameter will need to be created for the despatching depot with a valid grid location that is known as a WCS location.

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
DEFAULT_BAY_LOCATION WMS Interface A WCS ‘grid’ location This default location will be used for the current location of the order items when they are created via the ‘MAR’ and ‘PACK’ messages in the WMS-TMS interface should the despatching trip not have a bay location.
DEFAULT_BAY_LOCATION WMS Interface NULL No default value will be available.


OBS Log Number: 350657

Summary of Call WMS-TMS Interface Current Item Location
Detail of Fix The transport order items need to trigger a 441 message for WCS when they are created via the WMS-TMS interface as well as when they are updated with a new trip despatch bay location.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350467

Summary of Call Planning Screen trip filter
Detail of Fix Add trip prefix to trip filters, and shift code to PTV RO planning
Set-up and Configuration No set-up/configuration required


OBS Log Number: 350849

Summary of Call Despatch bay trigger in multi-depots
Detail of Fix The current location of the order items will be updated to the despatch bay for the trip as advised for loading.

WCS will be informed in which depot the loading will occur, the latest trip in a depot that contains the despatch bay will be used.

The latest trip being a trip that has not been given an actual departure time from the depot.

This is to ensure that the depot is identified should the order be cross-docked through multiple depots and the same despatch bays are being used in those depots.

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


OBS Log Number: 350847

Summary of Call Order Interface
Detail of Fix Based on system parameter GEO_TOMTOM_SEND_CUST_REF customer ref will be sent instead of delivery type
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
GE0_TOMTOM_SEND_CUST_REF SYSTEM Y Send customer ref not delivery type ID to TomTom


OBS Log Number: 350942

Summary of Call TOMTOM - Set to EN-ROUTE status
Detail of Fix Set trips to En-ROUTE from ACCEPTED via TomTom based on system parameter GEO_TOMTOM_TRIP_EN-ROUTE
Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
GEO_TOMTOM_TRIP_EN-ROUTE SYSTEM Y/N Will change trip status from ACCEPTED to EN-ROUTE via TomTom


OBS Log Number: 351038

Summary of Call WMS-TMS interface collection times
Detail of Fix This new logic for the transport orders via the WMS-TMS interface from the sales orders will be based on a new WMS parameter called APPLY_COLL_OFFSET being set to Y in the despatching depot/warehouse in TMS.

This WMS parameter can be set for the ORD/ORDA message type 101 in the Locations maintenance screen for the depot (it is not required at the customer level because the schedule rules will be created at the customer level).

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
APPLY_COLL_OFFSET Location WMS Parameter Y The collection/available time windows for the transport order will be based on schedule rules should they exist for the cost centre, customer, service level and location zones.

The location zones will be based on the delivery locations for the customer groups in WMS. The delivery date of the corresponding sales order will be used to assess when the collection date will be.

APPLY_COLL_OFFSET Location WMS Parameter N The collection/available time windows for the transport order will be based on the booking date of the corresponding sales order.


OBS Log Number: 351388

Summary of Call Hold MAR order messages when exclude r/l
Detail of Fix Assesses the presence of a storage location on the picking containers for MAR messages by route/load as well as by sales order and for packs.

Control records by sales order will be placed on hold if they are missing, a later control record by route/load will then omit the sales orders with missing storage locations and process the ones that do have them.

Control records by sales order will be actioned if they are not missing and there is a later control record by route/load that will then process the sales order.

The WCS despatch bay locations for the marshalling racking will be created automatically for the marshalling racking as well as the marshalling location for the MAR and PACK messages.

The WMS Status in the Planning screen will display the date and time when the status was last updated.

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


OBS Log Number: 351440

Summary of Call Enable the 441 message to delete items
Detail of Fix Transport order items that are deleted after they have sent a 441 message to WCS as a loading request will send a new 441 message to WCS to delete the previous request.

The WMS-TMS interface will not delete any transport order items that have been updated as successfully loaded at the depot with a reason code of SL, UL, OL or ML.

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


OBS Log Number: 351922

Summary of Call WMS-TMS interface staying at PROCESSING
Detail of Fix If an exceptional error occurs during processing the record status of the control record will be updated to FAILURE from PROCESSING and the control record will need to be reprocessed after the error message has been reviewed.
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.72 Accounts package 350382
ACC_MAINT.fmx 2.88 Accounts Maintenance 350382
AT_CNT_DEL_TYPE_345683.sql 1.1 Alter Table Script 345863
AT_GEO_LOCATION_350685.sql 1.1 Alter Table Script 350685
AT_LOGIX_EXPORT_HISTORY_345863.sql 1.1 Alter Table Script 345863
AT_ORD_BOOKING_STATUS_345863.sql 1.1 Alter Table Script 345863
AT_ORG_CUSTOMER_346521.sql 1.1 Alter Table Script 346521
AT_ORG_CUSTOMER_352015.sql 1.1 Alter Table Script 352015
AT_PAR_TRIP_DTL_349362.sql 1.2 Alter Table Script 349362
AT_PAR_TRIP_DTL_350686.sql 1.1 Alter Table Script 350686
AT_RES_CARRIER_345863.sql 1.1 Alter Table Script 345863
AT_RES_CARRIER_349030.sql 1.1 Alter Table Script 349030
AT_RES_CARRIER_CONFIG_349030.sql 1.1 Alter Table Script 349030
AT_RES_PERSON_349412.sql 1.1 Alter Table Script 349412
AT_RES_RPE_CUST_LOC_325932.sql 1.1 Alter Table Script 325932
AT_RES_TRAILER_TYPE_345863.sql 1.1 Alter Table Script 345863
AT_SCH_ORD_346521.sql 1.3 Alter Table Script 346521
AT_SCH_ORD_CUSTOMER_DEFAULTS_351984.sql 1.1 Alter Table Script 351984
AT_SCH_ORD_MANF_346521.sql 1.1 Alter Table Script 346521
AT_SCH_ORD_MANF_350684.sql 1.1 Alter Table Script 350684
AT_SCH_ORD_MANF_350685.sql 1.1 Alter Table Script 350685
AT_SCH_ORD_MANF_350686.sql 1.1 Alter Table Script 350686
AT_SCH_ORD_STATUS_345863.sql 1.1 Alter Table Script 345863
AT_SCH_ORD_TRACKING_349714.sql 1.1 Alter Table Script 349714
AT_SCH_TRIP_STATUS_345863.sql 1.1 Alter Table Script 345863
BATHSTORE_MANIFEST.rep 1.11 Manifest Report 350321
BATHSTORE_RET_TO_BASE.rep 1.14 Return to Base Report 349651
BDM.fmx 2.99 Business Data Form 350156
CNT.sql 5.48 Contracts package 350065
CONTRACT.fmx 2.68 Contracts Form 350156
CSV.sql 5.103 CSV extract package 346521
CSV.sql 5.104 CSV extract package 349362
CSV.sql 5.105 CSV extract package 350685
CSV.sql 5.106 CSV extract package 350686
CT_CNT_DEL_TYPE_CUST_EXCL_350156.sql 1.1 Create Table Script 350156
CT_ORG_CUST_HANDOVER_LOC_351745.sql 1.1 Create Table Script 351745
CT_ORG_CUSTOMER_PRINTERS_346521.sql 1.1 Create Table Script 346521
CT_PTV_ORDER_TYPE_TIME_345863.sql 1.1 Create Table Script 345863
CT_PTV_RO_DYNAMIC_COLS_345863.sql 1.1 Create Table Script 345863
CT_SCH_ORD_CUSTOMER_DEFAULTS_325932.sql 1.2 Create Table Script 325932
CT_SEQ_DEFAULT_ID_351699.sql 1.1 Create Table Script 351699
CT_SEQ_ORG_CUSTOMER_PRINTERS_346521.sql 1.2 Create Table Script 346521
CT_SEQ_WEB_SERV_LABEL_AUDIT_346521.sql 1.1 Create Table Script 346521
CT_WEB_SERV_LABEL_AUDIT_346521.sql 1.1 Create Table Script 346521
CUST_COST.fmx 2.126 Customer Maintenance form 346521
CUST_COST.fmx 2.128 Customer Maintenance form 351745
CUST_COST.fmx 2.130 Customer Maintenance form 352015
DATA_1_ALL_XML_SCHEMAS_351943.sql 1.2 Data Script 351943
DATA_ADM_FORM_TAB_345863.sql 1.1 Data Script 345863
DATA_ADM_FORM_TAB_346521.sql 1.1 Data Script 346521
DATA_ADM_FORM_TAB_351745.sql 1.1 Data Script 351745
DATA_ADM_LOG_PROG_NAME_349419.sql 1.1 Data Script 349419
DATA_ADM_MENU_ITEM_345863.sql 1.2 Data Script 345863
DATA_ADM_MENU_ITEM_350684.sql 1.1 Data Script 350684
DATA_ADM_MENU_ITEM_351745.sql 1.1 Data Script 351745
DATA_ADM_SYSTEM_PARAM_325932.sql 1.1 Data Script 325932
DATA_ADM_SYSTEM_PARAM_345863.sql 1.1 Data Script 345863
DATA_ADM_SYSTEM_PARAM_348301.sql 1.1 Data Script 348301
DATA_ADM_SYSTEM_PARAM_348405.sql 1.1 Data Script 348405
DATA_ADM_SYSTEM_PARAM_349362.sql 1.1 Data Script 349362
DATA_ADM_SYSTEM_PARAM_349402.sql 1.1 Data Script 349402
DATA_ADM_SYSTEM_PARAM_349412.sql 1.1 Data Script 349412
DATA_ADM_SYSTEM_PARAM_349413.sql 1.1 Data Script 349413
DATA_ADM_SYSTEM_PARAM_349831.sql 1.1 Data Script 349831
DATA_ADM_SYSTEM_PARAM_350156.sql 1.1 Data Script 350156
DATA_ADM_SYSTEM_PARAM_350198.sql 1.1 Data Script 350198
DATA_ADM_SYSTEM_PARAM_350294.sql 1.1 Data Script 350294
DATA_ADM_SYSTEM_PARAM_350382.sql 1.1 Data Script 350382
DATA_ADM_SYSTEM_PARAM_350431.sql 1.1 Data Script 350431
DATA_ADM_SYSTEM_PARAM_350433.sql 1.4 Data Script 350433
DATA_ADM_SYSTEM_PARAM_350466.sql 1.1 Data Script 350466
DATA_ADM_SYSTEM_PARAM_350468.sql 1.1 Data Script 350468
DATA_ADM_SYSTEM_PARAM_350682.sql 1.1 Data Script 350682
DATA_ADM_SYSTEM_PARAM_350684.sql 1.1 Data Script 350684
DATA_ADM_SYSTEM_PARAM_350685.sql 1.2 Data Script 350685
DATA_ADM_SYSTEM_PARAM_350686.sql 1.2 Data Script 350686
DATA_ADM_SYSTEM_PARAM_350823.sql 1.1 Data Script 350823
DATA_ADM_SYSTEM_PARAM_350847.sql 1.1 Data Script 350847
DATA_ADM_SYSTEM_PARAM_350942.sql 1.1 Data Script 350942
DATA_ADM_SYSTEM_PARAM_351065.sql 1.1 Data Script 351065
DATA_ADM_SYSTEM_PARAM_351235.sql 1.1 Data Script 351235
DATA_ADM_SYSTEM_PARAM_351836.sql 1.1 Data Script 351836
DATA_ADM_SYSTEM_PARAM_351984.sql 1.1 Data Script 351984
DATA_ADM_SYSTEM_PARAM_CONFIG_348301.sql 1.1 Data Script 348301
DATA_ADM_SYSTEM_PARAM_CONFIG_349362.sql 1.1 Data Script 349362
DATA_ADM_SYSTEM_PARAM_CONFIG_350433.sql 1.1 Data Script 350433
DATA_ADM_SYSTEM_PARAM_CONFIG_350682.sql 1.1 Data Script 350682
DATA_ADM_SYSTEM_PARAM_CONFIG_351836.sql 1.1 Data Script 351836
DATA_ADM_SYSTEM_PARAM_CONFIG_351984.sql 1.1 Data Script 351984
DATA_ALL_XML_SCHEMAS_350684.sql 1.3 Data Script 350684
DATA_IMP_FIELD_349362.sql 1.2 Data Script 349362
DATA_PTV_RO_DYNAMIC_COLS_345863.sql 1.1 Data Script 345863
DATA_REP_REPORT_346861.sql 1.1 Data Script 346861
DATA_REP_REPORT_349419.sql 1.1 Data Script 349419
DATA_REP_REPORT_350294.sql 1.2 Data Script 350294
DATA_REP_REPORT_351257.sql 1.1 Data Script 351257
DATA_REP_REPORT_351880.sql 1.1 Data Script 351880
DATA_REP_REPORT_352038.sql 1.10 Data Script 352038
DATA_REP_REPORT_PARAM_346861.sql 1.1 Data Script 346861
DATA_REP_REPORT_PARAM_349419.sql 1.1 Data Script 349419
DATA_REP_REPORT_PARAM_350294.sql 1.2 Data Script 350294
DATA_REP_REPORT_PARAM_351257.sql 1.1 Data Script 351257
DATA_REP_REPORT_PARAM_351880.sql 1.1 Data Script 351880
DATA_REP_REPORT_PARAM_352038.sql 1.1 Data Script 352038
DATA_RES_LABEL_FORMATS_346521.sql 1.2 Data Script 346521
DATA_RES_LABEL_FORMATS_349852.sql 1.1 Data Script 349852
DATA_RES_LABEL_FORMATS_351409.sql 1.1 Data Script 351409
DATA_RES_LABEL_FORMATS_351745.sql 1.2 Data Script 351745
DATA_RES_LABEL_FORMATS_351916.sql 1.1 Data Script 351916
DATA_RES_LABEL_FORMATS_352427.sql 1.1 Data Script 352427
DATA_SCH_SOURCE_SYSTEM_350684.sql 1.1 Data Script 350684
DP_ASSET_SCANNING.sql 5.39 Tag to Asset Scanning 346767
DP_ASSET_SCANNING.sql 5.40 Tag to Asset Scanning 349327
DP_ASSET_SCANNING.sql 5.41 Tag to Asset Scanning 349715
DP_ASSET_SCANNING.sql 5.42 Tag to Asset Scanning 349793
DP_ASSET_SCANNING.sql 5.43 Tag to Asset Scanning 350751
DP_CARRIER.sql 1.72 Carrier Management 346521
DP_CARRIER.sql 1.73 Carrier Management 349030
DP_CARRIER.sql 1.74 Carrier Management 349396
DP_CARRIER.sql 1.75 Carrier Management 349714
DP_CARRIER.sql 1.76 Carrier Management 349852
DP_CARRIER.sql 1.77 Carrier Management 350757
DP_CARRIER.sql 1.78 Carrier Management 351409
DP_CARRIER.sql 1.79 Carrier Management 351745
DP_CARRIER.sql 1.80 Carrier Management 352427
DP_CSV_CSS.sql 1.2 CSS Specific Interfaces 350294
DP_CSV_DHL.sql 1.20 Export Package 351177
DP_CSV_DUN.sql 5.34 Client specific CSV extracts 349419
DP_CSV_DUN.sql 5.35 Client specific CSV extracts 350690
DP_CSV_DUN.sql 5.37 Client specific CSV extracts 350772
DP_CSV_DUN.sql 5.38 Client specific CSV extracts 352300
DP_CSV_GEN.sql 1.3 Generic CVS package 351880
DP_CSV_GEN.sql 1.4 Generic CVS package 352038
DP_CSV_POD.sql 1.5 CSV Package 349627
DP_CSV5.sql 1.68 Fifth CSV extract package 346861
DP_CSV5.sql 1.69 Fifth CSV extract package 350049
DP_CSV6.sql 1.33 CSV Extract package 351257
DP_CSV6.sql 1.34 CSV Extract package 351412
DP_EPOD_WEB_SERVICE.sql 1.104 EPOD Web Service 349373
DP_EPOD_WEB_SERVICE.sql 1.106 EPOD Web Service 349413
DP_EPOD_WEB_SERVICE.sql 1.108 EPOD Web Service 325932
DP_EPOD_WEB_SERVICE.sql 1.109 EPOD Web Service 351699
DP_EPOD_WEB_SERVICE.sql 1.110 EPOD Web Service 352036
DP_EPOD_WEB_SERVICE.sql 1.111 EPOD Web Service 352113
DP_IMP.sql 5.36 Imports Package 349427
DP_IMP_2.sql 1.76 Import Package 350156
DP_INT_TMS_WMS_IN_STUB.sql 1.10 Inbound WMS/TMS Interface Package 350696
DP_INT_TMS_WMS_IN_STUB.sql 1.11 Inbound WMS/TMS Interface Package 351038
DP_INT_TMS_WMS_IN_STUB.sql 1.12 Inbound WMS/TMS Interface Package 351161
DP_INT_TMS_WMS_IN_STUB.sql 1.13 Inbound WMS/TMS Interface Package 351388
DP_INT_TMS_WMS_IN_STUB.sql 1.14 Inbound WMS/TMS Interface Package 351440
DP_INT_TMS_WMS_IN_STUB.sql 1.15 Inbound WMS/TMS Interface Package 351748
DP_INT_TMS_WMS_IN_STUB.sql 1.16 Inbound WMS/TMS Interface Package 351932
DP_INT_TMS_WMS_IN_STUB.sql 1.17 Inbound WMS/TMS Interface Package 351922
DP_INT_TMS_WMS_IN_STUB.sql 1.6 Inbound WMS/TMS Interface Package 348304
DP_INT_TMS_WMS_IN_STUB.sql 1.7 Inbound WMS/TMS Interface Package 350476
DP_INT_TMS_WMS_IN_STUB.sql 1.8 Inbound WMS/TMS Interface Package 350632
DP_INT_TMS_WMS_IN_STUB.sql 1.9 Inbound WMS/TMS Interface Package 350657
DP_INT_XML_MIC2.sql 1.24 CTMS to MIC Interface 349321
DP_INT_XML_MIC2.sql 1.25 CTMS to MIC Interface 350763
DP_INT_XML_MIC2.sql 1.26 CTMS to MIC Interface 349930
DP_INT_XML_MIC2.sql 1.27 CTMS to MIC Interface 352419
DP_INVOICE_XML.sql 1.3 Invoice XML Package 350382
DP_INVOICE_XML.sql 1.6 Invoice XML Package 351997
DP_LOGIX_CONFIG.sql 1.1 PTV Interface 345863
DP_LOGIX_CONFIG.sql 1.10 PTV Interface 350277
DP_LOGIX_CONFIG.sql 1.11 PTV Interface 350992
DP_LOGIX_CONFIG.sql 1.13 PTV Interface 351608
DP_LOGIX_CONFIG.sql 1.14 PTV Interface 352204
DP_LOGIX_CONFIG.sql 1.5 PTV Interface 349945
DP_LOGIX_CONFIG.sql 1.6 PTV Interface 350198
DP_LOGIX_CONFIG.sql 1.7 PTV Interface 350364
DP_LOGIX_CONFIG.sql 1.8 PTV Interface 350414
DP_LOGIX_CONFIG.sql 1.9 PTV Interface 350466
DP_PATCH_RELEASE.sql 1.4 Patch Release Package 351789
DP_PULSE.sql 1.47 Pulse Interface Package 349453
DP_PULSE.sql 1.49 Pulse Interface Package 350468
DP_RDT_FAST_LOAD.sql 5.25 Load confirmation message procedure 350696
DP_RDT_FAST_LOAD.sql 5.26 Load confirmation message procedure 350793
DP_RDT_FAST_LOAD.sql 5.27 Load confirmation message procedure 350686
DP_RDT_FAST_UNLOAD.sql 5.40 RF Unload Package 350686
DP_SCHEDULING_ENGINE.sql 5.134 Scheduling Package 349972
DP_SCHEDULING_ENGINE.sql 5.135 Scheduling Package 351038
DP_SCHEDULING_ENGINE.sql 5.136 Scheduling Package 351246
DP_SCHEDULING_ENGINE.sql 5.137 Scheduling Package 351252
DP_TOMTOM.sql 1.27 TomTom Package 350258
DP_TOMTOM.sql 1.28 TomTom Package 350431
DP_TOMTOM.sql 1.29 TomTom Package 350433
DP_TOMTOM.sql 1.30 TomTom Package 350823
DP_TOMTOM.sql 1.31 TomTom Package 350847
DP_TOMTOM.sql 1.32 TomTom Package 350942
DP_TOY_EDI_IN.sql 1.10 Inbound EDI database package 352263
DP_WEB_SERV_LABEL.sql 1.2 Web service Label 346521
DP_WEB_SERV_LABEL.sql 1.3 Web service Label 350757
DP_WEB_SERV_LABEL.sql 1.4 Web service Label 351803
DP_WEB_SERV_LABEL.sql 1.5 Web service Label 351869
DP_WEB_SERV_LABEL.sql 1.6 Web service Label 352427
DP_WEB_SERVICE_ORD.sql 1.10 Web Service Package 352286
DP_WEB_SERVICE_ORD.sql 1.3 Web Service Package 350684
DP_WEB_SERVICE_ORD.sql 1.5 Web Service Package 351745
DP_WEB_SERVICE_ORD.sql 1.6 Web Service Package 351836
DP_WEB_SERVICE_ORD.sql 1.7 Web Service Package 351943
DP_WEB_SERVICE_ORD.sql 1.8 Web Service Package 351972
DP_WEB_SERVICE_ORD.sql 1.9 Web Service Package 352132
EPOD_WSA.fmx 1.6 EPOD Web Service Audit Form 350684
HCR_LOADING_SHEET.rep 1.2 Customer Loading Sheet 346861
HCR_LOADING_SHEET.rep 1.3 Customer Loading Sheet 350049
IMP.sql 5.167 CSV Imports Package 348328
IMP.sql 5.169 CSV Imports Package 349362
IMP.sql 5.171 CSV Imports Package 350686
INT_ERR.fmx 1.108 Interface Errors 346521
INT_XML_IN.sql 5.175 Order Import Package 350320
INT_XML_IN.sql 5.176 Order Import Package 351186
INT_XML_IN.sql 5.178 Order Import Package 350156
INT_XML_IN.sql 5.179 Order Import Package 351472
INT_XML_IN.sql 5.180 Order Import Package 352107
INT_XML_OUT.sql 5.38 XML Order Interface with CTMS 351836
INT_XML_OUT.sql 5.39 XML Order Interface with CTMS 351943
INT_XML_OUT2.sql 5.265 Outbound XML Package 349714
INT_XML_OUT2.sql 5.266 Outbound XML Package 348732
INT_XML_OUT2.sql 5.267 Outbound XML Package 350095
INT_XML_OUT2.sql 5.268 Outbound XML Package 349402
INT_XML_OUT2.sql 5.270 Outbound XML Package 350371
INT_XML_OUT2.sql 5.271 Outbound XML Package 350848
INT_XML_OUT2.sql 5.272 Outbound XML Package 351389
INT_XML_OUT2.sql 5.274 Outbound XML Package 352092
INV.sql 5.36 Invoice Package 349233
INV.sql 5.37 Invoice Package 349540
INV.sql 5.38 Invoice Package 350276
INV.sql 5.39 Invoice Package 350382
INVOICE_CUST_DUN.rep 1.24 Customer Invoice Report 349540
INVOICES.fmx 2.54 Invoices Screen 350382
LOAD_MAN.fmx 1.23 Load Management Form 350845
LOAD_MAN.fmx 1.24 Load Management Form 351235
LOAD_MAN.fmx 1.25 Load Management Form 351972
LOCATION.fmx 2.185 Location Maintenance 350384
LOCATION.fmx 2.186 Location Maintenance 350685
LOCATION.fmx 2.187 Location Maintenance 350686
MSG_PROCESSING.sql 5.68 Message Processing package 348405
OMS.sql 5.209 Order package 348301
OMS.sql 5.210 Order package 348245
OMS.sql 5.211 Order package 349560
OMS.sql 5.212 Order package 349586
OMS.sql 5.213 Order package 350682
OMS.sql 5.214 Order package 352355
ORDERS.fmx 2.406 Order Screen 350332
ORDERS.fmx 2.407 Order Screen 325932
ORDERS.fmx 2.409 Order Screen 350156
ORDERS.fmx 2.410 Order Screen 350684
ORDERS.fmx 2.411 Order Screen 351432
ORDERS.fmx 2.413 Order Screen 351984
ORDERS.fmx 2.415 Order Screen 352012
ORDERS_WIDE.fmx 1.20 Orders Screen 350156
ORDERS_WIDE.fmx 1.21 Orders Screen 351432
ORION.mmx 1.45 Orion Menu 345863
ORION.mmx 1.47 Orion Menu 349781
ORION.mmx 1.48 Orion Menu 349945
PAR.sql 5.89 Paragon Interface 349362
PAR.sql 5.90 Paragon Interface 349831
PAR.sql 5.91 Paragon Interface 350685
PAR.sql 5.92 Paragon Interface 350686
PAR.sql 5.93 Paragon Interface 351350
PAR_INT.fmx 10.37 Paragon Interface form 350224
PAYMENTS.fmx 2.46 Payments Screen 349040
PLANNING.fmx 1.86 Planning Screen 345863
PLANNING.fmx 1.87 Planning Screen 349616
PLANNING.fmx 1.88 Planning Screen 349666
PLANNING.fmx 1.89 Planning Screen 349945
PLANNING.fmx 1.90 Planning Screen 350467
PLANNING.fmx 1.91 Planning Screen 350845
PLANNING.fmx 1.92 Planning Screen 349405
PLANNING.fmx 1.93 Planning Screen 350992
PLANNING.fmx 1.95 Planning Screen 351388
PLANNING.fmx 1.97 Planning Screen 351984
PLANNING.fmx 1.98 Planning Screen 352125
PTV_CONFIG.fmx 1.2 PTV Configuration screen 345863
PTV_CONFIG.fmx 1.3 PTV Configuration screen 349945
PTV_CONFIG.fmx 1.6 PTV Configuration screen 350280
RATE.sql 5.145 Rates Tariff database package 350382
RATE.sql 5.146 Rates Tariff database package 351997
RESOURCE.fmx 2.189 Resource Maintenance form 349030
RESOURCE.fmx 2.190 Resource Maintenance form 349412
RESOURCE.fmx 2.191 Resource Maintenance form 325932
SENDMAIL.sql 1.3 Java Script 348405
TI_SCH_TRIP_AUDIT.sql 5.4 Trigger 350294
TRG_ORG_CUST_HANDOVER_LOC_BIU.sql 1.1 Trigger 351745
TRG_PTV_ORDER_TYPE_TIME_BIU.sql 1.1 Trigger 345863
TRG_PTV_RO_DYNAMIC_COLS_BIU.sql 1.1 Trigger 345863
TRG_SCH_ORD_CUST_DEFAULTS_BIU.sql 1.1 Trigger 351699
TRG_SCH_TRIP_XML_GEN.sql 5.13 Trigger 351748
TRG_SCH_TRIP_XML_GEN.sql 5.14 Trigger 351969
TRG_SHA_XML_OUT.sql 1.14 Haulage Activity Trigger 351186
TRG_SOI_DESP_BAY.sql 5.3 Trigger 350696
TRG_SOI_DESP_BAY.sql 5.4 Trigger 350849
TRG_SOI_DESP_BAY.sql 5.5 Trigger 351440
TRG_SOL_XML.sql 5.43 Trigger 351186
TRG_SOM_SUPP_CONF.sql 5.19 Trigger 351916
TRG_STS_AI.sql 1.1 Trigger 351063
TRIP_OVERVIEW.fmx 1.57 Trip Waterfall 351065
TRIP_OVERVIEW.fmx 1.58 Trip Waterfall 351370
TRIP_PLAN.fmx 1.273 Trip Planning Screen 351033
TRIP_RES_DIARY.fmx 1.32 Resource Allocation 349914
TRIP_SHEET_DUN_DETAIL.rep 5.21 Driver Trip Sheet 349414
TRIP_SHEET_DUN_DETAIL.rep 5.22 Driver Trip Sheet 351381
TRIPDTL.fmx 2.216 Trip Debrief 349560
TRIPDTL.fmx 2.217 Trip Debrief 351279
TRIPSUM.fmx 2.433 Trip Manipulation screen 349405
TRIPSUM.fmx 2.436 Trip Manipulation screen 351984
TRIPSUM.fmx 2.437 Trip Manipulation screen 352125
TRM.sql 5.166 Trip manipulation package 351033
TRM.sql 5.167 Trip manipulation package 349831
TRM.sql 5.168 Trip manipulation package 350197
TRM.sql 5.169 Trip manipulation package 350234
TRM.sql 5.170 Trip manipulation package 349412
TRM.sql 5.171 Trip manipulation package 351497
V_T2A_BOOKING_ORDERS.sql 1.4 View 349589
V_T2A_BOOKING_ORDERS.sql 1.5 View 349793


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_CTMS_11.0_P029&oldid=6300’