Retail Integration Mappings Report Release:16.0.030 (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:16.0.030 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 BDI) 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. No 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. No Not used in SIM
store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. No 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 No city id for address type
county varchar2250 0 1 Not used by RMS. ADDRESS COUNTY VARCHAR2 250 No Holds the county of the contact
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 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. No Not used in SIM
store_mgr_name varchar2120 0 1 Contains the name of the store manager. No Not used in SIM
store_open_date xs:dateTime 0 1 Contains the date on which the store opened. STORE OPEN_DATE DATE 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 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. Yes Not used in SIM
remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. No 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 phone for address type
email varchar2100 0 1 Contains the email address for the location. ADDRESS CONTACT_EMAIL VARCHAR2 100 No 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. No 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 No 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. No 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. No Not used in SIM
mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. No Not used in SIM
district number10 0 1 Contains the number of the district in which the store is a member. No Not used in SIM
district_name varchar2120 0 1 Contains the name of the district. No Not used in SIM
promo_zone number4 0 1 Not used by RMS. No Not used in SIM
promo_desc varchar220 0 1 Not used by RMS. No 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. No 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. No 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. No 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. No 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. No 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 No Not used in SIM
duns_number varchar29 0 1 This type can hold a number of digits count umber. No Not used in SIM
duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. No 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. No Not used in SIM
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. No 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.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
store_name_secondary varchar2150 0 1 Contains the secondary name of the store. No Not used by SIM.
store_class_description varchar2150 0 1 Contains the description of the class of which the store is a member. No Not used by SIM.
vat_region number4 0 1 Contains the number of the Value Added Tax region in which this store is contained. No Not used by SIM.
vat_include_ind varchar21 0 1 Indicates whether or not Value Added Tax will be included in the retail prices in the POS files coming from the store. Valid values are Y or N. No Not used by SIM.
channel_name varchar2120 0 1 Indicates the channel description with which the store is associated. No Not used in SIM
store_format_name varchar2120 0 1 Contains the name or description of the store format. No Not used by SIM.
sister_store number10 0 1 This field will hold a store number which will be used to relate the current store to the historical data of an existing store. No Not used by SIM.
tsf_entity_id number10 0 1 This field will hold id of the transfer entity with which a store is associated. No Not used by SIM.
auto_rcv varchar21 0 1 This column will indicate whether the client is allowing automatic receipt for the store. Valid Values are Y (Yes), N (No), D (System Default). No Not used in SIM
remerch_ind varchar21 0 1 This field identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS. No Not used by SIM.
wf_customer_id number10 0 1 This field identifies numeric id of the customer. No Not used by SIM.
customer_order_loc_ind varchar21 0 1 This Column determines whether the location is customer order location or not.If the indicator is Y then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used.It is enabled only for the company stores. No Not used by SIM.
gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. No Not used by SIM.
customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. No Not used by SIM.
StoreHoursDesc:StoreHoursDesc * 0 unbounded References a collection of store hours details. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:16.0.030 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 BDI) 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. No Not used by SIM.
state_name varchar2120 0 1 Indicates the State name. No Not used by SIM.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States No Not used by SIM.
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 EXTERNAL_ID VARCHAR2 25 No this will hold the external reference id
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 TYPE VARCHAR2 2 Yes denotes the address type. Possible values: 01(for Business Address), 02 (for Postal Address), 03 (for Return Address), 04 (for Order Address), 05 (for Invoice Address), 06 (for Remittance Address), 07 (for Billing Address), 08 (for Delivery Address) 09 (for External Address)
primary_addr_type_ind varchar21 0 1 Description is not available. No Not used by SIM.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type ADDRESS IS_PRIMARY VARCHAR2 1 Yes indicator to denote which address is primary
add_1 varchar2240 1 1 Contains the first line of the address ADDRESS ADDRESS_LINE_1 VARCHAR2 240 No first address
add_2 varchar2240 0 1 Contains the second line of the address. ADDRESS ADDRESS_LINE_2 VARCHAR2 240 No second address
add_3 varchar2240 0 1 Contains the thirdline of the address. ADDRESS ADDRESS_LINE_3 VARCHAR2 240 Yes third address
city varchar2120 1 1 Contains the name of the city that is associated with the address. ADDRESS CITY VARCHAR2 120 No city for address type
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. ADDRESS STATE VARCHAR2 3 No State for the address type.
country_id varchar23 1 1 Contains the country where the address exists. ADDRESS COUNTRY_ID VARCHAR2 3 No country id for the address location
post varchar230 0 1 Contains the zip code for the address. ADDRESS POSTAL_CODE VARCHAR2 30 No postal code for the address
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. ADDRESS CONTACT_NAME VARCHAR2 120 No name of contact person for address type
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. ADDRESS CONTACT_PHONE VARCHAR2 20 No phone number for the contact person at the address.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. No Not used by SIM.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. ADDRESS CONTACT_FAX VARCHAR2 20 No fax for address type
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. ADDRESS CONTACT_EMAIL VARCHAR2 100 No email for address type
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. No Not used by SIM.
county varchar2250 0 1 Contains the county name for the location. No Not used by SIM.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. No Not used by SIM.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
name varchar230 1 1 Holds the attribute name. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA NAME VARCHAR2 30 Yes the name of the custom flex attribute.
value varchar2250 0 1 Holds the numeric or string value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE VARCHAR2 250 No the value of the custom flex attribute.
value_date xs:dateTime 0 1 Holds the date value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE_DATE DATE No the date value of the custom flex attribute.

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
name varchar230 1 1 Holds the attribute name. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA NAME VARCHAR2 30 Yes the name of the custom flex attribute.
value varchar2250 0 1 Holds the numeric or string value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE VARCHAR2 250 No the value of the custom flex attribute.
value_date xs:dateTime 0 1 Holds the date value of the attribute. ITEM_CFA, SUPPLIER_CFA, SUPPLIER_ITEM_CFA, STORE_ITEM_CFA VALUE_DATE DATE No the date value of the custom flex attribute.

XML-Schema Name:StoreHoursDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
store_id number10 1 1 Unique ID of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
store_open_time varchar28 0 1 Contains the open time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
store_close_time varchar28 0 1 Contains the close time for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.