Retail Integration Bus Mappings Report Release:13.2.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.

XML-Schema Name:WOInDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOInDesc
Table Name Column Name API Type Column Length API Required 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 Yes Used in interface only.
order_no varchar210 1 1 The order number associated with the work order. inbound_work_order po_nbr varchar2 10 Yes Populates the PO_NO in inbound_work_order Table
WOInDtl * 1 unbounded Child node - see below.
ExtOfWOInDesc:ExtOfWOInDesc * 0 1 Provide an extension hook to customize WOInDesc. NA NA NA NA NA NA
LocOfWOInDesc:LocOfWOInDesc * 0 1 Provide an extension hook to localize WOInDesc. NA NA NA NA NA NA

XML-Schema Name:WOInDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For WOInDtl
Table Name Column Name API Type Column Length API Required API Description
wh number10 1 1 The warehouse where the work order will be done. n/a n/a number 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 varchar2 1 Yes 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 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 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 6 Yes Populates wip_code in inbound_work_order table.
instructions varchar2300 0 1 Not used by RMS. inbound_work_order instructions varchar2 300 No *
ExtOfWOInDesc:ExtOfWOInDtl * 0 1 Provide an extension hook to customize WOInDtl. NA NA NA NA NA NA
LocOfWOInDesc:LocOfWOInDtl * 0 1 Provide an extension hook to localize WOInDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOInDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOInDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOInDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOInDtl
Table Name Column Name API Type Column Length API Required API Description
InWOInDesc:InWOInDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOInDesc:BrWOInDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOInDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfWOInDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfWOInDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For LocOfWOInDesc
Table Name Column Name API Type Column Length API Required API Description
InWOInDesc:InWOInDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOInDesc:BrWOInDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA