Retail Integration Mappings Report Release:15.0.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/WOInDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:WOInDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOInDesc in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
wo_id number10 1 1 The unique identifier for work in process associated with an order or transfer. n/a n/a number 10 No Used in interface only.
order_no varchar212 1 1 The order number associated with the work order. inbound_work_order po_nbr varchar2 12 Yes Populates the PO_NO in inbound_work_order Table
WOInDtl * 1 unbounded Child node - see below.

XML-Schema Name:WOInDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOInDtl in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
wh number10 1 1 The warehouse where the work order will be done. n/a n/a varchar2 10 Yes Not used by RWMS.
item varchar225 1 1 The item on which the work order will be done. inbound_work_order item_id varchar2 25 Yes Populates item_id in inbound_work_order table
loc_type varchar21 1 1 The location type of the final destination location. Valid values are:'S' - Store or 'W' - Warehouse n/a n/a * * No Not used by RWMS.
location number10 1 1 The final destination of the merchandise. If the item is predistributed this location will be the store/warehouse on the allocation. If not, it will be the same warehouse as in the wh column. inbound_work_order dest_id number 10 Yes A number which uniquely identifies a destination to which the DC delivers goods. Populates dest_id in inbound_work_order table.
seq_no number4 1 1 The sequence number (needed to ensure each record is unique, since the same wip code can be listed more than once on the same work order). inbound_work_order wip_seq_no number 4 Yes Order in which WIP Codes are processed. Populates wip_seq_no in inbound_work_order table
wip_code varchar29 1 1 The wip code for the work to be done on the item. inbound_work_order wip_code varchar2 9 Yes Work in process code setup in wip_code table. Populates wip_code in inbound_work_order table.
instructions varchar2300 0 1 Not used by RMS. inbound_work_order instructions varchar2 300 No A field to indicate specific instructions needed to be processed for the inbound work order.