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

XML-Schema Name:StrInvGpCriVo 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 StrInvGpCriVo 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_col varchar225 1 10 Collection of sku numbers ITEM ITEM_ID varchar2 25 Yes the retailers sku or unique item identifier for items sold or returned. this field is required by sim. store_id number10 1 1 Store identifier STORE_ITEM STORE_ID NUMBER 10,0 Yes the unique identifier of the location that is holding the item. uom_type StrInvUomType 1 1 Type of unit of measure to attempt to return quantities. Will default to STANDARD if unable to perform a unit of measure conversion. Valid values are STANDARD, SELLING. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes valid values are SELLING and STANDARD