Customer turnover (CustTurnMix)

The description below deals with the record layout for the abstract database table CustTurnMix which stores data for the following statistics:

  1. Cust.grp itemturn/branch = CGrArtTBrch
  2. Cust.grp itemturn/company = CGrArtTComp
  3. Cust.grp itemturn /prof.center = CGrArtTProC
  4. Cust.grp dept.turn/branch = CGrDeptTBrch
  5. Cust.grp dept.turn/company = CGrDeptTComp
  6. Cust.grp dept.turn/prof.center.= CGrDeptTProC
  7. Cust.grp turnover/branch = CGrpTurnBrch
  8. Cust.grp turnover/company = CGrpTurnComp
  9. Cust.grp turnover/prof.center =CGrpTurnProC
  10. Cust.type itemturn/branch= CTyArtTBrch
  11. Cust.type itemturn/company = CTyArtTComp
  12. Cust.type itemturn/prof.center CTyArtTProC
  13. Cust.type dept.turn/branch = CTyDeptTBrch
  14. Cust.type dept.turn/company = CTyDeptTComp
  15. Cust.type dept.turn/prof.center = CTyDeptTProC
  16. Cust.type turnover/branch = CTypTurnBrch
  17. Cust.type turnover/company = CTypTurnComp
  18. Cust.type turnover/prof. center = CTypTurnProC
  19. Customer itemturn/branch = CstArtTBrch
  20. Customer itemturn/company = CstArtTComp
  21. Customer itemturn/prof.center = CstArtTProC
  22. Customer dept.turn/branch = CstDeptTBrch
  23. Customer dept.turn/company = CstDeptTComp
  24. Customer dept.turn/prof.center = CstDeptTProC
  25. Customer turnover/branch = CustTurnBrch
  26. Customer turnover/company = CustTurnComp
  27. Customer turnover/prof.center = CustTurnProC

The description below deals with the field names, the data types and the field size as well as providing a short review of the field content.

Deliv.turnover

Decimal (12,2)

Total turnover of all article and department recordings.

Inv.turnover

Decimal (12,2)

Turnover of the invoice created.

Promotion turnover

Decimal (12,2)

Turnover share of promotions

No. of purchases

Number

Number of visits. The count advances by one per customer receipt.

No. of positions

Decimal (11,3)

Number of item recordings.

Disc./incr.

Decimal (12,2)

Turnover of price modifications (markup and markdown).

Cost val.

Decimal (12,2)

Total of calculated cost of goods. This value will only be shown if the article sold is a stock article if a calculated cost price exists or if the article is linked to a cost of goods price.

Percent 1

Decimal (20,2)

(Not in database)

Percent 2

Decimal (20,2)

(Not in database)

Percent 3

Decimal (20,2)

(Not in database)

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin