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

XML-Schema Name:StrInvColDesc 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 StrInvColDesc 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
StrInvDesc:StrInvDesc * 0 unbounded Collection of store item inventory information. NA NA NA NA NA NA
collection_size number4 1 1 Size of 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:StrInvDesc 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 StrInvDesc 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_id varchar225 1 1 Sku number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
store_id number10 1 1 Store identifier Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
is_ranged xs:boolean 1 1 True if item has inventory at the store, otherwise false. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
is_estimated xs:boolean 1 1 True if pack item's inventory was estimated from component inventory, otherwise false. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
uom_code varchar24 1 1 Unit of measure code of the quantities. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
case_size number10_2 1 1 Default case size of the item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
stock_on_hand_qty number20_4 1 1 Stock on hand quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
back_room_qty number20_4 1 1 Quantity in the back room area Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
shop_floor_qty number20_4 1 1 Quantity on the shop floor Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
delivery_bay_qty number20_4 1 1 Quantity in delivery bay Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
available_qty number20_4 1 1 Available quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
unavailable_qty number20_4 1 1 Unavailable quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
nonsell_total_qty number20_4 1 1 Total non-sellable quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
on_order_qty number20_4 1 1 On order quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
in_transit_qty number20_4 1 1 In transit quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
cust_reserved_qty number20_4 1 1 Customer reserved quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
transfer_reserved_qty number20_4 1 1 Transfer reserved quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
vendor_return_qty number20_4 1 1 Vendor return quantity Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
allocation_total_qty number20_4 1 1 Total quantity of allocations Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvNslQty * 0 unbounded Collection of non-sellable quantities by specific non-sellable reason.