Retail Integration Bus Mappings Report Release:13.2.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.

XML-Schema Name:StoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For StoreDesc
Table Name Column Name API Type Column Length API Required API Description
store number10 1 1 Description is not available. PA_STR_RTL ID_STR_RT NUMBER 10 No Store id
store_type varchar21 1 1 Description is not available. null null varchar2 1 Yes Contains the Type of Store.
store_name varchar2150 1 1 Description is not available. PA_ORGN NM_ORGN VARCHAR2 150 No Contains name of the Store.
store_name10 varchar210 0 1 Description is not available. null null null null Not used in SIM
store_name3 varchar23 0 1 Description is not available. null null null null Not used in SIM
store_add1 varchar2240 0 1 Description is not available. ADDRESS_DETAIL ADD_1 varchar2 240 Yes Contains line 1 of the Address.
store_add2 varchar2240 0 1 Description is not available. ADDRESS_DETAIL ADD_2 varchar2 240 No Contains line 2 of the Address.
store_city varchar2120 0 1 Description is not available. ADDRESS_DETAIL CITY VARCHAR2 120 Yes This column indicates the city in which is located.
county varchar2250 0 1 Description is not available. null null null null Not used in SIM
state varchar23 0 1 Description is not available. ADDRESS_DETAIL STATE VARCHAR2 3 No This column indicates the state in which store is located.
country_id varchar23 0 1 Description is not available. ADDRESS_DETAIL COUNTRY_ID VARCHAR2 3 Yes Contains the country in which store is located.
store_pcode varchar230 0 1 Description is not available. ADDRESS_DETAIL POST varchar2 30 No Contains the postal code.
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. null null null null Not used in SIM
store_mgr_name varchar2120 0 1 Description is not available. null null null null Not used in SIM
store_open_date xs:dateTime 0 1 Description is not available. PA_STR_RTL DC_OPN_RT_STR RIBDate No Contains the date on which store gets opened.
store_close_date xs:dateTime 0 1 Description is not available. PA_STR_RTL DC_CL_RT_STR RIBDate No Contains the date on which store gets closed.
acquired_date xs:dateTime 0 1 Description is not available. null RIBDate null null Not used in SIM
remodel_date xs:dateTime 0 1 Description is not available. null RIBDate null null Not used in SIM
fax_number varchar220 0 1 This type can hold a number of digits count mber. ADDRESS_DETAIL CONTACT_FAX varchar2 20 No Contains fax number.
phone_number varchar220 0 1 This type can hold a number of digits count number. ADDRESS_DETAIL CONTACT_PHONE varchar2 20 No Contains phone number.
email varchar2100 0 1 Description is not available. ADDRESS_DETAIL CONTACT_EMAIL varchar2 100 No Contains email address.
total_square_ft number8 0 1 Description is not available. PA_STR_RTL QU_SZ_STR NUMBER 9,2 No Total Square ft.
selling_square_ft number8 0 1 Description is not available. PA_STR_RTL QU_SZ_AR_SL NUMBER 9,2 No Selling Square Ft.
linear_distance number8 0 1 Description is not available. 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 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. 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. null number 4 null Not used in SIM
mall_name varchar2120 0 1 Description is not available. null varchar2 120 null Not used in SIM
district number10 0 1 Description is not available. null null null null Not used in SIM
district_name varchar2120 0 1 Description is not available. null null null null Not used in SIM
promo_zone number4 0 1 Description is not available. null null null null Not used in SIM
promo_desc varchar220 0 1 Description is not available. 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. PA_STR_RTL ID_TSF_ZONE varchar2 128 No Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table.
description varchar21000 0 1 Description is not available. 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. 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. 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. null null null null Not used in SIM
currency_code varchar23 0 1 Description is not available. PA_STR_RTL TY_CNY VARCHAR2 40 No Currency of the store's country.
lang number6 0 1 Description is not available. PA_PRTY ED_LA varchar2 20 No Contains language used in the store's country.
integrated_pos_ind varchar21 0 1 Description is not available. 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 null null null null Not used in SIM
duns_number varchar29 0 1 This type can hold a number of digits count umber. null varchar2 9 null Not used in SIM
duns_loc varchar24 0 1 Description is not available. 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. null null null null Not used in SIM
pricing_loc_curr varchar23 0 1 Description is not available. null null null null Not used in SIM
org_unit_id number15 0 1 Description is not available. NA NA NA NA NA NA
timezone_name varchar264 0 1 Description is not available. NA NA NA NA NA NA
ExtOfStoreDesc:ExtOfStoreDesc * 0 1 Provide an extension hook to customize StoreDesc. NA NA NA NA NA NA
LocOfStoreDesc:LocOfStoreDesc * 0 1 Provide an extension hook to localize StoreDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
city_id varchar210 0 1 Indicates the City Id or Code. NA NA NA NA NA NA
state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA
addr number11 1 1 Description is not available. 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 1 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 Description is not available. ADDRESS_DETAIL Add_1 VARCHAR2 240 Yes First Address
add_2 varchar2240 0 1 Description is not available. ADDRESS_DETAIL Add_2 VARCHAR2 240 No Second Address
add_3 varchar2240 0 1 Description is not available. ADDRESS_DETAIL Add_3 varchar2 240 No Third Address
city varchar2120 1 1 Description is not available. 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
country_id varchar23 1 1 Description is not available. LO_ADS_NSTD CO_NM VARCHAR2 40 No Not Yet Available
post varchar230 0 1 Description is not available. LO_ADS_NSTD PC_NM VARCHAR2 15 No Not Yet Available
contact_name varchar2120 0 1 Description is not available. ADDRESS_DETAIL contact_name varchar2 120 null Contact name for object
contact_phone varchar220 0 1 Description is not available. 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 Description is not available. 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. null null null No Not used
county varchar220 0 1 Description is not available. null null null null null
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. NA NA NA NA NA NA
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA
LocOfAddrDesc:LocOfAddrDesc * 0 1 Provide an extension hook to localize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfStoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfStoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description
InStoreDesc:InStoreDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrStoreDesc:BrStoreDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA