PATCH CTMS P036: Difference between revisions

From Calidus HUB
VisualWikitext
m (Categorisation)
m (Categorisation)
Line 3: Line 3:
{{#vardefine:ClientName|OBS Logistics Ltd}}
{{#vardefine:ClientName|OBS Logistics Ltd}}
{{#vardefine:System|''CALIDUS'' TMS}}
{{#vardefine:System|''CALIDUS'' TMS}}
{{#vardefine:SystemCode|CTMS}}
{{#vardefine:Doc_Title|Release Notes}}
{{#vardefine:Doc_Title|Release Notes}}
{{#vardefine:Version|1.0}}
{{#vardefine:Version|1.0}}
Line 1,510: Line 1,511:
</div>
</div>
[[Category:{{#var:Client}} PATCH]]
[[Category:{{#var:Client}} PATCH]]
[[Category:{{#var:System}} PATCH]]
[[Category:{{#var:SystemCode}} PATCH]]

Revision as of 12:30, 12 May 2025





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

20th Feb 2020 - 1.0
Reference: P036











































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

OBS Log Number: 357997
Summary of Call Empties actual flow.
Detail of Fix Changes to allow Actual empties to be matched and replaced on C-TMS
Set-up and Configuration No set-up/configuration required


Customer Ref: No Ref

OBS Log Number: 361892
Summary of Call Amendments to VDA4987 matches to VDA4933
Detail of Fix Changes to how the 4987 orders find a matching 4933 order
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0036862

OBS Log Number: 367512
Summary of Call New Invoicing development
Detail of Fix Changes to the Invoice processing and Shipment Extract
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0037013

OBS Log Number: 368441
Summary of Call New invoicing extract
Detail of Fix New Invoicing Extract for identifying payment and invoice issues
Set-up and Configuration No set-up/configuration required


Customer Ref: No Ref

OBS Log Number: 369093
Summary of Call HAM-MCS-Part complete despatch
Detail of Fix MCS scanning will be emabled to allow a user to handover scanning to another user for loading an unloading a trip.

System parameter MCS_UPDATE_SCAN_IMMEDIATELY will enable this functionality when set to Y.

System parameter MCS_RECEIVE_TO_PLAN will enforce the receipt scanning of packages and pallets to the planned trips when set to Y.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
MCS_UPDATE_DESPATCH_IMMEDIATELY SYSTEM Y MCS will update C-TMS as each package or pallet is scanned as despatched or damaged at despatch.
MCS_UPDATE_DESPATCH_IMMEDIATELY SYSTEM N MCS will not update C-TMS as each package or pallet is scanned as despatched or damaged at despatch. C-TMS will be updated when the trip is completed at despatch as usual.
MCS_RECEIVE_TO_PLAN SYSTEM Y MCS will enforce the receipt scanning of packages and pallets to the planned trips.
MCS_RECEIVE_TO_PLAN SYSTEM N MCS will not enforce the receipt scanning of packages and pallets to the planned trips.


Customer Ref: WREQ0024767 v3.0

OBS Log Number: 356056
Summary of Call GSN:Manifest to be sent to suppliers
Detail of Fix The 'NR Supplier Manifest' report will be made available for use in addition to the 'NR Driver Manifest' report.

The system parameter 'SEND_MANF_TO_SUPP' will be made available at the 'COST_CENTRE' and 'CUSTOMER' levels for configuration: a value of 'Y' will make the active the automatic generation of the 'NR Supplier Manifest' report when the trip status is set to 'ACCEPTED'.

The automatic generation will use the same configuration of the message requests as the existing 'NR Driver Manifest' report for 'TRIP_ACCEPT' for the 'Carrier' of the trip.

The 'NR Supplier Manifest' report will require a message request for the 'Postcode' of a collection location on the trip.

The 'SUPPLIER_MANF' system parameter must be set to 'NR_SUPP_MANF.rep' for the appropriate cost centre of the orders on the trip.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
SUPPLIER_MANF COST_CENTRE NR_SUPP_MANF.rep Includes the name of the 'NR Supplier Manifest' report to produce.
SEND_MANF_TO_SUPP COST_CENTRE Y Indicates that the 'NR Supplier Manifest' report can be produced for cost centre.
SEND_MANF_TO_SUPP COST_CENTRE N Indicates that the 'NR Supplier Manifest' report cannot be produced for cost centre.
SEND_MANF_TO_SUPP CUSTOMER Y Indicates that the 'NR Supplier Manifest' report can be produced for customer.
SEND_MANF_TO_SUPP CUSTOMER N Indicates that the 'NR Supplier Manifest' report cannot be produced for customer.


Customer Ref: Schedule Engine

OBS Log Number: 361806
Summary of Call Scheduling Engine - two customers
Detail of Fix Changes to Zones to allow customers to be specified
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0033532

OBS Log Number: 362756
Summary of Call GSN:Asset Dwell Report-Valid assets
Detail of Fix New export to report asset dwelling
Set-up and Configuration No set-up/configuration required


Customer Ref: PO: 44010895168

OBS Log Number: 364692
Summary of Call HAM - Add Package Number to VANFLEET1
Detail of Fix Changes to the Vanfleet label to include the package number details
Set-up and Configuration No set-up/configuration required


Customer Ref: MCS

OBS Log Number: 365641
Summary of Call HAM Prevent MCS setting Trip status
Detail of Fix Changes to the MCS processing to allow locations to be configured to not set trips status to COMPLETED
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035190

OBS Log Number: 365701
Summary of Call GSN: Unshedule multiple orders
Detail of Fix Changes to the order screens to allow unscheduling of multiple sched coll orders and searching and filtering based on van fleet field
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035370

OBS Log Number: 365935
Summary of Call GSN:Create a new HC Delivery Note
Detail of Fix New Van Delivery Note, based on the existing version but producing POD paperwork at child location level.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035624

OBS Log Number: 366435
Summary of Call GSN:Report changes
Detail of Fix The 'Receipt Scanning' export will include any contents (child assets) for the order items (parent assets).

The 'On Time Items' export will include any contents (child assets) for the order items (parent assets).

The counts will not include the child assets.

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


Customer Ref: WREQ0037056

OBS Log Number: 368669
Summary of Call Modify ZETES/Athena Interface for Items
Detail of Fix The ZETES files will assess the format of the item identifiers based on a new system parameter ZET_INC_SSCC_PREFIX.

When this parameter is set to Y for the cost centre of the order the format will be assessed to include a prefix for files from CTMS to ZETES or to exclude a prefix for files from ZETES to CTMS.

This format is fixed as 05050210 or 202.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ZET_INC_SSCC_PREFIX COST_CENTRE Y Includes prefixes for SSCC formats for the Zetes interface
ZET_INC_SSCC_PREFIX COST_CENTRE N Does not include prefixes for SSCC formats for the Zetes interface


Customer Ref: WREQ0037626

OBS Log Number: 369353
Summary of Call Modify Trip Sheet
Detail of Fix Changes to the Trip sheet formats, to include additional text
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Customer Ref: Invoicing

OBS Log Number: 362735
Summary of Call Invoice rejected
Detail of Fix Changes to allow the XML file to deal with special characters without causing issues for invoicing
Set-up and Configuration No set-up/configuration required


Customer Ref: INC30622188

OBS Log Number: 365637
Summary of Call Not able to split without adding volume
Detail of Fix Amendment to the OMS packages called when splitting and order to prevent an error when calculation of the remaining volume/weight has a divide by 0.
Set-up and Configuration No set-up/configuration required


Customer Ref: MCS

OBS Log Number: 366165
Summary of Call HAM - MCS Item History / Splitting
Detail of Fix The item history will be retained when the item is split to a new order and given a prefix of X to exclude the item from further scanning. The validation of the pallets being despatched will enable other depots and trips to be assessed.
Set-up and Configuration No set-up/configuration required


Customer Ref: MCS

OBS Log Number: 366346
Summary of Call HAM - MCS Despatch Logging
Detail of Fix Added some additional info messages for load status changes.
Set-up and Configuration No set-up/configuration required


Customer Ref: No ref

OBS Log Number: 366711
Summary of Call HAM - Pallet Build validation fix
Detail of Fix Pallet building validation has been fixed to that, under new pallet building validation rules, packages passing through different final delivery depots (ROCs) can no longer be palletised together.

This also fixes the suggestion of pallets when an item is scanned.

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


Customer Ref: Despatch Validation

OBS Log Number: 367006
Summary of Call HAM - Despatch Pallet Validation
Detail of Fix A pallet cannot be despatched on a trip that is going to be unloaded at a different depot than the planned depot.

This validation will also apply to the despatch of loose packages.

Note that system parameter MCS_DESPATCH_TO_PLAN will prevent any pallets or packages being despatched on any but the planned trip when it is active.

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


Customer Ref: MCS

OBS Log Number: 367068
Summary of Call HAM - MCS Damages errors
Detail of Fix Only validates if the package or pallet exists for DAMAGES using MCS instead of assessing it as part of the despatch process.

Updates the trip items with the same reason code as the damaged order items.

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


Customer Ref: POD Generation

OBS Log Number: 367400
Summary of Call POD Generation Extract query
Detail of Fix The POD Generation Extract will produce the file more efficiently.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC31146492

OBS Log Number: 367549
Summary of Call Order failed with duplicate key error
Detail of Fix Amendment to order validation process so when called from INT_ERR_ORD the correct EDI process is used for setting global and process parameters.
Set-up and Configuration No set-up/configuration required


Customer Ref: Internal

OBS Log Number: 367610
Summary of Call Sched Engine Trunks - multiple legs
Detail of Fix Changes to allow trunk scheduling regardless of delivery windows
Set-up and Configuration No set-up/configuration required


Customer Ref: Auditing

OBS Log Number: 368117
Summary of Call Auditing of WCS msg send
Detail of Fix Add user / trip / order info to audit when messages are sent to WCS
Set-up and Configuration No set-up/configuration required


Customer Ref: EDI

OBS Log Number: 368178
Summary of Call Duplicate EDI Order Validation
Detail of Fix The inbound EDI orders will either allow duplicate orders or not allow duplicate orders based on the system parameter OMS_UNIQUE_EXT_REF and the EDI parameter 4000. This EDI parameter will be optional

The EDI parameter 4000 will be optional and it will have a default value of N.

The duplicate order check will be performed when EDI files are processed or reprocessed in the Interface Errors screen when they have failed.

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


Customer Ref: INC31401083

OBS Log Number: 368473
Summary of Call Merge branch into mainline version
Detail of Fix Amendment to initialise variable that was causing first DU qty on first line of Paragon extract to be incorrect.
Set-up and Configuration No set-up/configuration required


Customer Ref: Inventory Transaction

OBS Log Number: 368963
Summary of Call Inventory Transaction - Scanned Trunks
Detail of Fix The scanned trunk trip information will be displayed for the Inventory Transaction extract.
Set-up and Configuration No set-up/configuration required


Customer Ref: MCS

OBS Log Number: 369066
Summary of Call HAM-MCS-Damage parcels are still planned
Detail of Fix A new system parameter called MCS_EXCEPTIONS_DAMAGED is available to mark items as DAMAGED at despatch and receipt when a MCS user loads or unloads with a reason code to indicate an exception to the plan.

The advised reason code will still be stored for the item for the scan but the comment will be DAMAGED instead of the description of the reason code.

This new functionality will be active when this system parameter is set to Y.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
MCS_EXCEPTIONS_DAMAGED SYSTEM Y MCS exceptions at Receipt (excluding FNR and LATE) and Despatch will be marked as damaged items with ‘DAMAGED’ as the reason code comment and be removed from onward trips.
MCS_EXCEPTIONS_DAMAGED SYSTEM N MCS exceptions at Receipt and Despatch will be marked with the description of the provided reason code as the reason code comment and be removed from onward trips.


Customer Ref: MCS

OBS Log Number: 369066
Summary of Call HAM-MCS-Damage parcels are still planned
Detail of Fix If a package or a pallet is not despatched, it will not be available to scan on receipt at the next depot or for any onward trips.

A damaged item will not be available for pallet building.

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


Customer Ref: INC31644327

OBS Log Number: 369154
Summary of Call Not generated LOAD messages for H61
Detail of Fix The LOAD and CITD files can be create for an outbase and without an outbase.

If the EDI parameter OUTBASE_INDICATOR is set to Y and the trip contains an order (or orders) for an outbase (or outbases) and orders not for an outbase, separate files will be produced for each outbase and for the orders without an outbase.

If the EDI parameter OUTBASE_INDICATOR is set to Y and the trip does not contain an order for an outbase (or outbases) and does contain orders not for an outbase, a single file will be produced for the orders without an outbase.

If the EDI parameter OUTBASE_INDICATOR is set to N and the trip contains an order (or orders) for an outbase (or outbases) and orders not for an outbase, a single file will be produced for the orders without an outbase.

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


Customer Ref: INC31776738

OBS Log Number: 369623
Summary of Call Invalid content in EDI file
Detail of Fix Amendment to Microlise outbound file generation to ensure variable to build the shipment detail value can accommodate the combined order field values.
Set-up and Configuration No set-up/configuration required


Customer Ref: Delivery Extract

OBS Log Number: 370161
Summary of Call POD Delivery Extract
Detail of Fix Amend date handling so dates outside expected range do not cause errors.
Set-up and Configuration No set-up/configuration required


Customer Ref: No ref

OBS Log Number: 365630
Summary of Call Mainline version of branch 365197
Detail of Fix Mainline changes for Forecast quantities
Set-up and Configuration No set-up/configuration required


Customer Ref: INC30925539

OBS Log Number: 366646
Summary of Call Trips not having preadvised values
Detail of Fix Changes to the schedule format to allow the change of month to be calcualted correctly
Set-up and Configuration No set-up/configuration required


Customer Ref: INC31394604

OBS Log Number: 368392
Summary of Call Not able to run Revenue Check Report
Detail of Fix Re-work on data selection query to improve speed of generating the Revenue check report.
Set-up and Configuration No set-up/configuration required


Customer Ref: No ref

OBS Log Number: 366240
Summary of Call Add Detail Tab and Audit log
Detail of Fix Amendment to order update trigger to audit change to order comments
Set-up and Configuration No set-up/configuration required


Customer Ref: N/A

OBS Log Number: 368228
Summary of Call Cages scanned on trips query
Detail of Fix Master data fields added to the Extract parameters for ASSET_HISTORY to allow report to query on particulare trip id. Will allow extract to be take of assets being scanned into an RDC during a specified arrive time frame.
Set-up and Configuration No set-up/configuration required


Customer Ref: NO REF

OBS Log Number: 361965
Summary of Call Rebook Functionality Error
Detail of Fix Changes to re-book in Orders screen to allow unscheduling when POC flag has been set
Set-up and Configuration No set-up/configuration required


Customer Ref: Collection Trip

OBS Log Number: 368474
Summary of Call Amend to collection trip WCS send
Detail of Fix Ability to prevent collection pre-advices
Set-up and Configuration No set-up/configuration required


Customer Ref: Inventory Trans

OBS Log Number: 367200
Summary of Call DUN Inventory Transactions - Scan Data
Detail of Fix The DUN Inventory Transactions export will include order items that have been planned on a trip or scanned on a trip.

Items that are scanned on different trunk trips are not always back-planned on a trip but need to be included for the scanned trip for which they do not exist.

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


Customer Ref: Packing

OBS Log Number: 368406
Summary of Call Issues with packing orders
Detail of Fix The packed quantity on the order lines will be audited.
Set-up and Configuration No set-up/configuration required



TID CHANGES

OBS Log Number: 365686

Customer Ref: No ref
Summary of Call Report DUN_INVENTORY_TRANS
Detail of Fix A new DUN Inventory Transactions export will be available to authorise for the appropriate user groups. The scan user will be reported for the receipts and despatches.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 366131

Customer Ref: 365830
Summary of Call HAM: Seal number in MCS
Detail of Fix Display Consignment Type.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 366342

Customer Ref: No ref
Summary of Call HAM - Re-loading/unloading fails
Detail of Fix MCS scanning of pallets and packages will maintain Item reasons to be inserted or updated for the combination of order, item, depot and reason.

Updates will be to the reason comments to append the existing reason comments with a time and user stamp.

The following processes will be maintained as above:

1. Pallet Building

2. Despatch Confirmation

3. Despatch Completion

4. Receipt Confirmation

5. Receipt Completion

6. Order Splitting from Despatch and Receipt

7. Damages

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


OBS Log Number: 366424

Customer Ref: No ref
Summary of Call Site name amendment
Detail of Fix Allow for change of database name on CTMS without impacting EPOD.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 366709

Customer Ref: No ref
Summary of Call HAM - Product Incompatibility fix
Detail of Fix The Products maintenance screen can display up to 50 characters for the product types and their incompatible product types.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 366726

Customer Ref: No ref
Summary of Call HAM - Item Validation at Despatch
Detail of Fix A new system parameter called MCS_DESPATCH_TO_PLAN can be set to control the scanning of pallets and packages at despatch.

When set to Y:

New functionality: The package or pallet must be planned on the trip being despatched.

When set to N:

Current functionality: The package or pallet can be planned on a different trip for the same routing.

Note: This release also fixes the issue whereby valid packages may not be scanned onto the same pallet in Pallet Building.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
MCS_DESPATCH_TO_PLAN SYSTEM Y New functionality: The package or pallet must be planned on the trip being despatched.
MCS_DESPATCH_TO_PLAN SYSTEM N Current functionality: The package or pallet can be planned on a different trip for the same routing.


OBS Log Number: 367440

Customer Ref: No ref
Summary of Call Site name amendment
Detail of Fix Changes to site indentifier to cope when the database changes name on CTMS.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 368907

Customer Ref: No ref
Summary of Call Allow return trunk legs between depots
Detail of Fix Allow two directional trunking in home delivery function
Set-up and Configuration No set-up/configuration required


OBS Log Number: 368955

Customer Ref: No ref
Summary of Call TID: Order Import new address creation
Detail of Fix A new system parameter called IMP_FULL_LOC_ADDR_MATCH can be used to control the level of address data that must match an existing location for that location to be used for an order when it is imported.

When IMP_FULL_LOC_ADDR_MATCH is Y, the address must match the location name, address line 1, postcode, country code and location type for the order to use the existing location.

Otherwise, the existing functionality will apply and the existing location will be found for the location name and postcode then address line 1, postcode, country code and location type.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
IMP_FULL_LOC_ADDR_MATCH SYSTEM Y Checks the addresses match for the location name, address line 1, postcode, country code and location type for imported orders before creating a new location.
IMP_FULL_LOC_ADDR_MATCH SYSTEM N Checks the addresses match for the location name and postcode then address line 1, postcode, country code and location type for imported orders before creating a new location.


OBS Log Number: 369128

Customer Ref: PROD
Summary of Call Interface screen duplicate entries
Detail of Fix Changes to the way a duplicate is identified for shipment actuals
Set-up and Configuration No set-up/configuration required


OBS Log Number: 369254

Customer Ref: 367512
Summary of Call UAT:Changes to shipment consolidation
Detail of Fix Changes to shipment consolidation logic to use sender and delivery numbers
Set-up and Configuration No set-up/configuration required


OBS Log Number: 365830

Customer Ref: No ref
Summary of Call HAM - MCS UAT Issues
Detail of Fix Prevent the despatch update process from completing and record error messages if the trip status fails to update.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 367012

Customer Ref: No ref
Summary of Call HAM - MCS Reporting
Detail of Fix Database scripts will be run to create any missing master data for ORS extracts:

AWB

AWB_CONS

LABOUR

MCS_DTLS

O/S SCANS

OPEN_AWB

PALLETS

PALL_ITEM

PAYMENTS

RE-DELIVER

REASONS

RES_EQUIP

RULES

STORAGE

TRIP SCANS

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



OBSL PRODUCT DEVELOPMENT

OBS Log Number: 369369

Summary of Call Append date to Import fail/results files
Detail of Fix If file name length permits, append user and date/time to FAIL & RES files
Set-up and Configuration No set-up/configuration required


OBS Log Number: 367395

Summary of Call Bring Order creation & split in line
Detail of Fix Include references when copying and spliting orders
Set-up and Configuration No set-up/configuration required


OBS Log Number: 367264

Summary of Call Parameters for POD Delivery Extract
Detail of Fix The POD Delivery Extract will have parameters for:

From Schedule

To Schedule

POD Status

Del Msg Sent

Carrier

Customer

Group (Schedule not Customer)

Scanning Depot

> Days Outstanding

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.80 Accounts package 369254
AT_ACC_INVOICE_367512.sql 1.1 AT Script 367512
AT_GEO_LOCATION_365641.sql 1.1 AT Script 365641
AT_GEO_LOCATION_ZONE_361806.sql 1.1 AT Script 361806
BDM.fmx 2.100 Business Data Form 361806
CSV.sql 5.118 CSV extract package 365630
CSV.sql 5.119 CSV extract package 368473
CT_TMP_MATCH_REPLACE_361892.sql 1.2 CT Script 361892
DATA_1_ORS_SQL_367012.sql 1.1 Data Script 367012
DATA_10_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_11_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_12_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_13_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_14_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_15_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_16_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_2_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_3_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_4_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_5_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_6_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_7_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_8_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_9_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_99_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_ADM_SYSTEM_PARAM_365701.sql 1.1 Data Script 365701
DATA_ADM_SYSTEM_PARAM_366726.sql 1.1 Data Script 366726
DATA_ADM_SYSTEM_PARAM_367395.sql 1.2 Data Script 367395
DATA_ADM_SYSTEM_PARAM_368474.sql 1.1 Data Script 368474
DATA_ADM_SYSTEM_PARAM_368669.sql 1.1 Data Script 368669
DATA_ADM_SYSTEM_PARAM_368955.sql 1.1 Data Script 368955
DATA_ADM_SYSTEM_PARAM_369066.sql 1.1 Data Script 369066
DATA_ADM_SYSTEM_PARAM_369093.sql 1.1 Data Script 369093
DATA_ADM_SYSTEM_PARAM_CONFIG_368669.sql 1.1 Data Script 368669
DATA_I_1_ADM_SYSTEM_PARAM_356056.sql 1.1 Data Script 356056
DATA_I_2_ADM_SYSTEM_PARAM_CONFIG_356056.sql 1.1 Data Script 356056
DATA_I_3_MSG_RECIPIENT_TYPE_356056.sql 1.1 Data Script 356056
DATA_I_4_MSG_REQ_356056.sql 1.1 Data Script 356056
DATA_I_5_REP_REPORT_356056.sql 1.1 Data Script 356056
DATA_I_6_REP_REPORT_PARAM_356056.sql 1.1 Data Script 356056
DATA_IMP_FIELD_357997.sql 1.1 Data Script 357997
DATA_IMP_FIELD_361806.sql 1.1 Data Script 361806
DATA_ORS_MASTER_DATA_368228.sql 1.2 Data Script 368228
DATA_REP_REPORT_362756.sql 1.1 Data Script 362756
DATA_REP_REPORT_365935.sql 1.1 Data Script 365935
DATA_REP_REPORT_367264.sql 1.1 Data Script 367264
DATA_REP_REPORT_368441.sql 1.1 Data Script 368441
DATA_REP_REPORT_PARAM_362756.sql 1.1 Data Script 362756
DATA_REP_REPORT_PARAM_365935.sql 1.1 Data Script 365935
DATA_REP_REPORT_PARAM_367264.sql 1.1 Data Script 367264
DATA_REP_REPORT_PARAM_368441.sql 1.2 Data Script 368441
DATA_RES_LABEL_FORMATS_364692.sql 1.3 Data Script 364692
DP_CSV_DUN.sql 5.51 Client specific CSV extracts 365686
DP_CSV_DUN.sql 5.52 Client specific CSV extracts 367200
DP_CSV_DUN.sql 5.53 Client specific CSV extracts 368963
DP_CSV_NR.sql 5.56 NR CSV reports 368392
DP_CSV2.sql 5.77 Second CSV extract package 368441
DP_CSV2.sql 5.78 Second CSV extract package 370161
DP_CSV3.sql 5.35 Third CSV extract package 362756
DP_CSV5.sql 1.76 Fifth CSV extract package 367400
DP_CSV6.sql 1.40 CSV Extract package 366435
DP_EPOD_WEB_SERVICE.sql 1.125 EPOD Web Service 367440
DP_IMP_2.sql 1.77 Import Package 361806
DP_INVOICE_XML.sql 1.12 Invoice XML Package 362735
DP_LOGIX_CONFIG.sql 1.16 PTV Interface 361806
DP_LOGIX_DOM.sql 1.13 Logix Procedures 361806
DP_MCS_SCANNING.sql 5.49 MCS Scanning Package 365641
DP_MCS_SCANNING.sql 5.50 MCS Scanning Package 365830
DP_MCS_SCANNING.sql 5.52 MCS Scanning Package 366165
DP_MCS_SCANNING.sql 5.53 MCS Scanning Package 366346
DP_MCS_SCANNING.sql 5.54 MCS Scanning Package 366342
DP_MCS_SCANNING.sql 5.55 MCS Scanning Package 366711
DP_MCS_SCANNING.sql 5.56 MCS Scanning Package 366726
DP_MCS_SCANNING.sql 5.57 MCS Scanning Package 367068
DP_MCS_SCANNING.sql 5.58 MCS Scanning Package 367006
DP_MCS_SCANNING.sql 5.59 MCS Scanning Package 369066
DP_MCS_SCANNING.sql 5.60 MCS Scanning Package 369093
DP_PORTAL.sql 5.18 Portal Package 366424
DP_RDT_FAST_UNLOAD.sql 5.45 RF Unload Package 365686
DP_RDT_PREADVICE.sql 5.8 RDT Pre-advice Package 368474
DP_SCHEDULING_ENGINE.sql 5.157 Scheduling Package 361806
DP_SCHEDULING_ENGINE.sql 5.158 Scheduling Package 367610
DP_SCHEDULING_ENGINE.sql 5.159 Scheduling Package 368907
DP_SHIPMENT.sql 5.25 Shipment Code package 357997
DP_SHIPMENT.sql 5.27 Shipment Code package 361892
DP_SHIPMENT.sql 5.28 Shipment Code package 367512
DP_SHIPMENT.sql 5.29 Shipment Code package 369254
DP_WEB_SERVICE_ORD.sql 1.26 Web Service Package 365630
GEO.sql 5.36 Location Processing 368955
HCR_VAN_DELIVERY_NOTE.rep 1.1 HCR Delivery Note 365935
IMP.sql 5.195 CSV Imports Package 357997
IMP.sql 5.196 CSV Imports Package 367512
IMP.sql 5.197 CSV Imports Package 369369
IMP.sql 5.198 CSV Imports Package 368955
INT_XML_IN.sql 5.194 Order Import Package 357997
INT_XML_IN.sql 5.195 Order Import Package 361892
INT_XML_IN.sql 5.196 Order Import Package 367549
INT_XML_IN.sql 5.197 Order Import Package 368178
INT_XML_IN.sql 5.198 Order Import Package 369128
INT_XML_MIC.sql 5.147 MIC interface 369623
INT_XML_OUT2.sql 5.300 Outbound XML Package 368669
INT_XML_OUT2.sql 5.301 Outbound XML Package 369154
INV.sql 5.47 Invoice Package 367512
INV.sql 5.49 Invoice Package 368441
INVOICES.fmx 2.62 Invoices Screen 367512
LOAD_MAN.fmx 1.27 Load Management Form 368117
LOCATION.fmx 2.192 Location Maintenance 365641
MSG_MAINT.fmx 2.32 Message Maintenance screen 356056
MSG_PROCESSING.sql 5.70 Message Processing package 356056
NR_SUPP_MANF.rep 1.1 NR Supplier Manifest Report 356056
OF_INT.sql 5.59 Oracle Financials interface 357997
OF_INT.sql 5.60 Oracle Financials interface 367512
OF_INT.sql 5.61 Oracle Financials interface 369254
OMS.sql 5.228 Order package 365637
OMS.sql 5.229 Order package 361965
OMS.sql 5.230 Order package 361892
OMS.sql 5.231 Order package 361806
OMS.sql 5.232 Order package 367395
ORDERS.fmx 2.427 Order Screen 361965
ORDERS.fmx 2.429 Order Screen 365701
ORDERS_WIDE.fmx 1.26 Orders Screen 361965
ORDERS_WIDE.fmx 1.28 Orders Screen 365701
PAR.sql 5.107 Paragon Interface 366646
PAYMENTS.fmx 2.50 Payments Screen 367512
PLANNING.fmx 1.109 Planning Screen 357997
PLANNING.fmx 1.110 Planning Screen 365701
PLANNING.fmx 1.111 Planning Screen 367512
PRODUCT.fmx 2.54 Product form to maintain Volumetric data 366709
RATE.sql 5.157 Rates Tariff database package 367512
RATE.sql 5.158 Rates Tariff database package 369254
SHIPMENT_PALLETS.fmx 5.6 Shipment Pallets Form 366131
T_SCH_ORD_AUDIT.sql 5.17 Trigger for SCH_ORD_AUDIT 366240
T_SCH_ORDER_LINE_AUDIT.sql 1.4 Trigger 368406
TRG_SCH_ORD_ITEMS_ACTUALS.sql 1.6 Database Trigger Script 367068
TRG_SCH_ORD_ITEMS_ACTUALS.sql 1.7 Database Trigger Script 369066
TRIP_SHEET_DUNELM_DETAIL.rep 5.26 Driver Trip Sheet 369353
TRIPDTL.fmx 2.226 Trip Debrief 367512
TRM.sql 5.196 Trip manipulation package 361892
TRM.sql 5.197 Trip manipulation package 367610
V_MCS_SITE.sql 1.4 View 362654
WCS_MAINT.fmx 1.11 WCS Maintenance 368117


ADDITIONAL CHANGES

WCS

There are no WCS changes required.


EPOD/T2A

There are no EPOD/T2A changes required.


MCS

An MCS change is required for the following logs:

  • 365830 - 2.00.03.004
  • 366726 - 2.00.03.007
  • 367068 - 2.00.03.008
  • 369066 - 2.00.03.010
  • 369093 - 2.00.03.012


PORTAL/TTM

There are no Portal changes required.


EDI

There are no EDI changes required.


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