location_id
(primary key)

varchar(40)

not null

The ID of the location.

type

enum

null

The type of location, available types are location and store.

ext_loc_id

varchar(40)

null

An external location ID.

version

integer

not null

The version of the product.

name

varchar(254)

null

The name of the store.

start_date

datetime

null

The date from which available quantity can be searched. If no start date is provided, the current date is used.

end_date

datetime

null

The date to which available quantities can be searched. If no end date is provided, all quantity from the start date onward is returned.

latitude

numeric

not null

The latitude of the store.

longitude

numeric

not null

The longitude of the store.

location_id
(primary key)

varchar(40)

not null

The ID of the location.

site_id

varchar(40)

not null

The ID of the site.

location_id
(primary key)

varchar(40)

not null

The ID of the store.

site_group_id

varchar(40)

not null

The ID of the site group.

location_id
(primary key)

varchar(40)

not null

The ID of the store.

hours

varchar(64)

null

The hours of the store.

location_id
(primary key)

varchar(40)

not null

The store ID.

address_1

varchar(50)

null

The first address line of the store.

address_2

varchar(50)

null

The second address line of the store.

address_3

varchar(50)

null

The third address line of the store.

city

varchar(40)

null

The city in which the store is located.

county

varchar(40)

null

The county in which the store is located.

state_addr

varchar(40)

null

The state in which the store is located.

postal_code

varchar(10)

null

The postal code of the store.

country

varchar(40)

null

The country in which the store is located.

phone_number

varchar(40)

null

The phone number of the store.

fax_number

varchar(40)

null

The fax number of the store.

email

varchar(255)

null

The e-mail address of the store.