# Microsoft Dynamics 365 CRM schema ERD

Table and field reference for the Fivetran Microsoft Dynamics 365 CRM connector.

## Table & Field Reference

### connection

| Column | Type | Keys |
| --- | --- | --- |
| connection_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| related_connection_id | String | FK |
| transaction_currency_id | String | FK |
| created_on | Instant |  |
| description | String |  |
| effective_end | Instant |  |
| effective_start | String |  |
| entity_image | String |  |
| entity_image_id | String |  |
| entity_image_timestamp | Long |  |
| entity_image_url | String |  |
| exchange_rate | Double |  |
| import_sequence_number | String |  |
| is_master | Boolean |  |
| modified_on | Instant |  |
| name | String |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| owning_team | String |  |
| owning_user | String |  |
| record_1_id | String |  |
| record_1_object_type_code | Long |  |
| record_1_role_id | String |  |
| record_2_id | String |  |
| record_2_object_type_code | Long |  |
| record_2_role_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| version_number | Long |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | String | PK |
| campaign_id | String | FK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| master_id | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| originating_case_id | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_account_id | String | FK |
| parent_contact_id | String | FK |
| qualifying_opportunity_id | String | FK |
| transaction_currency_id | String | FK |
| address_1_city | String |  |
| address_1_country | String |  |
| address_1_line_1 | String |  |
| address_1_postalcode | String |  |
| address_1_stateorprovince | String |  |
| company_name | String |  |
| created_on | Instant |  |
| description | String |  |
| email_address_1 | String |  |
| full_name | String |  |
| industry_code | Long |  |
| job_title | String |  |
| lead_source_code | Long |  |
| merged | Boolean |  |
| modified_on | Instant |  |
| msdyn_lead_kpi_id | String |  |
| msdyn_predictive_score_id | String |  |
| msdyn_segment_id | String |  |
| number_of_employees | Long |  |
| owner_id | String |  |
| priority_code | Long |  |
| revenue | Double |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |

### queueitem

| Column | Type | Keys |
| --- | --- | --- |
| queue_item_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| queue_id | String | FK |
| transaction_currency_id | String | FK |
| created_on | Instant |  |
| entered_on | Instant |  |
| exchange_rate | Double |  |
| import_sequence_number | Long |  |
| modified_on | Instant |  |
| msdyn_live_workstream_id | String |  |
| object_id | String |  |
| object_type_code | Long |  |
| organization_id | String |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_user | String |  |
| state_code | String |  |
| status_code | Long |  |
| time_zone_rule_version_number | Long |  |
| title | String |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |
| worker_id | String |  |
| worker_id_modified_on | Instant |  |

### queue

| Column | Type | Keys |
| --- | --- | --- |
| queue_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| transaction_currency_id | String | FK |
| created_on | Instant |  |
| default_mailbox | String |  |
| description | String |  |
| email_address | String |  |
| email_router_access_approval | Long |  |
| email_signature | String |  |
| entity_image | String |  |
| entity_image_id | String |  |
| entity_image_timestamp | Long |  |
| entity_image_url | String |  |
| exchange_rate | Double |  |
| ignore_unsolicited_email | Boolean |  |
| import_sequence_number | Long |  |
| incoming_email_delivery_method | Long |  |
| incoming_email_filtering_method | Long |  |
| is_email_address_approved_by_o_365_admin | Boolean |  |
| modified_on | Instant |  |
| msdyn_assignment_input_contract_id | String |  |
| msdyn_operating_hour_id | String |  |
| msdyn_queue_type | Long |  |
| msdyn_unique_name | String |  |
| name | String |  |
| number_of_items | Long |  |
| number_of_members | Long |  |
| organization_id | String |  |
| outgoing_email_delivery_method | Long |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| owning_team | String |  |
| owning_user | String |  |
| queue_type_code | Long |  |
| queue_view_type | Long |  |
| state_code | Long |  |
| status_code | Long |  |
| version_number | Long |  |

### email

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| senders_account | String | FK |
| accepting_entity_id | String |  |
| activity_additional_params | String |  |
| activity_type_code | String |  |
| actual_duration_minutes | Long |  |
| actual_end | String |  |
| actual_start | Instant |  |
| attachment_count | Long |  |
| attachment_open_count | Long |  |
| category | String |  |
| correlated_activity_id | String |  |
| created_by | String |  |
| created_on | Instant |  |
| created_on_behalf_by | String |  |
| email_sender | String |  |
| in_reply_to | String |  |
| is_billed | Boolean |  |
| is_regular_activity | Boolean |  |
| is_unsafe | Long |  |
| last_opened_time | Instant |  |
| modified_by | String |  |
| modified_on | Instant |  |
| modified_on_behalf_by | String |  |
| open_count | Long |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_user | String |  |
| parent_activity_id | String |  |
| priority_code | Long |  |
| process_id | String |  |
| receiving_mailbox_id | String |  |
| regarding_object_id | String |  |
| sender | String |  |
| sent_on | Instant |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| sub_category | String |  |
| subject | String |  |
| submitted_by | String |  |
| to_recipients | String |  |

