Opportunities File Links Table Format (OpportunityFileLinks)
Follow DPS 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) |