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/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 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 Description is not available. wo_head wo_id null null Yes The work order for which deletion activity is occurring.
order_no varchar212 1 1 Description is not available. wo_head order_no number 12 Yes The order number associated with the work order.
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 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 Description is not available. wo_detail wh null null Yes The warehouse of the work order.
item varchar225 1 1 Description is not available. wo_detail item null null Yes The item of the work order.
loc_type varchar21 1 1 The location type of the final destination location. Valid values are:'S' - Store 'W' - Warehouse wo_detail loc_type null Fill column length. Yes The location type of the final destination location. Valid values are S (store) and 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 Description is not available. wo_detail seq_no null null Yes The sequence number.
wip_code varchar29 1 1 Description is not available. wo_detail wip_code null null Yes The wip code that indicates the work to be done on the item.