Home > Technical > Table Definitions > ITEMRATING

ITEMRATING

This table lists the ratings that apply to an item. For example, you might have a rating to indicate that this is an alcohol item and should only be sold to people 18+ years. Different countries can have different ratings so the rating codes are stored in a separate table from the main ITEM table.

Column

Type

Description

LINTITEMNUMBER

INT

The item that this rating belongs to.

ITEM.lintItemNumber

STRTRADECODE

VARCHAR(10)

The location to which this rating applies. If this is a group, it will apply to all locations within the group.

TRADUNIT.strTradeCode

STRRATINGCODE

VARCHAR(10)

The rating code for the item/location.

RATINGCODE.strCode

 

Primary Key: LINTITEMNUMBER + STRTRADECODE + STRRATINGCODE

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