PATCH CTMS P036

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.