title: "Email" category: reference tags: [entity, email, datamodel] source: Entities.xml date: 2026-04-17 status: published
Type: Entity Properties: 27 Contexts: 2 Statussen: 9
DB-schema:
lookup_table_schema("Email")· ../tables/Email
Contextsbewerken
- 0: Standaard (
EmailContext.None) - 1: Standaard (
EmailContext.Email)
Statussenbewerken
- -1: Trash (
EmailStatus.Trash) - 0: None (
EmailStatus.None) - 1: Te verzenden (
EmailStatus.Draft) - 2: Verzonden (
EmailStatus.Sent) - 4: Te verzenden na error (
EmailStatus.ToBeSentAfterError) - 8: Verzenden mislukt (
EmailStatus.Failed) - 16: Incorrect (
EmailStatus.Invalid) - 32: Concept (
EmailStatus.Concept) - 64: Genegeerd (
EmailStatus.Ignored)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | EMLID | 11 | false | |
| BCC | UltimoString | EMLBCC | true | ||
| Body | UltimoString | EMLBODY | true | ||
| CC | UltimoString | EMLCC | true | ||
| Context | Context | EMLCONTEXT | false | ||
| CreatedEmployee | Employee | EMLCREATEDEMPID | true | USERID | |
| DataProvider | UltimoString | EMLDATAPROVIDER | 50 | true | |
| EmailAttachments | List[EmailAttachment] | EMLAEMLID | false | ||
| EmailRecipients | List[EmailRecipient] | EMLREMLID | false | ||
| EmailSubjects | List[EmailSubject] | EMLSEMLID | false | ||
| ErrorMessage | UltimoString | EMLERRORMESSAGE | true | ||
| Exported | Boolean | EMLEXPORTED | false | ||
| ExternalId | UltimoString | EMLEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | EMLEXTERNALSTATUS | 50 | true | |
| FailedCount | Int32 | EMLFAILEDCOUNT | false | 0 | |
| From | UltimoString | EMLFROM | 255 | true | |
| IsBodyHtml | Boolean | EMLISBODYHTML | false | 0 | |
| LastFailureTime | DateTime? | EMLLASTFAILURETIME | true | ||
| ProviderMutationDate | DateTime? | EMLPROVIDERMUTDATE | true | ||
| RecordCreateDate | DateTime? | EMLRECCREATEDATE | true | SYSDATETIME | |
| Sender | Employee | EMLFROMEMPID | true | ||
| SendTime | DateTime? | EMLSENDTIME | true | ||
| Status | Status | EMLRECSTATUS | false | ||
| Subject | UltimoString | EMLSUBJECT | 500 | true | |
| SystemCompany | Company | EMLCOMPID | false | ||
| To | UltimoString | EMLTO | true | ||
| TransferNextTime | Boolean | EMLTRANSFERNEXTTIME | false | 0 |
Brondatabewerken
- Entity-definitie —
lookup_entity("Email")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Email")· ../tables/Email DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Email")Before/After Save events voor Email. Bron:workflows.xml.