Firm File Links Table Formats (ClientFileLinks)

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

Field Name Data Type Length Notes
ClientID varchar 32 Firm record number; required field; must exist in CL (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; valid options are Y (Yes) or N (No); default 'N'
LinkID varchar 32 Unique internal key for the file's link to the firm record; primary key