Home > Technical > Table Definitions > OPERATORSTATS
A summary record containing details about specific users for a statistics period.
Column |
Type |
Description |
INTUSERCODE |
INTEGER |
The user the stats are for.
|
STRYEARWEEK |
VARCHAR(7) |
The period the stats are for. |
STRTRADECODE |
VARCHAR(5) |
The location that the stats are for. |
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) |