Oracle Portal
 Retail Integration Bus Mappings Report    

Application Name: Retail Merchandising System
XML-Schema or Node Name:StoreDesc.xsd
Tag Name Table Name Column Name API Req Description
store store store Yes Contains the number which uniquely identifies the store.
store_type * * Yes *
org_unit_type * * No *
store_name store store_name Yes Contains the name of the store.
store_name10 store store_name10 Yes Contains a ten character abbreviation of the store name.
store_name3 store store_name3 Yes Contains a three character abbreviation of the store name.
store_add1 * * No Field not used.
store_add2 * * No Field not used.
store_city * * No Field not used.
county * * No Field not used.
state * * No Field not used.
country_id * * No Field not used.
store_pcode * * No Field not used.
store_class store store_class Yes Contains the code letter indicating the class of which the store is a member. Valid values are A through E.
store_mgr_name store store_mgr_name Yes Contains the name of the store manager.
store_open_date store store_open_date Yes Contains the date on which the store opened.
store_close_date store store_close_date No Contains the date on which the store closed.
acquired_date store acquired_date No Contains the date on which the store was acquired.
remodel_date store remodel_date No Contains the date on which the store was last remodeled.
fax_number store fax_number No Contains the fax number for the store.
phone_number store phone_number No Contains the phone number for the store.
email store email No Holds the email address for the location
total_square_ft store total_square_ft No Contains the total square footage of the store.
selling_square_ft store selling_square_ft No Contains the total square footage of the store's selling area.
linear_distance store linear_distance No Holds the total merchandisable space of the location.
stockholding_ind store stockholding_ind Yes This column indicates whether the store can hold stock. In a non-multichannel environment this will always be
channel_id store channel_id 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 store store_format No Contains the number indicating the format of the store. Valid values are found on the store format table.
mall_name store mall_name No Contains the name of the mall in which the store is located.
district store district Yes Contains the number of the district in which the store is a member.
district_name district district_name No Contains the name of the district.
promo_zone * * No Field not used.
promo_desc * * No Field not used.
transfer_zone store transfer_zone No Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table.
description tsfzone description No Contains the name of the transfer zone.
default_wh store default_wh 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 store stop_order_days 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 store start_order_days Yes Contains the number of days before the store_open_date that the store will begin accepting orders.
currency_code store currency_code Yes This field contains the currency code under which the store operates.
lang store lang Yes This column identifies the language to be used for the given store.
integrated_pos_ind store integrated_pos_ind Yes Indicates whether or not the POS system at the Store is integrated.
orig_currency_code store orig_currency_code Yes holds the original currency of a store after it's adopted the Euro as its main operating currency
duns_number store duns_number No This field holds the Dun and Bradstreet number to identify the store.
duns_loc store duns_loc No This field holds the Dun and Bradstreet number to identify the location
AddrDesc * * * See layout below.
pricing_loc store-add price-store No The store from which pricing info was copied for this store.
pricing_loc_curr store currency_code No This is the currency code of the pricing_loc store.

Application Name: Retail Merchandising System
XML-Schema or Node Name:AddrDesc
Tag Name Table Name Column Name API Req Description
addr addr addr_key Yes Address Unigue Identifier
addr_type addr addr_type 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 add_type_module primary_ind Yes Y or N - indicates whether this address type is the primary address type.
primary_addr_ind addr primary_addr_ind Yes Indicates whether this address is the primary address for this address type
add_1 addr add_1 Yes Contains the first line of the address
add_2 addr add_2 No Contains the second line of the address
add_3 addr add_3 No Contains the third line of the address
city addr city Yes Contains the city.
state addr state No Contains the postal abbreviation for the state.
country_id addr country_id Yes Contains the country code.
post addr post No Contains the zip code for the address
contact_name addr contact_name No Contains the name of the contact.
contact_phone addr contact_phone No Contains the phone number of the contact.
contact_telex addr contact_telex No Contains the telex number of the contact.
contact_fax addr contact_fax No Contains the fax number of the contact.
contact_email addr contact_email No Contains the email address of the contact.
oracle_vendor_site_id addr oracle_vendor_site_id No Generally not used.
county addr county No Holds the county of the location