Setup and Transactional Data

This section refers to list of setup and transactional entities that must be integrated with ERP or other 'host' systems in order to get data in and out of the WMS. Please refer to the Interface Specfications excel document for all the entity definitions and fields. The document is modeled towards the delimited file structure, however all the fields are the same as those used in the XML via Web Services. Refer to the XSD's for the XML schema definitions.

Note: To access the latest XSD's, go to the Oracle WMS Cloud Information Center From the top of the page, click on the Documentation tab at the top, then click the link under Current Documentation.

There are three different ways to upload these entities into WMS:

• Upload excel or flat file via the Input Interface Screen in the application.
  Note: To access the latest Interface Specifications, go to the Oracle WMS Cloud Information Center From the top of the page, click on the Documentation tab at the top, then click the link under Current Documentation.
• Oracle WMS Cloud provides excel templates and flat file format definitions.
• Use web services with XML payload to load the data.
• For XML, XSD schema definitions and sample XMLs are available
• Send flat files to the SFTP site (externally hosted site)

Touch point	Description
Items	Master item (SKU) definitions
Item barcode	Vendor barcodes
Item facility	Facility specific item properties
Item pre pack	Predefined kit definitions
Cubiscan	Item dimensional information
Vendors	Vendor definitions
Store	Destination stores for shipping
Location	Warehouse (DC) location defintions (bins)
Site	Facility stype of site. Used when shipping to a generic site or to model individual customers
Shipto Company	Destination companies
Asset	Assets such as high value pallets, totes used in a warehouse
Consolidation location map	Mapping stores and locations for store distribution configuration
LPN Location lock	Locate LPNs and lock. Used in initial data setup in combination with IB Shipment interface
Planned OB Load	Load planning for Orders from a TMS
Users	User definitions
Routes	Static routes definition
Price labels	Pricing information for Items
Purchase Orders	Purchase order transactional data
IB Shipments	Shipments of incoming inventory that may or may not be tied to PO's
IB Shipment serial nbr	Serial number information in IB Shipments
Appointments	Appointments for inbound loads
Orders	Sales orders (shipping requests)
Order instructions	Order picking/packing instructions
Work order	Work orders
Point of sale	Store POS update

Touch Point	Description
IB Shipment verification	Confirmation of received inventory
Inventory History	All WMS activities
Outbound Load shipment	Outbound shipment confirmation for LTL/TL
Parcel Manifest	Shipping confirmation for parcel
Inventory summary	Summary of all inventory
Wave Pick Info	Wave data to send to MHE or other systems