Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
items varchar225 1 unbounded Contains the transaction level item numbers for which to check inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Contains the transaction level item numbers for which to check inventory.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM

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 SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
location number10 1 1 The location at which to check item inventory. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes store identifier
loc_type loc_type 1 1 Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes valid values are S and W
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel.