StockRec
Column | Format | Unique value | Contents |
---|---|---|---|
ModelNo | varchar(18) | Store Tekso: Unique combination ModelNo + EAN | Model ID. |
ShopId | smallint | Fashion Tekso: Unique combination ShopId + EAN Store Tekso: Unique combination ModelNo + EAN | Shop ID. |
EAN | varchar(13) | Fashion Tekso: Unique combination ShopId + EAN | EAN. |
Qty | decimal(9,3) | Quantity. | |
EpcShopID | int | Store reference. |
Example Data
Query
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 |