Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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 rms 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. wo_head wo_id null null Yes The unique identifier for work in process associated with an order or transfer.
order_no varchar210 1 1 The order number associated with the work order. wo_head order_no null null Yes The order number associated with the work order.
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 rms 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. 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 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.
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 rms 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 rms 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 rms 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 rms 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