Retail Integration Mappings Report Release:16.0.030 (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:16.0.030 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 BDI) 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. n/a (multiple tables) n/a RIB or/and RSB n/a Yes Size of the collection

XML-Schema Name:StrInvDesc Version:16.0.030 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 BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item_id varchar225 1 1 Sku number ITEM ITEM_ID VARCHAR2 25 Yes Sku number
store_id number10 1 1 Store identifier STORE_ITEM_STOCK. STORE_ID NUMBER 10 Yes Store identifier
is_ranged xs:boolean 1 1 True if item has inventory at the store, otherwise false. No True if item has inventory at the store, otherwise false
is_estimated xs:boolean 1 1 True if pack item's inventory was estimated from component inventory, otherwise false. No True if pack item's inventory was estimated from component inventory, otherwise false.
uom_code varchar24 1 1 Unit of measure code of the quantities. ITEM UNIT_OF_MEASURE VARCHAR2 4 Yes Unit of measure code of the quantities
case_size number10_2 1 1 Default case size of the item. ITEM CASE_SIZE NUMBER (12,4) No Default case size of the item
stock_on_hand_qty number20_4 1 1 Stock on hand quantity STORE_ITEM_STOCK QUANTITY_TOTAL NUMBER 12,4 Yes total stock quantity
back_room_qty number20_4 1 1 Quantity in the back room area No Quantity in the back room area,
shop_floor_qty number20_4 1 1 Quantity on the shop floor STORE_ITEM_STOCK QUANTITY_SHOP_FLOOR NUMBER 12,4 Yes Quantity on the shop floor
delivery_bay_qty number20_4 1 1 Quantity in delivery bay STORE_ITEM_STOCK QUANTITY_DELIVERY_BAY NUMBER 12,4 Yes Quantity in delivery bay
available_qty number20_4 1 1 Available quantity No Available quantity, calculated value
unavailable_qty number20_4 1 1 Unavailable quantity No unavailable quantity, calculated value.
nonsell_total_qty number20_4 1 1 Total non-sellable quantity STORE_ITEM_STOCK QUANTITY_NON_SELLABLE NUMBER 12,4 Yes Total non-sellable quantity
in_transit_qty number20_4 1 1 In transit quantity STORE_ITEM_STOCK QUANTITY_IN_TRANSIT NUMBER 12,4 Yes Quantity in transit
cust_reserved_qty number20_4 1 1 Customer reserved quantity STORE_ITEM_STOCK QUANTITY_CUSTOMER_RESERVE NUMBER (12,4) Yes Customer reserved quantity
transfer_reserved_qty number20_4 1 1 Transfer reserved quantity STORE_ITEM_STOCK QUANTITY_RESERVED NUMBER 12,4 Yes Transfer reserved quantity
vendor_return_qty number20_4 1 1 Vendor return quantity STORE_ITEM_STOCK QUANTITY_VENDOR_RETURN NUMBER 12,4 Yes Vendor return quantity
StrInvNslQty * 0 unbounded Collection of non-sellable quantities by specific non-sellable reason.