Home > Technical > Table Definitions > 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. |
STRTRADECODE |
VARCHAR(10) |
The location to which this rating applies. If this is a group, it will apply to all locations within the group. |
STRRATINGCODE |
VARCHAR(10) |
The rating code for the item/location. |
Primary Key: LINTITEMNUMBER + STRTRADECODE + STRRATINGCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |