Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/CustOrdSubColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:CustOrdSubColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdSubColDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
CustOrdSubDesc:CustOrdSubDesc * 0 unbounded A collection of CustOrdSubDesc objects. NA NA NA NA NA NA
collection_size number4 1 1 Number of items in the collection. N/A N/A number N/A Yes Number of items in the collection.

XML-Schema Name:CustOrdSubDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustOrdSubDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
customer_order_no varchar248 1 1 Holds the master customer order number from OMS. ORDCUST CUSTOMER_ORDER_NO RSB 48 Yes Fill this description.
fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. ORDCUST FULFILL_ORDER_NO RSB 48 Yes Fill this description.
loc_type loc_type 1 1 This would be 'S' for store. Item substitute is only supported for store fulfillment. ORDCUST FULFILL_LOC_TYPE RIB or/and RSB or/and RSL 1 Yes Fill this description.
loc_id number10 1 1 Indicates the store number associated with the customer order. ORDCUST FULFILL_LOC_ID RSB 10 Yes Fill this description.
item varchar225 1 1 Contains the item number for which substitute item is used. ORDCUST_DETAIL ITEM RSB 25 Yes Fill this description.
item_qty number12_4 1 1 Contains the revised order quantity of the original item. ORDCUST_DETAIL QTY_ORDERED_SUOM RSB 12 Yes Fill this description.
qty_uom varchar24 1 1 Contains the unit of measure for original item order quantity. This will be the standard uom of the item ITEM_MASTER STANDARD_UOM RSB 4 Yes Fill this description.
SubItemDetails * 1 unbounded Contains the substitute item details.