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
|