store |
store |
store |
Yes |
The unique
identifier of the store. |
store_name |
store |
store_name |
Yes |
The name of the
store. |
store_name10 |
store |
store_name10 |
No |
The ten
character abbreviation of the store name. |
store_name3 |
store |
store_name3 |
No |
The three
character abbreviation of the store name. |
store_add1 |
addr |
add1 |
Yes |
The first line
of the store's address. |
store_add2 |
addr |
add2 |
No |
The second line
of the store's address. |
store_city |
addr |
city |
Yes |
The city in
which the store is located. |
state |
addr |
state |
No |
The postal
abbreviation of the state in which the store is located. This value must
be predefined on the STATE table. |
country_id |
addr |
country_id |
Yes |
The identifier
of the country in which the store is located. This value must be
predefined in the COUNTRY table. |
store_pcode |
addr |
post |
No |
The postal zip
code for the store. |
store_class |
store |
store_class |
Yes |
The code of the
class of which the store is a member. |
store_mgr_name |
store |
store_mgr_name |
Yes |
The name of the
store manager. |
store_open_date |
store |
store_open_date |
Yes |
The date on
which the store opened. |
store_close_date |
store |
store_close_date |
No |
The date on
which the store closed. |
acquired_date |
store |
acquired_date |
No |
The date on
which the store was acquired. |
remodel_date |
store |
remodel_date |
No |
The date on
which the store was remodeled. |
fax_number |
store |
fax_number |
No |
The fax number
of the store. |
phone_number |
store |
phone_number |
No |
The store's
phone number. |
email |
store |
email |
No |
The email
address of the store. |
total_square_ft |
store |
total_square_ft |
No |
The total square
footage of the store. |
selling_square_ft |
store |
selling_square_ft |
No |
The total square
footage of the store's selling area. |
linear_distance |
store |
linear_distance |
No |
The total
merchandise space of the store. |
stockholding_ind |
store |
stockholding_ind |
Yes |
Indicates if the
store can hold stock. This field cannot be modified. |
channel_id |
store |
channel_id |
No |
The identifier
of the channel. This value must be predefined on the CHANNELS table. In a
multichannel environment this field is required. |
store_format |
store |
store_format |
No |
The code of the
store format of the store. This value must be predefined on the
STORE_FORMAT table. |
mall_name |
store |
mall_name |
No |
The name of the
mall in which the store is located. |
district |
store |
district |
Yes |
The number of
the district of which the store is a member. This value must be predefined
on the DISTRICT table. |
promo_zone |
* |
* |
No |
Field not
used. |
transfer_zone |
store |
transfer_zone |
No |
The transfer
zone in which the store is located. This value must be predefined on the
TSFZONE table. |
default_wh |
store |
default_wh |
No |
The default
warehouse for the store. This value must be predefined on the WH
table. |
stop_order_days |
store |
stop_order_days |
No |
The number of
days before the store close date that the store will stop accepting
orders. |
start_order_days |
store |
start_order_days |
Yes |
The number of
days before the store open date that the store will begin accepting
orders. |
currency_code |
store |
currency_code |
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 |
store |
lang |
No |
The code of the
language used at the store. This value must be predefined on the LANG
table. |
iso_code |
store |
iso_code |
No |
The character
code corresponding to the Language used at the store |
integrated_pos_ind |
store |
integrated_pos_ind |
Yes |
Indicates
whether the store's POS is integrated. |
duns_number |
store |
duns_number |
No |
The Dun and
Bradstreet number to identify the store. |
duns_loc |
store |
duns_loc |
No |
The Dun and
Bradstreet number to identify the location. |
copy_dlvry_ind |
store |
copy_dlvry_ind |
No |
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. |
copy_activity_ind |
store |
copy_activity_ind |
No |
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. |
price_store |
store |
price_store |
No |
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. |
cost_location |
store |
cost_location |
No |
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. |
vat_include_ind |
store |
vat_include_ind |
No |
Indicates
whether retail prices for the store will contain VAT. |
vat_region |
store |
vat_region |
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 |
store |
like_store |
No |
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. |
copy_repl_ind |
store |
copy_repl_ind |
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 on
a store create message. |
transfer_entity |
store |
tsf_entity_id |
No |
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 |
store |
sister_store |
No |
The store which
will be used to relate historical data to the new store. This value must
be predefined on the STORE table. |
tran_no_generated |
store |
tran_no_generated |
Yes |
The level at
which unique POS transaction numbers are generated. |
addr_change |
* |
* |
No |
Field not
used. |
county |
addr |
county |
No |
The county in
which the store is located. |
XStoreLocTrt |
* |
* |
No |
This is a child
node - see below. |
XStoreWT |
* |
* |
No |
This is a child
node - see below. |