Home > Technical > Table Definitions > CUSTCONTACT

CUSTCONTACT

This table contains the additional contacts for a customer.

Column Type Description

LINTCUSTOMERNUM

INTEGER

The customer these points belong to.

CUSTOMER.lintCustomerNum

CTRCODE

INTEGER

A unique number assigned by the system.

STRTITLE

VARCHAR(5)

The title of the contact, for example MR.

STRLASTNAME

VARCHAR(50)

The last name of the contact.

STRFIRSTNAME

VARCHAR(50)

The first name of the contact.

STRPHONE

VARCHAR(20)

Phone number.

STRFAX

VARCHAR(20)

Fax number.

STRMOBILE

VARCHAR(20)

Mobile phone number.

STREMAIL

VARCHAR(60)

Customer’s email address.

STRWORKPHONE

VARCHAR(20)

The customer's work phone number.

 

Primary Key: LINTCUSTOMERNUM+CTRCODE

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