Contacts File Links Table Formats (ContactsFileLinks)

Follow Vantagepoint specifications for preparing a file containing contact file links.

See the Vantagepoint Data Dictionary for more information about the fields (columns) in this table.

Field Name Data Type Length Notes
ContactID varchar 32 Contact record number; required field; must exist in Contacts (ContactID/(LastName,FirstName,MiddleName,ClientID/Client))
Description varchar 100 User-entered file description
FilePath varchar 255 File's file path location
Graphic varchar 1 Variable indicating whether or not the linked file is a graphic file; default is N (No)
LinkID varchar 32 Unique internal key for the file's link to the contact record; primary key
ContactLastName varchar
ContactFirstName varchar
ContactMiddleName varchar
ClientID varchar