Home > Technical > Table Definitions > ITEM
An item is a product that we have decided to sell at one or more stores. It contains basic information such as description, classification, department, and so on. It does not contain cost or sell information which are stored in separate tables. A record must exist in the RANGE table for each ITEM record.
Column |
Type |
Description |
||||||||||
INT |
IPN of the item. This is a unique number assigned by the
system. |
|||||||||||
VARCHAR(12) |
Short POS description. |
|||||||||||
VARCHAR(20) |
Long POS description |
|||||||||||
VARCHAR(10) |
The department code to which the item belongs. |
|||||||||||
VARCHAR(10) |
The category code to which the item belongs. |
|||||||||||
VARCHAR(10) |
The group code to which the item belongs. |
|||||||||||
VARCHAR(10) |
The classification code to which the item belongs. |
|||||||||||
VARCHAR(10) |
The unit of measure to which the item belongs. |
|||||||||||
STRTAXCODE |
VARCHAR(10) |
No longer used. |
||||||||||
STRLIQUORTAXCODE |
VARCHAR(10) |
No longer used. |
||||||||||
VARCHAR(10) |
The family code to which the item belongs. . |
|||||||||||
STRCOMPETITION |
VARCHAR(10) |
Competition/grading code. This is free-format text, no actual codes used. |
||||||||||
YSNDISCOUNT |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCREDITCARD |
VARCHAR(1) |
No longer used. |
||||||||||
VARCHAR(10) |
The normal label required for this item. |
|||||||||||
DTMDATEENTERED |
DATETIME |
The date the record was created. |
||||||||||
YSNNEW |
VARCHAR(1) |
No longer used. It has been superseded by INTCHANGEFLAG |
||||||||||
YSNCHANGED |
VARCHAR(1) |
No longer used. It has been superseded by INTNEWFLAG |
||||||||||
YSNCHANGEAPN |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEBRAND |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGECATEG |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGECLASS |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGECOLOUR |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGECOMPETITION |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEDEPT |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEDESC |
VARCHAR(1) |
No longer used. It has been superseded by INTCHANGEDESC. |
||||||||||
YSNCHANGEFAMILY |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEGROUP |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEPOS12 |
VARCHAR(1) |
No longer used. It has been superseded by INTCHANGEPOS. |
||||||||||
YSNCHANGEPOS20 |
VARCHAR(1) |
No longer used. It has been superseded by INTCHANGEPOS. |
||||||||||
YSNCHANGESIZE |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGETAX |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGELIQUORTAX |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEUNITOFMEASURE |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGEDISCOUNT |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGECREDITCARD |
VARCHAR(1) |
No longer used. |
||||||||||
YSNCHANGELABEL |
VARCHAR(1) |
No longer used. |
||||||||||
DBLTAXRATE |
DECIMAL(19,4) |
No longer used. |
||||||||||
YSNCHANGETAXRATE |
VARCHAR(1) |
No longer used. |
||||||||||
TEXT |
General free-format comments about the item. |
|||||||||||
YSNCHANGECOMMENTS |
VARCHAR(1) |
No longer used. |
||||||||||
LINTLINKEDITEM |
INT |
The item this item is linked to. Link to lintItemNumber above. See dblLinkedQty below. If this item is not linked to another, this value will be the same as lintItemNumber above. |
||||||||||
DECIMAL(19,4) |
The number of the linked item contained in this item. For example, if this item was a six-pack of beer cans, it would be linked to the original single beer can and the quantity would be six. If the item is not linked to another item, this value is 1. |
|||||||||||
INTPOINTS |
INT |
No longer used. |
||||||||||
YSNCHANGEPOINTS |
VARCHAR(1) |
No longer used. |
||||||||||
YSNLINKPARENT |
VARCHAR(1) |
‘T’ if other items are linked to this item |
||||||||||
YSNRECIPEITEM |
VARCHAR(1) |
‘T’ if this is a recipe item. |
||||||||||
VARCHAR(30) |
The brandname of the item. |
|||||||||||
VARCHAR(30) |
The description of the item. |
|||||||||||
VARCHAR(30) |
The colour/variety of the item.
|
|||||||||||
VARCHAR(10) |
The size of the item. |
|||||||||||
STROTHERDESCRIPTION |
VARCHAR(50) |
The item description that will be sent to third-party venue systems. |
||||||||||
STROTHERSIZE |
VARCHAR(10) |
The item size that will be sent to third-party venue systems. |
||||||||||
STROTHERPOS |
VARCHAR(20) |
The item POS that will be sent to third-party venue systems. |
||||||||||
YSNCHANGEOTHER |
VARCHAR(1) |
No longer used. |
||||||||||
STRXREFCODE |
VARCHAR(20) |
If data has been converted from another system, this field can contain the original item number. |
||||||||||
INTTICKETREQUIRED |
INT |
The default number of tickets required for a new store. The same field exists in STORERNG which contains the actual number for a specific location. |
||||||||||
YSNKEEPSTOCKCOUNT |
VARCHAR(1) |
If 'T' then the system will keep track of stock on hand for the item (if using the stock programs). |
||||||||||
YSNACTIVE |
VARCHAR(1) |
No longer used. |
||||||||||
LINTTICKETCLIP1 |
INT |
Points to a media clip that can be printed on a ticket. |
||||||||||
LINTTICKETCLIP2 |
INT |
Points to a media clip that can be printed on a ticket. |
||||||||||
LINTTICKETCLIP3 |
INT |
Points to a media clip that can be printed on a ticket. |
||||||||||
LINTTICKETCLIP4 |
INT |
Points to a media clip that can be printed on a ticket. |
||||||||||
LINTTICKETCLIP5 |
INT |
Points to a media clip that can be printed on a ticket. |
||||||||||
LINTINFOCLIP |
INT |
Points to a media clip that can be played on the Boothplayer or
DynaPOS. |
||||||||||
MEMNOTES |
TEXT |
Notes about the item for head office. |
||||||||||
VARCHAR(2) |
Indicates the profitability of the item. This can then be printed on tickets to help layout stock. This is used as a default value for STORERNG.strTicketType when creating new records. |
|||||||||||
STRSELLADVICE |
VARCHAR(255) |
A comment from head office to advise where the item should be placed in a store for best sales. |
||||||||||
MEMCOMMENTS2 |
TEXT |
Similar to memComments, this is simply second set of comments available for the customer. For example, memComments might be tasting notes for wine and memComments2 is cellaring notes. |
||||||||||
INTWARRANTYMONTHS |
INT |
The number of months standard warranty available for the item. |
||||||||||
VARCHAR(10) |
SubGroup code item belongs in. |
|||||||||||
DBLHEIGHT |
DECIMAL(19,4) |
The height of a item in cms. |
||||||||||
DBLWIDTH |
DECIMAL(19,4) |
The width of the item in cms. |
||||||||||
DBLDEPTH |
DECIMAL(19,4) |
The depth of the item in cms. |
||||||||||
INTSPACEMANAGERCLIP |
INT |
A media clip containing a picture of the item which can be used
for space management software. |
||||||||||
STRDELIVERYCODE |
VARCHAR(10) |
The delivery type applicable to this item. |
||||||||||
LINTMANUFACTURERCLIP |
INT |
Not currently used. |
||||||||||
YSNPROPOSESELLEXCEPTION |
VARCHAR(1) |
If 'T' then no sell price will be proposed for this item when doing the end of day processing, 'F' otherwise. |
||||||||||
YSNCHANGETERMS |
VARCHAR(1) |
Not currently used. |
||||||||||
YSNCHARGECESS |
VARCHAR(1) |
'T' if CESS can be charged on this item. |
||||||||||
YSNCHARGESERVICE |
VARCHAR(1) |
'T' if service fee can be charged on this item. |
||||||||||
YSNDISCOUNTABLE |
VARCHAR(1) |
'T' if a discount can be given to this item. |
||||||||||
STRSEASONCODE |
VARCHAR(10) |
The season that the item belongs to, if any. |
||||||||||
STRYEARCODE |
VARCHAR(4) |
The season year that the item belongs to, if any. |
||||||||||
YSNPACKAGEITEM |
VARCHAR(1) |
'T' if this is a package item. Defaults to 'F'. |
||||||||||
DTMITEMRELEASE |
DATETIME |
The date the item was released. |
||||||||||
DTMITEMDELETED |
DATETIME |
Not used. |
||||||||||
YSNASKPOSCOMMENT |
VARCHAR(1) |
If 'T' then when the item is scanned at POS, the user will be asked for a comment about the item. |
||||||||||
ysnConsignment |
VARCHAR(1) |
'T' if the item is a consignment item. |
||||||||||
YSNTRANSFERITEM |
VARCHAR(1) |
'T' if item can be transferred into other items. 'F' otherwise. |
||||||||||
YSNWAREHOUSE |
VARCHAR(1) |
'T' if this item should be transferred from a warehouse (instead of being ordered directly from the supplier). |
||||||||||
STRORDERMETHOD |
VARCHAR(10) |
This is used by the system to determine how any suggested orders should be calculated (if any) for this item.
|
||||||||||
INTCHANGEFLAG | INT | An incrementing number that changes each time the item is changed. This can be used by EOD processes to determine which items have changed since the last time the EOD process was run. | ||||||||||
INTNEWFLAG | INT | Similar to INTCHANGEFLAG but indicates that the item is new. | ||||||||||
INTCHANGEPOS | INT | Similar to INTCHANGEFLAG but indicates that the POS description has been changed. | ||||||||||
INTCHANGEDESC | INT | Similar to INTCHANGEFLAG but indicates that the description has been changed. | ||||||||||
INTCHANGECOST | INT | Similar to INTCHANGEFLAG but indicates that cost or terms for the item have been changed. | ||||||||||
INTCHANGESELL | INT | Similar to INTCHANGEFLAG but indicates that sells for the item have been changed. | ||||||||||
STRORDERCATCODE | VARCHAR(10) | The order category to which the item belongs. It can be used as as selection criteria when determining items to be ordered. | ||||||||||
DBLALCOHOLPER | DECIMAL(10,4) | The percentage of alcohol this item contains. | ||||||||||
STRSPECIFICATION | VARCHAR(100) | A free format description containing the specification of the item. | ||||||||||
STRMANUFACTURERCOUNTRY | VARCHAR(100) | A free format description containing the manufacturer's country. | ||||||||||
STRFORMOFPRODUCT | VARCHAR(100) | A free format description containing a description about the shape of the item. | ||||||||||
STRENGLISHDESCRIPTION | VARCHAR(100) | A free format description containing the English description of the item. | ||||||||||
STRREGISTEREDTRADEMARK | VARCHAR(100) | A free format description containing any registered trademarks for the item. | ||||||||||
STRPRODUCTREFERENCE1 | VARCHAR(100) | A free format description containing a reference number for user-defined purposes. | ||||||||||
STRPRODUCTREFERENCE2 | VARCHAR(100) | A free format description containing a reference number for user-defined purposes. | ||||||||||
STRPRODUCTREFERENCE3 | VARCHAR(100) | A free format description containing a reference number for user-defined purposes. | ||||||||||
STRPRODUCTREFERENCE4 | VARCHAR(100) | A free format description containing a reference number for user-defined purposes. | ||||||||||
STRPRODUCTREFERENCE5 | VARCHAR(100) | A free format description containing a reference number for user-defined purposes. | ||||||||||
STRTRACKSERIALNUM | VARCHAR(1) | Indicates
the level of serial number tracking required.
|
||||||||||
strSize | VARCHAR(10) | An old field superseded by strProductSize. It may not exist in some databases. | ||||||||||
strColour | VARCHAR(30) | An old field superseded by strProductVariety. It may not exist in some databases. | ||||||||||
strItemDescription | VARCHAR(30) | An old field superseded by strProductDescription. It may not exist in some databases. | ||||||||||
strBrandName | VARCHAR(30) | An old field superseded by strProductBrandname. It may not exist in some databases. | ||||||||||
LINTSTOCKITEM | INT | The item that should have its stock decremented when this item is sold or adjusted. It will usually default to the lintItemNumber. | ||||||||||
STRKITCHENINSTRUCT | VARCHAR(20) | Any special instructions that should be printed on the kitchen printer for this item. | ||||||||||
STRKITCHENCODE | VARCHAR(10) | The kitchen code the item belongs to. This is used to control which items print to which kitchen printers. | ||||||||||
YSNSETMEAL | VARCHAR(1) | 'T' if this is a set meal item. | ||||||||||
YSNSETMEALALWAYSAVAIL | VARCHAR(1) | 'T' if the set meal is always available. If the set meal is only available at certain times, the flag will be 'F' and records will exist in SETMEALAVAILHDR tables to control when the set meal is available. | ||||||||||
STRITEMMENU |
VARCHAR(10) |
The menu that this item belongs to (if any). |
||||||||||
YSNASKDELIVERYITEM |
VARCHAR(1) |
If 'T' POS will ask how the item is to be delivered. |
||||||||||
INTDELIVERYSOURCE |
INTEGER |
This defines where the default delivery source of the item will be. 0 = Store |
||||||||||
STRPERWEIGHTCODE |
VARCHAR(10) |
When using the price per unit feature on tickets, this is the pricing unit, for example 100GM. |
||||||||||
DBLPERWEIGHTQTY |
DECIMAL(19,4) |
When using the price per unit feature on tickets, this is the number of pricing units in this item, for example how many times does 100GM go into this item? |
||||||||||
YSNALLOWOVERRIDE |
VARCHAR(1) |
If 'T' the store is allowed to override the price. |
||||||||||
YSNFOODSTAMP |
VARCHAR(1) |
Not currently used. |
||||||||||
YSNWIC |
VARCHAR(1) |
Not currently used. |
||||||||||
STRPRODUCTFIT |
VARCHAR(20) |
The product's fit description. |
||||||||||
YSNKIT |
VARCHAR(1) |
If 'T' the item is a kit item. |
||||||||||
STRTVLA |
VARCHAR(1) |
If the item needs to be used for TVLA reporting, this will contain a code indicating the type of TVLA item. 0 = Monochrome TV |
||||||||||
LINTSUBSTITUTEITEM |
INTEGER |
The item that can be used as a substitute for this item. |
||||||||||
STRLONGDESCRIPTION |
VARCHAR(200) |
A long description of the item which can be printed on the A4 receipt. |
||||||||||
STRTAREWEIGHTGROUPCODE |
VARCHAR(10) |
The tare weight group code. |
||||||||||
STRTAREWEIGHTPERCENTAGECODE |
VARCHAR(10) |
The tare weight percentage code. |
||||||||||
STRFSACATEGORY |
VARCHAR(20) |
To allow the configuration of an Flexible Spending Account Category for an item. Options are: Medical |
||||||||||
YSNPROMPTCOMMENT |
VARCHAR(1) |
|
Primary Key: LINTITEMNUMBER
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |