|
Column |
Format |
Unique value |
Contents |
|---|---|---|---|
|
ModelNo |
varchar(18) |
|
Model ID. |
|
ShopId |
smallint |
|
Shop ID. |
|
EAN |
varchar(13) |
|
EAN. |
|
Qty |
decimal(9,3) |
|
Quantity. |
|
EpcShopID |
int |
|
Store reference. |
Example Data
Query
SQL
SELECT TOP 10 *
FROM dbo.StockRecords
Result
|
ModelNo |
ShopId |
EAN |
Qty |
EpcShopId |
|---|---|---|---|---|
|
01-22990 |
1 |
158404 |
0.000 |
1 |
|
103-0290 |
1 |
141653 |
0.000 |
1 |
|
1062-1518 |
1 |
140821 |
0.000 |
1 |
|
1070-1522 |
1 |
162197 |
0.000 |
1 |
|
11-66420 |
1 |
152084 |
0.000 |
1 |
|
111-3401 |
1 |
145154 |
0.000 |
1 |
|
117+256-7530 |
1 |
100151 |
0.000 |
1 |
|
121/340 |
1 |
174484 |
0.000 |
1 |
|
125-3470 |
1 |
135397 |
0.000 |
1 |
|
127-3469 |
1 |
161295 |
0.000 |
1 |