Skip to main content
Skip table of contents

StockRec

Column

Format

Unique value

Contents

ModelNo

varchar(18)

(info) Store Tekso: Unique combination ModelNo + EAN

Model ID.

ShopId

smallint

(info) Fashion Tekso: Unique combination ShopId + EAN

(info) Store Tekso: Unique combination ModelNo + EAN

Shop ID.

EAN

varchar(13)

(info) Fashion Tekso: Unique combination ShopId + EAN

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.