### businessunit

| Column | Type | Keys |
| --- | --- | --- |
| business_unit_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| parent_business_unit_id | String | FK |
| transaction_currency_id | String | FK |
| address_1_address_id | String |  |
| address_1_city | String |  |
| address_1_country | String |  |
| address_1_line_1 | String |  |
| address_1_line_2 | String |  |
| address_1_line_3 | String |  |
| address_1_name | String |  |
| address_1_postalcode | String |  |
| address_1_stateorprovince | String |  |
| address_1_telephone_1 | String |  |
| calendar_id | String |  |
| cost_center | String |  |
| created_on | String |  |
| credit_limit | Double |  |
| description | String |  |
| disabled_reason | String |  |
| division_name | String |  |
| email_address | String |  |
| exchange_rate | Double |  |
| file_as_name | String |  |
| ftp_site_url | String |  |
| import_sequence_number | Long |  |
| inheritance_mask | Long |  |
| is_disabled | Boolean |  |
| modified_on | Instant |  |
| name | String |  |
| organization_id | String |  |
| overridden_created_on | Instant |  |
| picture | String |  |
| stock_exchange | String |  |
| ticker_symbol | String |  |
| utc_offset | Long |  |
| version_number | Long |  |
| website_url | String |  |
| workflow_suspended | Boolean |  |

### stringmap

| Column | Type | Keys |
| --- | --- | --- |
| string_map_id | String | PK |
| attribute_name | String |  |
| attribute_value | Long |  |
| display_order | Long |  |
| lang_id | Long |  |
| object_type_code | String |  |
| organization_id | String |  |
| value | String |  |
| version_number | Long |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| activity_additional_params | String |  |
| activity_type_code | String |  |
| actual_duration_minutes | Long |  |
| actual_end | Instant |  |
| actual_start | Instant |  |
| category | String |  |
| community | Long |  |
| created_by | String |  |
| created_on | Instant |  |
| created_on_behalf_by | String |  |
| delivery_priority_code | Long |  |
| description | String |  |
| instance_type_code | Long |  |
| is_billed | Boolean |  |
| is_workflow_created | Boolean |  |
| modified_by | String |  |
| modified_on | Instant |  |
| modified_on_behalf_by | String |  |
| on_hold_time | Long |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_team | String |  |
| owning_user | String |  |
| percent_complete | Long |  |
| priority_code | Long |  |
| process_id | String |  |
| regarding_object_id | String |  |
| scheduled_duration_minutes | Long |  |
| scheduled_end | Instant |  |
| scheduled_start | Instant |  |
| sender_mailbox_id | String |  |
| sent_on | Instant |  |
| series_id | String |  |
| sla_id | String |  |
| sort_date | Instant |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| subcategory | String |  |
| subject | String |  |
| subscription_id | String |  |

### systemuser

| Column | Type | Keys |
| --- | --- | --- |
| system_user_id | String | PK |
| business_unit_id | String | FK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| parent_system_user_id | String | FK |
| transaction_currency_id | String | FK |
| address_1_city | String |  |
| address_1_country | String |  |
| address_1_line_1 | String |  |
| address_1_postalcode | String |  |
| address_1_stateorprovince | String |  |
| address_1_telephone_1 | String |  |
| azure_active_directory_object_id | String |  |
| azure_deleted_on | Instant |  |
| azure_state | Long |  |
| calendar_id | String |  |
| created_on | Instant |  |
| default_mailbox | String |  |
| deleted_state | Long |  |
| domain_name | String |  |
| employee_id | String |  |
| first_name | String |  |
| full_name | String |  |
| identity_id | Long |  |
| internal_email_address | String |  |
| is_disabled | Boolean |  |
| is_integration_user | Boolean |  |
| job_title | String |  |
| last_name | String |  |
| mobile_offline_profile_id | String |  |
| modified_on | Instant |  |
| msdyn_defaultpresenceiduser | String |  |
| organization_id | String |  |
| owner_id | String |  |
| position_id | String |  |
| queue_id | String |  |
| site_id | String |  |
| stage_id | String |  |
| territory_id | String |  |
| title | String |  |

### knowledgearticle

| Column | Type | Keys |
| --- | --- | --- |
| knowledge_article_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_article_content_id | String | FK |
| previous_article_content_id | String | FK |
| primary_author_id | String | FK |
| root_article_id | String | FK |
| transaction_currency_id | String | FK |
| article_public_number | String |  |
| content | String |  |
| created_on | Instant |  |
| description | String |  |
| exchange_rate | Double |  |
| expiration_date | Instant |  |
| expiration_state_id | String |  |
| expiration_status_id | Long |  |
| expired_review_options | Long |  |
| import_sequence_number | Long |  |
| is_internal | Boolean |  |
| is_latest_version | Boolean |  |
| is_primary | Boolean |  |
| is_root_article | Boolean |  |
| keywords | String |  |
| knowledge_article_views | Long |  |
| knowledge_article_views_date | Instant |  |
| knowledge_article_views_state | Long |  |
| language_locale_id | String |  |
| major_version_number | String |  |
| minor_version_number | Long |  |
| modified_on | Instant |  |
| msdyn_content_store | String |  |
| msdyn_content_store_name | String |  |
| msdyn_ingested_article_url | String |  |
| msdyn_is_content_synced_to_store | Boolean |  |
| msdyn_is_ingested_article | Boolean |  |
| owner_id | String |  |
| subject_id | String |  |

### listmember

| Column | Type | Keys |
| --- | --- | --- |
| list_member_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| created_on | Instant |  |
| entity_id | String |  |
| entity_type | String |  |
| import_sequence_number | Long |  |
| list_id | String |  |
| modified_on | String |  |
| name | String |  |
| overridden_created_on | String |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_user | String |  |
| time_zone_rule_version_number | Long |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |

### transactioncurrency

| Column | Type | Keys |
| --- | --- | --- |
| transaction_currency_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| created_on | Instant |  |
| currency_name | String |  |
| currency_precision | Long |  |
| currency_symbol | String |  |
| currency_type | Long |  |
| entity_image | String |  |
| entity_image_id | String |  |
| entity_image_timestamp | Long |  |
| entity_image_url | String |  |
| exchange_rate | Double |  |
| import_sequence_number | Long |  |
| iso_currency_code | String |  |
| modified_on | Instant |  |
| organization_id | String |  |
| overridden_created_on | Instant |  |
| state_code | Long |  |
| status_code | Long |  |
| version_number | Long |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| existing_case | String | FK |
| master_id | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_case_id | String | FK |
| primary_contact_id | String | FK |
| product_id | String | FK |
| transaction_currency_id | String | FK |
| account_id | String |  |
| case_origin_code | Long |  |
| case_type_code | Long |  |
| contract_detail_id | String |  |
| contract_id | String |  |
| created_on | Instant |  |
| customer_contacted | Boolean |  |
| customer_id | String |  |
| description | String |  |
| entitlement_id | String |  |
| first_response_by_kpi_id | String |  |
| kb_article_id | String |  |
| modified_on | Instant |  |
| msdyn_iot_alert | String |  |
| owner_id | String |  |
| priority_code | Long |  |
| resolve_by_kpi_id | String |  |
| resolve_by_sla_status | Long |  |
| service_stage | Long |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| social_profile_id | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| subject_id | String |  |
| ticket_number | String |  |
| title | String |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| list_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| transaction_currency_id | String | FK |
| cost | Double |  |
| cost_base | Double |  |
| created_from_code | String |  |
| created_on | Instant |  |
| description | String |  |
| do_not_send_on_opt_out | Boolean |  |
| exchange_rate | Double |  |
| ignore_inactive_list_members | Boolean |  |
| import_sequence_number | Long |  |
| last_used_on | Instant |  |
| list_name | String |  |
| lock_status | Boolean |  |
| member_count | Long |  |
| member_type | Long |  |
| modified_on | Instant |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| process_fetch_xml | String |  |
| process_id | String |  |
| processed_member_count | Long |  |
| purpose | String |  |
| query | String |  |
| source | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| time_zone_rule_version_number | Long |  |
| traversed_path | String |  |
| type | Boolean |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |

### campaignitem

| Column | Type | Keys |
| --- | --- | --- |
| campaign_item_id | String | PK |
| campaign_id | String |  |
| entity_id | String |  |
| entity_type | String |  |
| import_sequence_number | Long |  |
| name | String |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_user | String |  |
| time_zone_rule_version_number | Long |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |

### activitypointer

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| transaction_currency_id | String | FK |
| activity_type_code | String |  |
| actual_duration_minutes | Long |  |
| actual_end | Instant |  |
| actual_start | Instant |  |
| created_on | Instant |  |
| delivery_last_attempted_on | Instant |  |
| delivery_priority_code | Long |  |
| description | String |  |
| exchange_rate | Double |  |
| instance_type_code | String |  |
| is_billed | Boolean |  |
| is_mapi_private | Boolean |  |
| is_regular_activity | Boolean |  |
| is_workflow_created | Boolean |  |
| left_voicemail | Boolean |  |
| modified_on | Instant |  |
| owner_id | String |  |
| priority_code | String |  |
| process_id | String |  |
| regarding_object_id | String |  |
| scheduled_duration_minutes | Long |  |
| scheduled_end | Instant |  |
| scheduled_start | Instant |  |
| sender_mailbox_id | String |  |
| sent_on | Instant |  |
| series_id | String |  |
| sort_date | Instant |  |
| state_code | Long |  |
| status_code | Long |  |
| subject | String |  |
| time_zone_rule_version_number | Long |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |

### phonecall

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| activity_additional_params | String |  |
| activity_type_code | String |  |
| actual_duration_minutes | Long |  |
| actual_end | Instant |  |
| actual_start | Instant |  |
| category | String |  |
| created_by | String |  |
| created_on | Instant |  |
| created_on_behalf_by | String |  |
| description | String |  |
| direction_code | Boolean |  |
| exchange_rate | Double |  |
| import_sequence_number | String |  |
| is_billed | Boolean |  |
| is_regular_activity | Boolean |  |
| is_workflow_created | Boolean |  |
| left_voicemail | Boolean |  |
| modified_by | String |  |
| modified_on | Instant |  |
| modified_on_behalf_by | String |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_team | String |  |
| owning_user | String |  |
| phone_number | String |  |
| priority_code | Long |  |
| regarding_object_id | String |  |
| scheduled_duration_minutes | Long |  |
| scheduled_end | Instant |  |
| scheduled_start | Instant |  |
| sender_mailbox_id | String |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| sort_date | Instant |  |
| state_code | Long |  |
| status_code | Long |  |
| subcategory | String |  |
| subject | String |  |
| time_zone_rule_version_number | Long |  |
| transaction_currency_id | String |  |
| version_number | Long |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| parent_product_id | String | FK |
| transaction_currency_id | String | FK |
| created_by_external_party | String |  |
| created_on | Instant |  |
| current_cost | Double |  |
| current_cost_base | Double |  |
| default_uom_id | String |  |
| default_uom_schedule_id | String |  |
| description | String |  |
| dmtimportstate | Long |  |
| entity_image | String |  |
| entity_image_id | String |  |
| entity_image_timestamp | Long |  |
| entity_image_url | String |  |
| hierarchy_path | String |  |
| modified_by_external_party | String |  |
| modified_on | Instant |  |
| msdyn_gdproptout | Boolean |  |
| name | String |  |
| organization_id | String |  |
| overridden_created_on | Instant |  |
| price | Double |  |
| price_base | Double |  |
| price_level_id | String |  |
| process_id | String |  |
| product_number | String |  |
| product_structure | Long |  |
| product_type_code | Long |  |
| quantity_decimal | Long |  |
| size | String |  |
| stage_id | String |  |
| standard_cost | Double |  |
| standard_cost_base | Double |  |
| state_code | Long |  |
| status_code | Long |  |
| subject_id | String |  |
| supplier_name | String |  |

### activityparty

| Column | Type | Keys |
| --- | --- | --- |
| activity_party_id | String | PK |
| activity_id | String | FK |
| address_used | String |  |
| address_used_email_column_number | Long |  |
| do_not_email | Boolean |  |
| do_not_fax | Boolean |  |
| do_not_phone | Boolean |  |
| do_not_postal_mail | Boolean |  |
| effort | Double |  |
| exchange_entry_id | String |  |
| external_id | String |  |
| external_id_type | String |  |
| instance_type_code | Long |  |
| is_party_deleted | Boolean |  |
| owner_id | String |  |
| participation_type_mask | Long |  |
| party_id | String |  |
| resource_spec_id | String |  |
| scheduled_end | Instant |  |
| scheduled_start | Instant |  |
| unresolved_party_name | String |  |
| version_number | Long |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_id | String | PK |
| campaign_id | String | FK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| originating_lead_id | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_account_id | String | FK |
| parent_contact_id | String | FK |
| transaction_currency_id | String | FK |
| actual_close_date | String |  |
| actual_value | Double |  |
| actual_value_base | Double |  |
| budget_amount | Double |  |
| budget_amount_base | Double |  |
| close_probability | Long |  |
| created_on | Instant |  |
| customer_id | String |  |
| description | String |  |
| estimated_close_date | String |  |
| estimated_value | Double |  |
| exchange_rate | Double |  |
| modified_on | Instant |  |
| msdyn_forecast_category | Long |  |
| msdyn_opportunity_kpi_id | String |  |
| msdyn_predictive_score_id | String |  |
| msdyn_segment_id | String |  |
| name | String |  |
| owner_id | String |  |
| price_level_id | String |  |
| sales_stage | Long |  |
| sales_stage_code | Long |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| step_name | String |  |
| total_amount | Double |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | String | PK |
| administrator_id | String | FK |
| business_unit_id | String | FK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| transaction_currency_id | String | FK |
| azure_active_directory_object_id | String |  |
| created_on | Instant |  |
| delegated_authorization_id | String |  |
| description | String |  |
| email_address | String |  |
| exchange_rate | Double |  |
| import_sequence_number | Long |  |
| is_default | Boolean |  |
| is_sas_token_set | Boolean |  |
| membership_type | Long |  |
| modified_on | Instant |  |
| name | String |  |
| organization_id | String |  |
| overridden_created_on | String |  |
| owner_id | String |  |
| process_id | String |  |
| queue_id | String |  |
| regarding_object_id | String |  |
| share_link_qualifier | String |  |
| stage_id | String |  |
| system_managed | Boolean |  |
| team_template_id | String |  |
| team_type | Long |  |
| traversed_path | String |  |
| version_number | Long |  |
| yomi_name | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| master_id | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| msa_managing_partner_id | String | FK |
| originating_lead_id | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_contact_id | String | FK |
| preferred_system_user_id | String | FK |
| transaction_currency_id | String | FK |
| account_id | String |  |
| address_1_city | String |  |
| address_1_country | String |  |
| address_1_line_1 | String |  |
| address_1_postalcode | String |  |
| address_1_stateorprovince | String |  |
| birth_date | String |  |
| created_on | Instant |  |
| default_price_level_id | String |  |
| email_address_1 | String |  |
| first_name | String |  |
| full_name | String |  |
| job_title | String |  |
| last_name | String |  |
| merged | Boolean |  |
| modified_on | Instant |  |
| msdyn_contact_kpi_id | String |  |
| owner_id | String |  |
| parent_customer_id | String |  |
| preferred_equipment_id | String |  |
| preferred_service_id | String |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| telephone_1 | String |  |

