version: 2

sources:
  - name: dynamics_365_crm 
    database: "{% if target.type not in ('spark') %}{{ var('dynamics_365_crm_database', target.database) }}{% endif %}"
    schema: "{{ var('dynamics_365_crm_schema', 'dynamics_365')}}"

    loader: fivetran
    config:
      loaded_at_field: _fivetran_synced

    tables:
      - name: account
        identifier: "{{ var('dynamics_365_crm_account_identifier', 'account') }}"
        description: "Table containing businesses that represent customers or potential customers. Includes information about the companies billed in business transactions."
        config:
          enabled: "{{ var('dynamics_365_crm_using_account', true) }}"
      - name: appointment
        identifier: "{{ var('dynamics_365_crm_appointment_identifier', 'appointment') }}"
        description: "Table storing commitments representing time intervals, including start/end times and durations."
        config:
          enabled: "{{ var('dynamics_365_crm_using_appointment', true) }}"
      - name: contact
        identifier: "{{ var('dynamics_365_crm_contact_identifier', 'contact') }}"
        description: "Table capturing persons with whom a business unit has relationships, such as customers, suppliers, or colleagues."
        config:
          enabled: "{{ var('dynamics_365_crm_using_contact', true) }}"
      - name: email
        identifier: "{{ var('dynamics_365_crm_email_identifier', 'email') }}"
        description: "Table used to track activities related to emails."
        config:
          enabled: "{{ var('dynamics_365_crm_using_email', true) }}"
      - name: incident
        identifier: "{{ var('dynamics_365_crm_incident_identifier', 'incident') }}"
        description: "Table tracking service request cases associated with contracts."
        config:
          enabled: "{{ var('dynamics_365_crm_using_incident', true) }}"
      - name: msdyn_customerasset
        identifier: "{{ var('dynamics_365_crm_msdyn_customerasset_identifier', 'msdyn_customerasset') }}"
        description: "Table storing customer-owned assets serviced by the organization, used in Dynamics 365 Field Service."
        config:
          enabled: "{{ var('dynamics_365_crm_using_msdyn_customerasset', true) }}"
      - name: msdyn_workorder
        identifier: "{{ var('dynamics_365_crm_msdyn_workorder_identifier', 'msdyn_workorder') }}"
        description: "Table storing work orders that define service tasks to be performed at a customer location in Dynamics 365 Field Service."
        config:
          enabled: "{{ var('dynamics_365_crm_using_msdyn_workorder', true) }}"
      - name: msdyn_workorderproduct
        identifier: "{{ var('dynamics_365_crm_msdyn_workorderproduct_identifier', 'msdyn_workorderproduct') }}"
        description: "Table storing products associated with a work order in Dynamics 365 Field Service."
        config:
          enabled: "{{ var('dynamics_365_crm_using_msdyn_workorderproduct', true) }}"
      - name: opportunity
        identifier: "{{ var('dynamics_365_crm_opportunity_identifier', 'opportunity') }}"
        description: "Table representing potential revenue-generating events or sales to accounts that are tracked through the sales process."
        config:
          enabled: "{{ var('dynamics_365_crm_using_opportunity', true) }}"
      - name: phonecall
        identifier: "{{ var('dynamics_365_crm_phonecall_identifier', 'phonecall') }}"
        description: "Table used to track activities related to telephone calls."
        config:
          enabled: "{{ var('dynamics_365_crm_using_phonecall', true) }}"
      - name: stringmap
        identifier: "{{ var('dynamics_365_crm_stringmap_identifier', 'stringmap') }}"
        description: "Table mapping option set values (integer codes) to their corresponding string labels for fields across Dynamics 365 CRM tables."
      - name: systemuser
        identifier: "{{ var('dynamics_365_crm_systemuser_identifier', 'systemuser') }}"
        description: "Table storing details of persons with access to the Microsoft CRM system, who own and manage objects in the CRM database."
        config:
          enabled: "{{ var('dynamics_365_crm_using_systemuser', true) }}"
      - name: task
        identifier: "{{ var('dynamics_365_crm_task_identifier', 'task') }}"
        description: "Table used to track activities related to tasks."
        config:
          enabled: "{{ var('dynamics_365_crm_using_task', true) }}"