|
Column |
Format |
Contents |
|---|---|---|
|
Sku |
Varchar(13) |
Tekso product code (EAN, UPC, and such). |
|
Row Type |
Varchar(13) |
Possible values
|
|
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
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 |