Home > Technical > Table Definitions > STATITEM
This table contains sales, purchases and other miscellaneous statistics at an item level. The summary statistics are held in STATDEPT. 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
category the statistics belong to. CATEGORY.strCatCode |
STRGROUPCODE | VARCHAR(10) | The group
the statistics belong to. GROUPS.strGroupCode |
LINTITEMNUMBER | INT | The IPN of
the item this statistics are for. ITEM.lintItemNumber |
STRMANUFACTURER | VARCHAR(10) | The
manufacturer the statistics belong to. SUPPLIER.strSupplierCode |
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. Updated by system. |
STRPROMOTYPE | VARCHAR(10) | The type of promotion, if any, during this statistics period. |
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). |
CURPURCHASES | DECIMAL(19,4) | Value of stock purchases. Updated by system. |
DBLQTYPURCHASED | DECIMAL(19,4) | Number of units purchased. Updated by system. |
CURGROSSPURCHASES | DECIMAL(19,4) | Gross value of purchases. Updated by system. |
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. Updated by system. |
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. |
CURPCCLOSESTOCK | DECIMAL(19,4) | The value of the stock based on last invoice cost. |
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. This is calculating by looking up RANGE.dblUnitVolume and multiplying it by the dblQtySold. If the item is a linked item then this amount is multipled by ITEM.dblLinkedQty. A trigger on the table does this automatically. |
DBLKILOSSOLD | DECIMAL(19,4) | The number of kilos sold. This is calculating by looking up RANGE.dblUnitWeight and multiplying it by the dblQtySold. If the item is a linked item then this amount is multipled by ITEM.dblLinkedQty. A trigger on the table does this automatically. |
DBLCARTONSSOLD | DECIMAL(19,4) | The number of cartons sold. This is calculated by dividing the dblQtySold by the STORERNG.intCartonSize. A trigger on the table does this automatically. |
DBLLITRESPURCHASED | DECIMAL(19,4) | The number of litres purchased. This is calculating by looking up RANGE.dblUnitVolume and multiplying it by the dblQtyPurchased. If the item is a linked item then this amount is multipled by ITEM.dblLinkedQty. A trigger on the table does this automatically. |
DBLKILOSPURCHASED | DECIMAL(19,4) | The number of litres purchased. This is calculating by looking up RANGE.dblUnitWeight and multiplying it by the dblQtyPurchased. If the item is a linked item then this amount is multipled by ITEM.dblLinkedQty. A trigger on the table does this automatically. |
DBLCARTONSPURCHASED | DECIMAL(19,4) | The number of cartons purchased. This is calculated by dividing the dblQtyPurchased by the STORERNG.intCartonSize. A trigger on the table does this automatically. |
STRSUBGROUPCODE | VARCHAR(10) | The
subgroup the statistics belong to. This has not been included as
part of the key and summary levels in STATDEPTare not available.
Instead STATITEM records must be summed to get the total for a
subgroup. SUBGROUP.strSubGroupCode |
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. |
STRORDERCODE | VARCHAR(20) | The order code of the item |
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 |
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. |
CURSHRINKAGE | DECIMAL(19,4) | The value of adjustments in a stocktake. Updated by system. |
CURDAMAGE | DECIMAL(19,4) | The value of stock adjustments. Updated by system. |
CURTRANSFER | DECIMAL(19,4) | The net value of transfers. Updated by system. |
INTTRIPID | INT | The trip id, if any, to which the statistics belong. |
LINTCUSTOMERS | INT | The number of customers. 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. |
STRSUPPLIERCODE | VARCHAR(10) | The
manufacturer the statistics belong to. SUPPLIER.strSupplierCode |
STRROUTECODE |
VARCHAR(10) |
The route to which the statistic belong. |
INTSHIFTCODE |
INTEGER |
The shift to which this stats record belongs. |
INTSALESMETHOD |
INTEGER |
The sales method to which this stats record belongs. |
CURRETURNSALES |
DECIMAL(19,4) |
The value of item returns (similar to curSales). |
DBLRETURNQTYSOLD |
DECIMAL(19,4) |
The quantity of items returns (similar to dblQtySold). |
CURRETURNCOGS |
DECIMAL(19,4) |
The COGS of returns (similar to curCOGS). |
CURRETURNTAXAMT1 |
DECIMAL(19,4) |
The tax amount of returns (similar to curTaxAmt1). |
CURRETURNTAXAMT2 |
DECIMAL(19,4) |
The tax amount of returns (similar to curTaxAmt1). |
CURRETURNTAXAMT3 |
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). |
CUREXCHANGECOGS |
DECIMAL(19,4) |
The COGS of exchanges (similar to curCOGS). |
CUREXCHANGETAXAMT1 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
CUREXCHANGETAXAMT2 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
CUREXCHANGETAXAMT3 |
DECIMAL(19,4) |
The tax amount of exchanges (similar to curTaxAmt1). |
INTTRANSCOUNT |
INTEGER |
The number of transactions. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |