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 |
128 |
No |
Not Yet Available |
store_type |
varchar21 |
1 |
1 |
Description is not available. |
* |
* |
varchar2 |
1 |
Yes |
* |
store_name |
varchar2150 |
1 |
1 |
Description is not available. |
PA_ORGN |
NM_ORGN |
VARCHAR2 |
40 |
No |
Not Yet Available |
store_name10 |
varchar210 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
store_name3 |
varchar23 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
store_add1 |
varchar2240 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
store_add2 |
varchar2240 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
store_city |
varchar2120 |
0 |
1 |
Description is not available. |
PA_ORGN |
ID_GRP_MSG |
VARCHAR2 |
128 |
No |
Not Yet Available |
county |
varchar2250 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
state |
varchar23 |
0 |
1 |
Description is not available. |
PA_ORGN |
ID_GRP_MSG |
VARCHAR2 |
128 |
No |
Not Yet Available |
country_id |
varchar23 |
0 |
1 |
Description is not available. |
PA_ORGN |
ID_GRP_MSG |
VARCHAR2 |
128 |
No |
Not Yet Available |
store_pcode |
varchar230 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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 |
null |
store_mgr_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
store_open_date |
xs:dateTime |
0 |
1 |
Description is not available. |
PA_STR_RTL |
DC_OPN_RT_STR |
RIBDate |
* |
No |
Not Yet Available |
store_close_date |
xs:dateTime |
0 |
1 |
Description is not available. |
PA_STR_RTL |
DC_CL_RT_STR |
RIBDate |
* |
No |
Not Yet Available |
acquired_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
* |
null |
null |
remodel_date |
xs:dateTime |
0 |
1 |
Description is not available. |
|
null |
RIBDate |
* |
null |
null |
fax_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count mber. |
|
null |
varchar2 |
20 |
null |
null |
phone_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count number. |
|
null |
varchar2 |
20 |
null |
null |
email |
varchar2100 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
100 |
null |
null |
total_square_ft |
number8 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
QU_SZ_STR |
NUMBER |
9,2 |
No |
Not Yet Available |
selling_square_ft |
number8 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
QU_SZ_AR_SL |
NUMBER |
9,2 |
No |
Not Yet Available |
linear_distance |
number8 |
0 |
1 |
Description is not available. |
|
null |
number |
8 |
null |
null |
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 |
null |
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 |
null |
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 |
null |
mall_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
120 |
null |
null |
district |
number10 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
district_name |
varchar2120 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
promo_zone |
number4 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
promo_desc |
varchar220 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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 |
NUMBER |
128 |
No |
Not Yet Available |
description |
varchar21000 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
1000 |
null |
null |
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 |
null |
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 |
null |
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 |
null |
currency_code |
varchar23 |
0 |
1 |
Description is not available. |
PA_STR_RTL |
TY_CNY |
VARCHAR2 |
40 |
No |
Not Yet Available |
lang |
number6 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
integrated_pos_ind |
varchar21 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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 |
null |
duns_number |
varchar29 |
0 |
1 |
This type can hold a number of digits count umber. |
|
null |
varchar2 |
9 |
null |
null |
duns_loc |
varchar24 |
0 |
1 |
Description is not available. |
|
null |
varchar2 |
4 |
null |
null |
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 |
null |
pricing_loc_curr |
varchar23 |
0 |
1 |
Description is not available. |
|
null |
null |
null |
null |
null |
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
|