Retail Integration Mappings Report Release:16.0.21 (Integrated Gateway Services)
Application Integrated Gateway Services
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.
XSD Structure

XML-Schema Name:XOrderRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
order_no varchar212 1 1 The unique identifier for the order. RMS.ordhead order_no number 12 Yes The unique identifier for the order.
XOrderDtlRef * 0 unbounded Description is not available.
attempt_rms_load varchar26 0 1 This field indicates if the order will be created in RMS or the staging tables. Valid values are RMS or STG. If not defined, the default is STG. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:XOrderDtlRef Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XOrderDtlRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's 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'). RMS.ordsku item varchar2 25 No An approved, transaction-level item. If a pack, it must be an orderable pack (where order_as_type = 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. RMS.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. RMS.ordsku ref_item varchar2 25 No The ID of a reference item that can be used instead of using the item field. If the item field is not populated, this field is required.