SentEmail
sent_email__v
Columns
| Name | Type | Description |
| ID [KEY] | String | id |
| Sent Email Type | String | object_type__v |
| Global ID | String | global_id__sys |
| Link | String | link__sys |
| Sent Email Name | String | name__v |
| Status | String | status__v |
| Created By | String | created_by__v |
| Created Date | Datetime | created_date__v |
| Last Modified By | String | modified_by__v |
| Last Modified Date | Datetime | modified_date__v |
| To Address | String | account_email__v |
| Activity Tracking Mode | String | activity_tracking_mode__v |
| Bcc | String | bcc__v |
| Capture Datetime | Datetime | capture_datetime__v |
| Email Values | String | email_config_values__v |
| Email Fragments | String | email_fragments__v |
| Email Group ID | String | email_group_id__v |
| Sent Date | Datetime | email_sent_date__v |
| Email Source | String | email_source__v |
| Entity Reference ID | String | entity_reference_id__v |
| Event Attendee Mobile Id | String | event_attendee_mobile_id__v |
| Event Mobile Id | String | event_mobile_id__v |
| Status Details | String | failure_msg__v |
| Last Email Activity Date | Datetime | last_activity_date__v |
| Last Device | String | last_device__v |
| MC Capture Datetime | Datetime | mc_capture_datetime__v |
| Mobile ID | String | mobile_id__v |
| Receipt Entity Type | String | receipt_entity_type__v |
| Receipt Record Id | String | receipt_record_id__v |
| Reject Reason | String | reject_reason__v |
| Related Transaction ID | String | related_transaction_id__v |
| Review Datetime | Datetime | review_datetime__v |
| Scheduled Send Datetime | Datetime | scheduled_send_datetime__v |
| From Address | String | sender_email__v |
| Sent Email Status | String | sent_email_status__v |
| Subject | String | subject__v |
| Territory | String | territory__v |
| User Input Text | String | user_input_text__v |
| VExternal Id | String | vexternal_id__v |
| Valid Consent Exists | Bool | valid_consent_exists__v |
| Account | String | account__v |
| Email Template | String | approved_email_template__v |
| Call | String | call2__v |
| Content Type | String | content_type__v |
| Detail Group | String | detail_group__v |
| Attendee | String | em_attendee__v |
| Event Speaker | String | em_event_speaker__v |
| Event | String | event__v |
| Key Message | String | key_message__v |
| Medical Event | String | medical_event__v |
| Medical Inquiry | String | medical_inquiry__v |
| Parent Email | String | parent_email__v |
| Product | String | product__v |
| Reviewer | String | reviewer__v |
| Suggestion | String | suggestion__v |
| User | String | user__v |
| Owner | String | ownerid__v |
| Document Views | Decimal | approved_document_views__v |
| Total Clicks | Decimal | click_count__v |
| Last Click | Datetime | last_click_date__v |
| Last Open | Datetime | last_open_date__v |
| Total Opens | Decimal | open_count__v |
| Clicked | Decimal | clicked__v |
| Events Management Subtype | String | events_management_subtype__v |
| Opened | Decimal | opened__v |
| Product Display | String | product_display__v |
| Event Attendee | String | event_attendee__v |
| Event Team Member | String | em_event_team_member__v |
| Legacy CRM Id | String | legacy_crm_id__v |
| Campaign Execution ID | String | campaign_execution_id__v |
| Email Files | String | email_files__v |
| Veeva Distributions | String | veeva_distributions__v |
| Controlling Campaign | String | ctrl_campaign__v |
| Campaign Activity | String | campaign_activity__v |
| User Country | String | country_user__v |
| Account Country | String | country_account__v |
| Email Builder Values | String | email_builder_values__v |
| Event Execution ID | String | event_execution_id__v |
| List Unsubscribe Header | String | list_unsubscribe_header__v |
| Email Builder | String | email_builder__v |
| Veeva Content | String | veeva_content__v |
| Campaign Target | String | campaign_target__v |
| Email Builder Rule | String | email_builder_rule__v |
| Email Values2 | String | email_config_values_file__v |
| Email Content | String | email_content_file__v |
| Campaign Activity Object Type | String | campaign_activity_object_type__v |