### campaignactivity

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| activity_additional_params | String |  |
| activity_type_code | String |  |
| actual_cost | Double |  |
| actual_cost_base | Double |  |
| actual_duration_minutes | Long |  |
| actual_end | Instant |  |
| actual_start | Instant |  |
| budgeted_cost | Double |  |
| budgeted_cost_base | String |  |
| category | String |  |
| channel_type_code | Long |  |
| community | Long |  |
| created_by | String |  |
| created_on | Instant |  |
| created_on_behalf_by | String |  |
| delivery_last_attempted_on | String |  |
| delivery_priority_code | Long |  |
| description | String |  |
| description_blob_id | String |  |
| description_blob_id_name | String |  |
| do_not_send_on_opt_out | Boolean |  |
| exchange_item_id | String |  |
| exchange_rate | Double |  |
| exchange_web_link | String |  |
| exclude_if_contacted_in_x_days | Long |  |
| formatted_scheduled_end | Instant |  |
| formatted_scheduled_start | Instant |  |
| ignore_inactive_list_members | Boolean |  |
| import_sequence_number | Long |  |
| modified_by | String |  |
| modified_on_behalf_by | String |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_team | String |  |
| owning_user | String |  |
| regarding_object_id | String |  |
| sender_mailbox_id | String |  |
| service_id | String |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| transaction_currency_id | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| master_id | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| msa_managing_partner_id | String | FK |
| originating_lead_id | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| parent_account_id | String | FK |
| preferred_system_user_id | String | FK |
| primary_contact_id | String | FK |
| transaction_currency_id | String | FK |
| account_category_code | Long |  |
| account_number | String |  |
| address_1_city | String |  |
| address_1_country | String |  |
| address_1_line_1 | String |  |
| address_1_postalcode | String |  |
| address_1_stateorprovince | String |  |
| business_type_code | Long |  |
| created_on | Instant |  |
| default_price_level_id | String |  |
| industry_code | Long |  |
| merged | Boolean |  |
| modified_on | Instant |  |
| msdyn_account_kpi_id | String |  |
| msdyn_sales_acceleration_insight_id | String |  |
| name | String |  |
| number_of_employees | Long |  |
| owner_id | String |  |
| preferred_equipment_id | String |  |
| preferred_service_id | String |  |
| revenue | Double |  |
| sla_id | String |  |
| sla_invoked_id | String |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| territory_id | String |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_team | String | FK |
| owning_user | String | FK |
| transaction_currency_id | String | FK |
| actual_end | Instant |  |
| actual_start | Instant |  |
| budgeted_cost | Double |  |
| budgeted_cost_base | Double |  |
| code_name | String |  |
| created_on | Instant |  |
| description | String |  |
| email_address | String |  |
| entity_image | String |  |
| entity_image_timestamp | Long |  |
| exchange_rate | Double |  |
| expected_revenue | Double |  |
| expected_revenue_base | Double |  |
| is_template | Boolean |  |
| modified_on | Instant |  |
| name | String |  |
| objective | String |  |
| other_cost | Double |  |
| other_cost_base | Double |  |
| owner_id | String |  |
| price_list_id | String |  |
| proposed_end | Instant |  |
| proposed_start | Instant |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| time_zone_rule_version_number | Long |  |
| total_actual_cost | Double |  |
| total_actual_cost_base | Double |  |
| total_campaign_activity_actual_cost | Double |  |
| total_campaign_activity_actual_cost_base | Double |  |
| type_code | Long |  |
| version_number | Long |  |

### opportunityproduct

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_product_id | String | PK |
| created_by | String | FK |
| created_on_behalf_by | String | FK |
| modified_by | String | FK |
| modified_on_behalf_by | String | FK |
| opportunity_id | String | FK |
| owning_team | String | FK |
| parent_bundle_id | String | FK |
| parent_bundle_id_ref | String | FK |
| product_id | String | FK |
| transaction_currency_id | String | FK |
| base_amount | Double |  |
| base_amount_base | Double |  |
| created_on | Instant |  |
| description | String |  |
| entity_image | String |  |
| entity_image_id | String |  |
| entity_image_timestamp | Long |  |
| entity_image_url | String |  |
| exchange_rate | Double |  |
| extended_amount | Double |  |
| extended_amount_base | Double |  |
| import_sequence_number | Long |  |
| is_price_overridden | Boolean |  |
| is_product_overridden | Boolean |  |
| line_item_number | Long |  |
| manual_discount_amount | Double |  |
| manual_discount_amount_base | Double |  |
| modified_on | Instant |  |
| opportunity_product_name | String |  |
| opportunity_state_code | Long |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| price_per_unit | Double |  |
| product_association_id | String |  |
| product_description | String |  |
| product_name | String |  |
| product_type_code | Long |  |
| property_configuration_status | String |  |
| quantity | Double |  |
| sequence_number | Long |  |
| uom_id | String |  |

### socialprofile

| Column | Type | Keys |
| --- | --- | --- |
| social_profile_id | String | PK |
| created_on_behalf_by | String | FK |
| modified_on_behalf_by | String | FK |
| owning_business_unit | String | FK |
| owning_user | String | FK |
| transaction_currency_id | String | FK |
| blocked | Boolean |  |
| community | Long |  |
| created_by | String |  |
| created_on | Instant |  |
| customer_id | String |  |
| exchange_rate | Double |  |
| import_sequence_number | Long |  |
| influence_score | Double |  |
| modified_by | String |  |
| modified_on | Instant |  |
| msdyn_customer_opt_out | Boolean |  |
| msdyn_oc_follower_count | Long |  |
| msdyn_oc_following_count | Long |  |
| msdyn_oc_friend_count | Long |  |
| msdyn_phone_number | String |  |
| msdyn_profile_image_link | String |  |
| overridden_created_on | Instant |  |
| owner_id | String |  |
| owning_team | String |  |
| profile_full_name | String |  |
| profile_link | String |  |
| profile_name | String |  |
| state_code | Long |  |
| status_code | Long |  |
| time_zone_rule_version_number | Long |  |
| unique_profile_id | String |  |
| utc_conversion_time_zone_code | Long |  |
| version_number | Long |  |

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| activity_type_code | String |  |
| actual_duration_minutes | Long |  |
| actual_end | Instant |  |
| actual_start | Instant |  |
| category | String |  |
| community | Long |  |
| created_by | String |  |
| created_on | Instant |  |
| description | String |  |
| global_object_id | String |  |
| instance_type_code | Long |  |
| is_all_day_event | Boolean |  |
| is_billed | Boolean |  |
| is_draft | Boolean |  |
| is_regular_activity | Boolean |  |
| is_unsafe | Long |  |
| is_workflow_created | Boolean |  |
| location | String |  |
| modified_by | String |  |
| modified_fields_mask | String |  |
| modified_on | Instant |  |
| modified_on_behalf_by | String |  |
| original_start_date | Instant |  |
| outlook_owner_appt_id | Long |  |
| owner_id | String |  |
| owning_business_unit | String |  |
| owning_team | String |  |
| owning_user | String |  |
| priority_code | Long |  |
| process_id | String |  |
| regarding_object_id | String |  |
| scheduled_duration_minutes | Long |  |
| scheduled_end | Instant |  |
| scheduled_start | Instant |  |
| sort_date | Instant |  |
| stage_id | String |  |
| state_code | Long |  |
| status_code | Long |  |
| sub_category | String |  |
| subject | String |  |
| subscription_id | String |  |

## Relationships

