Supplier Turnover (SupplTurnMix)

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

  1. Suppliers / Company (SuTurnComp)
  2. Suppliers / Branch (SuTurnBranch)

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


Delivery Value

Decimal (13,3)

Net value of the deliveries.


Deliveries

Number 0 - 99999999

Number of deliveries.


Quantity of Orders

Number 0 - 99999999

Number of orders.


Quantity of Returns

Number 0 - 99999999

Number of Returns.


Quantity of wrong Deliveries

Number 0 - 99999999

Currently not in use.


Quantity of damaged Deliveries

Number 0 - 99999999

Currently not in use.


Delayed Deliveries  

Number 0 - 99999999

Currently not in use.


Value of Cash Discount

Decimal (13,3)

Turnover cash discount.


Value of Turnover Discount

Decimal (13,3)

Value of the turnover discounts.


Value of Quantity Discount

Decimal (13,3)

Value of the quantity discounts.


Value of Discounts in Kind

Decimal (13,3)

Value of the received discounts in kind.


Value of Delivery Costs

Decimal (13,3)

Value of the delivery costs.


Value of Pick up Costs

Decimal (13,3)

Value of the pick up costs.


Average Delivery Time

Number 0 - 9999

Average delivery time of the supplier.


MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany