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