Retail Integration Bus Mappings Report
Release: 13.0.1
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:WOInDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
wo_id
wo_head
wo_id
Yes
The unique
identifier for work in process associated with an order or
transfer.
order_no
wo_head
order_no
Yes
The order number
associated with the work order.
WOInDtl
*
*
Yes
Child node - see
below.
Application Name: Retail
Merchandising System
Version 13.0.1
XML-Schema or Node
Name:WOInDtl
Tag Name
Table Name
Column Name
API Req
Description
wh
wo_detail
wh
Yes
The warehouse
where the work order will be done.
item
wo_detail
item
Yes
The item on
which the work order will be done.
loc_type
wo_detail
loc_type
Yes
The location
type of the final destination location. Valid values are:'S' - Store or
'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 (needed to ensure each record is unique, since the same wip code
can be listed more than once on the same work order).