VendorContact Table

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.