Home > Technical > Table Definitions > TRADUNITCLASS

TRADUNITCLASS

This table records which classifications are allowed to be used by a specific location.

Column

Type

Description

STRTRADECODE

VARCHAR(10)

Our trading unit this cross-reference is for.
TRADUNIT.strTradeCode

STRCLASSCODE

VARCHAR(10)

The code of the classification that can be used at the location.
CLASS.strClassCode

STRSUPPLIERCODE

VARCHAR(10)

The supplier that this classification MUST be ordered from. Only required if you want to override the system working out which is the best supplier to use.
SUPPLIER.strSupplierCode

STRFREQCODE

VARCHAR(10)

The frequency code that MUST be used for this location/classification. This is only required if you want to override the standard supplier frequency codes.

ORDERFREQUENCY.strFrequencyCode

 

Primary Key: STRTRADECODE + STRCLASSCODE

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