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

XML-Schema Name:StrInvDesc Version:16.0.21 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 STORE_ITEM_STOCK ITEM_ID RIB or/and RSB 25 Yes Sku number
store_id number10 1 1 Store identifier STORE_ITEM_STOCK. STORE_ID RIB or/and RSB 10 Yes Store identifier
is_ranged xs:boolean 1 1 True if item has inventory at the store, otherwise false. n/a n/a RIB or/and RSB n/a Yes 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. n/a n/a RIB or/and RSB n/a Yes 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 RIB or/and RSB 4 Yes Unit of measure code of the quantities
case_size number10_2 1 1 Default case size of the item. ITEM CASE_SIZE RIB or/and RSB (12,4) Yes Default case size of the item
stock_on_hand_qty number20_4 1 1 Stock on hand quantity STORE_ITEM_STOCK QUANTITY_TOTAL RIB or/and RSB 12,4 Yes total stock quantity
back_room_qty number20_4 1 1 Quantity in the back room area STORE_ITEM_STOCK n/a RIB or/and RSB n/a Yes Quantity in the back room area,
shop_floor_qty number20_4 1 1 Quantity on the shop floor STORE_ITEM_STOCK QUANTITY_SHOP_FLOOR RIB or/and RSB 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 RIB or/and RSB 12,4 Yes Quantity in delivery bay
available_qty number20_4 1 1 Available quantity STORE_ITEM_STOCK Fill table column name. RIB or/and RSB Fill column length. Yes Available quantity, calculated value
unavailable_qty number20_4 1 1 Unavailable quantity STORE_ITEM_STOCK n/a RIB or/and RSB n/a Yes unavailable quantity
nonsell_total_qty number20_4 1 1 Total non-sellable quantity STORE_ITEM_STOCK QUANTITY_NON_SELLABLE RIB or/and RSB 12,4 Yes Total non-sellable quantity
in_transit_qty number20_4 1 1 In transit quantity STORE_ITEM_STOCK QUANTITY_IN_TRANSIT RIB or/and RSB 12,4 Yes Quantity in transit
cust_reserved_qty number20_4 1 1 Customer reserved quantity STORE_ITEM_STOCK QUANTITY_CUSTOMER_RESERVE RIB or/and RSB (12,4) Yes Customer reserved quantity
transfer_reserved_qty number20_4 1 1 Transfer reserved quantity STORE_ITEM_STOCK QUANTITY_RESERVED RIB or/and RSB 12,4 Yes Transfer reserved quantity
vendor_return_qty number20_4 1 1 Vendor return quantity STORE_ITEM_STOCK QUANTITY_VENDOR_RETURN RIB or/and RSB 12,4 Yes Vendor return quantity
StrInvNslQty * 0 unbounded Collection of non-sellable quantities by specific non-sellable reason.