Microsoft Dynamics 365 CRM

Explore the interactive ERD

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