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/StoreDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:StoreDesc 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 StoreDesc 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 number10 1 1 Contains the number to uniquely identify the store. STORE ID NUMBER 10 Yes a unique retailer assigned identifier for a location.
store_type varchar21 1 1 This will indicate whether a particular store is a franchise or company store. Fill application table name. null null null Yes Contains the Type of Store.
store_name varchar2150 1 1 Contains the name of the store. STORE NAME VARCHAR2 150 Yes Contains name of the Store.
store_name10 varchar210 0 1 Contains a ten character abbreviation of the store name. Fill application table name. null null null null Not used in SIM
store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. Fill application table name. null null null null Not used in SIM
store_add1 varchar2240 0 1 Not used by RMS. ADDRESS ADDRESS_LINE_1 VARCHAR2 240 Yes first address
store_add2 varchar2240 0 1 Not used by RMS. ADDRESS ADDRESS_LINE_2 VARCHAR2 240 No second address
store_city varchar2120 0 1 Not used by RMS. ADDRESS CITY VARCHAR2 120 Yes supplier city id for address type
county varchar2250 0 1 Not used by RMS. Fill application table name. null null null null Not used in SIM
state varchar23 0 1 Not used by RMS. ADDRESS STATE VARCHAR2 3 No supplier state for address type
country_id varchar23 0 1 Not used by RMS. STORE LOCALE_COUNTRY VARCHAR2 3 No The 2-letter country code from ISO-3166.
store_pcode varchar230 0 1 Not used by RMS. ADDRESS POSTAL_CODE VARCHAR2 30 No supplier post info depending on address type
store_class varchar21 0 1 Contains the code letter indicating the class of which the store is a member. Valid values are A through E. Fill application table name. null null null null Not used in SIM
store_mgr_name varchar2120 0 1 Contains the name of the store manager. Fill application table name. null null null null Not used in SIM
store_open_date xs:dateTime 0 1 Contains the date on which the store opened. STORE OPEN_DATE DATE Fill column length. No the opening date for location.
store_close_date xs:dateTime 0 1 Contains the date on which the store closed. STORE CLOSE_DATE Date Fill column length. No the closing date for the location. (currently not used by sim)
acquired_date xs:dateTime 0 1 Contains the date on which the store was acquired. Fill application table name. null RIBDate null null Not used in SIM
remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. Fill application table name. null RIBDate null null Not used in SIM
fax_number varchar220 0 1 Contains the fax number for the store. ADDRESS CONTACT_FAX VARCHAR2 20 No supplier fax for address type
phone_number varchar220 0 1 Contains the phone number for the store. ADDRESS CONTACT_PHONE varchar2 20 No supplier phone for address type
email varchar2100 0 1 Contains the email address for the location. ADDRESS CONTACT_EMAIL VARCHAR2 100 No supplier email for address type
total_square_ft number8 0 1 Contains the total square footage of the store. STORE TOTAL_SQUARE_FEET NUMBER 9,2 No Total Square ft.
selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. STORE SELLING_SQUARE_FEET NUMBER 9,2 No Selling Square Ft.
linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. Fill application table name. null number 8 null Not used in SIM
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Fill application table name. null null null null Not used in SIM
channel_id number4 0 1 In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table. Fill application table name. null number 4 null Not used in SIM
store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. Fill application table name. null number 4 null Not used in SIM
mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. Fill application table name. null varchar2 120 null Not used in SIM
district number10 0 1 Contains the number of the district in which the store is a member. Fill application table name. null null null null Not used in SIM
district_name varchar2120 0 1 Contains the name of the district. Fill application table name. null null null null Not used in SIM
promo_zone number4 0 1 Not used by RMS. Fill application table name. null null null null Not used in SIM
promo_desc varchar220 0 1 Not used by RMS. Fill application table name. null null null null Not used in SIM
transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. 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.
description varchar21000 0 1 Contains the name of the transfer zone. Fill application table name. null varchar2 1000 null Not used in SIM
default_wh varchar210 0 1 Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment. Fill application table name. null varchar2 10 null Not used in SIM
stop_order_days number3 0 1 Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined. Fill application table name. null number 3 null Not used in SIM
start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. Fill application table name. null null null null Not used in SIM
currency_code varchar23 0 1 This field contains the currency code under which the store operates. STORE CURRENCY_CODE VARCHAR2 40 No a code that signifies the currency that this location is operating under.
lang number6 0 1 This column identifies the language to be used for the store. STORE LOCALE_LANGUAGE VARCHAR2 2 No The 2-letter language code from ISO-639.
integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. Fill application table name. null null null null Not used in SIM
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency Fill application table name. null null null null Not used in SIM
duns_number varchar29 0 1 This type can hold a number of digits count umber. Fill application table name. null varchar2 9 null Not used in SIM
duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. Fill application table name. null varchar2 4 null Not used in SIM
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
pricing_loc number10 0 1 If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. Fill application table name. null null null null Not used in SIM
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. Fill application table name. null null null null Not used in SIM
org_unit_id number15 0 1 Column will contain the organizational unit ID value. STORE ORGANIZATION_UNIT_ID VARCHAR2 15 No this indicates the org unit to which the store belongs to
timezone_name varchar264 0 1 Indicates the time zone of the store. For example, 'America/New_York'. STORE TIMEZONE VARCHAR2 80 No contains the time zone that this store is located in.

XML-Schema Name:AddrDesc 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 AddrDesc 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
city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. ADDRESS_DETAIL entity_id varchar2 128 Yes Id of object
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. ADDRESS_DETAIL addr_type varchar2 2 Yes Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table.
primary_addr_type_ind varchar21 0 1 Description is not available. null null null null null
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type null null null null null
add_1 varchar2240 1 1 Contains the first line of the address ADDRESS_DETAIL Add_1 VARCHAR2 240 Yes First Address
add_2 varchar2240 0 1 Contains the second line of the address. ADDRESS_DETAIL Add_2 VARCHAR2 240 No Second Address
add_3 varchar2240 0 1 Contains the thirdline of the address. ADDRESS_DETAIL Add_3 varchar2 240 No Third Address
city varchar2120 1 1 Contains the name of the city that is associated with the address. ADDRESS_DETAIL CITY VARCHAR2 120 Yes City of object
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. LO_ADS_NSTD TE_NM VARCHAR2 40 No Fill this description.
country_id varchar23 1 1 Contains the country where the address exists. LO_ADS_NSTD CO_NM VARCHAR2 40 No Not Yet Available
post varchar230 0 1 Contains the zip code for the address. LO_ADS_NSTD PC_NM VARCHAR2 15 No Not Yet Available
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. ADDRESS_DETAIL contact_name varchar2 120 null Contact name for object
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. ADDRESS_DETAIL contact_phone VARCHAR2 20 No Contact phone for object
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. LO_PH TA_PH VARCHAR2 10 No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. ADDRESS-DETAIL contact_fax VARCHAR2 20 No Contact fax for object
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. ADDRESS_DETAIL contact_email VARCHAR2 100 No Contains the email address of the partner or suppliers representative contact.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. Fill application table name. null null null No Not used
county varchar2250 0 1 Contains the county name for the location. null null null null null
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.