XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XStoreDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
store |
number10 |
1 |
1 |
The unique identifier of the store. |
store |
store |
varchar2 |
10 |
Yes |
The unique identifier of the store. |
store_name |
varchar2150 |
1 |
1 |
The name of the store. |
store |
store_name |
varchar2 |
150 |
Yes |
The name of the store. |
store_type |
varchar21 |
0 |
1 |
The one character abbreviation of the store type. |
store |
store_type |
varchar2 |
6 |
No |
The one character abbreviation of the store type |
store_name10 |
varchar210 |
0 |
1 |
The ten character abbreviation of the store name. |
store |
store_name10 |
varchar2 |
10 |
No |
The ten character abbreviation of the store name. |
store_name3 |
varchar23 |
0 |
1 |
The three character abbreviation of the store name. |
store |
store_name3 |
varchar2 |
3 |
No |
The three character abbreviation of the store name. |
store_class |
varchar21 |
1 |
1 |
The code of the class of which the store is a member. |
store |
store_class |
varchar2 |
1 |
Yes |
The code of the class of which the store is a member. |
store_mgr_name |
varchar2120 |
1 |
1 |
The name of the store manager. |
store |
store_mgr_name |
varchar2 |
120 |
Yes |
The name of the store manager. |
store_open_date |
xs:dateTime |
1 |
1 |
The date on which the store opened. |
store |
store_open_date |
date |
null |
Yes |
The date on which the store opened. |
store_close_date |
xs:dateTime |
0 |
1 |
The date on which the store closed. |
store |
store_close_date |
date |
null |
No |
The date on which the store closed. |
acquired_date |
xs:dateTime |
0 |
1 |
The date on which the store was acquired. |
store |
acquired_date |
date |
null |
No |
The date on which the store was acquired. |
remodel_date |
xs:dateTime |
0 |
1 |
The date on which the store was remodeled. |
store |
remodel_date |
date |
null |
No |
The date on which the store was remodeled. |
fax_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count mber. |
store |
fax_number |
varchar2 |
20 |
No |
The fax number of the store. |
phone_number |
varchar220 |
0 |
1 |
This type can hold a number of digits count number. |
store |
phone_number |
varchar2 |
20 |
No |
The store's phone number. |
email |
varchar2100 |
0 |
1 |
The email address of the store. |
store |
email |
varchar2 |
100 |
No |
The email address of the store. |
total_square_ft |
number8 |
0 |
1 |
The total square footage of the store. |
store |
total_square_ft |
number |
8 |
No |
The total square footage of the store. |
selling_square_ft |
number8 |
0 |
1 |
The total square footage of the store's selling area. |
store |
selling_square_ft |
number |
8 |
No |
The total square footage of the store's selling area. |
linear_distance |
number8 |
0 |
1 |
The total merchandise space of the store. |
store |
linear_distance |
number |
8 |
No |
The total merchandise space of the store. |
stockholding_ind |
varchar21 |
1 |
1 |
Indicates if the store can hold stock. This field cannot be modified. |
store |
stockholding_ind |
varchar2 |
1 |
Yes |
Indicates if the store can hold stock. This field cannot be modified. |
channel_id |
number4 |
0 |
1 |
The identifier of the channel. This value must be predefined on the CHANNELS table. In a multichannel environment this field is required. |
store |
channel_id |
number |
4 |
No |
The identifier of the channel. This value must be predefined in the CHANNELS table. In a multichannel environment this field is required. |
store_format |
number4 |
0 |
1 |
The code of the store format of the store. This value must be predefined on the STORE_FORMAT table. |
store |
store_format |
number |
4 |
No |
Indicates the store's format. This value must be predefined in the STORE_FORMAT table. |
mall_name |
varchar2120 |
0 |
1 |
The name of the mall in which the store is located. |
store |
mall_name |
varchar2 |
120 |
No |
The name of the mall in which the store is located. |
district |
number10 |
1 |
1 |
The number of the district of which the store is a member. This value must be predefined on the DISTRICT table. |
store |
district |
number |
10 |
Yes |
The number of the district towhich the store belongs. This value must be predefined in the DISTRICT table. |
promo_zone |
number4 |
0 |
1 |
Field not used. |
* |
* |
null |
null |
No |
Not used by RMS. |
transfer_zone |
number4 |
0 |
1 |
The transfer zone in which the store is located. This value must be predefined on the TSFZONE table. |
store |
transfer_zone |
number |
4 |
No |
The transfer zone in which the store is located. This value must be predefined in the TSFZONE table. |
default_wh |
number10 |
0 |
1 |
The default warehouse for the store. This value must be predefined on the WH table. |
store |
default_wh |
number |
10 |
No |
The default warehouse for the store. This value must be predefined in the WH table. |
stop_order_days |
number3 |
0 |
1 |
The number of days before the store close date that the store will stop accepting orders. |
store |
stop_order_days |
number |
3 |
No |
The number of days before the store close date that the store will stop accepting orders. |
start_order_days |
number3 |
1 |
1 |
The number of days before the store open date that the store will begin accepting orders. |
store |
start_order_days |
number |
3 |
Yes |
The number of days before the store open date that the store will begin accepting orders. |
currency_code |
varchar23 |
1 |
1 |
The code of the currency under which the store operates. This value must be predefined on the CURRENCIES table. It cannot be modified. |
store |
currency_code |
varchar2 |
3 |
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 |
number6 |
0 |
1 |
The code of the language used at the store. This value must be predefined on the LANG table. |
store |
lang |
number |
6 |
No |
The code of the language used at the store. This value must be predefined in the LANG table. |
iso_code |
varchar26 |
0 |
1 |
The character code corresponding to the Language used at the store |
Fill application table name. |
Fill table column name. |
null |
null |
No |
The character code corresponding to the language used at the store. |
integrated_pos_ind |
varchar21 |
1 |
1 |
Indicates whether the store's POS is integrated. |
store |
integrated_pos_ind |
varchar2 |
1 |
Yes |
Indicates whether the store's POS is integrated. |
duns_number |
varchar29 |
0 |
1 |
This type can hold a number of digits count umber. |
store |
duns_number |
varchar2 |
9 |
No |
The Dun and Bradstreet number to identify the store. |
duns_loc |
varchar24 |
0 |
1 |
The Dun and Bradstreet number to identify the location. |
store |
duns_loc |
varchar2 |
4 |
No |
The Dun and Bradstreet number to identify the location. |
copy_dlvry_ind |
varchar21 |
0 |
1 |
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. |
store_add |
copy_dlvry_ind |
varchar2 |
1 |
No |
Indicates whether 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 |
varchar21 |
0 |
1 |
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. |
store_add |
copy_activity_ind |
varchar2 |
1 |
No |
Indicates whether 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 |
number10 |
0 |
1 |
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. |
store_add |
price_store |
number |
10 |
No |
The store from which pricing information is copied to the new store. The pricing store does not need the same currency as the new store. This value is not required in a create message and should not be populated in a modify message. |
cost_location |
number10 |
0 |
1 |
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. |
store_add |
cost_location |
number |
10 |
No |
The location from which to copy cost information to the new store. This field should only be populated in store create messages. This value must be predefined in the WH or STORE table. This value cannot be modified. |
vat_include_ind |
varchar21 |
0 |
1 |
Indicates whether retail prices for the store will contain VAT. |
store |
vat_include_ind |
varchar2 |
1 |
No |
Indicates whether retail prices for the store will contain VAT. |
vat_region |
number4 |
0 |
1 |
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. |
store |
vat_region |
number |
4 |
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 |
number10 |
0 |
1 |
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. |
store_add |
like_store |
number |
10 |
No |
The store from which the new store copies item\locations. This value must be predefined in the STORE table. It cannot be modified and will only be populated in a create message. |
copy_repl_ind |
varchar21 |
0 |
1 |
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. |
store |
copy_repl_ind |
varchar2 |
1 |
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 in a store create message. |
transfer_entity |
number10 |
1 |
1 |
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. |
store |
tsf_entity_id |
number |
10 |
Yes |
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 |
number10 |
0 |
1 |
The store which will be used to relate historical data to the new store. This value must be predefined on the STORE table. |
store |
sister_store |
number |
10 |
No |
The store used for relating historical data to the new store. This value must be predefined in the STORE table. |
tran_no_generated |
varchar26 |
1 |
1 |
The level at which unique POS transaction numbers are generated. |
store |
tran_no_generated |
varchar2 |
6 |
Yes |
The level at which unique POS transaction numbers are generated. |
county |
varchar2250 |
0 |
1 |
The county in which the store is located. |
addr |
county |
varchar2 |
250 |
No |
The county in which the store is located. |
XStoreLocTrt:XStoreLocTrt
|
*
|
0
|
unbounded
|
It's a referenced element. For detailed description, please refer referenced element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
XStoreWT:XStoreWT
|
*
|
0
|
unbounded
|
It's a referenced element. For detailed description, please refer referenced element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
AddrDesc:AddrDesc
|
*
|
0
|
unbounded
|
It's a referenced element. For detailed description, please refer referenced element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
timezone_name |
varchar264 |
0 |
1 |
TimeZone name. |
store |
timezone_name |
varchar2 |
64 |
Yes |
Indicates the time zone of the store. For example, 'America/New_York'. |
wf_customer_id |
number10 |
0 |
1 |
Customer ID associated with the WF Store. |
store |
wf_customer_id |
number |
10 |
No |
Customer ID associated with the WF store |
org_unit_id |
number15 |
0 |
1 |
Column will contain the organizational unit ID value. |
store |
org_unit_id |
number |
15 |
No |
Column will contain the organizational unit ID value. |
store_name_secondary |
varchar2150 |
0 |
1 |
Secondary name of the store. This field can only be populated when system_options.secondary_desc_ind = Y. |
store |
store_name_secondary |
varchar2 |
150 |
No |
Secondary name of the store. This field can only be populated when system_options.secondary_desc_ind = Y. |
customer_order_loc_ind |
varchar21 |
0 |
1 |
Customer order location indicator. This field can have Y or N. |
store |
customer_order_loc_ind |
varchar2 |
1 |
Yes |
This determines whether the location is customer order location or not.If the indicator is Y then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used. |