Tables and fields used by the Letter System
The following tables and fields are used with the Letter System:
| Activity\_Attach (stores merged MS Word documents as attachments) | ||
| ATTACH\_SEQN | long integer | Primary key |
| TEMPLATE | varchar(255) | Name of the template used |
| ATTACH\_TEXT | text | Text of the MS Word document as sent by the merge process |
| Activity | ||
| ATTACH\_SEQN | long integer | Used to store a reference to an associated record in the Activity\_Attach table |
| Report\_Desc | ||
| REPORT\_OPTIONS | text | PRINT\_CREATE\_ACTIVITY (default) - The checkbox on the Report Selection window is enabled by default. NO\_CREATE\_ACTIVITY - The checkbox on the Report Selection window is disabled by default |
Updated 3 months ago
Did this page help you?

