Clients File Links Table Formats (ClientFileLinks)
Follow Ajera CRM specifications for preparing a file containing client file links.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| LinkID | varchar | 32 | Unique internal key for the file's link to the client record; primary key |
| ClientID | varchar | 32 | Client 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' |