Retail Integration Bus Mappings Report Release:13.1.1 (Retail Merchandising System)
Application Retail Merchandising 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.1.1 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 which uniquely identifies 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 Field not used.
store_add2 varchar2240 0 1 Description is not available. * * null null No Field not used.
store_city varchar2120 0 1 Description is not available. * * null null No Field not used.
county varchar2250 0 1 Description is not available. * * null null No Field not used.
state varchar23 0 1 Description is not available. * * null null No Field not used.
country_id varchar23 0 1 Description is not available. * * null null No Field not used.
store_pcode varchar230 0 1 Description is not available. * * null null No Field not used.
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 of which the store is a member. Valid values are A through 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 Holds 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 Holds the total merchandisable space of the location.
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. In a non-multichannel environment this will always be
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 will contain the channel with which the store is associated. Valid values can be found on 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 found on 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 Field not used.
promo_desc varchar220 0 1 Description is not available. * * null null No Field not used.
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 on 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 which stores are associated with or sourced from a warehouse. Will hold 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 will be 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 given store.
integrated_pos_ind varchar21 0 1 Description is not available. store integrated_pos_ind null null Yes Indicates whether or not 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 holds the original currency of a store after it's 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 holds 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 holds 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 info 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

XML-Schema Name:AddrDesc Version:13.1.1 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
addr number6 1 1 Description is not available. addr addr_key null null Yes Address Unigue Identifier
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 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. add_type_module primary_ind null null Yes Y or N - indicates whether this address type is the primary address type.
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.
county varchar220 0 1 Description is not available. addr county null null No Holds the county of the location
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.1.1 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:ExtOfStoreDesc Version:13.1.1 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