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

SQL

SELECT TOP 10 *
  FROM dbo.StockTransactions

^Sku	^RowType	^FromStoreId	^ToStoreId	^Description	^Created	^RawType	^{PurchasePrice}
^1425598	^{StockTransfer}	¹	²	^{Siirto: 1 > 2 2 KPL}	^{2023-02-09 13:24:48.000}	¹⁵²	^366.320
^1425604	^{StockTransfer}	¹	²	^{Siirto: 1 > 2 1 KPL}	^{2023-02-09 13:24:48.000}	¹⁵²	^366.320
^1429798	^StockTake	⁰	¹	^{Inventointikirjaus: 1 KPL}	^{2023-02-08 14:39:24.000}	¹⁵³	^NULL
^1429938	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-12-13 11:36:17.000}	¹⁵¹	^11.300
^1429947	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-12-13 11:36:17.000}	¹⁵¹	^11.300
^1429956	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-12-13 11:36:17.000}	¹⁵¹	^11.300
^1429965	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-12-13 11:36:17.000}	¹⁵¹	^11.300
^1429929	^Purchase	⁰	¹	^{Tulo: 1000 KPL}	^{2022-12-13 11:24:59.000}	¹⁵¹	^0.150
^1429646	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-08-22 12:18:43.000}	¹⁵¹	^11.300
^1427550	^Purchase	⁰	¹	^{Tulo: 1 KPL}	^{2022-08-22 12:18:43.000}	¹⁵¹	^12.210