Home > Technical > Table Definitions > STATITEM

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.

SHIFTCODE.intCode

INTSALESMETHOD

INTEGER

The sales method to which this stats record belongs.

SALESMETHOD.intCode

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)