PATCH WMS 810 P025

OBS Logistics Ltd

Release Notes

CALIDUS WMS

9th Jan 2018 - 1.0
Reference: P025

SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS WMS users with the level of detail required to accurately test all software included in the patch. The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.

GLOSSARY OF TERMS

Term	Meaning
C-TMS	Transport Management System
C-WMS	Warehouse Management System
CR	Change Request
C-WCS	Warehouse Control System
C-ePOD	Electronic Proof of Delivery
C-MCS	Mobile Control System
C-TTM	Track and Trace Management
EDI	Electronic Data Interchange
TID	Testing Issue Development, or Log

TESTING PROCESS

TIDs AND RESOLUTION

If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.

FINAL 'END TO END' TESTING

Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.

AUTHORISATION

Authorisation from nominated release personnel only will be required when requesting a release to a production environment

CHANGE REQUESTS

Customer Ref: 345469

OBS Log Number:	345469
Reporter:	Howard Allen
Summary of Call	New inbound order EDI based on JLO
Detail of Fix	Generate new LBL format EDI sales order upload Amend both WES format pick list and despatch note - controlled by a new owner rule FOLM (Format Order Line Comment) If set, the 'Order Line Comment' field has 'pack' and 'kit' headers added to the data. 'Order Line Comment' field is also not printed on despatch note.
Set-up and Configuration

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner/FOLC	Y	Add Order Line comment 'labels' to pick list and suppress data from despatch note
Format Order Line Comment	Not set or any other value	No Change

Customer Ref: Despatch Note Changes

OBS Log Number:	345951
Reporter:	Sue Blake
Summary of Call	Despatch Note Changes
Detail of Fix	Create a new layout for customer despatch note.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Returns Processing

OBS Log Number:	346569
Reporter:	Pamela Hodgkinson
Summary of Call	Returns Processing
Detail of Fix	Retain supplier code of stock rather than using supplier code of ASN - this is controlled by activating OWNER level rule USSC.
Set-up and Configuration

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner Level Rule USSC	Y	Ensure supplier of stock is used instead of the supplier code of ASN

Customer Ref: 346832

OBS Log Number:	346832
Reporter:	Michael Huxley
Summary of Call	Default stock supplier in add pallets
Detail of Fix	Rule code APSR extended to have a value of .D. which will default in the normal supplier of the stock when creating new pallets.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Depatch note change

OBS Log Number:	347470
Reporter:	Colin Cook
Summary of Call	Despatch Note Change
Detail of Fix	The 'Customer Pallet ID' column has been replaced by a 'Rotation / Batch' column to display the customer rotation number instead. The despatch details will be displayed sequentially within the sales order by ascending order of customer rotation number and then customer pallet ID. The data will be displayed at the lowest level as before so that each despatch detail is displayed if the customer rotation number has been obtained for multiple rotation numbers, pallet IDs, customer pallet IDs or from multiple warehouse locations.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Pallet temp recording

OBS Log Number:	347903
Reporter:	Matthew Tipping
Summary of Call	Add pallet temp recording at receipt
Detail of Fix	Trailer and pallet temperature recording using WCS
Set-up and Configuration	No set-up/configuration required

Customer Ref: 348071

OBS Log Number:	348071
Reporter:	Howard Allen
Summary of Call	Change to order import EDI's
Detail of Fix	Removed address concatenation from sales order edi flows for edi formats JLO, SHP, GBB
Set-up and Configuration	No set-up/configuration required

Customer Ref: PO No: 106297

OBS Log Number:	346463
Reporter:	Tony Higgins
Summary of Call	Returns Process (Consolidation/HOF)
Detail of Fix	New Consolidated Return process. User will create a new returns record, which will send putaway message to RF. Depending on rule controls, no pallet records will be created if the stock is not marked as to be 'returned to stock'.
Set-up and Configuration

New Screens
Suggested Menu Path	Screen ID	Screen Description
/Warehouse/Goods Receipt	WHS0175.fmx	Consolidated Returns Screen

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner 'ASUR' / 'Allow single unit returns'	Y	All returns have a quantity of 1, which is not amendable
Owner 'ASUR' / 'Allow single unit returns'	Not set, or any other version	User is able to enter in a valid return quantity ie 2,3 etc.
Owner 'DWRS' / 'Don't write plt recs for damaged returned stock'	Y	Don't write pallet records for stock which is not marked as 'returned to stock'
Owner 'DWRS' / 'Don't write plt recs for damaged returned stock'	Not set, or any other version	Write pallet records / generate RDT putaway messages for stock which is not marked as 'returned to stock'

Customer Ref: PO 44010492966

OBS Log Number:	346572
Reporter:	Mark Hext
Summary of Call	Despatch manifest for digital prisons
Detail of Fix	A new checkbox labelled 'Output for Digital Prison?' has been added to the Despatch Manifest screen (WHS1901). When checked the 'Print XLS' option will include the 'Discount' and 'Order Total' columns.
Set-up and Configuration	No set-up/configuration required

Customer Ref: 346839

OBS Log Number:	346839
Reporter:	Charles Codrington
Summary of Call	CR: DOM Format CSV Update
Detail of Fix	Amendment to DOM format EDI flow: Do not concatenate address lines. Remove single quote mark from phone and mobile phone nos.
Set-up and Configuration	No set-up/configuration required

Customer Ref: PO 106282

OBS Log Number:	348046
Reporter:	Sue Blake
Summary of Call	First release for log 344287
Detail of Fix	Initial release for log 344287 - more to follow. Please note that an additional change has been made to remove code that set a negative available total to zero if the CASB rule is "Y" or the 'Stock Snapshot Include in Free Qty' flag is set to "Y". In order to zero a negative available total the 'ANAT' owner rule should be set to "N" or should not be set up. For the DDU format stock snapshot to work the 'ANAT' owner rule MUST be set to "Y" to enable the GRN Free Quantities to be calculated correctly, however, the DDU format will then zero any negative quantities.
Set-up and Configuration

Registry/Rules Settings
Path & Name	Setting Value	Result
ANAT Owner Rule	Y	Allows negative available totals on stock snapshot. This is required to allow quantities to be calculated correctly when adding on pre-advised quantities in the DDU format snapshot. Any negative quantities will be reported as 0 after the calculations have been performed.
CASB Owner Rule	Y	Subtracts committed quantities from available total.
DNCC Owner Rule	Y	Reports three character currency code as a suffix on the GEN format despatch note instead of having the currency symbol as a prefix.
SSMG Owner Rule	000-999	Optional. If set up this should be set to a three digit number (including leading zeroes, e.g. 005 not 5). This will then be the maximum number of GRNs to be included in the DDU format stock snapshot. If the rule is not set or is not set to a valid value this defaults to 10.

Customer Ref: Po No 106300

OBS Log Number:	348111
Reporter:	Pam Hogkinson
Summary of Call	Customer Despatch Note
Detail of Fix	New GE2 despatch note format. Channel data maintained in 'Channel' tab in 'Owner Maintenance' screen. Return reason codes maintained in 'Channel Return Reason Codes Maintenance'.
Set-up and Configuration

Registry/Rules Settings
Path & Name	Setting Value	Result
MCOC Owner Rule	Y	Display the 'Channel' tab in the 'Owner Maintenance' screen. (Re-execute the query after entering for owner to display)

Customer Ref: PO No: 106297

OBS Log Number:	348151
Reporter:	Unknown
Summary of Call	Return Reason Codes Maintenance
Detail of Fix	WHS0086 is a new screen that will need to be added to the menu structure. This allows return reason codes to be entered against an order channel. This is required for log 346463.
Set-up and Configuration

New Screens
Suggested Menu Path	Screen ID	Screen Description
Warehouse Maintenance	WHS0086	Channel return reason codes maintenance

SUPPORT INCIDENTS

Customer Ref: Autoputaway issue

OBS Log Number:	344186
Reporter:	Phil Harding
Summary of Call	Autoputaway - manual vrs RF location
Detail of Fix	Add concept of quantity by location. Rather than defining a location as being full by the number of pallets, a location can be defined as being full by the number of units found.
Set-up and Configuration	No set-up/configuration required

Customer Ref: WMS Movements

OBS Log Number:	345510
Reporter:	Phil Harding
Summary of Call	WMS Movements - deleting records
Detail of Fix	A pallet move can only be performed if the pallet is a whole pallet of single stock (i.e. same product, rotation, customer rotation, customer pallet). Otherwise, a stock move will be required to move the different parts of the pallet.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Display time

OBS Log Number:	346253
Reporter:	Phil Harding
Summary of Call	Display time in 24hrs in email
Detail of Fix	Change time fields to report time in 24hr format ie 20:00 rather than 08:00.
Set-up and Configuration	No set-up/configuration required

Customer Ref: 001

OBS Log Number:	346658
Reporter:	DANIEL BROMLEY
Summary of Call	Stock movement issue MISSING location
Detail of Fix	Amendment to stock moves to prevent divide by 0 error when confirming the movement.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Despatch Note Print Error

OBS Log Number:	347072
Reporter:	Daniel Brown
Summary of Call	Despatch Note Print Error
Detail of Fix	Improve performance of load number validation.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Allocation change

OBS Log Number:	347073
Reporter:	Steve Carpenter
Summary of Call	Fixed to Line type 8 Allocation change
Detail of Fix	If multiple rotations exist in bulk and pick, and less that a pallets quantity is ordered, ensure that if possible, the stock is taken purely from pick, even if it is not the lowest rotation.
Set-up and Configuration	No set-up/configuration required

Customer Ref: WHR1720_WES

OBS Log Number:	347469
Reporter:	Peter Blackburn
Summary of Call	Log to release WHR1720_WES
Detail of Fix	Amendment to WHR1720_WES to remove debug message retained in the program unit.
Set-up and Configuration	No set-up/configuration required

Customer Ref: INC20482095

OBS Log Number:	347500
Reporter:	Lukasz Grzybkowski
Summary of Call	Issue with email notifications
Detail of Fix	Amendment to Sales order import for single file processing for assigning control number and preventing multiple e-mail notfications on the same file.
Set-up and Configuration	No set-up/configuration required

Customer Ref: KLE/907

OBS Log Number:	347539
Reporter:	Ryan Hinds
Summary of Call	Goods Receipt EDI output
Detail of Fix	Ensure EDI (GRMK) is triggered in line with other screens / processes
Set-up and Configuration	No set-up/configuration required

Customer Ref: 347546

OBS Log Number:	347546
Reporter:	Barry Preece
Summary of Call	Ensure held stock records are correct
Detail of Fix	Ensure the rotation / customer rotation are updated fully when a changed pallet is on hold.
Set-up and Configuration	No set-up/configuration required

Customer Ref: INC20645616

OBS Log Number:	347804
Reporter:	Stevie Jones
Summary of Call	Error message when using the XFMonitor
Detail of Fix	Correct navigation errors when using the forward/backward buttons to scroll through all EDI flows.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Warehouse rule

OBS Log Number:	348014
Reporter:	Carl Styles
Summary of Call	Release of warehouse rule
Detail of Fix	Release of warehouse rule data script.
Set-up and Configuration	No set-up/configuration required

Customer Ref: EDI upload file update

OBS Log Number:	348232
Reporter:	Colin Cook/P Clucas
Summary of Call	Customer/Supplier EDI Upload File Errors
Detail of Fix	The inbound EDI files for customers and suppliers will create and update the addresses as advised. The delivery and invoice addresses for the customers and the buyer addresses for the suppliers will be maintained with the partners.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Generic despatch note

OBS Log Number:	348278
Reporter:	Emilia Borecka
Summary of Call	Generic despatch note w/prepaid return
Detail of Fix	Release of generic despatch note with pre-paid return. Note this release does not integrate to RM. Format code is 'GE1' when setting up.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Owner warehouse parameters

OBS Log Number:	348306
Reporter:	Mike Huxley
Summary of Call	Owner warehouse parameters error
Detail of Fix	Only prompt for / validate SSCC information if the owner has been configured to use SSCC numbers.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Bay diary - issues

OBS Log Number:	346694
Reporter:	Phil Harding
Summary of Call	Bay diary - UI issues
Detail of Fix	Amendment to bay diary move function to update delivery receipt date.
Set-up and Configuration	No set-up/configuration required

Customer Ref: FTP EDI issue

OBS Log Number:	347260
Reporter:	Phil Harding
Summary of Call	FTP EDI issue
Detail of Fix	Windows carriage returns had infiltrated the Unix shell scripts, these have now been removed. Please note that this log needs to be released along with log 346701 which includes a similar fix for xfFtpAudit.ksh.
Set-up and Configuration	No set-up/configuration required

Customer Ref: ORS0100 Update

OBS Log Number:	347378
Reporter:	Phil Harding
Summary of Call	ORS0100 Update - sysdate management
Detail of Fix	Allow minus values in date to field
Set-up and Configuration	No set-up/configuration required

Customer Ref: 550

OBS Log Number:	346314
Reporter:	James Lees
Summary of Call	Sales order EDI file rejected but no EDI
Detail of Fix	SOP critical error emails not being processed
Set-up and Configuration	No set-up/configuration required

Customer Ref: 8RLIT28

OBS Log Number:	347242
Reporter:	Dave Bessell
Summary of Call	Multiple Prompts
Detail of Fix	Now only shows default pallet quantity calculated value once when tab through on entry.
Set-up and Configuration	No set-up/configuration required

Customer Ref: Allocation changes

OBS Log Number:	347475
Reporter:	Emily Collins
Summary of Call	Allocation changes.
Detail of Fix	If Alloc_Rule_1 is set to either '0' (Bulk Until OT Then Pick) or '2' (Bulk Locations First), check if ordered quantity is greater than the standard pallet quantity before deciding to look in either bulk or pick locations. When ordering Line Type 8 order lines, when checking quantities in pick, use the free quantity rather than on hand quantity when selecting rotations.
Set-up and Configuration	No set-up/configuration required

Customer Ref: 347990

OBS Log Number:	347990
Reporter:	COLIN CROOK
Summary of Call	ERROR MESSAGES SEEN WHEN MARKING ORDERS
Detail of Fix	Ensure if pick-wave contains orders from multiple owners, it is able to confirm orders correctly.
Set-up and Configuration	No set-up/configuration required

Customer Ref: 348244

OBS Log Number:	348244
Reporter:	Michael Huxley
Summary of Call	Error when opening Owner System
Detail of Fix	Add new location code / product type index to both Ware Location Entries and Ware Goods Entry Pallets tables to improve performance.
Set-up and Configuration	No set-up/configuration required

Customer Ref: New Returns Screen

OBS Log Number:	348292
Reporter:	Michael Huxley
Summary of Call	New Returns Screen - Error FRM-40405
Detail of Fix	Change screen to allow users to clear old record from screen with the press of a button. Apply missing database change from log 346463
Set-up and Configuration	No set-up/configuration required

Customer Ref: No Reference

OBS Log Number:	348254
Reporter:	Michael Huxley
Summary of Call	Error after entering kit order FWL02158
Detail of Fix	Log to release modules called from LOV in Kit assembly request SOS1427 for stock locator (advanced search and components).
Set-up and Configuration	No set-up/configuration required

TID CHANGES

OBS Log Number: 347513

Customer Ref:	345951
Reporter:	Michael Huxley
Summary of Call	Customer Despatch Note Changes
Detail of Fix	The printed text has been moved down about 2mm as requested to match the pre-printed stationery being used in the printer on site.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 348311

Customer Ref:	hof ret1
Reporter:	Mike
Summary of Call	Error - Receiving Returns Item - WHS0175
Detail of Fix	Ensure audit trail is created from consolidated returns
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 348345

Customer Ref:	No ref
Reporter:	Emily Collins
Summary of Call	Put return reason code in GRMK message
Detail of Fix	Correct Ret Reason Code of WGED in D001 segment of GRMK message.
Set-up and Configuration	No set-up/configuration required

OBSL PRODUCT DEVELOPMENT

OBS Log Number: 346701

Reporter:	Peter Hill
Summary of Call	FTP audit issue
Detail of Fix	FTP audit is now configurable
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346773

Reporter:	Tony Walker
Summary of Call	TID: LOAD message
Detail of Fix	A user context has been applied to the TMS-WMS interface package for the new databases.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346774

Reporter:	Tony Walker
Summary of Call	TID: LOAD message on Trip Deletion
Detail of Fix	The TMS-WMS interface has been changed to delete rather than cancel a route/load that is now empty of orders when the corresponding trip is deleted.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346793

Reporter:	Tony Walker
Summary of Call	TID: Carrier Code
Detail of Fix	The carrier code of the sales order can be used to set a mandated carrier for the transport order. An interface parameter called INC_MANDATED_CARRIER will be used to set the carrier: when Y the functionality will be active. The carrier code will be translated using a new import decode with the name WMS_CARRIER_MAPPING of type CARRIER: the source value will store the carrier code from WMS and the target value will store the carrier code in TMS. The mandated carrier code must be valid for the order to be created or amended when the mandated carrier is enabled and one exists for the sales order to use. If the carrier code of the sales order is changed, the transport order will be updated to match. This log will store the changes to WMS and the changes to TMS will be released under 346789. The carrier code of the route/load will likewise be translated in reverse for the carrier of the trip using WMS_CARRIER_MAPPING. This will apply to the LOAD and DESP messages for when a route/load is created or updated for a LOAD message, or despatched for a DESP message. The route code of the load in WMS will be based on the carrier route code in preference to the other available route codes for PAR trips. For LOG trips, the trip route code will be used. For trips that are not LOG or PAR, the trip route code will be used in preference to the carrier route code and customer route codes.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 340680

Reporter:	Matthew Tipping
Summary of Call	Complete SSCC Solution
Detail of Fix	SSCC Solution
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346677

Reporter:	Matthew Tipping
Summary of Call	Add Purchase order functionality to WMS
Detail of Fix	Add the purchase order functionality to the Oracle WMS system
Set-up and Configuration

New Screens
Suggested Menu Path	Screen ID	Screen Description
WHS3503	Delivered Purchase Order Flag	POP/PO Reports

OBS Log Number: 346295

Reporter:	JS
Summary of Call	ASN - Edifact Generation
Detail of Fix	ASN Edifact Generation
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346510

Reporter:	Phil Harding
Summary of Call	WHS0091 Update - add to XFM0020
Detail of Fix	Integrated Free location generation with standard edi screens
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 344506

Reporter:	Phil Harding
Summary of Call	PFS1541 Update
Detail of Fix	Control Number label change.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 344508

Reporter:	Phil Harding
Summary of Call	STS3000 Update
Detail of Fix	Allow query without a stock code being provided.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 344829

Reporter:	Leon Winchester
Summary of Call	WHS0610 Update - select by location
Detail of Fix	Add aisle and location range selection.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 345283

Reporter:	Peter Hill
Summary of Call	Tracking sequence mismatch
Detail of Fix	Fix for Edi Errors not being displayed
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 346296

Reporter:	Phil Harding
Summary of Call	STS3001 Update
Detail of Fix	Transaction Type added to selection parameters. Transaction type description added to fields available via 'Configure' button and added to detail screen (STS3001) accessed via 'All Detail' button.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 347105

Reporter:	Phil Harding
Summary of Call	STS3008 Update
Detail of Fix	Make form bigger so fields can be bigger. Add extra descriptions and spread out a little.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 347109

Reporter:	Phil Harding
Summary of Call	WHS0902 Update
Detail of Fix	Call pallet moves enquiry from stock loc enquiry. Also standardize size.
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 347160

Reporter:	Phil Harding
Summary of Call	ENQSOON10A update
Detail of Fix	Minor layout changes
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 347218

