Home > Technical > Table Definitions > VALIDDESC

VALIDDESC

This table has been superceded by VALIDDESC2.

These records are used to validate the entry of various long codes used in items. If the entry is not found in VALIDDESC2, then it looks here in VALIDDESC.

Column

Type

Description

STRTYPE

VARCHAR(1)

Indicates the type of data to be validated.

B  

Brandname

C

Seasons

S  

Size

M

Media types, for example NEWSPAPER, RADIO, and so on.

STRDESCRIPTION

VARCHAR(30)

A unique description.

STRIMAGENAME

VARCHAR(100)

The name of an image associated with this description.
INTORDER INT The sequence in which the size should be displayed. If you looking at sizes of mens clothing which is XS,S,M,L,XL, alphabetically sorting would not be sufficient.
 

Primary Key: STRTYPE + STRDESCRIPTION

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