Home > Technical > Table Definitions > STATDEPT
This table contains sales, purchases and other miscellaneous
statistics at a department/category/group level. The details
statistics is held in STATITEM.
See also STATBUCKET.
Both STATDEPT and STATITEM show their heritage. There are a lot of
fields that are no longer used or updated. You can use these fields
for your own purposes. Fields that are updated by the system or can
be entered with a program are marked as such, for example
curSales.
| Column | Type | Description |
| STRYEARWEEK | VARCHAR(7) | The period
in which the statistics were collected.
STATSPER.strYearWeek
|
| STRSTORECODE | VARCHAR(10) | The trading
unit these statistics are for.
TRADUNIT.strTradeCode
|
| STRDEPTCODE | VARCHAR(10) | The
department the statistics belong to.
DEPT.strDeptCode
|
| STRCATCODE | VARCHAR(10) | The
department the statistics belong to.
CATEGORY.strCatCode
|
| STRGROUPCODE | VARCHAR(10) | The
department the statistics belong to.
GROUPS.strGroupCode
|
| STRMANUFACTURER | VARCHAR(10) | The manufacturer the statistics belong to. This is always *TOT*. Manufacturer statistics should be obtained from STATITEM. |
| DBLQTYSOLD | DECIMAL(19,4) | Number of units sold. Updated by system. |
| CURCOGS | DECIMAL(19,4) | Cost of Goods Sold. Updated by system. |
| CURSALES | DECIMAL(19,4) | Sales revenue. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURPLANSALES | DECIMAL(19,4) | Planned sales revenue. |
| LINTCUSTOMERS | INT | Number of customers who purchased items from this department. Updated by system. |
| CURTOTALWAGES | DECIMAL(19,4) | Total wages. Can be entered using Statistics Entry. |
| CUROTWAGES | DECIMAL(19,4) | Overtime wages. Can be entered using Statistics Entry. |
| CURFTWAGES | DECIMAL(19,4) | Fulltime wages. Can be entered using Statistics Entry. |
| CURPTWAGES | DECIMAL(19,4) | Parttime wages. Can be entered using Statistics Entry. |
| DBLLABOURHRSTOTAL | DECIMAL(19,4) | Labour hours. Can be entered using Statistics Entry. |
| DBLLABOURHRSOT | DECIMAL(19,4) | Overtime labour hours. Can be entered using Statistics Entry. |
| DBLLABOURHRSFT | DECIMAL(19,4) | Fulltime labour hours. Can be entered using Statistics Entry. |
| DBLLABOURHRSPT | DECIMAL(19,4) | Parttime labour hours. Can be entered using Statistics Entry. |
| CURPLANWAGESTOTAL | DECIMAL(19,4) | Planned total wages. |
| DBLPLANHRSTOTAL | DECIMAL(19,4) | Planned total labour hours. |
| DBLPLANHRSOT | DECIMAL(19,4) | Planned overtime labour hours. |
| DBLPLANHRSFT | DECIMAL(19,4) | Planned fulltime labour hours. |
| DBLPLANHRSPT | DECIMAL(19,4) | Planned parttime labour hours. |
| CURWORKCOMP | DECIMAL(19,4) | Workers’ compensation expenses. |
| CURFREIGHT | DECIMAL(19,4) | Freight expenses. Can be entered using Statistics Entry. |
| CURMARKDOWN | DECIMAL(19,4) | Markdown expenses. Can be entered using Statistics Entry. |
| CURDAMAGE | DECIMAL(19,4) | Damages expenses. Updated by system. |
| CURCASHSHORTOVER | DECIMAL(19,4) | Cash short/over expenses. Updated by system. |
| CURCASHTENDER | DECIMAL(19,4) | Cash tendered at POS register. |
| CUREFTTENDER | DECIMAL(19,4) | EFT tendered at POS register. |
| CURCHEQUETENDER | DECIMAL(19,4) | Cheques tendered at POS register. |
| CURBAGSWRAP | DECIMAL(19,4) | Bags & Wrap expenses. Can be entered using Statistics Entry. |
| CURPURCHASES | DECIMAL(19,4) | Value of stock purchases. Updated by system. |
| DBLQTYPURCHASED | DECIMAL(19,4) | Number of units purchased. Updated by system. |
| INTTROLLEYCOUNT | SMALLINT | Number of trolleys. Can be entered using Statistics Entry. |
| CUROFFINVOICEDEAL | DECIMAL(19,4) | Total value of off-invoice deals. |
| CURCLAIMDEAL | DECIMAL(19,4) | Total value of claims. |
| CURTERMS | DECIMAL(19,4) | Total value of terms. Updated by system (when rebates are claimed). |
| DBLPLANQTYHR | DECIMAL(19,4) | Planned quantity sold/labour hour. |
| CURPLANLABOURCOST | DECIMAL(19,4) | Planned labour cost. |
| CURAVGSALE | DECIMAL(19,4) | Average sale price per unit. |
| CURSTAFFDISCOUNT | DECIMAL(19,4) | Staff discount expenses. |
| CURDISCOUNT | DECIMAL(19,4) | Discount expenses. |
| CURSHRINKAGE | DECIMAL(19,4) | Shrinkage expenses. Updated by system. |
| CURINSTOREDEALS | DECIMAL(19,4) | Value of instore deals. |
| CURSERVICEFEE | DECIMAL(19,4) | Service fee expenses. |
| CURWAREHOUSEREBATE | DECIMAL(19,4) | Value of warehouse rebates. |
| CURREBATE | DECIMAL(19,4) | Value of other rebates. |
| CURSTOCKTAKEADJ | DECIMAL(19,4) | Value of stocktake adjustment. |
| CUROTHERADJ | DECIMAL(19,4) | Other adjustment expenses. |
| CURGROSSPURCHASES | DECIMAL(19,4) | Gross value of purchases. Updated by system. |
| CURROUNDING | DECIMAL(19,4) | Value of rounding. |
| CURCOOPAMT | DECIMAL(19,4) | Value of promotional coops. |
| CURREPORTSALES | DECIMAL(19,4) | Sales as reported by the store. |
| CURREPORTCOGS | DECIMAL(19,4) | COGS as reported by the store. |
| CURPHYSICALOPENSTOCK | DECIMAL(19,4) | Physical opening stock for the period. |
| CURPHYSICALCLOSESTOCK | DECIMAL(19,4) | Physical closing stock for the period. Updated by system. |
| CURSPECIALSALES | DECIMAL(19,4) | Sales revenue for items on promotion. |
| CURSPECIALCOGS | DECIMAL(19,4) | COGS for items on promotion. |
| CURGP | DECIMAL(19,4) | GP dollars. |
| CURREPORTGP | DECIMAL(19,4) | GP dollars as reported by the store. |
| CURREPORTPURCHASES | DECIMAL(19,4) | Estimated purchases as reported by the store. |
| CURREPORTADJPURCHASES | DECIMAL(19,4) | Difference between actual and estimated purchases for the period. |
| CURREPORTTOTPURCHASES | DECIMAL(19,4) | This weeks estimated plus last weeks adjustment. |
| CURLEDGERCLOSESTOCK | DECIMAL(19,4) | Closing stock according to the ledger. |
| CURPCCLOSESTOCK | DECIMAL(19,4) | Closing stock according to the computer. |
| DBLSTOREPCMARGIN | DECIMAL(19,4) | The sales margin according to the store’s computer. |
| CURLIQUORLICENCE | DECIMAL(19,4) | Liquor licence fees for the period. |
| DBLREPORTQTYSOLD | DECIMAL(19,4) | Units sold as reported by the store. |
| DBLREPORTQTYPURCHASED | DECIMAL(19,4) | Units purchased as reported by the store. |
| CURNETPROFIT | DECIMAL(19,4) | The net profit (gross profit less expenses). |
| CURREPORTNETPROFIT | DECIMAL(19,4) | The net profit as reported by the store. |
| CURREPORTSPECIALSALES | DECIMAL(19,4) | The sales for items on promotion as reported by the store. |
| CURREPORTSPECIALCOGS | DECIMAL(19,4) | The COGS for items on promotion as reported by the store. |
| CURPACKAGING | DECIMAL(19,4) | Packaging expense. |
| CURINGREDIENTS | DECIMAL(19,4) | Ingredients expense. |
| CURCASUALWAGES | DECIMAL(19,4) | Casual labour wages. Can be entered using Statistics Entry. |
| DBLLABOURHRSCASUAL | DECIMAL(19,4) | Casual labour hours. Can be entered using Statistics Entry. |
| DBLPLANHRSCASUAL | DECIMAL(19,4) | Planned casual labour hours. |
| DBLPLANGPPER | DECIMAL(19,4) | Planned GP percent |
| CURCOMPETITIONADJ | DECIMAL(19,4) | Adjustment to prices because of competition. |
| CURTRANSFER | DECIMAL(19,4) | The value of stock transferred. Updated by system. |
| CURMANAGEMENTWAGES | DECIMAL(19,4) | The value of management wages. |
| DBLLABOURHRSMANAGEMENT | DECIMAL(19,4) | The number of management hours worked. |
| DBLPLANHRSMANAGEMENT | DECIMAL(19,4) | The planned number of management labour hours. |
| CURONCOSTS | DECIMAL(19,4) | The costs associated with wages. |
| CURPLANONCOSTS | DECIMAL(19,4) | The planned costs associated with wages. |
| CURSALES1 | DECIMAL(19,4) | The sales on the first day of the period. curSales is the total of sales within the period. Although not normalised, provides a useful means of showing trends within a week and easily accumulating sales for a day of week. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES2 | DECIMAL(19,4) | The sales on the second day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES3 | DECIMAL(19,4) | The sales on the third day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES4 | DECIMAL(19,4) | The sales on the fourth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES5 | DECIMAL(19,4) | The sales on the fifth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES6 | DECIMAL(19,4) | The sales on the sixth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
| CURSALES7 | DECIMAL(19,4) | The sales on the seventh day of the period. If using GST Tax System, then this amount is GST exclusive. |
| CURCOGS1 | DECIMAL(19,4) | The COGS on the first day of the period. Updated by system. |
| CURCOGS2 | DECIMAL(19,4) | The COGS on the second day of the period. Updated by system. |
| CURCOGS3 | DECIMAL(19,4) | The COGS on the third day of the period. Updated by system. |
| CURCOGS4 | DECIMAL(19,4) | The COGS on the fourth day of the period. Updated by system. |
| CURCOGS5 | DECIMAL(19,4) | The COGS on the fifth day of the period. Updated by system. |
| CURCOGS6 | DECIMAL(19,4) | The COGS on the sixth day of the period. Updated by system. |
| CURCOGS7 | DECIMAL(19,4) | The COGS on the seventh day of the period. Updated by system. |
| DBLQTYSOLD1 | DECIMAL(19,4) | The quantity sold of the first day of the period. Updated by system. |
| DBLQTYSOLD2 | DECIMAL(19,4) | The quantity sold of the second day of the period. Updated by system. |
| DBLQTYSOLD3 | DECIMAL(19,4) | The quantity sold of the third day of the period. Updated by system. |
| DBLQTYSOLD4 | DECIMAL(19,4) | The quantity sold of the fourth day of the period. Updated by system. |
| DBLQTYSOLD5 | DECIMAL(19,4) | The quantity sold of the fifth day of the period. Updated by system. |
| DBLQTYSOLD6 | DECIMAL(19,4) | The quantity sold of the sixth day of the period. Updated by system. |
| DBLQTYSOLD7 | DECIMAL(19,4) | The quantity sold of the seventh day of the period. Updated by system. |
| INTCUSTOMERS1 | INT | The number of customers on the first day of the period. Updated by system. |
| INTCUSTOMERS2 | INT | The number of customers on the second day of the period. Updated by system. |
| INTCUSTOMERS3 | INT | The number of customers on the third day of the period. Updated by system. |
| INTCUSTOMERS4 | INT | The number of customers on the fourth day of the period. Updated by system. |
| INTCUSTOMERS5 | INT | The number of customers on the fifth day of the period. Updated by system. |
| INTCUSTOMERS6 | INT | The number of customers on the sixth day of the period. Updated by system. |
| INTCUSTOMERS7 | INT | The number of customers on the seventh day of the period. Updated by system. |
| CURPROMOTIONS | DECIMAL(19,4) | Promotional expenses. |
| CURCORPRECOVERY | DECIMAL(19,4) | Corporate recovery expenses. |
| CURDELETEDLINES | DECIMAL(19,4) | Deleted lines expense. |
| CURMANAGEMENTLOSS | DECIMAL(19,4) | Management loss expense. |
| CURINDIRECT | DECIMAL(19,4) | Indirect expenses |
| CURBRNCEXP | DECIMAL(19,4) | Branch NC Expenses |
| CURBRDIRECTEXP | DECIMAL(19,4) | Branch direct expenses |
| CURBRINDIRECTEXP | DECIMAL(19,4) | Branch indirect expenses |
| CURBRCONTPROFIT | DECIMAL(19,4) | Branch contribution to profit |
| CURHOEXP | DECIMAL(19,4) | Head office expenses |
| CURPCSTOCKRETAIL | DECIMAL(19,4) | The retail value of stock. |
| DBLPCSTOCKQTY | DECIMAL(19,4) | The quantity of stock. |
| CTRCODE | BIGINT | A unique number assigned by the system. |
| DBLLITRESSOLD | DECIMAL(19,4) | The number of litres sold. |
| DBLKILOSSOLD | DECIMAL(19,4) | The number of kilos sold. |
| DBLCARTONSSOLD | DECIMAL(19,4) | The number of cartons sold. |
| DBLLITRESPURCHASED | DECIMAL(19,4) | The number of litres purchased. |
| DBLKILOSPURCHASED | DECIMAL(19,4) | The number of kilos purchased. |
| DBLCARTONSPURCHASED | DECIMAL(19,4) | The number of cartons purchased. |
| CURTAXAMT | DECIMAL(19,4) | The amount of tax charged on sales (prior to 2003.1 this was DAILYSALES.curTaxAmt1+curTaxAmt2+curTaxAmt3). It is now equivalent to curTaxAmt2. (GST) Updated by system. |
| CURGIFTCERTSSOLD | DECIMAL(19,4) |
|
| CURABUSEDSTOCK | DECIMAL(19,4) |
|
| CURCNSOLD | DECIMAL(19,4) |
|
| CURORDERSTHISPERIOD | DECIMAL(19,4) |
|
| CURLAYBYSTHISPERIOD | DECIMAL(19,4) |
|
| CURCODSTHISPERIOD | DECIMAL(19,4) |
|
| CURQUOTESTHISPERIOD | DECIMAL(19,4) |
|
| CURORDERSOUTSTANDING | DECIMAL(19,4) |
|
| CURLAYBYSOUTSTANDING | DECIMAL(19,4) |
|
| CURCODSOUTSTANDING | DECIMAL(19,4) |
|
| CURQUOTESOUTSTANDING | DECIMAL(19,4) |
|
| CURTAXAMT1 | DECIMAL(19,4) | Sum of DAILYSALES.curTaxAmt1. Updated by system. |
| CURTAXAMT3 | DECIMAL(19,4) | Sum of DAILYSALES.curTaxAmt3. Updated by system. |
| CURPURCHASETAX | DECIMAL(19,4) | Tax paid on purchases. Updated by system. |
| CURITEMDISC | DECIMAL(19,4) | Value of item discounts including tax. Updated by system. |
| CUROFFERDISC | DECIMAL(19,4) | Value of offer discounts including tax. Updated by system. |
| CURSALEDISC | DECIMAL(19,4) | Value of sale discounts including tax. Updated by system. |
| CURTENDERDISC | DECIMAL(19,4) | Value of tender discounts including tax. Updated by system. |
| CURITEMDISCEX | DECIMAL(19,4) | Value of item discounts excluding tax. Updated by system. |
| CUROFFERDISCEX | DECIMAL(19,4) | Value of offer discounts excluding tax. Updated by system. |
| CURSALEDISCEX | DECIMAL(19,4) | Value of sale discounts excluding tax. Updated by system. |
| CURTENDERDISCEX | DECIMAL(19,4) | Value of tender discounts excluding tax. Updated by system. |
| DBLSHRINKAGE | DECIMAL(19,4) | The quantity of units adjusted in a stocktake. Updated by system. |
| DBLDAMAGE | DECIMAL(19,4) | The quantity of units adjusted in stock adjustment. Updated by system. |
|
DBLTRANSFER |
DECIMAL(19,4) |
The net quantity of units adjusted in transfers. Updated by system. |
|
CURRETURNSALES |
DECIMAL(19,4) |
The value of item returns (similar to curSales). |
|
DBLRETURNQTYSOLD |
DECIMAL(19,4) |
The quantity of items returns (similar to dblQtySold). |
|
DBLRETURNCOGS |
DECIMAL(19,4) |
The COGS of returns (similar to curCOGS). |
|
DBLRETURNTAXAMT1 |
DECIMAL(19,4) |
The tax amount of returns (similar to curTaxAmt1). |
|
DBLRETURNTAXAMT2 |
DECIMAL(19,4) |
The tax amount of returns (similar to curTaxAmt1). |
|
DBLRETURNTAXAMT3 |
DECIMAL(19,4) |
The tax amount of returns (similar to curTaxAmt1). |
|
CUREXCHANGESALES |
DECIMAL(19,4) |
The value of item exchanges (similar to curSales). |
|
DBLEXCHANGEQTYSOLD |
DECIMAL(19,4) |
The quantity of items exchanges (similar to dblQtySold). |
|
DBLEXCHANGECOGS |
DECIMAL(19,4) |
The COGS of exchanges (similar to curCOGS). |
|
DBLEXCHANGETAXAMT1 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
|
DBLEXCHANGETAXAMT2 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
|
DBLEXCHANGETAXAMT3 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
|
CURPAIDIN |
DECIMAL(19,4) |
The value of paid in transactions. |
|
CURPAIDOUT |
DECIMAL(19,4) |
The value of paid out transactions. |
|
INTTRANSCOUNT |
INTEGER |
The number of transactions. |
Primary Key: CTRCODE
Note that the main key is strYearWeek +strStoreCode +strDeptCode +strCatCode +strGroupCode +strManufacturer. The ctrCode is used as the primary index for performance reasons only.
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |