Stores
Column | Format | Unique value | Contents |
|---|---|---|---|
Id | Smallint |
| Store ID. |
Name | Varchar(40) | Store name. | |
LocationId | Smallint | Warehouse ID (if different than Store ID). |
Example data
Query
SQL
SELECT TOP 10 *
FROM dbo.StoresResult
Id | Name | LocationId |
|---|---|---|
1 | Myymälä 1 | 1 |
2 | Myymälä 2 | 2 |
90 | Varasto | 90 |
91 | Messumyymälä | 91 |
92 | Varastomyymälä | 92 |
3 | Myymälä 3 | 3 |