Home > Technical > Table Definitions > TRADCODE

TRADCODE

There are several fields in TRADUNIT which need lookup codes. Rather than create a separate table for each one, this table is shared amongst them. A type code identifies sets of records.

Column

Type

Description

STRTYPE

VARCHAR(1)

Identifies the type of code.

C  

Contact Type

D  

Departments

M  

Member of buying group

S  

Statistics group

T  

Type of store

W  

Wholesaler

STRTEXT

VARCHAR(15)

Unique code for this type of record. The same code can be used for different types of records.

 

Primary Key: STRTYPE + STRTEXT

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