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/XOrderRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:XOrderRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XOrderRef
Table Name Column Name API Type Column Length API Required API Description
order_no varchar210 1 1 The unique identifier for the order. ordhead order_no varchar2 10 Yes The unique identifier for the order.
XOrderDtlRef * 0 unbounded Description is not available.
ExtOfXOrderRef:ExtOfXOrderRef * 0 1 Provide an extension hook to customize XOrderRef. NA NA NA NA NA NA

XML-Schema Name:XOrderDtlRef Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For XOrderDtlRef
Table Name Column Name API Type Column Length API Required API Description
item varchar225 0 1 An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P'). ordsku item varchar2 25 No An approved, transaction level item. If a pack, it must be an orderable pack (with an order_as_type of 'P').
location number10 1 1 An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected. ordloc location number 10 Yes An active store or warehouse. If multichannel is on, and a warehouse is being order to, a virtual warehouse is expected.
ref_item varchar225 0 1 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. ordsku ref_item varchar2 25 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.
ExtOfXOrderRef:ExtOfXOrderDtlRef * 0 1 Provide an extension hook to customize XOrderDtlRef. NA NA NA NA NA NA

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

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