Home > Technical > Table Definitions > TRADCONTACT

TRADCONTACT

This lists the various contacts for a location. The contacts can be stored for a group or specific location.

Column

Type

Description

STRTRADECODE

VARCHAR(10)

The trading unit this department is for.
TRADUNIT.strTradeCode

STRCONTACTTYPE

VARCHAR(15)

The type of contact, for example Area Manager, Inventory Mgr, and so on.
TRADCODE.strText  (where strType='C')

STRUSERCODE

VARCHAR(20)

The code of the user who is this contact for the location.
USERCODE.strUserCode

 

Primary Key: STRTRADECODE + STRCONTACTTYPE + STRUSERCODE

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