Opportunities File Links Table Format (OpportunityFileLinks)

Follow Deltek specifications for preparing a file containing opportunity file links.

Field Name Data Type Length Notes
LinkID varchar 32 Unique internal key for the file's link to the opportunity record; primary key
OpportunityID varchar 32 Internal reference number for the linked opportunity record; required field; must exist in Opportunity
Description varchar 100 User-entered file description
FilePath varchar 255 File's file path location
Graphic varchar 1 Variable indicating whether or not the file is a graphic file; default is N (No)