- connection(created_by) → systemuser(system_user_id)
- connection(created_on_behalf_by) → systemuser(system_user_id)
- connection(modified_by) → systemuser(system_user_id)
- connection(modified_on_behalf_by) → systemuser(system_user_id)
- connection(owning_business_unit) → businessunit(business_unit_id)
- connection(related_connection_id) → connection(connection_id)
- connection(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- lead(campaign_id) → campaign(campaign_id)
- lead(created_by) → systemuser(system_user_id)
- lead(created_on_behalf_by) → systemuser(system_user_id)
- lead(master_id) → lead(lead_id)
- lead(modified_by) → systemuser(system_user_id)
- lead(modified_on_behalf_by) → systemuser(system_user_id)
- lead(originating_case_id) → incident(incident_id)
- lead(owning_business_unit) → businessunit(business_unit_id)
- lead(owning_team) → team(team_id)
- lead(owning_user) → systemuser(system_user_id)
- lead(parent_account_id) → account(account_id)
- lead(parent_contact_id) → contact(contact_id)
- lead(qualifying_opportunity_id) → opportunity(opportunity_id)
- lead(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- queueitem(queue_id) → queue(queue_id)
- queueitem(created_by) → systemuser(system_user_id)
- queueitem(modified_by) → systemuser(system_user_id)
- queueitem(created_on_behalf_by) → systemuser(system_user_id)
- queueitem(modified_on_behalf_by) → systemuser(system_user_id)
- queueitem(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- queue(created_by) → systemuser(system_user_id)
- queue(modified_by) → systemuser(system_user_id)
- queue(owning_business_unit) → businessunit(business_unit_id)
- queue(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- queue(created_on_behalf_by) → systemuser(system_user_id)
- queue(modified_on_behalf_by) → systemuser(system_user_id)
- email(senders_account) → account(account_id)
- businessunit(parent_business_unit_id) → businessunit(business_unit_id)
- businessunit(created_by) → systemuser(system_user_id)
- businessunit(created_on_behalf_by) → systemuser(system_user_id)
- businessunit(modified_by) → systemuser(system_user_id)
- businessunit(modified_on_behalf_by) → systemuser(system_user_id)
- businessunit(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- systemuser(business_unit_id) → businessunit(business_unit_id)
- systemuser(parent_system_user_id) → systemuser(system_user_id)
- systemuser(created_by) → systemuser(system_user_id)
- systemuser(modified_by) → systemuser(system_user_id)
- systemuser(modified_on_behalf_by) → systemuser(system_user_id)
- systemuser(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- systemuser(created_on_behalf_by) → systemuser(system_user_id)
- knowledgearticle(created_by) → systemuser(system_user_id)
- knowledgearticle(created_on_behalf_by) → systemuser(system_user_id)
- knowledgearticle(modified_by) → systemuser(system_user_id)
- knowledgearticle(modified_on_behalf_by) → systemuser(system_user_id)
- knowledgearticle(owning_business_unit) → businessunit(business_unit_id)
- knowledgearticle(owning_team) → team(team_id)
- knowledgearticle(owning_user) → systemuser(system_user_id)
- knowledgearticle(parent_article_content_id) → knowledgearticle(knowledge_article_id)
- knowledgearticle(previous_article_content_id) → knowledgearticle(knowledge_article_id)
- knowledgearticle(primary_author_id) → systemuser(system_user_id)
- knowledgearticle(root_article_id) → knowledgearticle(knowledge_article_id)
- knowledgearticle(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- listmember(created_by) → systemuser(system_user_id)
- listmember(modified_by) → systemuser(system_user_id)
- listmember(created_on_behalf_by) → systemuser(system_user_id)
- listmember(modified_on_behalf_by) → systemuser(system_user_id)
- transactioncurrency(created_on_behalf_by) → systemuser(system_user_id)
- transactioncurrency(created_by) → systemuser(system_user_id)
- transactioncurrency(modified_by) → systemuser(system_user_id)
- transactioncurrency(modified_on_behalf_by) → systemuser(system_user_id)
- incident(created_by) → systemuser(system_user_id)
- incident(existing_case) → incident(incident_id)
- incident(master_id) → incident(incident_id)
- incident(modified_by) → systemuser(system_user_id)
- incident(owning_business_unit) → businessunit(business_unit_id)
- incident(owning_team) → team(team_id)
- incident(owning_user) → systemuser(system_user_id)
- incident(parent_case_id) → incident(incident_id)
- incident(created_on_behalf_by) → systemuser(system_user_id)
- incident(modified_on_behalf_by) → systemuser(system_user_id)
- incident(primary_contact_id) → contact(contact_id)
- incident(product_id) → product(product_id)
- incident(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- list(created_by) → systemuser(system_user_id)
- list(modified_by) → systemuser(system_user_id)
- list(modified_on_behalf_by) → systemuser(system_user_id)
- list(owning_business_unit) → businessunit(business_unit_id)
- list(owning_user) → systemuser(system_user_id)
- list(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- list(created_on_behalf_by) → systemuser(system_user_id)
- list(owning_team) → team(team_id)
- activitypointer(created_by) → systemuser(system_user_id)
- activitypointer(modified_by) → systemuser(system_user_id)
- activitypointer(created_on_behalf_by) → systemuser(system_user_id)
- activitypointer(modified_on_behalf_by) → systemuser(system_user_id)
- activitypointer(owning_business_unit) → businessunit(business_unit_id)
- activitypointer(owning_team) → team(team_id)
- activitypointer(owning_user) → systemuser(system_user_id)
- activitypointer(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- product(created_by) → systemuser(system_user_id)
- product(modified_by) → systemuser(system_user_id)
- product(parent_product_id) → product(product_id)
- product(created_on_behalf_by) → systemuser(system_user_id)
- product(modified_on_behalf_by) → systemuser(system_user_id)
- product(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- activityparty(activity_id) → activitypointer(activity_id)
- opportunity(created_by) → systemuser(system_user_id)
- opportunity(parent_account_id) → account(account_id)
- opportunity(campaign_id) → campaign(campaign_id)
- opportunity(modified_by) → systemuser(system_user_id)
- opportunity(parent_contact_id) → contact(contact_id)
- opportunity(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- opportunity(created_on_behalf_by) → systemuser(system_user_id)
- opportunity(modified_on_behalf_by) → systemuser(system_user_id)
- opportunity(originating_lead_id) → lead(lead_id)
- opportunity(owning_business_unit) → businessunit(business_unit_id)
- opportunity(owning_team) → team(team_id)
- opportunity(owning_user) → systemuser(system_user_id)
- team(business_unit_id) → businessunit(business_unit_id)
- team(administrator_id) → systemuser(system_user_id)
- team(created_by) → systemuser(system_user_id)
- team(modified_by) → systemuser(system_user_id)
- team(modified_on_behalf_by) → systemuser(system_user_id)
- team(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- team(created_on_behalf_by) → systemuser(system_user_id)
- contact(created_by) → systemuser(system_user_id)
- contact(owning_business_unit) → businessunit(business_unit_id)
- contact(owning_user) → systemuser(system_user_id)
- contact(modified_by) → systemuser(system_user_id)
- contact(owning_team) → team(team_id)
- contact(created_on_behalf_by) → systemuser(system_user_id)
- contact(master_id) → contact(contact_id)
- contact(modified_on_behalf_by) → systemuser(system_user_id)
- contact(preferred_system_user_id) → systemuser(system_user_id)
- contact(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- contact(originating_lead_id) → lead(lead_id)
- contact(msa_managing_partner_id) → account(account_id)
- contact(parent_contact_id) → contact(contact_id)
- account(parent_account_id) → account(account_id)
- account(modified_by) → systemuser(system_user_id)
- account(created_by) → systemuser(system_user_id)
- account(owning_business_unit) → businessunit(business_unit_id)
- account(primary_contact_id) → contact(contact_id)
- account(owning_team) → team(team_id)
- account(owning_user) → systemuser(system_user_id)
- account(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- account(master_id) → account(account_id)
- account(created_on_behalf_by) → systemuser(system_user_id)
- account(modified_on_behalf_by) → systemuser(system_user_id)
- account(preferred_system_user_id) → systemuser(system_user_id)
- account(originating_lead_id) → lead(lead_id)
- account(msa_managing_partner_id) → account(account_id)
- campaign(created_by) → systemuser(system_user_id)
- campaign(modified_by) → systemuser(system_user_id)
- campaign(owning_business_unit) → businessunit(business_unit_id)
- campaign(owning_user) → systemuser(system_user_id)
- campaign(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- campaign(created_on_behalf_by) → systemuser(system_user_id)
- campaign(modified_on_behalf_by) → systemuser(system_user_id)
- campaign(owning_team) → team(team_id)
- opportunityproduct(opportunity_id) → opportunity(opportunity_id)
- opportunityproduct(product_id) → product(product_id)
- opportunityproduct(created_by) → systemuser(system_user_id)
- opportunityproduct(modified_by) → systemuser(system_user_id)
- opportunityproduct(owning_team) → team(team_id)
- opportunityproduct(created_on_behalf_by) → systemuser(system_user_id)
- opportunityproduct(modified_on_behalf_by) → systemuser(system_user_id)
- opportunityproduct(parent_bundle_id_ref) → opportunityproduct(opportunity_product_id)
- opportunityproduct(transaction_currency_id) → transactioncurrency(transaction_currency_id)
- opportunityproduct(parent_bundle_id) → opportunityproduct(opportunity_product_id)
- socialprofile(created_on_behalf_by) → systemuser(system_user_id)
- socialprofile(modified_on_behalf_by) → systemuser(system_user_id)
- socialprofile(owning_business_unit) → businessunit(business_unit_id)
- socialprofile(owning_user) → systemuser(system_user_id)
- socialprofile(transaction_currency_id) → transactioncurrency(transaction_currency_id)