Projects File Links Table Formats (PRFileLinks)
FollowAjera CRM specifications for preparing a file containing project file links.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| LinkID | varchar | 32 | Unique internal key for the file's link to the project record; primary key |
| WBS1 | varchar | 30 | Linked project record; required field; must exist in PR |
| WBS2 | varchar | 7 | Linked phase record; must exist in PR |
| WBS3 | varchar | 7 | Linked task record; must exist in PR |
| 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) |