Reporter:	Phil Harding
Summary of Call	Stock Enq. UI update
Detail of Fix	Cosmetic screen changes
Set-up and Configuration	No set-up/configuration required

OBS Log Number: 348202

Reporter:	Pete Clucas
Summary of Call	Add 'R' to temp validation on prod load
Detail of Fix	In EDI import processing for stock data, add 'R'ecord as option for Y/N temperature controlled.
Set-up and Configuration	No set-up/configuration required

MODULES DELIVERED

Module Name	Version No	Description	Log Number
AT_CUSTOMERS_340680.sql	4.1	Alter Table Script	346569
AT_CUSTOMERS_346295.sql	4.1	Alter Table Script	346295
AT_EDI_SALES_ORDER_DETAIL_344287.sql	4.1	Alter Table Script	348046
AT_EDI_SALES_ORDER_MASTER_344287.sql	4.1	Alter Table Script	348046
AT_LOC_PALLET_TYPES_344186.sql	4.1	Alter Table Script	344186
AT_ORDER_DETAIL_344287.sql	4.1	Alter Table Script	348046
AT_ORDER_HEADER_344287.sql	4.1	Alter Table Script	348046
AT_OWNER_WARE_PARAMS_340680.sql	4.1	Alter Table Script	340680
AT_PICKING_CONTAINERS_346295.sql	4.1	Alter Table Script	346295
AT_STK_STOCKIST_340680.sql	4.1	Alter Table Script	346569
AT_STK_STOCKIST_344287.sql	4.1	Alter Table Script	348046
AT_STK_STOCKIST_346295.sql	4.1	Alter Table Script	346295
AT_WARE_GOODS_ENTRY_DETAILS_346463.sql	4.1	Alter Table Script	346463
AT_WARE_GOODS_ENTRY_DETAILS_346569.sql	1.1	Alter Table Script	346569
AT_WARE_GOODS_ENTRY_DETAILS_348292.sql	4.1	Alter Table Script	348292
AT_WARE_GOODS_ENTRY_HEADERS_346463.sql	4.1	Alter Table Script	347903
AT_WARE_GOODS_ENTRY_PALLETS_346463.sql	4.100	Alter Table Script	346463
AT_WARE_GOODS_ENTRY_PALLETS_348244.sql	4.1	Alter Table Script	348244
AT_WARE_LOCATION_ENTRIES_340680.sql	4.1	Alter Table Script	346569
AT_WARE_LOCATION_ENTRIES_348244.sql	4.1	Alter Table Script	348244
AT_WARE_MOVE_DETAILS_340680.sql	4.1	Alter Table Script	340680
AT_WAREHOUSES_348379.sql	1.1	Alter Table Script	348379
AT_XF_PROCESS_REPORTS_346701.sql	4.1	Alter Table Script	346701
CASP0104.fmx	4.2	PL Enquiry Supplier Details	346677
CT_CHANNEL_RETURN_REASONS_348151.sql	4.1	Create Table Script	348151
CT_MULTI_CHANNEL_INFO_348111.sql	4.1	Create Table Script	348111
CT_ORDER_CHANNELS_348151.sql	4.1	Create Table Script	348151
CT_USER_CONTEXT_346773.sql	1.1	Create Table Script	346773
DATA_DYNAMIC_MESSAGES_340680.sql	4.1	Data Script	340680
DATA_DYNAMIC_MESSAGES_344186.sql	4.1	Data Script	344186
DATA_DYNAMIC_MESSAGES_344287.sql	4.1	Data Script	348046
DATA_DYNAMIC_MESSAGES_345510.sql	4.1	Data Script	345510
DATA_DYNAMIC_MESSAGES_346463.sql	4.1	Data Script	346463
DATA_DYNAMIC_MESSAGES_348111.sql	4.1	Data Script	348111
DATA_DYNAMIC_MESSAGES_348151.sql	4.1	Data Script	348151
DATA_DYNAMIC_MESSAGES_348202.sql	4.1	Data Script	348202
DATA_EDI_MAPS_344287.sql	4.1	Data Script	348046
DATA_EDI_MAPS_345469.sql	4.1	Data Script	345469
DATA_FILE_TEMPLATE_344287.sql	4.1	Data Script	348046
DATA_FILE_TEMPLATE_VALUES_344287.sql	4.1	Data Script	348046
DATA_ML_CAPTIONS_340680.sql	4.1	Data Script	340680
DATA_ML_CAPTIONS_345951.sql	4.1	Data Script	345951
DATA_ML_CAPTIONS_348111.sql	4.1	Data Script	348111
DATA_ML_CAPTIONS_348278.sql	1.1	Data Script	348278
DATA_WAREHOUSE_RULES_CONTROL_344287.sql	4.1	Data Script	348046
DATA_WAREHOUSE_RULES_CONTROL_345469.sql	4.1	Data Script	345469
DATA_WAREHOUSE_RULES_CONTROL_346463.sql	4.1	Data Script	346463
DATA_WAREHOUSE_RULES_CONTROL_346569.sql	1.1	Data Script	346569
DATA_WAREHOUSE_RULES_CONTROL_346569.sql	1.2	Data Script	348014
DATA_WAREHOUSE_RULES_CONTROL_348111.sql	4.1	Data Script	348111
DATA_WAREHOUSES_348379.sql	1.1	Data Script	348379
DATA_XF_COMMAND_346510.sql	4.2	Data Script	346510
DP_ASN.sql	4.1	ASN Message Generation	340680
DP_ASN.sql	4.2	ASN Message Generation	346295
DP_CONF_EDI_IN.sql	4.90	Dynamic Inbound EDI package	348232
DP_CONF_EDI_IN.sql	4.91	Dynamic Inbound EDI package	348202
DP_CTMS_INTERFACE_STUB.sql	4.3	CTMS Interface Package	346774
DP_CTMS_INTERFACE_STUB.sql	4.4	CTMS Interface Package	346773
DP_CTMS_INTERFACE_STUB.sql	4.7	CTMS Interface Package	346793
DP_DESPATCH.sql	4.76	Despatch Confirmation Package 1	346295
DP_DESPATCH.sql	4.77	Despatch Confirmation Package 1	347990
DP_EDI_OUTBOUND.sql	4.99	EDI Outbound Receipt Confirmation	348046
DP_EDIGEN_OUT_PDP_CONF.sql	4.87	Outbound EDI Generation	348046
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql	4.37	Receipt conf outbound file creation	346463
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql	4.38	Receipt conf outbound file creation	348345
DP_EDIGEN_OUT_ST_BAL.sql	4.76	STK balance flat file package	348046
DP_EDIGEN_PRE_ADVICE_LOAD.sql	4.38	WMS Pre Advice EDI load	348046
DP_EDIGEN_PRE_ADVICE_VAL.sql	4.60	EDI Pre-Advice Validation	346569
DP_EDIGEN_PRE_ADVICE_VAL.sql	4.62	EDI Pre-Advice Validation	348046
DP_EDIGEN_PROD_VAL.sql	4.44	Inbound EDI Stock Upload Validation	348202
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.198	Inbound EDI Sales Order Upload	346314
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.199	Inbound EDI Sales Order Upload	345469
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.200	Inbound EDI Sales Order Upload	346839
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.202	Inbound EDI Sales Order Upload	348046
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.203	Inbound EDI Sales Order Upload	347500
DP_EDIGEN_SALES_ORDER_LOAD.sql	4.204	Inbound EDI Sales Order Upload	348071
DP_EDIGEN_SALES_ORDER_LOAD_2.sql	4.2	Inbound EDI Sales Order Upload	348046
DP_EDIGEN_SALES_ORDER_VAL.sql	4.175	Order_Header update package	348046
DP_MSG_EMAIL.sql	4.14	Email creation package	346253
DP_NET_PORTAL.sql	4.16	Package for .net diary system	346694
DP_PICK_CONF_1.sql	4.54	Pick Confirmation Database Package 1	340680
DP_PICK_CONF_1.sql	4.55	Pick Confirmation Database Package 1	344186
DP_PICK_CONF_2.sql	4.20	Pick Confirmation Database Package 2	340680
DP_PICK_CONF_2.sql	4.21	Pick Confirmation Database Package 2	344186
DP_PROCESS_CONTROL_XFM.sql	4.33	Outbound process control	345283
DP_PROCESS_CONTROL_XFM.sql	4.34	Outbound process control	346701
DP_RDT.sql	4.38	RDT Messages	347903
DP_RDT_DESP_UPDATE.sql	4.8	RDT Despatch process	340680
DP_RDT_GRNCONF.sql	4.32	RDT Goods Receipt Confirmation	346569
DP_RDT_GRNCONF.sql	4.33	RDT Goods Receipt Confirmation	344186
DP_RDT_GRNCONF.sql	4.34	RDT Goods Receipt Confirmation	347539
DP_RDT_GRNCONF.sql	4.35	RDT Goods Receipt Confirmation	347903
DP_RDT_LOCENQ.sql	4.18	RDT Location Enquiry	340680
DP_RDT_PALLET_MOVE_REQ.sql	4.23	RDT Pallet Moves	340680
DP_RDT_PALLET_MOVE_REQ.sql	4.24	RDT Pallet Moves	346463
DP_RDT_PICK_CONF.sql	4.68	RDT Pick Confirmation	340680
DP_RDT_PICK_CONF.sql	4.69	RDT Pick Confirmation	344186
DP_RDT_PICK_CONF.sql	4.70	RDT Pick Confirmation	346295
DP_RDT_STKTAKE.sql	4.28	WCS Inbound Stock Take Process	340680
DP_SSCC.sql	4.3	SSCC Last Number	346569
DP_SSCC_LABELS.sql	4.4	SSCC Label Package	346569
DP_WARE_LOC.sql	4.29	Free Location Generation – database package	346510
DP_WARE_LOC.sql	4.30	Free Location Generation – database package	344186
DP_WARE_LOC.sql	4.31	Free Location Generation – database package	348379
DP_WARE_STOCK_TAKE_UPDATE.sql	4.17	Stock Take Database Package	344186
DP_WHR1901.sql	4.12	Despatch Manifest XLS Output Procedure	346572
DP_WHS0150.sql	4.44	Goods Receipt Confirmation	346569
DP_WHS0150.sql	4.45	Goods Receipt Confirmation	346463
DP_WHS0150.sql	4.46	Goods Receipt Confirmation	346677
DP_WHS0155.sql	4.5	Putaway Confirmation	346569
DP_WHS0175.sql	4.1	Consolidated Returns Screen	346463
DP_WHS2180.sql	4.13	Find Nearest Free Location	344186
DP_WHS2181.sql	4.8	Update Free Locations	344186
DP_WHS2182.sql	4.4	Downdate Free Locations	344186
DP_WHS2185.sql	4.22	Suggested Location database package	344186
DP_WHS3503.sql	4.1	Delivered Purchase Order Extract	346677
DP_WHS7872.sql	4.40	RDT Inbound Pallet Movements	340680
DP_WHS7872.sql	4.41	RDT Inbound Pallet Movements	344186
DP_WHS7872.sql	4.42	RDT Inbound Pallet Movements	347539
DP_WMS_ALLOC.sql	4.140	Allocation Procedure	340680
DP_WMS_ALLOC.sql	4.141	Allocation Procedure	347073
DP_WMS_ALLOC.sql	4.142	Allocation Procedure	347475
DP_WMS_IF.sql	4.22	Database package for warehousing	347903
ENQSKSK01A.fmx	4.14	Stock Enquiries	347218
ENQSKSK02A.fmx	4.9	Stock Enquiries	347218
ENQSKSK03A.fmx	4.10	Stock Enquiry Detail	347218
ENQSOON10A.fmx	4.12	Order Enquiry - Multiple warehouses/owners	347160
ENQSOOP01B.fmx	4.2	Purchase Order Enquiry - SO screen	346677
ORS0100.fmx	4.34	Updates to SQL Data	347378
PFS1520.fmx	4.14	Product Master Validation	348202
PFS1541.fmx	4.33	EDI Sales Order Validation	344506
PFS1541.fmx	4.34	EDI Sales Order Validation	348046
POPAUCM01A.fmx	4.2	POP Authorisation Code Maintenance	346677
POPCOMP01A.fmx	4.3	Line completion maintenance	346677
POPOENT01A.fmx	4.2	Purchase Order Print	346677
POPOENT01A.rdf	4.2	Purchase Order Print	346677
POPOPRT01A.fmx	4.2	Purchase Order Print	346677
POPOSPO01A.fmx	4.2	Outstanding Purchase Orders	346677
POPOSPO01B_1.rdf	4.2	Outstanding PO Print	346677
POPOSPO01B_2.rdf	4.2	Outstanding PO Print	346677
POPTRAN01A.fmx	4.2	Purchase Transactions Report	346677
POPTRAN01B_1.rdf	4.3	Purchase Transactions Report	346677
POPTRAN01B_2.rdf	4.2	Purchase Transactions Report	346677
POPUAUM01A.fmx	4.2	User Authorisation Maintenance	346677
POS4000.fmx	4.2	Purchase order enquiry	346677
POS4011.fmx	4.2	Purchase Order Enquiry	346677
POS4012.fmx	4.2	POP Tracking Screen	346677
POS4020.fmx	4.2	View Movement details	346677
POS4030.fmx	4.2	Purchase Order Enquiry by stock code	346677
POS4060.fmx	4.2	View Purchase Order Information	346677
POS4070.fmx	4.2	View Purchase Order Details	346677
POS4075.fmx	4.2	View PO text information	346677
POS4080.fmx	4.2	POP view addresses	346677
POS4090.fmx	4.2	Purchase Order Tracking - Expected Date Entry	346677
POS5000.fmx	4.6	Purchase Order Input - Header Screen	346677
POS5010.fmx	4.2	Purchase Order Input - Detail Screen	346677
POS5015.fmx	4.2	Purchase Order Input - Detail Screen for non-stock	346677
POS5020.fmx	4.2	Text detail for stock code	346677
POS5030.fmx	4.2	Purchase Order Nominal Breakdown	346677
POS5035.fmx	4.2	Purchase Order Delivery Details	346677
POS6020.fmx	4.2	Supplier Cost Maintenance	346677
POS6020H.fmx	4.2	Supplier Costs history	346677
POS6022.fmx	4.2	PO Stock Costs	346677
SOS1018.fmx	4.1	Stock Code locator	348254
SOS1019.fmx	4.1	Stock Code locator	348254
SOS1110.fmx	4.119	Sales Order Entry	346295
STKWHSE01A.fmx	4.18	Warehouse Control Maintenance	348379
STS1000.fmx	4.101	Owner Maintenance	340680
STS1000.fmx	4.102	Owner Maintenance	346295
STS1000.fmx	4.103	Owner Maintenance	348046
STS1000.fmx	4.104	Owner Maintenance	348111
STS3000.fmx	4.12	Stock Movement Enquiry	346296
STS3000.fmx	4.13	Stock Movement Enquiry	344508
STS3001.fmx	4.12	Stock Enquiry Sub Screen	346296
STS3007.fmx	4.10	Pallet Movement Enquiry	347109
STS3008.fmx	4.5	Pallet Movement Enquiry	347105
STS3008.fmx	4.6	Pallet Movement Enquiry	347109
TRG_ORDER_HEADER_AIR.sql	4.5	Order Header Trigger	346793
TRG_WGED_BIR.sql	4.2	WGED Trigger	346569
TRG_WGED_BUR.sql	4.2	WGED Trigger	346569
WHR1720_WES.rdf	4.5	Pick List	345469
WHR1720_WES.rdf	4.7	Pick List	347469
WHR1900_BRT.rdf	4.5	Despatch Note	347470
WHR1900_DBU.rdf	4.1	Despatch Note	345951
WHR1900_DBU.rdf	4.2	Despatch Note	347513
WHR1900_GE1.rdf	4.1	Generic despatch note with pre-paid returns	348278
WHR1900_GE2.rdf	4.1	GE2 format despatch note	348111
WHR1900_WES.rdf	4.19	Client specific despatch note	345469
WHS0012.fmx	4.12	Owner Warehouse Maintenance	340680
WHS0012.fmx	4.13	Owner Warehouse Maintenance	348306
WHS0070.fmx	4.8	Location Type Maintenance	344186
WHS0086.fmx	4.1	Channel return reason codes maintenance	348151
WHS0110.fmx	4.55	Goods Receipt Pre-Advice	347242
WHS0110.fmx	4.56	Goods Receipt Pre-Advice	346677
WHS0150.fmx	4.118	Goods Receipt Confirmation	340680
WHS0150.fmx	4.119	Goods Receipt Confirmation	344186
WHS0150.fmx	4.120	Goods Receipt Confirmation	347903
WHS0150.fmx	4.121	Goods Receipt Confirmation	346677
WHS0156.fmx	4.20	GRN Putaway Check Digits	344186
WHS0175.fmx	4.1	GRN Putaway by Area	346463
WHS0175.fmx	4.2	GRN Putaway by Area	348292
WHS0175.fmx	4.3	GRN Putaway by Area	348311
WHS0610.fmx	4.25	Bulk to Multi Pick Replenishment	344829
WHS0610.fmx	4.26	Bulk to Multi Pick Replenishment	340680
WHS0630.fmx	4.75	Stock Adjustments	340680
WHS0630.fmx	4.76	Stock Adjustments	344186
WHS0631.fmx	4.55	Stock Adjustments – add pallets	340680
WHS0631.fmx	4.57	Stock Adjustments – add pallets	346832
WHS0631.fmx	4.58	Stock Adjustments – add pallets	344186
WHS0633.fmx	4.4	GRN Reversals	340680
WHS0633.fmx	4.5	GRN Reversals	344186
WHS0670.fmx	4.29	Sell By Date	340680
WHS0670.fmx	4.30	Sell By Date	347546
WHS0700.fmx	4.43	Warehouse Movements	340680
WHS0700.fmx	4.44	Warehouse Movements	345510
WHS0700.fmx	4.45	Warehouse Movements	344186
WHS0700.fmx	4.46	Warehouse Movements	346658
WHS0900.fmx	4.13	Stock Location Enquiry	347218
WHS0902.fmx	4.16	Stock Location Enquiry	347218
WHS0902.fmx	4.17	Stock Location Enquiry	347109
WHS0915.fmx	4.31	Pallet Enquiry	340680
WHS1710A.fmx	4.68	Pick List Confirmation	340680
WHS1900.fmx	4.41	Despatch Print Kick-Off	347072
WHS1901.fmx	4.20	Despatch Note Reprint Kick-off	346572
WHS1910.fmx	4.69	Despatch Confirmation	340680
WHS2053.fmx	4.6	Change Ownership of Stock	340680
WHS2300.fmx	4.2	FGI Certificates Kick-Off Screen	340680
WHS3503.fmx	4.1	Delivered Purchase Order Extract	346677
WHSORA035.fmx	4.42	Customer Wizard	340680
WHSORA035.fmx	4.43	Customer Wizard	346295
xfFtpAudit.ksh	4.5	XF monitor FTP Shell	346701
xfFtpFileRecv.ksh	4.10	XF monitor FTP Receive Shell	347260
xfFtpFileSend.ksh	4.11	XF Monitor FTP Send Shell	347260
XFM0020.fmx	4.59	XF Monitor	346701
XFM0020.fmx	4.60	XF Monitor	347804

ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

• 340680
• 347903

EPOD/T2A

There are no ePOD/T2A changes required.

MCS

There are no MCS changes required.

PORTAL/TTM

There are no Portal changes required.

EDI

There are no EDI changes required.

MANUAL

A Manual change is required for the following logs:

• 346774
• 346773
• 346793