store |
store |
store |
Yes |
Contains the
number which uniquely identifies the store. |
store_type |
* |
* |
Yes |
* |
org_unit_type |
* |
* |
No |
* |
store_name |
store |
store_name |
Yes |
Contains the
name of the store. |
store_name10 |
store |
store_name10 |
Yes |
Contains a ten
character abbreviation of the store name. |
store_name3 |
store |
store_name3 |
Yes |
Contains a three
character abbreviation of the store name. |
store_add1 |
* |
* |
No |
Field not
used. |
store_add2 |
* |
* |
No |
Field not
used. |
store_city |
* |
* |
No |
Field not
used. |
county |
* |
* |
No |
Field not
used. |
state |
* |
* |
No |
Field not
used. |
country_id |
* |
* |
No |
Field not
used. |
store_pcode |
* |
* |
No |
Field not
used. |
store_class |
store |
store_class |
Yes |
Contains the
code letter indicating the class of which the store is a member. Valid
values are A through E. |
store_mgr_name |
store |
store_mgr_name |
Yes |
Contains the
name of the store manager. |
store_open_date |
store |
store_open_date |
Yes |
Contains the
date on which the store opened. |
store_close_date |
store |
store_close_date |
No |
Contains the
date on which the store closed. |
acquired_date |
store |
acquired_date |
No |
Contains the
date on which the store was acquired. |
remodel_date |
store |
remodel_date |
No |
Contains the
date on which the store was last remodeled. |
fax_number |
store |
fax_number |
No |
Contains the fax
number for the store. |
phone_number |
store |
phone_number |
No |
Contains the
phone number for the store. |
email |
store |
email |
No |
Holds the email
address for the location |
total_square_ft |
store |
total_square_ft |
No |
Contains the
total square footage of the store. |
selling_square_ft |
store |
selling_square_ft |
No |
Contains the
total square footage of the store's selling area. |
linear_distance |
store |
linear_distance |
No |
Holds the total
merchandisable space of the location. |
stockholding_ind |
store |
stockholding_ind |
Yes |
This column
indicates whether the store can hold stock. In a non-multichannel
environment this will always be |
channel_id |
store |
channel_id |
No |
In a
multichannel environment this will contain the channel with which the
store is associated. Valid values can be found on the channels
table. |
store_format |
store |
store_format |
No |
Contains the
number indicating the format of the store. Valid values are found on the
store format table. |
mall_name |
store |
mall_name |
No |
Contains the
name of the mall in which the store is located. |
district |
store |
district |
Yes |
Contains the
number of the district in which the store is a member. |
district_name |
district |
district_name |
No |
Contains the
name of the district. |
promo_zone |
* |
* |
No |
Field not
used. |
promo_desc |
* |
* |
No |
Field not
used. |
transfer_zone |
store |
transfer_zone |
No |
Contains the
transfer zone in which the store is located. Valid values are located on
the tsfzone table. |
description |
tsfzone |
description |
No |
Contains the
name of the transfer zone. |
default_wh |
store |
default_wh |
No |
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. |
stop_order_days |
store |
stop_order_days |
No |
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. |
start_order_days |
store |
start_order_days |
Yes |
Contains the
number of days before the store_open_date that the store will begin
accepting orders. |
currency_code |
store |
currency_code |
Yes |
This field
contains the currency code under which the store operates. |
lang |
store |
lang |
Yes |
This column
identifies the language to be used for the given store. |
integrated_pos_ind |
store |
integrated_pos_ind |
Yes |
Indicates
whether or not the POS system at the Store is integrated. |
orig_currency_code |
store |
orig_currency_code |
Yes |
holds the
original currency of a store after it's adopted the Euro as its main
operating currency |
duns_number |
store |
duns_number |
No |
This field holds
the Dun and Bradstreet number to identify the store. |
duns_loc |
store |
duns_loc |
No |
This field holds
the Dun and Bradstreet number to identify the location |
AddrDesc |
* |
* |
* |
See layout
below. |
pricing_loc |
store-add |
price-store |
No |
The store from
which pricing info was copied for this store. |
pricing_loc_curr |
store |
currency_code |
No |
This is the
currency code of the pricing_loc store. |