Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:WOInRef.xsd
Tag Name Table Name Column Name API Req Description
wo_id wo_head wo_id Yes The work order for which deletion activity is occurring.
order_no wo_head order_no Yes Th order number associated with the work order.
WOInDtlRef * * No Child node - see below.

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:WOInDtlRef
Tag Name Table Name Column Name API Req Description
wh wo_detail wh Yes The warehouse of the work order.
item wo_detail item Yes The item of the work order.
loc_type wo_detail loc_type Yes The location type of the final destination location. Valid values are:'S' - Store 'W' - Warehouse
location wo_detail location 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 wo_detail seq_no Yes The sequence number.
wip_code wo_detail wip_code Yes The wip code which indicates the work to be done on the item.