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

XML-Schema Name:InvAvailCriVo 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 InvAvailCriVo 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
items varchar225 1 unbounded Contains the transaction level item numbers for which to check inventory. N/A N/A N/A N/A Yes N/A
InvLocation * 1 unbounded Contains the locations at which to check inventory.
store_pickup_ind store_pickup_ind 1 1 Indicates if the inventory availability lookup is for general purpose or specific for store pickup. Valid values are 'Y' (store pickup) and 'N' (others). This field will be used for routing the input request. N/A N/A N/A N/A No N/A

XML-Schema Name:InvLocation 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 InvLocation 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
location number10 1 1 The location at which to check item inventory. N/A N/A N/A N/A Yes N/A
loc_type loc_type 1 1 Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). N/A N/A N/A N/A Yes N/A
channel_id number4 0 1 Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. N/A N/A N/A N/A Yes N/A