VendorContact Table

FlexNet Manager Suite (Cloud)

VendorContact contains a list of all the vendor contacts, or individuals employed by the vendor with whom this enterprise has contact.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for VendorContact table

Database Column

Details

VendorContactID

Type: integer. Key. Generated ID

A unique identifier for the contact.

UserTitleID

Type: integer. Nullable

The title of the contact’s name. Foreign key to the UserTitle table.

FirstName

Type: text (max 128 characters)

The first name of the contact.

MiddleName

Type: text (max 128 characters). Nullable

The middle name(s) of the contact.

LastName

Type: text (max 128 characters). Nullable

The last name name of the contact.

UserSuffixID

Type: integer. Nullable

The suffix to the name of the contact.

JobTitle

Type: text (max 128 characters). Nullable

The job title of the contact.

VendorID

Type: integer. Key

A link to the contact’s parent vendor. Foreign key to the Vendor table.

BusinessPhoneNumber

Type: text (max 30 characters). Nullable

The business phone number of the contact.

MobilePhoneNumber

Type: text (max 30 characters). Nullable

The mobile phone number of the contact.

FaxPhoneNumber

Type: text (max 30 characters). Nullable

The fax number of the contact.

Address_Street

Type: text (max 200 characters). Nullable

The street address of the contact.

Address_City

Type: text (max 200 characters). Nullable

The city of the contact.

Address_State

Type: text (max 200 characters). Nullable

The state or province of the contact.

Address_ZIP

Type: text (max 20 characters). Nullable

The ZIP or postal code of the contact.

Address_Country

Type: text (max 100 characters). Nullable

The country of the contact.

Address2_Street

Type: text (max 200 characters). Nullable

The second street address of the contact, if applicable.

Address2_City

Type: text (max 200 characters). Nullable

The second city of the contact.

Address2_State

Type: text (max 200 characters). Nullable

The second state or province of the contact.

Address2_ZIP

Type: text (max 20 characters). Nullable

The second ZIP or postal code of the contact.

Address2_Country

Type: text (max 100 characters). Nullable

The second country of the contact.

Email

Type: text (max 200 characters). Nullable

The email address of the contact.

Messenger

Type: text (max 200 characters). Nullable

The instant messenger address of the contact.

Comments

Type: text. Nullable

Comments recorded about the contact.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

FlexNet Manager Suite (Cloud)

Current