StockRec
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. |
Store Tekso: Unique combination ModelNo + EANExample Data
Query
SQL
SELECT TOP 10 *
FROM dbo.StockRecordsResult
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 |