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) |
USERCODE.intUserCode