---
title: "MAIL_TMP (AccountView)"
description: "Email templates"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/vismaaccountview/AccountView..MAIL_TMP
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..MAIL_TMP
updated: 2026-11-16T21:14:10Z
license: https://documentation.invantive.eu/nl/
---

# MAIL_TMP: AccountView Email templates

`read only`

- Catalogus: `AccountView`
- Label: Email templates

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `MAIL_TMP` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CNG_DATE` | `datetime` | Datum van wijziging | [ ] |  |  |
| `CNG_NR` | `int32` | Nummer wijzigen | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `INP_DATE` | `datetime` | Datum van inschrijving | [ ] |  |  |
| `INP_USR` | `varchar2(20)` | Entered by employee | [ ] |  |  |
| `KEEP_ORIG` | `char` | Include original message | [ ] |  |  |
| `MAIL_BODY` | `varchar2(4)` | Message | [ ] |  |  |
| `MAIL_BODYT` | `varchar2(4)` | Message text | [ ] |  |  |
| `MAIL_DISC` | `varchar2(4)` | Disclaimer | [ ] |  |  |
| `MAIL_DISCT` | `varchar2(4)` | Disclaimer text | [ ] |  |  |
| `MAIL_FILES` | `varchar2(4)` | Attachments | [ ] |  |  |
| `MAIL_SUBJ` | `varchar2(253)` | Subject | [ ] |  |  |
| `OBJ_CODE` | `varchar2(4)` | Object | [ ] |  |  |
| `PERS_SIGN` | `char` | Insert personal signature | [ ] |  |  |
| `PROF_CODE` | `varchar2(10)` | E-mailprofiel | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unieke code | [ ] |  |  |
| `TMPL_NAME` | `varchar2(40)` | Template name | [ ] |  |  |
| `TO_CLNT` | `char` | Client as recipient | [ ] |  |  |
