Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
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 rms Mapping For StoreDesc
Table Name Column Name API Type Column Length API Required API Description
store number10 1 1 Description is not available. store store number 10 Yes Contains the number to uniquely identify the store.
store_type varchar21 1 1 Description is not available. * * varchar2 1 Yes *
store_name varchar2150 1 1 Description is not available. store store_name null null Yes Contains the name of the store.
store_name10 varchar210 0 1 Description is not available. store store_name10 null null Yes Contains a ten character abbreviation of the store name.
store_name3 varchar23 0 1 Description is not available. store store_name3 null null Yes Contains a three character abbreviation of the store name.
store_add1 varchar2240 0 1 Description is not available. * * null null No Not used by RMS.
store_add2 varchar2240 0 1 Description is not available. * * null null No Not used by RMS.
store_city varchar2120 0 1 Description is not available. * * null null No Not used by RMS.
county varchar2250 0 1 Description is not available. * * null null No Not used by RMS.
state varchar23 0 1 Description is not available. * * null null No Not used by RMS.
country_id varchar23 0 1 Description is not available. * * null null No Not used by RMS.
store_pcode varchar230 0 1 Description is not available. * * null null No Not used by RMS.
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. store store_class null null Yes Contains the code (letter) indicating the class to which the store belongs. Valid values are A, B, C, D, and E.
store_mgr_name varchar2120 0 1 Description is not available. store store_mgr_name null null Yes Contains the name of the store manager.
store_open_date xs:dateTime 0 1 Description is not available. store store_open_date null null Yes Contains the date on which the store opened.
store_close_date xs:dateTime 0 1 Description is not available. store store_close_date RIBDate * No Contains the date on which the store closed.
acquired_date xs:dateTime 0 1 Description is not available. store acquired_date RIBDate * No Contains the date on which the store was acquired.
remodel_date xs:dateTime 0 1 Description is not available. store remodel_date RIBDate * No Contains the date on which the store was last remodeled.
fax_number varchar220 0 1 This type can hold a number of digits count mber. store fax_number varchar2 20 No Contains the fax number for the store.
phone_number varchar220 0 1 This type can hold a number of digits count number. store phone_number varchar2 20 No Contains the phone number for the store.
email varchar2100 0 1 Description is not available. store email varchar2 100 No Contains the email address for the location.
total_square_ft number8 0 1 Description is not available. store total_square_ft number 8 No Contains the total square footage of the store.
selling_square_ft number8 0 1 Description is not available. store selling_square_ft number 8 No Contains the total square footage of the store's selling area.
linear_distance number8 0 1 Description is not available. store linear_distance number 8 No Contains the total space of the location that can be used for merchandise.
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be store stockholding_ind null null Yes This column indicates whether the store can hold stock.
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. store channel_id number 4 No In a multichannel environment this field contains the channel with which the store is associated. Valid values are in the channels table.
store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. store store_format number 4 No Contains the number indicating the format of the store. Valid values are in the store format table.
mall_name varchar2120 0 1 Description is not available. store mall_name varchar2 120 No Contains the name of the mall in which the store is located.
district number10 0 1 Description is not available. store district null null Yes Contains the number of the district in which the store is a member.
district_name varchar2120 0 1 Description is not available. district district_name null null No Contains the name of the district.
promo_zone number4 0 1 Description is not available. * * null null No Not used by RMS.
promo_desc varchar220 0 1 Description is not available. * * null null No Not used by RMS.
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 number 4 No Contains the transfer zone in which the store is located. Valid values are located in the tsfzone table.
description varchar21000 0 1 Description is not available. tsfzone description varchar2 1000 No Contains the name of the transfer zone.
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. store default_wh varchar2 10 No Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines the stores associated with (or sourced from) a warehouse. Will contain only virtual warehouses in a multi-channel environment.
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. store stop_order_days number 3 No Contains the number of days before a store closing that the store will stop accepting orders. This column is used when the store_close_date is defined.
start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. store start_order_days null null Yes Contains the number of days before the store_open_date that the store will begin accepting orders.
currency_code varchar23 0 1 Description is not available. store currency_code null null Yes This field contains the currency code under which the store operates.
lang number6 0 1 Description is not available. store lang null null Yes This column identifies the language to be used for the store.
integrated_pos_ind varchar21 0 1 Description is not available. store integrated_pos_ind null null Yes Indicates whether the POS system at the store is integrated.
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency store orig_currency_code null null Yes The original currency of a store after it has adopted the Euro as its main operating currency.
duns_number varchar29 0 1 This type can hold a number of digits count umber. store duns_number varchar2 9 No This field contains the Dun and Bradstreet number to identify the store.
duns_loc varchar24 0 1 Description is not available. store duns_loc varchar2 4 No This field contains the Dun and Bradstreet number to identify the location.
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. store-add price-store null null No The store from which pricing infomation was copied for this store.
pricing_loc_curr varchar23 0 1 Description is not available. store currency_code null null No This is the currency code of the pricing_loc store.
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 rms 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. null null null No Contains the county of the location.
state_name varchar2120 0 1 Indicates the State name. addr n/a null null No Contains the county of the location.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States addr n/a null null No Contains the county of the location.
addr number11 1 1 Description is not available. addr addr_key null null Yes Unique identifier for the address.
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. addr addr_type null null Yes Indicates the type of address. Valid values in the add_type table are 01 (business) and 02 (postal).
primary_addr_type_ind varchar21 1 1 Description is not available. add_type_module primary_ind null null Yes Indicates whether this address type is the primary address type. Valid values are Y and N.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type addr primary_addr_ind null null Yes Indicates whether this address is the primary address for this address type.
add_1 varchar2240 1 1 Description is not available. addr add_1 varchar2 240 Yes Contains the first line of the address.
add_2 varchar2240 0 1 Description is not available. addr add_2 varchar2 240 No Contains the second line of the address.
add_3 varchar2240 0 1 Description is not available. addr add_3 varchar2 240 No Contains the third line of the address.
city varchar2120 1 1 Description is not available. addr city null null Yes Contains the city.
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state null null No Contains the postal abbreviation for the state.
country_id varchar23 1 1 Description is not available. addr country_id null null Yes Contains the country code.
post varchar230 0 1 Description is not available. addr post null null No Contains the zip code for the address.
contact_name varchar2120 0 1 Description is not available. addr contact_name null null No Contains the name of the contact.
contact_phone varchar220 0 1 Description is not available. addr contact_phone null null No Contains the phone number of the contact.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex null null No Contains the telex number of the contact.
contact_fax varchar220 0 1 Description is not available. addr contact_fax null null No Contains the fax number of the contact.
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. addr contact_email null null No Contains the email address of the contact.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. addr oracle_vendor_site_id null null No Generally not used by RMS.
county varchar220 0 1 Description is not available. addr county null null No Contains the county of the location.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. addr jurisdiction_code null varchar2(10) No ID associated to the tax jurisdiction of the country-state relationship.
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 rms 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 rms 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 rms 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 rms 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