PATCH C-TMS 11.0 P027: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 218: Line 218:
|}
|}
   
   
== Customer Ref: Label Printing ==
== Customer Ref: Label Printing ==
{| width="100%"
{| width="100%"
Line 238: Line 239:
|}
|}
   
   
== Customer Ref: Customer Services API ==
== Customer Ref: Customer Services API ==
{| width="100%"
{| width="100%"
Line 252: Line 254:
|}
|}
   
   
== Customer Ref: INC19535238 ==
== Customer Ref: INC19535238 ==
{| width="100%"
{| width="100%"
Line 266: Line 269:
|}
|}
   
   
== Customer Ref: Orders to RDC ==
== Customer Ref: Orders to RDC ==
{| width="100%"
{| width="100%"
Line 279: Line 283:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: Invoice changes ==
== Customer Ref: Invoice changes ==
Line 294: Line 299:
|}
|}
   
   
== Customer Ref: Label Output ==
== Customer Ref: Label Output ==
{| width="100%"
{| width="100%"
Line 308: Line 314:
|}
|}
   
   
== Customer Ref: Address Removal ==
== Customer Ref: Address Removal ==
{| width="100%"
{| width="100%"
Line 322: Line 329:
|}
|}
   
   
== Customer Ref: 345915 ==
== Customer Ref: 345915 ==
{| width="100%"
{| width="100%"
Line 336: Line 344:
|}
|}
   
   
== Customer Ref: 346040 ==
== Customer Ref: 346040 ==
{| width="100%"
{| width="100%"
Line 350: Line 359:
|}
|}
   
   
== Customer Ref: INC19728139 ==
== Customer Ref: INC19728139 ==
{| width="100%"
{| width="100%"
Line 364: Line 374:
|}
|}
   
   
== Customer Ref: 346040 ==
== Customer Ref: 346040 ==
{| width="100%"
{| width="100%"
Line 378: Line 389:
|}
|}
   
   
== Customer Ref: 346330 ==
== Customer Ref: 346330 ==
{| width="100%"
{| width="100%"
Line 392: Line 404:
|}
|}
   
   
== Customer Ref: 346388 ==
== Customer Ref: 346388 ==
{| width="100%"
{| width="100%"
Line 406: Line 419:
|}
|}
   
   
== Customer Ref: 346538 ==
== Customer Ref: 346538 ==
{| width="100%"
{| width="100%"
Line 420: Line 434:
|}
|}
   
   
== Customer Ref: INC20005756 ==
== Customer Ref: INC20005756 ==
{| width="100%"
{| width="100%"
Line 433: Line 448:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: INC20032729 ==
== Customer Ref: INC20032729 ==
Line 448: Line 464:
|}
|}
   
   
== Customer Ref: INC20036588 ==
== Customer Ref: INC20036588 ==
{| width="100%"
{| width="100%"
Line 462: Line 479:
|}
|}
   
   
== Customer Ref: 346655 ==
== Customer Ref: 346655 ==
{| width="100%"
{| width="100%"
Line 476: Line 494:
|}
|}
   
   
== Customer Ref: 346720 ==
== Customer Ref: 346720 ==
{| width="100%"
{| width="100%"
Line 490: Line 509:
|}
|}
   
   
== Customer Ref: INC20228674 ==
== Customer Ref: INC20228674 ==
{| width="100%"
{| width="100%"
Line 504: Line 524:
|}
|}
   
   
== Customer Ref: 347054 ==
== Customer Ref: 347054 ==
{| width="100%"
{| width="100%"
Line 518: Line 539:
|}
|}
   
   
== Customer Ref: INC20325858 ==
== Customer Ref: INC20325858 ==
{| width="100%"
{| width="100%"
Line 532: Line 554:
|}
|}
   
   
== Customer Ref: 347179 ==
== Customer Ref: 347179 ==
{| width="100%"
{| width="100%"
Line 545: Line 568:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: INC20365356  ==
== Customer Ref: INC20365356  ==
Line 559: Line 583:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: Customer Invoice ==
== Customer Ref: Customer Invoice ==
Line 573: Line 598:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
   
   
== Customer Ref: 345704 ==
== Customer Ref: 345704 ==
Line 588: Line 614:
|}
|}
   
   
== Customer Ref: Customer Invoice ==
== Customer Ref: Customer Invoice ==
{| width="100%"
{| width="100%"
Line 601: Line 628:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: ITINC0082634 ==
== Customer Ref: ITINC0082634 ==
Line 616: Line 644:
|}
|}
   
   
== Customer Ref: INC19742904 ==
== Customer Ref: INC19742904 ==
{| width="100%"
{| width="100%"
Line 629: Line 658:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: INC19664829 ==
== Customer Ref: INC19664829 ==
Line 643: Line 673:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}


== Customer Ref: INC20106359 ==
== Customer Ref: INC20106359 ==
Line 688: Line 719:
|}
|}
   
   
== OBS Log Number: 345569 ==
== OBS Log Number: 345569 ==
{| width="100%"
{| width="100%"
Line 702: Line 734:
|}
|}
   
   
== OBS Log Number: 345820 ==
== OBS Log Number: 345820 ==
{| width="100%"
{| width="100%"
Line 716: Line 749:
|}
|}
   
   
== OBS Log Number: 346128 ==
== OBS Log Number: 346128 ==
{| width="100%"
{| width="100%"
Line 730: Line 764:
|}
|}
   
   
== OBS Log Number: 346462 ==
== OBS Log Number: 346462 ==
{| width="100%"
{| width="100%"
Line 744: Line 779:
|}
|}
   
   
== OBS Log Number: 346686 ==
== OBS Log Number: 346686 ==
{| width="100%"
{| width="100%"
Line 758: Line 794:
|}
|}
   
   
== OBS Log Number: 346764 ==
== OBS Log Number: 346764 ==
{| width="100%"
{| width="100%"
Line 772: Line 809:
|}
|}
   
   
== OBS Log Number: 346974 ==
== OBS Log Number: 346974 ==
{| width="100%"
{| width="100%"
Line 786: Line 824:
|}
|}
   
   
== OBS Log Number: 346975 ==
== OBS Log Number: 346975 ==
{| width="100%"
{| width="100%"
Line 800: Line 839:
|}
|}
   
   
== OBS Log Number: 346976 ==
== OBS Log Number: 346976 ==
{| width="100%"
{| width="100%"

Revision as of 12:15, 22 November 2017





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

21st November 2017 - 1.0
Reference: P027











































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: Auto Email

OBS Log Number: 342621
Reporter: Colin Lowe
Summary of Call Auto email of invoices
Detail of Fix Changes to the Invoice screen to allow invoices to be emailed out to customers following generation
Set-up and Configuration No set-up/configuration required


Customer Ref: Trip Sheet

OBS Log Number: 343592
Reporter: Darren Owens
Summary of Call New Customer Trip sheet
Detail of Fix Create a customer specific Trip Sheet based on the generic removing unrequired fields.
Set-up and Configuration No set-up/configuration required


Customer Ref: Changes to Interface

OBS Log Number: 343746
Reporter: Michelle Naumovski
Summary of Call Changes to Interface
Detail of Fix Changes to the inbound XML interface
Set-up and Configuration No set-up/configuration required


Customer Ref: DH-AHXKWF

OBS Log Number: 340804
Reporter: Daniel Hammond
Summary of Call RIO: Actavis Revenue Rates
Detail of Fix New rating for du type consolidation
Set-up and Configuration No set-up/configuration required


Customer Ref: JB-AQXEME

OBS Log Number: 345511
Reporter: Jeremy Brooks
Summary of Call RIO: Amend the OTM upload
Detail of Fix Do not update order header when updates received from OTM.
Set-up and Configuration No set-up/configuration required


Customer Ref: GH-AQYBWS

OBS Log Number: 345545
Reporter: Geoff Holliday
Summary of Call RIO: Add Parameter to EDI maintenance
Detail of Fix Added SEND_ALL_ORDERS parameter to TRIP_XML edi flow
Set-up and Configuration No set-up/configuration required


Customer Ref: SS-ASAJJV

OBS Log Number: 346630
Reporter: Simon Shearburn
Summary of Call RIO: Add 'Redelivery X' to Trip Manifest
Detail of Fix Add Redelivery text to customer Manifest
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: Invoice amendments

OBS Log Number: 345368
Reporter: Ian Gaunt
Summary of Call Further Invoice amendments
Detail of Fix Changes to RPI calculations after UAT
Set-up and Configuration No set-up/configuration required


Customer Ref: Label Printing

OBS Log Number: 345373
Reporter: Daniel Hammond
Summary of Call Electronic Manifest - Label Printing
Detail of Fix Changes have been made to the order packing processes to ensure that the packed date is set after all of the labels have been printed. If labels are not required, the packed date of the order will still be set.

These changes apply to manual packing, XML packing and CIPD packing processes. Repacked orders will also update the packed date.

The electronic manifest will include the recently packed orders that have tracking references. The electronic manifest will include all orders that exist with tracking references when the first file is produced. The electronic manifest will include all of the orders with tracking references that have been packed since the last manifest file was produced. The concurrent processing of order packing and the electronic manifest will not include the orders that are currently being packed.

The carrier POD files will update the order/consignment. The order will be updated with a delivered quantity for its lines and subtotalled for the order. If a valid reason code is not derived the order will be updated as fully delivered by default. If the reason code is not valid, a non-conformance will not be recorded for the order. If a valid reason code or type 'FAILURE' is derived the order will be updated as not delivered.

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


Customer Ref: Customer Services API

OBS Log Number: 345502
Reporter: Neil Appadu
Summary of Call Customer Services API - changes
Detail of Fix Tweaks to customer services code.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19535238

OBS Log Number: 345561
Reporter: Damian Jackson
Summary of Call Adding a Trailer Type, not saving
Detail of Fix Always populate cost centre on trailer types
Set-up and Configuration No set-up/configuration required


Customer Ref: Orders to RDC

OBS Log Number: 345645
Reporter: Michelle
Summary of Call Orders to RDC's not setting qty
Detail of Fix Amendment to MCS scanning process for receipt so if the order is for delivery in to an RDC and the scan is done at that locaiton the quantity delivered is updated.
Set-up and Configuration No set-up/configuration required


Customer Ref: Invoice changes

OBS Log Number: 345793
Reporter: Dominic Murphy
Summary of Call Invoice changes
Detail of Fix Recalculate cost on customer invoice
Set-up and Configuration No set-up/configuration required


Customer Ref: Label Output

OBS Log Number: 345888
Reporter: Michelle Naumovski
Summary of Call Label output
Detail of Fix Fix to customer label for long addresses causing errors
Set-up and Configuration No set-up/configuration required


Customer Ref: Address Removal

OBS Log Number: 345898
Reporter: Julie Scott
Summary of Call Email - Hardcoded Addresses removal
Detail of Fix Change to user value within SMTP_SENDER parameter not hard coded sender address. SMTP_SENDER system parameter must be updated with appropriate email sender details for this release
Set-up and Configuration No set-up/configuration required


Customer Ref: 345915

OBS Log Number: 345915
Reporter: Matthew Tipping
Summary of Call Change decimal place of adjusted weight
Detail of Fix Changes to finance calculations for customer. System parameter ACC_ROUND_AVG_DU_WEIGHT must be switched on for this release
Set-up and Configuration No set-up/configuration required


Customer Ref: 346040

OBS Log Number: 346040
Reporter: Hayley Keegan
Summary of Call Fixes to new warehouse screen from tstin
Detail of Fix Additional Fixes to Warehouse Management screen
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19728139

OBS Log Number: 346113
Reporter: Jay Goddard
Summary of Call Orders being ignored
Detail of Fix Amendment to C-TMS Import process used for OTM order import to add validation of the Leg field - Expected to be 2 characters long [1-9][C/D/T] If the CSV file contains a leg value that is not in this format then the order will be rejected and the import total updated to reflect this.
Set-up and Configuration No set-up/configuration required


Customer Ref: 346040

OBS Log Number: 346241
Reporter: Carl Styles
Summary of Call New version for 346040
Detail of Fix Code amendments following internal testing
Set-up and Configuration No set-up/configuration required


Customer Ref: 346330

OBS Log Number: 346330
Reporter: Denis Starodubov
Summary of Call Electronic Manifest - Carrier Tracking
Detail of Fix The production of the electronic manifest will ensure that all of the existing tracking references for an order belong to the current carrier of the delivery trip. If they do not, the order will not be included in the file until the order is repacked with a new set of tracking references for the existing carrier.
Set-up and Configuration No set-up/configuration required


Customer Ref: 346388

OBS Log Number: 346388
Reporter: Michelle Naumovski
Summary of Call Cancelled orders showing on Portal
Detail of Fix Amendment to processing of LOTS interface files from C-TMS for event type 'ORD','REM' and 'REN' to correctly handle the opening of separate files for each event type.
Set-up and Configuration No set-up/configuration required


Customer Ref: 346538

OBS Log Number: 346538
Reporter: Matthew Tipping
Summary of Call Fix to allow woodchip contracts to rate
Detail of Fix Amendment for Woodchip contracts
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20005756

OBS Log Number: 346555
Reporter: Denis Starodubov
Summary of Call GB DSC Banbury CTMS issue
Detail of Fix Fix for repacking orders using CIPD files error with wrong product type
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20032729

OBS Log Number: 346619
Reporter: DENIS STARODUBOV
Summary of Call HCR_DELIVERY_NOTE Error
Detail of Fix Amendment to HCR_DELIVERY_NOTE to correctly handle run when trip id parameter is not supplied from screen.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20036588

OBS Log Number: 346634
Reporter: Sarah Howells
Summary of Call Messages failed in Link
Detail of Fix Amend order upload processing script to remove pound sign during load.
Set-up and Configuration No set-up/configuration required


Customer Ref: 346655

OBS Log Number: 346655
Reporter: Suzanne Woodcock
Summary of Call Remove hardcoding of Moisture allowance
Detail of Fix Amendments to round contractual weight to kilos, use moisture allowance rather than hard coded 15% for calculation
Set-up and Configuration No set-up/configuration required


Customer Ref: 346720

OBS Log Number: 346720
Reporter: Suzanne Woodcock
Summary of Call Fixes to Miles per tonne Calculation
Detail of Fix Amendments to the Milesperton calculation
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20228674

OBS Log Number: 347017
Reporter: Agnieszka Trojak
Summary of Call Missing dates/times.
Detail of Fix When a radial trip is respun through paragon with collection orders. Then if later legs have already been planned then remove before re-spinning radial and then try to add back on again at the end. Also if delivery depot changed on a respin then always remove from all trunks before reprocessing so respin can re-assign to different cross-docks (or none) if required.
Set-up and Configuration No set-up/configuration required


Customer Ref: 347054

OBS Log Number: 347054
Reporter: Craig Hopcroft
Summary of Call File uploaded in Unscheduled status
Detail of Fix Fix for order not being autoplanned via csv import
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20325858

OBS Log Number: 347166
Reporter: Piotr Plusa
Summary of Call Extract is inaccurate.
Detail of Fix Amend to supplier trends extract to include zero VAT payments for Jersey
Set-up and Configuration No set-up/configuration required


Customer Ref: 347179

OBS Log Number: 347179
Reporter: Emily Collins
Summary of Call Fixes to interface of Cust Ref to Portal
Detail of Fix Include customer groups when checking for duplicate customer refs
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20365356

OBS Log Number: 347237
Reporter: Damian Jackson
Summary of Call Rebook function is creating original
Detail of Fix Amendment to Orders rebook function to trim leading/trailing spaces from the customer reference after imported orders had several trailing spaces and caused the adding of the _R1 suffix to fail.
Set-up and Configuration No set-up/configuration required


Customer Ref: Customer Invoice

OBS Log Number: 345574
Reporter: sew
Summary of Call Invoice Interface failing for zero VAT
Detail of Fix Changes to the main code to allow multi VAT codes to be accomodated in Oracle Financials
Set-up and Configuration No set-up/configuration required


Customer Ref: 345704

OBS Log Number: 345704
Reporter: Dave Meir
Summary of Call Logix Interface - Consolidate DUs
Detail of Fix Ensure distinct Prod (DU) columns when duplicate decodes created.
Set-up and Configuration No set-up/configuration required


Customer Ref: Customer Invoice

OBS Log Number: 345813
Reporter: Kim Brown
Summary of Call Net ammount to include Fuel
Detail of Fix Fuel to be included in net amount, main code release following branch
Set-up and Configuration No set-up/configuration required


Customer Ref: ITINC0082634

OBS Log Number: 345758
Reporter: Chris Taylor
Summary of Call Cannot run asset screen or routes screen
Detail of Fix Issues in the routes maintenance and asset management screens
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19742904

OBS Log Number: 346042
Reporter: Sarah Howells
Summary of Call WOE Error message displayed during import
Detail of Fix Copy OTM code into additional section when ADDITIONAL_ORDER_VALIDATION is swicthed off.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19664829

OBS Log Number: 345871
Reporter: PIOTR PLUSA
Summary of Call C-TMS Reporting extract error
Detail of Fix Script to apply fix to reporting suite parameters for the INV-TYPE extract type
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20106359

OBS Log Number: 346743
Reporter: Lisa Mullen
Summary of Call Rebooking fails
Detail of Fix Amendment to re-book processing and order copy for the set-up of the _Rn suffix and order line copy.
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 343421

Customer Ref: DF045
Reporter: Emily Collins
Summary of Call New locations processing
Detail of Fix Remove geo_new_location records if no matching geo_location record exists
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345569

Customer Ref:
Reporter: Paul Fitzpatrick
Summary of Call CTMS
Detail of Fix Remove additional XML from ftp file
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345820

Customer Ref: ST-022
Reporter: Neil Appadu
Summary of Call CTL-CS Views - Service and Equipt
Detail of Fix The database view for the Customer Services for the order requirements (V_ORD_REQUIREMENT) will indicate (in ORV_TYPE) the type as 'SERVICE' or 'EQUIPMENT'.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346128

Customer Ref:
Reporter: Piotr Plusa
Summary of Call Error message when opening a form
Detail of Fix Remove QUEUE_MTM records
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346462

Customer Ref:
Reporter: Suzie Maskery
Summary of Call Receipt scanning report error
Detail of Fix Correct dealer name printed in detail section.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346686

Customer Ref:
Reporter: Denis Starodubov
Summary of Call Paragon unscheduled orders in CTMS
Detail of Fix Auto reset of status NEW orders changed in Paragon Interface form so not reliant on audit records existing.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346764

Customer Ref:
Reporter: Denis Starodubov
Summary of Call Paragon replan import blank drops in TMS
Detail of Fix Change code to delete empty stops as re-validate trip does not delete them for parcel carriers.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346974

Customer Ref: ST-123
Reporter: Tony Walker
Summary of Call EPOD Vehicles from CTMS
Detail of Fix Always send tractor description in messages to epod
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346975

Customer Ref: ST-124
Reporter: Tony Walker
Summary of Call EPOD Data Interface
Detail of Fix Only send action type of A and D within messages to epod
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346976

Customer Ref: ST-125
Reporter: Tony Walker
Summary of Call EPOD DU Type Send
Detail of Fix Send Du Type messages for site format CC and alter aduit messages in customer services package
Set-up and Configuration No set-up/configuration required


OBSL 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.sql 5.68 Accounts package 345368
ACC.sql 5.69 Accounts package 340804
ACC.sql 5.70 Accounts package 346040
ACC.sql 5.71 Accounts package 346720
ACC_MAINT.fmx 2.85 Accounts Maintenance 340804
ACC_MAINT.fmx 2.86 Accounts Maintenance 346040
ADM.sql 5.11 Administrator package containing various DB utils 346771
AGREEMENTS.fmx 2.40 Agreements Screen 346538
AGREEMENTS.fmx 2.42 Agreements Screen 346655
ASSET_MANAGEMENT.fmx 1.20 Asset Screen 345758
AT_ACC_PAYMENT_TYPE_340804.sql 1.1 Alter Table Script 340804
AT_ACC_PRICE_INDEX_EFFECTIVE_345368.sql 1.1 Alter Table Script 345368
AT_CNT_TARIFF_342621.sql 1.1 Alter Table Script 342621
AT_GEO_PLAN_REGION_345867.sql 1.1 Alter Table Script 345867
AT_LOGIX_TRIP_DTL_346516.sql 1.1 Alter Table Script 346516
AT_ORG_CUSTOMER_340804.sql 1.1 Alter Table Script 340804
AT_ORG_CUSTOMER_345829.sql 1.1 Alter Table Script 345829
AT_PRD_PRODUCT_TYPE_343746.sql 1.1 Alter Table Script 343746
AT_SCH_ORD_345502.sql 1.1 Alter Table Script 345502
AT_SCH_ORD_346342.sql 1.1 Alter Table Script 346342
AT_SCH_ORD_AUDIT_346548.sql 1.1 Alter Table Script 346548
AT_SCH_ORD_INFORMATION_346560.sql 1.1 Alter Table Script 346560
AT_SCH_ORDER_LINE_346655.sql 1.1 Alter Table Script 346655
AT_SCH_TRIP_345962.sql 1.1 Alter Table Script 345962
BATHSTORE_MANIFEST.rep 1.9 Manifest Report 346630
BDM.fmx 2.97 Business Data Form 345828
CNT.sql 5.47 Contracts package 345915
CONTRACT.fmx 2.66 Contracts Form 342621
CT_ACC_PRICE_INDEX_EFF_BKUP_345368.sql 1.1 Create Table Script 345368
CT_GEO_RADIAL_ROUTING_346134.sql 1.1 Create Table Script 346134
CT_ORD_BOOKING_STATUS_345828.sql 1.3 Create Table Script 345828
CT_ORG_CUST_CONSOLIDATE_QTY_340804.sql 1.1 Create Table Script 340804
CT_ORG_CUST_DU_CATEGORY_340804.sql 1.1 Create Table Script 340804
CT_RES_DU_CATEGORY_340804.sql 1.1 Create Table Script 340804
CUST_COST.fmx 2.123 Customer Maintenance form 340804
DATA_ADM_MENU_ITEM_346128.sql 1.1 Data Script 346128
DATA_ADM_SYSTEM_PARAM_340804.sql 1.1 Data Script 340804
DATA_ADM_SYSTEM_PARAM_342621.sql 1.2 Data Script 342621
DATA_ADM_SYSTEM_PARAM_345504.sql 1.1 Data Script 345504
DATA_ADM_SYSTEM_PARAM_345568.sql 1.1 Data Script 345568
DATA_ADM_SYSTEM_PARAM_345585.sql 1.1 Data Script 345585
DATA_ADM_SYSTEM_PARAM_345735.sql 1.1 Data Script 345735
DATA_ADM_SYSTEM_PARAM_345811.sql 1.1 Data Script 345811
DATA_ADM_SYSTEM_PARAM_345824.sql 1.1 Data Script 345824
DATA_ADM_SYSTEM_PARAM_345829.sql 1.2 Data Script 345829
DATA_ADM_SYSTEM_PARAM_345915.sql 1.1 Data Script 345915
DATA_ADM_SYSTEM_PARAM_346119.sql 1.2 Data Script 346119
DATA_ADM_SYSTEM_PARAM_346206.sql 1.1 Data Script 346206
DATA_ADM_SYSTEM_PARAM_346233.sql 1.1 Data Script 346233
DATA_ADM_SYSTEM_PARAM_346435.sql 1.1 Data Script 346435
DATA_ADM_SYSTEM_PARAM_CONFIG_345585.sql 1.1 Data Script 345585
DATA_ADM_SYSTEM_PARAM_CONFIG_345824.sql 1.1 Data Script 345824
DATA_ADM_SYSTEM_PARAM_CONFIG_340804.sql 1.1 Data Script 340804
DATA_ADM_SYSTEM_PARAM_CONFIG_345915.sql 1.1 Data Script 345915
DATA_ADM_SYSTEM_PARAM_CONFIG_345829.sql 1.1 Data Script 345829
DATA_ADM_SYSTEM_PARAM_CONFIG_346206.sql 1.1 Data Script 346206
DATA_ADM_SYSTEM_PARAM_CONFIG_346233.sql 1.1 Data Script 346233
DATA_ADM_SYSTEM_PARAM_CONFIG_346435.sql 1.1 Data Script 346435
DATA_MSG_SMS_VALUES_346235.sql 1.1 Data Script 346235
DATA_MSG_SMS_VALUES_346418.sql 1.1 Data Script 346418
DATA_ORS_MASTER_DATA_345871.sql 4.1 Data Script 345871
DATA_ORS_USER_DETAILS_345871.sql 4.1 Data Script 345871
DATA_REP_REPORT_343592.sql 1.1 Data Script 343592
DATA_REP_REPORT_PARAM_343592.sql 1.1 Data Script 343592
DOM_MANIFEST_POD.rep 1.7 Manifest Report 345962
DOM_MANIFEST_POD.rep 1.8 Manifest Report 346244
DP_CARRIER.sql 1.67 Carrier Management 345373
DP_CSV_DUN.sql 5.30 Client specific CSV extracts 347166
DP_CSV6.sql 1.32 CSV Extract package 346462
DP_CUST_SERV.sql 1.10 Customer Service Package 346255
DP_CUST_SERV.sql 1.11 Customer Service Package 346240
DP_CUST_SERV.sql 1.13 Customer Service Package 346233
DP_CUST_SERV.sql 1.15 Customer Service Package 346302
DP_CUST_SERV.sql 1.16 Customer Service Package 346351
DP_CUST_SERV.sql 1.17 Customer Service Package 346342
DP_CUST_SERV.sql 1.18 Customer Service Package 346513
DP_CUST_SERV.sql 1.19 Customer Service Package 346560
DP_CUST_SERV.sql 1.20 Customer Service Package 346557
DP_CUST_SERV.sql 1.21 Customer Service Package 346549
DP_CUST_SERV.sql 1.22 Customer Service Package 346548
DP_CUST_SERV.sql 1.23 Customer Service Package 346899
DP_CUST_SERV.sql 1.24 Customer Service Package 346921
DP_CUST_SERV.sql 1.25 Customer Service Package 346976
DP_CUST_SERV.sql 1.3 Customer Service Package 345571
DP_CUST_SERV.sql 1.4 Customer Service Package 345502
DP_CUST_SERV.sql 1.5 Customer Service Package 345811
DP_CUST_SERV.sql 1.6 Customer Service Package 345832
DP_CUST_SERV.sql 1.7 Customer Service Package 345844
DP_CUST_SERV.sql 1.8 Customer Service Package 346080
DP_CUST_SERV.sql 1.9 Customer Service Package 346157
DP_EPOD_WEB_SERVICE.sql 1.100 EPOD Web Service 345564
DP_EPOD_WEB_SERVICE.sql 1.101 EPOD Web Service 346435
DP_EPOD_WEB_SERVICE.sql 1.102 EPOD Web Service 346442
DP_EPOD_WEB_SERVICE.sql 1.103 EPOD Web Service 346925
DP_IMP.sql 5.34 Imports Package 345373
DP_IMP.sql 5.35 Imports Package 346555
DP_IMP_2.sql 1.69 Import Package 345511
DP_IMP_2.sql 1.70 Import Package 346113
DP_IMP_2.sql 1.71 Import Package 346042
DP_IMP_2.sql 1.72 Import Package 343746
DP_INT_XML_CARPOD.sql 5.5 Inbound EDI Carrier POD Interface 345373
DP_LOGIX.sql 1.7 Package for LOGIX Interfaces 345704
DP_LOGIX_DOM.sql 1.10 Logix Procedures 346063
DP_LOGIX_DOM.sql 1.11 Logix Procedures 346121
DP_LOGIX_DOM.sql 1.12 Logix Procedures 346516
DP_LOGIX_DOM.sql 1.7 Logix Procedures 345735
DP_LOGIX_DOM.sql 1.8 Logix Procedures 345872
DP_LOGIX_DOM.sql 1.9 Logix Procedures 345954
DP_MCS_SCANNING.sql 5.41 MCS Scanning Package 345645
DP_REPORTS.sql 5.45 Reports package 345898
DP_SCHEDULING_ENGINE.sql 5.125 Scheduling Package 345616
DP_SCHEDULING_ENGINE.sql 5.126 Scheduling Package 345826
DP_SCHEDULING_ENGINE.sql 5.127 Scheduling Package 345867
DP_SCHEDULING_ENGINE.sql 5.128 Scheduling Package 346134
DP_SCHEDULING_ENGINE.sql 5.129 Scheduling Package 346233
DP_SCHEDULING_ENGINE.sql 5.130 Scheduling Package 346547
DP_SCHEDULING_ENGINE.sql 5.131 Scheduling Package 346579
DP_SCHEDULING_ENGINE.sql 5.132 Scheduling Package 346999
F_SET_NEW_INDEXES.sql 1.2 Function 345368
GEO.sql 5.32 Location Processing 343421
HCR_DELIVERY_NOTE.rep 1.26 HCR Delivery Note 346619
IMP.sql 5.154 CSV Imports Package 345374
IMP.sql 5.155 CSV Imports Package 345842
IMP.sql 5.156 CSV Imports Package 346206
IMP.sql 5.157 CSV Imports Package 346233
IMP.sql 5.158 CSV Imports Package 346377
IMP.sql 5.159 CSV Imports Package 347054
INT_ERR.fmx 1.104 Interface Errors 346582
INT_XML_IN.sql 5.167 Order Import Package 345569
INT_XML_IN.sql 5.168 Order Import Package 345373
INT_XML_IN.sql 5.171 Order Import Package 343746
INT_XML_OUT2.sql 5.260 Outbound XML Package 345373
INT_XML_OUT2.sql 5.261 Outbound XML Package 345545
INT_XML_OUT2.sql 5.262 Outbound XML Package 346330
INT_XML_OUT2.sql 5.263 Outbound XML Package 346388
INV.sql 5.31 Invoice Package 346241
INVOICE_CUST_DUN.rep 1.22 Customer Invoice Report 345574
INVOICES.fmx 2.51 Invoices Screen 342621
INVOICES.fmx 2.52 Invoices Screen 346040
ITEM_LABELS_DOM.rep 1.6 Labels report 345413
ITEM_LABELS_DOM.rep 1.7 Labels report 345953
LFS_LABEL.rep 1.22 Label Report 345888
LFS_LABEL_MULTI.rep 1.10 Label Report 345888
LOCATION.fmx 2.182 Location Maintenance 346770
LOCATION.fmx 2.183 Location Maintenance 346775
MSG_MAINT.fmx 2.27 Message Maintenance screen 345736
MSG_MAINT.fmx 2.28 Message Maintenance screen 345828
MSG_MAINT.fmx 2.29 Message Maintenance screen 346244
MSG_PROCESSING.sql 5.57 Message Processing package 345898
MSG_PROCESSING.sql 5.58 Message Processing package 346119
MSG_PROCESSING.sql 5.59 Message Processing package 346235
MSG_PROCESSING.sql 5.60 Message Processing package 346350
MSG_PROCESSING.sql 5.61 Message Processing package 346418
MSG_PROCESSING.sql 5.62 Message Processing package 346586
OF_INT.sql 5.40 Oracle Financials interface 342621
OF_INT.sql 5.41 Oracle Financials interface 345574
OF_INT.sql 5.42 Oracle Financials interface 345813
OF_INT.sql 5.43 Oracle Financials interface 346040
OF_INT.sql 5.44 Oracle Financials interface 345898
OF_INT.sql 5.45 Oracle Financials interface 346241
OMS.sql 5.197 Order package 345374
OMS.sql 5.198 Order package 345824
OMS.sql 5.199 Order package 346547
OMS.sql 5.200 Order package 346896
OMS.sql 5.201 Order package 346743
OMS.sql 5.202 Order package 347179
ORDERS.fmx 2.390 Order Screen 345373
ORDERS.fmx 2.391 Order Screen 345585
ORDERS.fmx 2.392 Order Screen 345828
ORDERS.fmx 2.394 Order Screen 343746
ORDERS.fmx 2.395 Order Screen 346342
ORDERS.fmx 2.397 Order Screen 346560
ORDERS.fmx 2.398 Order Screen 346583
ORDERS.fmx 2.399 Order Screen 346743
ORDERS.fmx 2.402 Order Screen 347179
ORDERS.fmx 2.401 Order Screen 347237
ORDERS_WIDE.fmx 1.10 Orders Screen 345736
ORDERS_WIDE.fmx 1.11 Orders Screen 345828
ORDERS_WIDE.fmx 1.13 Orders Screen 343746
ORDERS_WIDE.fmx 1.14 Orders Screen 346342
ORDERS_WIDE.fmx 1.15 Orders Screen 346776
ORDERS_WIDE.fmx 1.9 Orders Screen 345585
PAR.sql 5.85 Paragon Interface 346764
PAR.sql 5.86 Paragon Interface 347017
PAR_INT.fmx 10.36 Paragon Interface form 346686
PAYMENTS.fmx 2.45 Payments Screen 340804
PLANNING.fmx 1.68 Planning Screen 345571
PLANNING.fmx 1.69 Planning Screen 345585
PLANNING.fmx 1.70 Planning Screen 345736
PLANNING.fmx 1.71 Planning Screen 345828
PLANNING.fmx 1.72 Planning Screen 345962
PLANNING.fmx 1.73 Planning Screen 345698
PLANNING.fmx 1.74 Planning Screen 346548
PRODUCT.fmx 2.53 Product form to maintain Volumetric data 343746
RATE.sql 5.133 Rates Tariff database package 342621
RATE.sql 5.135 Rates Tariff database package 340804
RATE.sql 5.136 Rates Tariff database package 345915
RATE.sql 5.137 Rates Tariff database package 346655
RATE.sql 5.138 Rates Tariff database package 346720
RES_PERSON_UID.sql 5.7 Trigger 346975
RES_TRACTOR_CARRIER_UID.sql 5.11 Trigger 346974
RES_TRACTOR_UID.sql 5.6 Trigger 346975
RES_TRACTOR_UID.sql 5.8 Trigger 346974
RESOURCE.fmx 2.188 Resource Maintenance form 340804
ROUTES_MAINT.fmx 2.47 Fixed Routes Maintenance 345758
STATIC_DATA_MAINT.fmx 1.24 Static Data Maintenance Screen 345867
STATIC_DATA_MAINT.fmx 1.25 Static Data Maintenance Screen 346134
STATIC_DATA_MAINT.fmx 1.26 Static Data Maintenance Screen 346543
SUPPLIER_INVOICE.rep 2.23 Supplier Invoice Report 345368
SUPPLIER_INVOICE.rep 2.24 Supplier Invoice Report 345793
SUPPLIER_INVOICE.rep 2.26 Supplier Invoice Report 345915
SUPPLIER_INVOICE.rep 2.29 Supplier Invoice Report 346720
T_SCH_ORD_PNL.sql 5.12 Trigger 346655
TI_SCH_ORD_STATUS.sql 1.16 Trigger on SCH_ORD for status change 345504
TI_SCH_TRIP_AUDIT.sql 5.3 Trigger 346513
TIU_TRIP_STATUS.sql 5.48 Trigger on SCH_TRIP for status change 345827
TIU_TRIP_STATUS.sql 5.49 Trigger on SCH_TRIP for status change 346302
TIU_TRIP_STATUS.sql 5.50 Trigger on SCH_TRIP for status change 346586
TRG_RES_DU_EPOD.sql 1.5 Trigger 346976
TRG_RES_TRAILER_TYPE_BIU.sql 1.1 Trigger 345561
TRG_SCH_ORD_DEL_TRP.sql 5.5 Trigger 345568
TRG_SCH_ORD_EQUIP_SERVICES.sql 5.2 Database Trigger Script 345504
TRG_SCH_ORD_LABOUR_SERVICES.sql 5.2 Database Trigger Script 345504
TRG_SCH_ORD_LINES_SERVICES.sql 5.7 Database Trigger Script 345504
TRG_SCH_ORD_LOTS.sql 5.14 Trigger 346746
TRG_SCH_TRIP_XML_GEN.sql 5.12 Trigger 345545
TRG_SHA_LOAD_TRIPS.sql 1.4 Trigger 345827
TRG_SHA_LOAD_TRIPS.sql 1.5 Trigger 346302
TRG_SHA_LOAD_TRIPS.sql 1.6 Trigger 346427
TRG_SHA_LOAD_TRIPS.sql 1.7 Trigger 346586
TRG_SO_BOOK_STATUS.sql 1.2 Trigger 346233
TRIP_PLAN.fmx 1.273 Trip Planning Screen 346548
TRIP_SHEET_MORAN.rep 1.1 Customer Trip Sheet 343592
TRIPDTL.fmx 2.213 Trip Debrief 343532
TRIPDTL.fmx 2.214 Trip Debrief 346342
TRIPSUM.fmx 2.431 Trip Manipulation screen 346548
TRM.sql 5.161 Trip manipulation package 346134
TRM.sql 5.162 Trip manipulation package 346547
TRM.sql 5.163 Trip manipulation package 346579
V_ORD_AUDIT.sql 1.1 View 346548
V_ORD_AUDIT.sql 1.2 View 346921
V_ORD_BOOKING_STATUS.sql 1.2 View 345828
V_ORD_ORDER_CONTACT.sql 1.3 View 346147
V_ORD_ORDER_HEADER.sql 1.10 View 346898
V_ORD_ORDER_HEADER.sql 1.3 View 345502
V_ORD_ORDER_HEADER.sql 1.4 View 346236
V_ORD_ORDER_HEADER.sql 1.7 View 346342
V_ORD_ORDER_HEADER.sql 1.8 View 346559
V_ORD_ORDER_HEADER.sql 1.9 View 346678
V_ORD_ORDER_LINE_ITEM.sql 1.2 View 345825
V_ORD_ORDER_LINE_ITEM_PROD.sql 1.2 View 345825
V_ORD_ORDER_LINE_ITEM_PROD.sql 1.3 View 346678
V_ORD_POSS_TRIP.sql 1.3 View 345586
V_ORD_POSS_TRIP.sql 1.4 View 345811
V_ORD_POSS_TRIP.sql 1.5 View 346055
V_ORD_REQUIREMENT.sql 1.2 View 345820
V_ORD_REQUIREMENT.sql 1.3 View 346342
V_ORD_REQUIREMENT.sql 1.4 View 346513
V_TRP_TRIP_STOP.sql 1.2 View 346894
WAREHOUSE.fmx 2.10 Warehouse Screen 346040
xml2.sed 1.3 Inbound XML Order Processing 346634


ADDITIONAL CHANGES

WCS

There are no WCS changes required.


EPOD/T2A

There are no ePOD/T2A changes required.


MCS

There are no MCS changes required.


PORTAL/TTM

A Portal change is required for the following logs:

  • 343746


EDI

There are no EDI changes required.


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