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/WOInRef/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:WOInRef 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 WOInRef 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 Description is not available. * * * * No Exists in code but not used.
order_no varchar212 1 1 Description is not available. inbound_work_order po_nbr varchar2 12 Yes Unique Purchase Order identifier.
WOInDtlRef * 0 unbounded Description is not available.

XML-Schema Name:WOInDtlRef 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 WOInDtlRef 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 Description is not available. n/a n/a * * Yes Not used by RWMS
item varchar225 1 1 Description is not available. inbound_work_order item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
loc_type varchar21 1 1 The location type of the final destination location. Valid values are:'S' - Store 'W' - Warehouse n/a n/a 8 * 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
seq_no number4 1 1 Description is not available. inbound_work_order wip_seq_nbr number 4 Yes Order in which WIP Codes are processed
wip_code varchar29 1 1 Description is not available. inbound_work_order wip_code varchar2 9 Yes Work in process code setup in wip_code table