Home > Technical > Table Definitions > ITEM

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

LINTITEMNUMBER

INT

IPN of the item. This is a unique number assigned by the system.
RANGE.lintItemNumber

STRPOS12DESCRIPTION

VARCHAR(12)

Short POS description.

STRPOS20DESCRIPTION

VARCHAR(20)

Long POS description

STRDEPTCODE

VARCHAR(10)

The department code to which the item belongs.
link.gif (858 bytes) DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

The category code to which the item belongs.
link.gif (858 bytes) CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

The group code to which the item belongs.
link.gif (858 bytes) GROUPS.strGroupCode

STRCLASSCODE

VARCHAR(10)

The classification code to which the item belongs. 
link.gif (858 bytes) CLASS.strClassCode

STRUNITOFMEASURE

VARCHAR(10)

The unit of measure to which the item belongs.
link.gif (858 bytes) UNITOFMEASURE.strUnitOfMeasure

STRTAXCODE

VARCHAR(10)

No longer used.

STRLIQUORTAXCODE

VARCHAR(10)

No longer used.

STRFAMILYCODE

VARCHAR(10)

The family code to which the item belongs. .
link.gif (858 bytes) FAMILY.strFamilyCode

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.

STRLABEL

VARCHAR(10)

The normal label required for this item.
link.gif (858 bytes) LABEL.strLabelCode

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.

MEMCOMMENTS

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.

DBLLINKEDQTY

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.

STRPRODUCTBRANDNAME

VARCHAR(30)

The brandname of the item.

STRPRODUCTDESCRIPTION

VARCHAR(30)

The description of the item.

STRPRODUCTVARIETY

VARCHAR(30)

The colour/variety of the item.

link.gif (858 bytes) ITEMDESCDTL and ITEMDESCHDR.

STRPRODUCTSIZE

VARCHAR(10)

The size of the item.

link.gif (858 bytes) VALIDDESC.

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.
link.gif (858 bytes) MEDIACLP.ctrCode

LINTTICKETCLIP2

INT

Points to a media clip that can be printed on a ticket.
link.gif (858 bytes) MEDIACLP.ctrCode

LINTTICKETCLIP3

INT

Points to a media clip that can be printed on a ticket.
link.gif (858 bytes) MEDIACLP.ctrCode

LINTTICKETCLIP4

INT

Points to a media clip that can be printed on a ticket.
link.gif (858 bytes) MEDIACLP.ctrCode

LINTTICKETCLIP5

INT

Points to a media clip that can be printed on a ticket.
link.gif (858 bytes) MEDIACLP.ctrCode

LINTINFOCLIP

INT

Points to a media clip that can be played on the Boothplayer or DynaPOS.
link.gif (858 bytes) MEDIACLP.ctrCode

MEMNOTES

TEXT

Notes about the item for head office.

STRTICKETTYPE

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.

STRSUBGROUPCODE

VARCHAR(10)

SubGroup code item belongs in.
link.gif (858 bytes) SUBGROUP.strSubGroupCode

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.
link.gif (858 bytes) MEDIACLP.ctrCode

STRDELIVERYCODE

VARCHAR(10)

The delivery type applicable to this item.
link.gif (858 bytes) DELIVERYCHARGE.strCode

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.
link.gif (858 bytes) VALIDDESC.strDescription

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.

NONE  

The item will not be included in any suggested orders.

MINMAXAUTO  

The system will use min/max stock quantities to determine the quantity of stock to order. The min/max quantities will be automatically updated by the EOD Suggest Stock Levels process.

MINMAXMANUAL  

The system will use min/max stock quantities to determine the quantity of stock to order. The item will NOT be processed when the EOD Suggest Stock Levels process is run.

REPLACE  

The system will replace the quantity sold since the last order.

MANUAL  

The item will be included on any manual suggested transactions and the user will need to specify the quantity to order.

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.

link.gif (858 bytes) ORDERCATEGORY.strCode

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.
F No tracking
B Batch number tracking only
T Track system generated serial numbers
S Track supplier generated serial numbers.
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.

link.gif (858 bytes) KITCHENCODE.strCode

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

link.gif (858 bytes)  ITEMCODES.strCode

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
1 = Warehouse
2 = Supplier

STRPERWEIGHTCODE

VARCHAR(10)

When using the price per unit feature on tickets, this is the pricing unit, for example 100GM.

link.gif (858 bytes) UNITOFMEASURE.strUnitOfMeasure

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.

link.gif (858 bytes) VALIDDESC.

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
1 = Analogue Colour Set
2 = Digital Colour Set
3 = VCR
4 = PCTV
5 = TV Card
6 = Set Top Box
7 = DVD Recorders

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
Vision
Dental
Prescription
Generic

YSNPROMPTCOMMENT

VARCHAR(1)

 

 

Primary Key: LINTITEMNUMBER

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)