| DocTmpl_id | Primary key | PK | No |
| name | The list item | String(239) | No |
| rank | Rank order | UShort | Yes |
| tooltip | Tooltip or other description | String(254) | Yes |
| deleted | 0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists | UShort | Yes |
| filename | Relative to TemplatePath in SOARC. Plugin specific extref in other doc archives. i.e. Google document URL or Notes id. | String(239) | No |
| autoevent_id | Document plugin id - where the documents generated from this template are to be stored. Copied to the document.archiveProvider when document is created. | Id | Yes |
| record_type | 1 = app, 2 = doc, 3 = email, 4 = fax, 5 = phone, 6 = todo - see EAppntRecordTypes | Enum DocTmplType | No |
| direction | 1 = incoming, 2 = outgoing, see EAppntDirection | Enum DocTmplDirection | Yes |
| saveInDb | 1 = save document records in DB; otherwise not. | UShort | Yes |
| default_oref | Processed via tag substitution to give document reference | String(239) | Yes |
| regkey_open | Registry key to use for Open, if blank, we simply ask Windows to do the operation for us | String(239) | Yes |
| regkey_edit | Registry key to use for Edit; if blank, we simply ask Windows to do the operation for us | String(239) | Yes |
| regkey_print | Registry key to use for Print; if blank, we simply ask Windows to do the operation for us | String(239) | Yes |
| accelerator | Accelerator key code for this template | UShort | Yes |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
| defaultPublishType | Should documents based on this template be published=true? Default state of publish flag on documents. | Enum PublishType | Yes |
| intentId | What is the intention of this document (used by SAINT) | FK Intent | Yes |
| mimeType | The MIME type, for Web/Browser use of documents of this type | String(254) | Yes |
| loadTemplateFromPlugin | If nonzero, then this is the ID of the document plugin that should supply the template document file, instead of the default so_arc/template | Int | Yes |
| quoteDocType | The role this document plays in the Quote system, if any | Enum DocTmplQuoteType | Yes |
| privacyDocType | Indicator that this document template has a functional role, related to privacy/GDPR | Enum DocTmplPrivacyType | Yes |
| emailSubject | Subject line for document templates that represent an email; template tags are accepted in this item | String(4000) | Yes |
| includeSignature | If True, signature (mail.htm) should be added at bottom of template when used | Bool | Yes |
| showCurrents | If True, A dialog or sidebar will be shown for changing current values on Contact, Person | Bool | Yes |
| senderEmailMode | Type of sender email setting. Always use senderEmailAddress = 0, Use Our contact = 1, Use Support Associate = 2 | Enum SenderMailMode | Yes |
| senderEmailAddress | The email address to use in from field | String(256) | Yes |
| invitationDocType | Type for sending email meeting invitation. Not an invitation type template = 0, New = 1, Changed = 2, Cancelled = 3 | Enum DocTmplInvitationType | Yes |
