Home > Technical > Table Definitions > SUPPCONTACT

SUPPCONTACT

This table stores the various contacts for a SUPPLIER.

Column Type Description
STRSUPPLIERCODE VARCHAR(10) The supplier that this contact belongs to
SUPPLIER.strSupplierCode
CTRCODE INT Unique code assigned by the system.
STRNAME VARCHAR(50) The name of the contact
STRPOSITION VARCHAR(50) The position that the contact holds. To promote consistency of entry this code is verified against the SUPPLIERDESC table where strType ='P'.
SUPPLIERDESC.strDescription
STRLOCATION VARCHAR(20) The location where the contact is. To promote consistency of entry this code is verified against the SUPPLIERDESC table where strType ='L'.
SUPPLIERDESC.strDescription
STRPHONE VARCHAR(20) The contact's phone number.
STRFAX VARCHAR(20) The contact's fax number.
STRMOBILE VARCHAR(20) The contact's mobile phone number.
STREMAIL VARCHAR(100) The contact's email address.
 

Primary Key: STRSUPPLIERCODE + CTRCODE

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