XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StoreDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
store |
number10 |
1 |
1 |
Contains the number to uniquely identify the store. |
STORE |
ID |
NUMBER |
10 |
Yes |
a unique retailer assigned identifier for a location. |
store_type |
varchar21 |
1 |
1 |
This will indicate whether a particular store is a franchise or company store. |
|
null |
null |
null |
Yes |
Contains the Type of Store. |
store_name |
varchar2150 |
1 |
1 |
Contains the name of the store. |
STORE |
NAME |
VARCHAR2 |
150 |
Yes |
Contains name of the Store. |
store_name10 |
varchar210 |
0 |
1 |
Contains a ten character abbreviation of the store name. |
|
null |
null |
null |
null |
Not used in SIM |
store_name3 |
varchar23 |
0 |
1 |
Contains a three character abbreviation of the store name. |
|
null |
null |
null |
null |
Not used in SIM |
store_add1 |
varchar2240 |
0 |
1 |
Not used by RMS. |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
Yes |
first address |
store_add2 |
varchar2240 |
0 |
1 |
Not used by RMS. |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
second address |
store_city |
varchar2120 |
0 |
1 |
Not used by RMS. |
ADDRESS |
CITY |
VARCHAR2 |
120 |
Yes |
supplier city id for address type |
county |
varchar2250 |
0 |
1 |
Not used by RMS. |
|
null |
null |
null |
null |
Not used in SIM |
state |
varchar23 |
0 |
1 |
Not used by RMS. |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
supplier state for address type |
country_id |
varchar23 |
0 |
1 |
Not used by RMS. |
STORE |
LOCALE_COUNTRY |
VARCHAR2 |
2 |
No |
The 2-letter country code from ISO-3166. |
store_pcode |
varchar230 |
0 |
1 |
Not used by RMS. |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
supplier post info depending on address type |
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 |
Contains the name of the store manager. |
|
null |
null |
null |
null |
Not used in SIM |
store_open_date |
xs:dateTime |
0 |
1 |
Contains the date on which the store opened. |
STORE |
OPEN_DATE |
DATE |
|
No |
the opening date for location. |
store_close_date |
xs:dateTime |
0 |
1 |
Contains the date on which the store closed. |
STORE |
CLOSE_DATE |
Date |
|
No |
the closing date for the location. (currently not used by sim) |
acquired_date |
xs:dateTime |
0 |
1 |
Contains the date on which the store was acquired. |
|
null |
RIBDate |
null |
null |
Not used in SIM |
remodel_date |
xs:dateTime |
0 |
1 |
Contains the date on which the store was last remodeled. |
|
null |
RIBDate |
null |
null |
Not used in SIM |
fax_number |
varchar220 |
0 |
1 |
Contains the fax number for the store. |
ADDRESS |
CONTACT_FAX |
VARCHAR2 |
20 |
No |
supplier fax for address type |
phone_number |
varchar220 |
0 |
1 |
Contains the phone number for the store. |
ADDRESS |
CONTACT_PHONE |
varchar2 |
20 |
No |
supplier phone for address type |
email |
varchar2100 |
0 |
1 |
Contains the email address for the location. |
ADDRESS |
CONTACT_EMAIL |
VARCHAR2 |
100 |
No |
supplier email for address type |
total_square_ft |
number8 |
0 |
1 |
Contains the total square footage of the store. |
STORE |
TOTAL_SQUARE_FEET |
NUMBER |
9,2 |
No |
Total Square ft. |
selling_square_ft |
number8 |
0 |
1 |
Contains the total square footage of the store's selling area. |
STORE |
SELLING_SQUARE_FEET |
NUMBER |
9,2 |
No |
Selling Square Ft. |
linear_distance |
number8 |
0 |
1 |
Contains the total space of the location that can be used for merchandise. |
|
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 |
Contains the name of the mall in which the store is located. |
|
null |
varchar2 |
120 |
null |
Not used in SIM |
district |
number10 |
0 |
1 |
Contains the number of the district in which the store is a member. |
|
null |
null |
null |
null |
Not used in SIM |
district_name |
varchar2120 |
0 |
1 |
Contains the name of the district. |
|
null |
null |
null |
null |
Not used in SIM |
promo_zone |
number4 |
0 |
1 |
Not used by RMS. |
|
null |
null |
null |
null |
Not used in SIM |
promo_desc |
varchar220 |
0 |
1 |
Not used by RMS. |
|
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. |
STORE |
TRANSFER_ZONE_ID |
VARCHAR2 |
128 |
No |
the unique identifier of the inventory transfer zone that the store belongs to. used to determine which locations are valid for inventory transfers from one location to another. |
description |
varchar21000 |
0 |
1 |
Contains the name of the transfer zone. |
|
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 |
This field contains the currency code under which the store operates. |
STORE |
CURRENCY_CODE |
VARCHAR2 |
40 |
No |
a code that signifies the currency that this location is operating under. |
lang |
number6 |
0 |
1 |
This column identifies the language to be used for the store. |
STORE |
LOCALE_LANGUAGE |
VARCHAR2 |
2 |
No |
The 2-letter language code from ISO-639. |
integrated_pos_ind |
varchar21 |
0 |
1 |
Indicates whether the POS system at the store is integrated. |
|
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 |
This field contains the Dun and Bradstreet number to identify the location. |
|
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 |
This is the currency code of the pricing_loc store. |
|
null |
null |
null |
null |
Not used in SIM |
org_unit_id |
number15 |
0 |
1 |
Column will contain the organizational unit ID value. |
STORE |
ORGANIZATION_UNIT_ID |
VARCHAR2 |
15 |
No |
this indicates the org unit to which the store belongs to |
timezone_name |
varchar264 |
0 |
1 |
Indicates the time zone of the store. For example, 'America/New_York'. |
STORE |
TIMEZONE |
VARCHAR2 |
80 |
No |
contains the time zone that this store is located in. |