Skip to main content
Skip table of contents

Stock Transactions

Column

Format

Contents

Sku

Varchar(13)

Tekso product code (EAN, UPC, and such).

Row Type

Varchar(13)

Possible values

  • Purchase = Entering the warehouse

  • StockTransfer = Transfer from warehouse x to y

  • StockTake = Inventory

  • StockSet = Inventory correction

FromStoreId

Smallint

Amount from store.

ToStoreId

Smallint

Amount to store.

Description

Varchar(46)

Description for the transfer.

Created

Datetime (yyyy-mm-dd)

Stock transaction created date.

RawType

Smallint

Row type as internal code.

PurchasePrice

Decimal(11,3)

Purchase price for the code.

Example Data

Query

SQL
SELECT TOP 10 *
  FROM dbo.StockTransactions

Result

Sku

RowType

FromStoreId

ToStoreId

Description

Created

RawType

PurchasePrice

1425598

StockTransfer

1

2

Siirto: 1 > 2 2 KPL

2023-02-09 13:24:48.000

152

366.320

1425604

StockTransfer

1

2

Siirto: 1 > 2 1 KPL

2023-02-09 13:24:48.000

152

366.320

1429798

StockTake

0

1

Inventointikirjaus: 1 KPL

2023-02-08 14:39:24.000

153

NULL

1429938

Purchase

0

1

Tulo: 1 KPL

2022-12-13 11:36:17.000

151

11.300

1429947

Purchase

0

1

Tulo: 1 KPL

2022-12-13 11:36:17.000

151

11.300

1429956

Purchase

0

1

Tulo: 1 KPL

2022-12-13 11:36:17.000

151

11.300

1429965

Purchase

0

1

Tulo: 1 KPL

2022-12-13 11:36:17.000

151

11.300

1429929

Purchase

0

1

Tulo: 1000 KPL

2022-12-13 11:24:59.000

151

0.150

1429646

Purchase

0

1

Tulo: 1 KPL

2022-08-22 12:18:43.000

151

11.300

1427550

Purchase

0

1

Tulo: 1 KPL

2022-08-22 12:18:43.000

151

12.210

JavaScript errors detected

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

If this problem persists, please contact our support.