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

XML-Schema Name:StrFtrInvColDesc 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 StrFtrInvColDesc 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
StrFtrInvDesc:StrFtrInvDesc * 0 unbounded Collection of store item fture 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 Fill column length. Yes Fill this description.

XML-Schema Name:StrFtrInvDesc 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 StrFtrInvDesc 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 Fill this description.
store_id number10 1 1 Store identifier STORE_ITEM_STOCK STORE_ID RIB or/and RSB 10 Yes Fill this description.
src_loc_type inv_location_type 1 1 Location type of the source of the delivery. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
src_loc_id number10 1 1 Identifier of the source of the delivery. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
delivery_type inv_delivery_type 1 1 Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER, UNKNOWN. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
expected_date xs:dateTime 0 1 The date the inventory is expected to arrive. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
inbound_qty number20_4 1 1 Amount of inventory inbound on delivery. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
ordered_qty number20_4 1 1 Amount of inventory on order. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.