Home > Technical > Table Definitions > OPERATORSTATS

OPERATORSTATS

A summary record containing details about specific users for a statistics period.

Column

Type

Description

INTUSERCODE

INTEGER

The user the stats are for.

USERCODE.intUserCode

STRYEARWEEK

VARCHAR(7)

The period the stats are for.

STATSPER.strYearWeek

STRTRADECODE

VARCHAR(5)

The location that the stats are for.

TRADUNIT.strTradeCode

CURSALES

DECIMAL(15,4)

The total value of sales.

INTSALES

INTEGER

The number of sales made.

INTCOUNTRETURNS

INTEGER

The number of returns made.

INTCOUNTCASHLIFT

INTEGER

The number of cash lifts/loans made.

INTCOUNTEXCHANGE

INTEGER

The number of exchanges made.

INTCOUNTCARD

INTEGER

The number of account payments made.

INTCOUNTNOSALES

INTEGER

The number of no sales made.

INTCOUNTCANCELLEDSALES

INTEGER

The number of cancelled sales made.

INTCOUNTREFUNDS

INTEGER

The number of refunds made.

INTCOUNTPAIDIN

INTEGER

The number of paid in/out.

DBLQTYSOLD

DECIMAL(15,4)

The total units sold.

CURDISCOUNT

DECIMAL(15,4)

The total value of discounts given.

CURCOGS

DECIMAL(15,4)

The total COGS sold.

DBLFULLTIMEHRS

DECIMAL(15,4)

The total fulltime hours worked.

DBLPARTTIMEHRS

DECIMAL(15,4)

The total part time hours worked.

DBLCASUALTIMEHRS

DECIMAL(15,4)

The total casual hours worked.

DBLOVERTIMEHRS

DECIMAL(15,4)

The total overtime hours worked.

INTCOUNTLAYBYS

INTEGER

 

INTCOUNTCODS

INTEGER

 

INTCOUNTORDERS

INTEGER

 

INTCOUNTQUOTES

INTEGER

 

INTCOUNTCANCELLEDLAYBYS

INTEGER

 

INTCOUNTCANCELLEDCODS

INTEGER

 

INTCOUNTCANCELLEDORDERS

INTEGER

 

INCOUNTCOMPLETELAYBYS

INTEGER

 

INCOUNTCOMPLETECODS

INTEGER

 

INTCOUNTCOMPLETEORDERS

INTEGER

 

CURTAXAMT1

DECIMAL

 

CURTAXAMT2

DECIMAL

 

CURTAXAMT3

DECIMAL

 

CURTENDERED

DECIMAL

 

CURDISCOUNTEXTAX

DECIMAL

 

DBLTILLINGHOURS

DECIMAL

 

INTSALELINES

INTEGER

 

INTSALESMETHOD

INTEGER

 

INTSHIFTCODE

INTEGER

 

INTTRIPID

INTEGER

 

STRTABLE

VARCHAR

 

CURSPLITSALES

DECIMAL(19,4)

 

CURSPLITDISCOUNT

DECIMAL(19,4)

 

DBLSPLITQTYSOLD

DECIMAL(19,4)

 

CURSPLITTAXAMT1

DECIMAL(19,4)

 

CURSPLITTAXAMT2

DECIMAL(19,4)

 

CURSPLITTAXAMT3

DECIMAL(19,4)

 

CURSPLITTENDERED

DECIMAL(19,4)

 

CURSPLITDISCOUNTEXTAX

DECIMAL(19,4)

 

DBLSPLITSALES

DECIMAL(19,4)

 

DBLCOUNTSPLITSALES

DECIMAL(19,4)

 

DBLCOUNTSPLITRETURNS

DECIMAL(19,4)

 

 

Primary Key: INTUSERCODE + STRYEARWEEK +STRTRADECODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)