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

XML-Schema Name:LocStoreColDesc 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 LocStoreColDesc 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
LocStoreDesc:LocStoreDesc * 0 unbounded Collection of stores. 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 or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:LocStoreDesc 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 LocStoreDesc 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
store_id number10 1 1 SIM internal identifier STORE ID NUMBER 10,0 Yes a unique retailer assigned identifier for a location.
name varchar2150 1 1 Store name STORE NAME VARCHAR2 150 Yes name of the store
language varchar22 1 1 Store's language of operation. A standardized 2 character code defined in ISO-639. STORE LOCALE_LANGUAGE VARCHAR2 2 Yes The 2-letter language code from ISO-639.
country varchar22 1 1 Store's country of operation. A standardized 2 character code defined in ISO-3166. STORE LOCALE_COUNTRY VARCHAR2 3 Yes The 2-letter country code from ISO-3166.
currency_code varchar240 1 1 Store's currency code of operation. A standardized 3 character code defined in ISO-4217. STORE CURRENCY_CODE VARCHAR2 40 Yes a code that signifies the currency that this location is operating under.
transfer_zone varchar2128 0 1 Store's transfer zone. STORE TRANSFER_ZONE_ID VARCHAR2 128 No the unique identifier of the inventory transfer zone that the store belongs to. used to determine which locations are valid for inventory transfers from one location to another.
timezone varchar280 1 1 Store's timezone as defined by the java TimeZone object. STORE TIMEZONE VARCHAR2 80 Yes contains the time zone that this store is located in.
is_managed xs:boolean 1 1 Indicates if the store is using the sim application. valid values are y or n. STORE SIM_STORE CHAR 1 Yes indicates if the store is using the sim application. valid values are y or n.