Contacts File Links Table Formats (ContactsFileLinks)

Follow GovWin Capture Management specifications for preparing a file containing contact file links.

Field Name Data Type Length Notes
LinkID varchar 32 Unique internal key for the file's link to the contact record; primary key
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)