Stock Turnover (StockTurnMix)

In the following description, you will find the record structure for the abstract database table StockTurnMix in which the data for the following statistics is stored:

Stock Turnover/ Branch (StockTurnBra)
Stock Turnover / Company (StockTurnCom)
Stock Turnover / Stock (StockTurnSto)

The following description contains the corresponding field names, the data type and the field size, and a short description of the field contents.

Stock Turnover

Decimal (13,3)

Quantity

Decimal (13,3)

In this field, the unit quantity of the stock item is stored.

Quantity Incoming Goods

Decimal (13,3)

In this field, the quantity of the delivered incoming goods for this stock item is stored.

Quantity Outgoing Goods

Decimal (13,3)

In this field, the quantity of the delivered outgoing goods for this stock item is stored.

Incoming Production

Decimal (13,3)

In this field, the quantity of incoming goods that have been produced in the own company is stored.

Outgoing Production

Decimal (13,3)

In this field, the quantity of outgoing goods that have been produced in the own company is stored.

Quantity

Decimal (13,3)

Currently not in use.

Quantity

Decimal (13,3)

Currently not in use.

Stock movement in

Decimal (13,3)

In this field, the quantity of incoming goods by stock movement is stored.

Stock movement out

Decimal (13,3)

In this field, the quantity of outgoing goods by stock movement is stored.

Gain Inventory

Decimal (13,3)

In this field, the quantity of the stock item resulting from an inventory gain is stored.

Inventory Loss

Decimal (13,3)

In this field, the quantity of the stock item resulting from an inventory loss is stored.

Shrinkage

Decimal (13,3)

In this field, the quantity of the stock item resulting from Shrinkage is stored.

Outgoing Sales

Decimal (13,3)

In this field, the quantity of the stock item resulting from sales is stored.

Value Incoming Goods

Decimal (13,3)

In this field, the value of the delivered incoming goods for this stock item is stored.

Value Outgoing Goods

Decimal (13,3)

In this field, the value of the delivered outgoing goods for this stock item is stored.

Value Incoming Production

Decimal (13,3)

In this field, the value of the incoming goods produced in the own company is stored.

Value Outgoing Production

Decimal (13,3)

In this field, the value of the outgoing goods produced in the company is stored.

Incoming Dissection

Decimal (13,3)

Currently not in use.

Outgoing Dissection

Decimal (13,3)

Currently not in use.

Incoming Shift Values

Decimal (13,3)

In this field, the value of the incoming goods resulting from shifts is stored.

Outgoing Shift Values

Decimal (13,3)

In this field, the value of the outgoing goods resulting from shifts is stored

Gain Inventory Value

Decimal (13,3)

In this field, the value of the stock item resulting from inventory gain is stored.

Inventory Loss Value

Decimal (13,3)

In this field, the value of the stock item resulting from inventory loss is stored.

Shrinkage Value

Decimal (13,3)

In this field, the value of the stock item resulting from Shrinkage is stored.

Outgoing Sales Value

Decimal (13,3)

In this field, the value of the stock item resulting from sales is stored.

Cost Item

Decimal (13,3)

In this field, the value of the stock item resulting from Cost Item sales is stored.

Last Stock Quantity

Decimal (10,0)

In this field, the quantity of the stock item after the inventory is stored.

Last Stock Value

Decimal (13,3)

In this field, the value of the stock item after the inventory is stored.

Outgoing Calculated Cost Price

Decimal (13,3)

In this field, the value (Calc. cost price) for this stock item resulting from sales is stored.

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany