Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:XStoreDesc.xsd
Tag Name Table Name Column Name API Req Description
store store store Yes The unique identifier of the store.
store_name store store_name Yes The name of the store.
store_name10 store store_name10 No The ten character abbreviation of the store name.
store_name3 store store_name3 No The three character abbreviation of the store name.
store_add1 addr add1 Yes The first line of the store's address.
store_add2 addr add2 No The second line of the store's address.
store_city addr city Yes The city in which the store is located.
state addr state No The postal abbreviation of the state in which the store is located. This value must be predefined on the STATE table.
country_id addr country_id Yes The identifier of the country in which the store is located. This value must be predefined in the COUNTRY table.
store_pcode addr post No The postal zip code for the store.
store_class store store_class Yes The code of the class of which the store is a member.
store_mgr_name store store_mgr_name Yes The name of the store manager.
store_open_date store store_open_date Yes The date on which the store opened.
store_close_date store store_close_date No The date on which the store closed.
acquired_date store acquired_date No The date on which the store was acquired.
remodel_date store remodel_date No The date on which the store was remodeled.
fax_number store fax_number No The fax number of the store.
phone_number store phone_number No The store's phone number.
email store email No The email address of the store.
total_square_ft store total_square_ft No The total square footage of the store.
selling_square_ft store selling_square_ft No The total square footage of the store's selling area.
linear_distance store linear_distance No The total merchandise space of the store.
stockholding_ind store stockholding_ind Yes Indicates if the store can hold stock. This field cannot be modified.
channel_id store channel_id No The identifier of the channel. This value must be predefined on the CHANNELS table. In a multichannel environment this field is required.
store_format store store_format No The code of the store format of the store. This value must be predefined on the STORE_FORMAT table.
mall_name store mall_name No The name of the mall in which the store is located.
district store district Yes The number of the district of which the store is a member. This value must be predefined on the DISTRICT table.
promo_zone * * No Field not used.
transfer_zone store transfer_zone No The transfer zone in which the store is located. This value must be predefined on the TSFZONE table.
default_wh store default_wh No The default warehouse for the store. This value must be predefined on the WH table.
stop_order_days store stop_order_days No The number of days before the store close date that the store will stop accepting orders.
start_order_days store start_order_days Yes The number of days before the store open date that the store will begin accepting orders.
currency_code store currency_code Yes The code of the currency under which the store operates. This value must be predefined on the CURRENCIES table. It cannot be modified.
lang store lang No The code of the language used at the store. This value must be predefined on the LANG table.
iso_code store iso_code No The character code corresponding to the Language used at the store
integrated_pos_ind store integrated_pos_ind Yes Indicates whether the store's POS is integrated.
duns_number store duns_number No The Dun and Bradstreet number to identify the store.
duns_loc store duns_loc No The Dun and Bradstreet number to identify the location.
copy_dlvry_ind store copy_dlvry_ind No Indicates if the like store's delivery schedule information should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
copy_activity_ind store copy_activity_ind No Indicates if the like store's closing date schedule should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
price_store store price_store No The store from which pricing information will be copied to the new store. The pricing store does not need the same currency as the new store. This value is not required on a create message and should not be populated on a modify message.
cost_location store cost_location No The location from which to copy cost information to the new store. This field should only be populated on store create messages. This value must be predefined on the WH or STORE table. This value cannot be modified.
vat_include_ind store vat_include_ind No Indicates whether retail prices for the store will contain VAT.
vat_region store vat_region No The vat region of which the store is a part. This value must be predefined on the VAT_REGION table. It is required if VAT is on in the system.
like_store store like_store No The store from which the new store will have item\locations copied. This value must be predefined on the STORE table. It cannot be modified and will only be populated on a create message.
copy_repl_ind store copy_repl_ind No Indicates whether replenishment information should be copied from the like store to the new store. This field cannot be modified. It will only be populated on a store create message.
transfer_entity store tsf_entity_id No The transfer entity of which the store is a part. This value must be predefined on the TSF_ENTITY table. If the system allows intercompany transfers this field is required.
sister_store store sister_store No The store which will be used to relate historical data to the new store. This value must be predefined on the STORE table.
tran_no_generated store tran_no_generated Yes The level at which unique POS transaction numbers are generated.
addr_change * * No Field not used.
county addr county No The county in which the store is located.
XStoreLocTrt * * No This is a child node - see below.
XStoreWT * * No This is a child node - see below.

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:XStoreLocTrt
Tag Name Table Name Column Name API Req Description
loc_trait loc_traits loc_trait Yes The identifier of the location trait. Though the node is optional, this field is required if the node is included. The node can not be populated on the store create message.

Application Name: Retail Merchandising System
Version 13.0.1
XML-Schema or Node Name:XStoreWT
Tag Name Table Name Column Name API Req Description
walk_through_store walk_through_store walk_through_store Yes A walk through store of the store being modified. Though the node is optional, if it is included this field is required. This node can not be populated on a store create message.