| ut_mail_dest | table des destinataires de mail |
Liste des champs :
Rang |
Champ |
Libellé |
Type |
Lg/Format |
| 1 | nummes | numero de mail | LONG | - |
| 2 | codlan | Code Langue 3 caractères | CHAR | 3 |
| 3 | rang | Rang de la clé | LONG | - |
| 4 | email256 | adresse email sur 256 caractères | CHAR | 256 |
| 5 | copie | indique si le destinataire est copie | CHAR | 1 |
| 7 | niv | Niveau d'habilitation | LONG | - |
| 8 | spl | .spl (O/N) | CHAR | 1 |
| 9 | datmod | Date de modification | DATE | AAAAMMJJ |
| 10 | utimod | Agent responsable de la dernière accès | CHAR | 8 |
| 11 | codsoc | Code societe | LONG | - |
Liste des clés :
| Rang | Clé |
Libellé |
Type |
Unique |
| 1 | ut_mail_dest_idx1 | index des destinataires | D | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| nummes (ASC) | ||||
| codlan (ASC) | ||||
| rang (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 2 | ut_mail_dest_idx2 | index de ut_mail_dest | P | O |
Clause Order By |
||||
| codsoc (ASC) | ||||
| nummes (ASC) | ||||
| codlan (ASC) | ||||
| email256 (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 3 | ut_mail_dest_idx3 | liste des destinataires avec spl (O/N) | P | O |
| index 3 de ut_mail_dest | ||||
Clause Order By |
||||
| codsoc (ASC) | ||||
| nummes (ASC) | ||||
| codlan (ASC) | ||||
| spl (ASC) | ||||
| Rang | Clé |
Libellé |
Type |
Unique |
| 4 | ut_mail_dest_idx4 | Clé 4 | P | N |
Clause Order By |
||||
| codsoc (ASC) | ||||
| email256 (ASC) | ||||
| nummes (ASC) | ||||
| codlan (ASC) | ||||
| rang (ASC) | ||||