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

XML-Schema Name:InvAvailColDesc 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 InvAvailColDesc 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
InvAvailDesc:InvAvailDesc * 0 unbounded A collection of InvAvailDesc objects. NA NA NA NA NA NA
collection_size number6 1 1 Number of items in the collection. N/A N/A N/A N/A Yes N/A

XML-Schema Name:InvAvailDesc 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 InvAvailDesc 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.
location number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. ITEM_LOC_SOH LOC RSB 10 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.
channel_id number4 0 1 Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is WH, this is optional based on the input criteria. STORE or WH CHANNEL_ID RSB 4 Yes Fill this description.
available_qty number12_4 1 1 Contains the available quantity for the item/location in standard unit of measure. ITEM_LOC_SOH STOCK_ON_HAND - TSF_RESERVED_QTY + CUSTOMER_RESV + RTV_QTY + NON_SELLABLE_QTY RSB 12 Yes Fill this description.
unit_of_measure varchar24 1 1 Contains the unit of measure for available quantity. ITEM_MASTER STANDARD_UOM RSB 4 Yes Fill this description.
available_date xs:dateTime 0 1 The date at which this quantity of inventory is available. N/A N/A N/A N/A No Fill this description.
pack_calculate_ind pack_calculate_ind 0 1 Valid for pack item only. Indicate if the pack item available quantity is actual held value ('N') or calculated using pack component ('Y'). Calculated pack quantity should be treated as an estimate value. N/A N/A RSB N/A Yes Fill this description.