Retail Integration Bus Mappings Report
Application Name: Retail Merchandising System
XML-Schema or Node Name:XOrderRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
order_no
ordhead
order_no
Yes
The unique identifier for the order.
XOrderDtlRef
*
*
*
*
Application Name: Retail Merchandising System
XML-Schema or Node Name:XOrderDtlRef
Tag Name
Table Name
Column Name
API Req
Description
item
ordsku
item
No
An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P').
location
ordloc
location
Yes
An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected.
ref_item
ordsku
ref_item
No
The id of a reference item which can be used instead of using the item field. If the item field is not populated this field is required.