Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For StoreDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
store |
number10 |
1 |
1 |
Description is not available. |
PA_STR_RTL |
ID_STR_RT |
NUMBER |
10 |
No |
Store id |
store_type |
varchar21 |
1 |
1 |
Description is not available. |
null |
null |
varchar2 |
1 |
Yes |
Contains the Type of Store. |
store_name |
varchar2150 |
1 |
1 |
Description is not available. |
PA_ORGN |
NM_ORGN |
VARCHAR2 |
150 |
No |
Contains name of the Store. |
store_name10 |
varchar210 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
store_name3 |
varchar23 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
store_add1 |
varchar2240 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
ADD_1 |
varchar2 |
240 |
Yes |
Contains line 1 of the Address. |
store_add2 |
varchar2240 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
ADD_2 |
varchar2 |
240 |
No |
Contains line 2 of the Address. |
store_city |
varchar2120 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
CITY |
VARCHAR2 |
120 |
Yes |
This column indicates the city in which is located. |
county |
varchar2250 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
state |
varchar23 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
STATE |
VARCHAR2 |
3 |
No |
This column indicates the state in which store is located. |
country_id |
varchar23 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
COUNTRY_ID |
VARCHAR2 |
3 |
Yes |
Contains the country in which store is located. |
store_pcode |
varchar230 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
POST |
varchar2 |
30 |
No |
Contains the postal code. |
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. |
|
null |
null |
null |
null |
Not used in SIM |
store_mgr_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
store_open_date |
xs:dateTime |
0 |
1 |
Description is not available. |
PA_STR_RTL |
DC_OPN_RT_STR |
RIBDate |
|
No |
Contains the date on which store gets opened. |
store_close_date |
xs:dateTime |
0 |
1 |
Description is not available. |
PA_STR_RTL |
DC_CL_RT_STR |
RIBDate |
|
No |
Contains the date on which store gets closed. |
acquired_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
null |
null |
Not used in SIM |
remodel_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
null |
null |
Not used in SIM |
fax_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count mber. |
ADDRESS_DETAIL |
CONTACT_FAX |
varchar2 |
20 |
No |
Contains fax number. |
phone_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count number. |
ADDRESS_DETAIL |
CONTACT_PHONE |
varchar2 |
20 |
No |
Contains phone number. |
email |
varchar2100 |
0 |
1 |
Description is not available. |
ADDRESS_DETAIL |
CONTACT_EMAIL |
varchar2 |
100 |
No |
Contains email address. |
total_square_ft |
number8 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
QU_SZ_STR |
NUMBER |
9,2 |
No |
Total Square ft. |
selling_square_ft |
number8 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
QU_SZ_AR_SL |
NUMBER |
9,2 |
No |
Selling Square Ft. |
linear_distance |
number8 |
0 |
1 |
Description is not available. |
|
null |
number |
8 |
null |
Not used in SIM |
stockholding_ind |
varchar21 |
0 |
1 |
This column indicates whether the store can hold stock. In a non-multichannel environment this will always be |
|
null |
null |
null |
null |
Not used in SIM |
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. |
|
null |
number |
4 |
null |
Not used in SIM |
store_format |
number4 |
0 |
1 |
Contains the number indicating the format of the store. Valid values are found on the store format table. |
|
null |
number |
4 |
null |
Not used in SIM |
mall_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
120 |
null |
Not used in SIM |
district |
number10 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
district_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
promo_zone |
number4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
promo_desc |
varchar220 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
transfer_zone |
number4 |
0 |
1 |
Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. |
PA_STR_RTL |
ID_TSF_ZONE |
varchar2 |
128 |
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. |
|
null |
varchar2 |
1000 |
null |
Not used in SIM |
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. |
|
null |
varchar2 |
10 |
null |
Not used in SIM |
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. |
|
null |
number |
3 |
null |
Not used in SIM |
start_order_days |
number3 |
0 |
1 |
Contains the number of days before the store_open_date that the store will begin accepting orders. |
|
null |
null |
null |
null |
Not used in SIM |
currency_code |
varchar23 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
TY_CNY |
VARCHAR2 |
40 |
No |
Currency of the store's country. |
lang |
number6 |
0 |
1 |
Description is not available. |
PA_PRTY |
ED_LA |
varchar2 |
20 |
No |
Contains language used in the store's country. |
integrated_pos_ind |
varchar21 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
orig_currency_code |
varchar23 |
0 |
1 |
holds the original currency of a store after it's adopted the Euro as its main operating currency |
|
null |
null |
null |
null |
Not used in SIM |
duns_number |
varchar29 |
0 |
1 |
This type can hold a number of digits count umber. |
|
null |
varchar2 |
9 |
null |
Not used in SIM |
duns_loc |
varchar24 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
4 |
null |
Not used in SIM |
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. |
|
null |
null |
null |
null |
Not used in SIM |
pricing_loc_curr |
varchar23 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
Not used in SIM |
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
|