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/InvBackOrdColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:InvBackOrdColDesc 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 InvBackOrdColDesc 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
InvBackOrdDesc:InvBackOrdDesc * 0 unbounded A collection of InvBackOrdDesc objects. NA NA NA NA NA NA
collection_size number4 1 1 Number of items in the collection. N/A N/A N/A N/A Yes Fill this description.

XML-Schema Name:InvBackOrdDesc 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 InvBackOrdDesc 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
item varchar225 1 1 The item identifier. ITEM_LOC_SOH ITEM RSB 25 Yes Fill this description.
loc_type loc_type 1 1 Type of location. Valid values are 'S' (store) and 'W' (warehouse). ITEM_LOC_SOH LOC_TYPE RSB 1 Yes Fill this description.
location number10 1 1 Location where the item back order inventory has to be updated. This field may contain a store or a physical warehouse. ITEM_LOC_SOH LOC RSB 10 Yes Fill this description.
channel_id number4 0 1 Channel id for the Physical Warehouse. STORE or WH CHANNEL_ID RSB 4 Yes Fill this description.
backorder_qty number12_4 1 1 Contains the Back Order quantity to be adjusted for the item/location. ITEM_LOC_SOH CUSTOMER_BACKORDER / PACK_COMP_CUST_BACK RSB 12 Yes Depending on whether the item is a regular item or pack item, customer_backorder or pack_comp_cust_back would be populated.
unit_of_measure varchar24 1 1 Contains the unit of measure for Back Orderable quantity. ITEM_MASTER STANDARD_UOM RSB 4 Yes Fill this description.