sentEmail
Tracks emails that have been sent from within the system, including metadata and status.
Columns
| Name | Type | References | Description |
| bccrecipients | String | The list of email addresses that received the message as blind carbon copy (BCC) recipients. | |
| body | String | The full content of the email message body, including any plain text or HTML formatting. | |
| ccrecipients | String | The list of email addresses that received the message as carbon copy (CC) recipients. | |
| dkimalignmentok | Boolean | If the value is 'true', the DomainKeys Identified Mail (DKIM) alignment check passed for the email. | |
| dkimrecord | String | The DKIM record used to validate the sender's identity through Domain Name System (DNS)-based email authentication. | |
| dkimsignatureok | Boolean | If the value is 'true', the DKIM signature was successfully verified and matched the expected domain. | |
| dmarccompliant | Boolean | If the value is 'true', the message complies with the sender’s Domain-based Message Authentication, Reporting and Conformance (DMARC) policy. | |
| dmarcrecord | String | The DMARC record retrieved and used during message validation. | |
| emailmessageid | String | The unique identifier of the email message, often used for threading or reference. | |
| enveloperecipients | String | The final recipients of the message as recorded in the Simple Mail Transfer Protocol (SMTP) envelope. | |
| failurereason | String | Describes the reason the email failed to send, if applicable. | |
| hostname | String | The hostname of the server involved in sending the email. | |
| key | Integer | The internal system ID used to uniquely identify the email record. | |
| logdate | Date | The date when the email sending event was logged in the system. | |
| machine | String | The server or processing machine used to send or handle the email. | |
| mailingid | String | The unique ID used to group or track mass email mailings or campaigns. | |
| messageid | String | The globally unique identifier assigned to the email, typically set in the 'Message-ID' header. | |
| netsuiteheader | String | Custom header information added by NetSuite to the outgoing email for tracking or processing. | |
| originalenveloperecipients | String | The original list of SMTP envelope recipients before any changes or redirection. | |
| replyto | String | The email address that will receive replies to this message, as specified in the 'Reply-To' header. | |
| sentdate | Date | The date the message was successfully sent. | |
| spfok | Boolean | If the value is 'true', the message passed Sender Policy Framework (SPF) validation, confirming the sender was authorized. | |
| status | String | The final delivery status of the message, such as 'Sent', 'Failed', or 'Bounced'. | |
| subject | String | The subject line of the email message. | |
| torecipients | String | The list of primary recipient email addresses included in the 'To' field. |