Home > Technical > Table Definitions > POREVIEWITEM

POREVIEWITEM

This is part of the purchase order review process which uses the table POREVIEWORIG, POREVIEWITEM, POREVIEWREPDTL, POREVIEWOTHER and POREVIEWTFR. This table stores details about the unique items which are being reviewed. If an item is on multiple purchase orders for the same supplier and manufacturer it will only appear in this table once.

Column

Type

Description

LINTITEMNUMBER

INT(4)

IPN of the item.

ITEM.lintItemNumber

STRDEPTCODE

VARCHAR(10)

Department code item belongs in.

DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Category code item belongs in.

CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Group code item belongs in.

GROUPS.strGroupCode

STRSUPPLIERCODE

VARCHAR(10)

The code of the supplier, this item belongs to

SUPPLIER.strSupplierCode

STRMANUFACTURER

VARCHAR(10)

The code of the manufacturer, this item belongs to

SUPPLIER.strSupplierCode

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.

STRPRODUCTSIZE

VARCHAR(10)

The size of the item.

 

Primary Key: LINTITEMNUMBER + STRSUPPLIERCODE + STRMANUFACTURER

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