Table 8889 "Sent Email"
System Application · System.Email
Across versions
- BC23-25present
- BC261 procedures added
- BC27-30unchanged
Neighbourhood 5 connected objects and pages
System Application · System.Email · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Access | Public |
| Extensible | true |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Id | BigInteger | — | AutoIncrement; DataClassification SystemMetadata |
| 2 | Message Id | Guid | — | TableRelation Table 8900 “Email Message” (“Email Message”.Id); DataClassification SystemMetadata |
| 3 | Account Id | Guid | — | DataClassification SystemMetadata |
| 4 | Connector | Enum “Email Connector” | Specifies the type of email extension that was used to send the email. via Page 8883 “Sent Emails” | enum Email Connector; DataClassification SystemMetadata |
| 5 | User Security Id | Guid | — | DataClassification EndUserPseudonymousIdentifiers |
| 6 | Description | Text[2048] | Specifies a short description of the email that was sent. via Page 8883 “Sent Emails” | DataClassification CustomerContent |
| 7 | Date Time Sent | DateTime | Specifies the date and time the email was sent. via Page 8883 “Sent Emails” | DataClassification SystemMetadata |
| 10 | Sender | Code[50] | Specifies the Business Central user who sent this email. via Page 8883 “Sent Emails” | FlowField: lookup(User.“User Name” where(“User Security ID” = field(“User Security Id”))) |
| 13 | Sent From | Text[250] | Specifies the email address that this email was sent from. via Page 8883 “Sent Emails” | DataClassification CustomerContent |
Keys
- PK: Id (clustered)
- Message: Message Id
- FiltersKey: Account Id, User Security Id, Date Time Sent
- UserSecurityId: User Security Id
- DateTimeSent: Date Time Sent
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 8905 “Email Message Impl.” OnAfterDeleteSentEmail
Procedures
GetMessageId(): Guid: Get the message id of the sent email.GetAccountId(): Guid+ BC26: Get the account id of the sent email.
Relations
- Message Id: TableRelation Table 8900 “Email Message”
Pages and codeunits on this table
- Page 12 “Email Viewer” (source table)
- Page 8883 “Sent Emails” (source table)
- Page 8888 “Sent Emails List Part” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Sent Email"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.