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/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 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
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

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 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
item varchar225 1 1 The item identifier. ITEM ID varchar2 25 Yes the retailers sku or unique item identifier for items sold or returned. this field is required by sim.
location number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. STORE_ITEM STORE_ID Number 10,0 Yes the unique identifier of the location that is holding the item.
loc_type loc_type 1 1 Type of 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 SIM sets values as ''S"
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
available_qty number12_4 1 1 Contains the available quantity for the item/location in standard unit of measure. STORE_ITEM_STOCK QUANTITY_RESERVED, QUANTITY_CUSTOMER_RESERVE, QUANTITY_NON_SELLABLE, QUANTITY_VENDOR_RETURN number 12,4 Yes Available quantity for item
unit_of_measure varchar24 1 1 Contains the unit of measure for available quantity. ITEM UNIT_OF_MEASURE varchar2 4 Yes unit of measure which the stock for this item is tracked at the coporate level.
available_date xs:dateTime 0 1 The date at which this quantity of inventory is available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes not used in SIM
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes pack calculated indicator Y or N