Retail Integration Mappings Report Release:14.1.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:14.1.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:14.1.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
fulfill_order_no varchar248 1 1 Unique number from OMS related to the fulfillment details. ORDCUST FULFILL_ORDER_NO RSB 48 Yes
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
loc_id number10 1 1 Indicates the store number associated with the customer order. ORDCUST FULFILL_LOC_ID RSB 10 Yes
item varchar225 1 1 Contains the item number for which substitute item is used. ORDCUST_DETAIL ITEM RSB 25 Yes
item_qty number12_4 1 1 Contains the revised order quantity of the original item. ORDCUST_DETAIL QTY_ORDERED_SUOM RSB 12 Yes
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
SubItemDetails * 1 unbounded Contains the substitute item details.