Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising 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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
wo_id number10 1 1 The unique identifier for work in process associated with an order or transfer. wo_head wo_id null null Yes The unique identifier for work in process associated with an order or transfer.
order_no varchar212 1 1 The order number associated with the work order. wo_head order_no number 12 Yes The order number associated with the work order.
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
wh number10 1 1 The warehouse where the work order will be done. wo_detail wh null null Yes The warehouse where the work order will be done.
item varchar225 1 1 The item on which the work order will be done. wo_detail item null null Yes The item on which the work order will be done.
loc_type varchar21 1 1 The location type of the final destination location. Valid values are:'S' - Store or 'W' - Warehouse wo_detail loc_type null Fill column length. Yes The location type of the final destination location. Valid values are S (store) or W (warehouse).
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. wo_detail location null null Yes 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 warehouse column.
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). wo_detail seq_no null null Yes The sequence number (needed to ensure each record is unique, because the same wip code can be listed more than once on the same work order).
wip_code varchar29 1 1 The wip code for the work to be done on the item. wo_detail wip_code null null Yes The wip code for the work to be done on the item.
instructions varchar2300 0 1 Not used by RMS. * * null null No Not used by RMS.