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/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.2.0 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 The 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
LocOfWOInRef:LocOfWOInRef * 0 1 Provide an extension hook to localize WOInRef. NA NA NA NA NA NA

XML-Schema Name:WOInDtlRef Version:13.2.0 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 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.
ExtOfWOInRef:ExtOfWOInDtlRef * 0 1 Provide an extension hook to customize WOInDtlRef. NA NA NA NA NA NA
LocOfWOInRef:LocOfWOInDtlRef * 0 1 Provide an extension hook to localize WOInDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOInDtlRef Version:13.2.0 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:LocOfWOInDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfWOInDtlRef
Table Name Column Name API Type Column Length API Required API Description
InWOInRef:InWOInDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOInRef:BrWOInDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOInRef Version:13.2.0 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

XML-Schema Name:LocOfWOInRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfWOInRef
Table Name Column Name API Type Column Length API Required API Description
InWOInRef:InWOInRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOInRef:BrWOInRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA