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

XML-Schema Name:StrInvItmColDesc 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 StrInvItmColDesc 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
StrInvItmDesc:StrInvItmDesc * 0 unbounded Collection of store item inventory information. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. STORE_ITEM_STOCK n/a RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StrInvItmDesc 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 StrInvItmDesc 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 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 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 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 Fill column length. Yes Fill this description.