Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:WOInRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For WOInRef
Table Name Column Name API Type Column Length API Required 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 varchar210 1 1 Description is not available. wo_head order_no null null Yes Th order number associated with the work order.
WOInDtlRef * 0 unbounded Description is not available.
ExtOfWOInRef:ExtOfWOInRef * 0 1 Provide an extension hook to customize WOInRef. NA NA NA NA NA NA

XML-Schema Name:WOInDtlRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For WOInDtlRef
Table Name Column Name API Type Column Length API Required 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 null Yes The location type of the final destination location. Valid values are:'S' - Store '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 wh 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 which indicates the work to be done on the item.
ExtOfWOInRef:ExtOfWOInDtlRef * 0 1 Provide an extension hook to customize WOInDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOInDtlRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfWOInDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfWOInRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfWOInRef
Table Name Column Name API Type Column Length API Required API Description