Windsor brings all your Freshsales data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Freshsales Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| accounts__active_sales_sequences | TEXT | accounts.active_sales_sequences | accounts.active_sales_sequences | accounts |
| accounts__address | TEXT | accounts.address | accounts.address | accounts |
| accounts__annual_revenue | NUMERIC | accounts.annual_revenue | accounts.annual_revenue | accounts |
| accounts__avatar | TEXT | accounts.avatar | accounts.avatar | accounts |
| accounts__business_type_id | NUMERIC | accounts.business_type_id | accounts.business_type_id | accounts |
| accounts__city | CITY | accounts.city | accounts.city | accounts |
| accounts__completed_sales_sequences | TEXT | accounts.completed_sales_sequences | accounts.completed_sales_sequences | accounts |
| accounts__country | COUNTRY | accounts.country | accounts.country | accounts |
| accounts__created_at | DATE | accounts.created_at | accounts.created_at | accounts |
| accounts__custom_field | OBJECT | accounts.custom_field | accounts.custom_field | accounts |
| accounts__customer_fit | TEXT | accounts.customer_fit | accounts.customer_fit | accounts |
| accounts__display_name | TEXT | accounts.display_name | accounts.display_name | accounts |
| accounts__email | TEXT | accounts.email | accounts.email | accounts |
| accounts__emails | OBJECT | accounts.emails | accounts.emails | accounts |
| accounts__external_id | TEXT | accounts.external_id | accounts.external_id | accounts |
| accounts__facebook | TEXT | accounts.facebook | accounts.facebook | accounts |
| accounts__first_name | TEXT | accounts.first_name | accounts.first_name | accounts |
| accounts__id | TEXT | accounts.id | accounts.id | accounts |
| accounts__industry_type_id | NUMERIC | accounts.industry_type_id | accounts.industry_type_id | accounts |
| accounts__is_deleted | BOOLEAN | accounts.is_deleted | accounts.is_deleted | accounts |
| accounts__job_title | TEXT | accounts.job_title | accounts.job_title | accounts |
| accounts__keyword | TEXT | accounts.keyword | accounts.keyword | accounts |
| accounts__last_assigned_at | DATE | accounts.last_assigned_at | accounts.last_assigned_at | accounts |
| accounts__last_contacted | DATE | accounts.last_contacted | accounts.last_contacted | accounts |
| accounts__last_contacted_mode | TEXT | accounts.last_contacted_mode | accounts.last_contacted_mode | accounts |
| accounts__last_contacted_sales_activity_mode | TEXT | accounts.last_contacted_sales_activity_mode | accounts.last_contacted_sales_activity_mode | accounts |
| accounts__last_contacted_via_sales_activity | TEXT | accounts.last_contacted_via_sales_activity | accounts.last_contacted_via_sales_activity | accounts |
| accounts__last_name | TEXT | accounts.last_name | accounts.last_name | accounts |
| accounts__last_seen | DATE | accounts.last_seen | accounts.last_seen | accounts |
| accounts__lead_score | NUMERIC | accounts.lead_score | accounts.lead_score | accounts |
| accounts__linkedin | TEXT | accounts.linkedin | accounts.linkedin | accounts |
| accounts__links | OBJECT | accounts.links | accounts.links | accounts |
| accounts__medium | TEXT | accounts.medium | accounts.medium | accounts |
| accounts__mobile_number | TEXT | accounts.mobile_number | accounts.mobile_number | accounts |
| accounts__name | TEXT | accounts.name | accounts.name | accounts |
| accounts__number_of_employees | NUMERIC | accounts.number_of_employees | accounts.number_of_employees | accounts |
| accounts__open_deals_amount | TEXT | accounts.open_deals_amount | accounts.open_deals_amount | accounts |
| accounts__open_deals_count | NUMERIC | accounts.open_deals_count | accounts.open_deals_count | accounts |
| accounts__owner_id | NUMERIC | accounts.owner_id | accounts.owner_id | accounts |
| accounts__parent_sales_account_id | NUMERIC | accounts.parent_sales_account_id | accounts.parent_sales_account_id | accounts |
| accounts__phone | TEXT | accounts.phone | accounts.phone | accounts |
| accounts__phone_numbers | OBJECT | accounts.phone_numbers | accounts.phone_numbers | accounts |
| accounts__recent_note | TEXT | accounts.recent_note | accounts.recent_note | accounts |
| accounts__state | TEXT | accounts.state | accounts.state | accounts |
| accounts__subscription_status | NUMERIC | accounts.subscription_status | accounts.subscription_status | accounts |
| accounts__subscription_types | TEXT | accounts.subscription_types | accounts.subscription_types | accounts |
| accounts__tags | OBJECT | accounts.tags | accounts.tags | accounts |
| accounts__team_user_ids | OBJECT | accounts.team_user_ids | accounts.team_user_ids | accounts |
| accounts__territory_id | NUMERIC | accounts.territory_id | accounts.territory_id | accounts |
| accounts__time_zone | TEXT | accounts.time_zone | accounts.time_zone | accounts |
| accounts__twitter | TEXT | accounts.twitter | accounts.twitter | accounts |
| accounts__updated_at | DATE | accounts.updated_at | accounts.updated_at | accounts |
| accounts__web_form_ids | OBJECT | accounts.web_form_ids | accounts.web_form_ids | accounts |
| accounts__website | TEXT | accounts.website | accounts.website | accounts |
| accounts__whatsapp_subscription_status | TEXT | accounts.whatsapp_subscription_status | accounts.whatsapp_subscription_status | accounts |
| accounts__won_deals_amount | TEXT | accounts.won_deals_amount | accounts.won_deals_amount | accounts |
| accounts__won_deals_count | NUMERIC | accounts.won_deals_count | accounts.won_deals_count | accounts |
| accounts__work_email | TEXT | accounts.work_email | accounts.work_email | accounts |
| accounts__work_number | TEXT | accounts.work_number | accounts.work_number | accounts |
| accounts__zipcode | TEXT | accounts.zipcode | accounts.zipcode | accounts |
| completed_tasks__Possible | TEXT | completed_tasks.Possible | completed_tasks.Possible | completed_tasks |
| completed_tasks__completed_date | DATE | completed_tasks.completed_date | completed_tasks.completed_date | completed_tasks |
| completed_tasks__created_at | DATE | completed_tasks.created_at | completed_tasks.created_at | completed_tasks |
| completed_tasks__creater_id | NUMERIC | completed_tasks.creater_id | completed_tasks.creater_id | completed_tasks |
| completed_tasks__description | TEXT | completed_tasks.description | completed_tasks.description | completed_tasks |
| completed_tasks__due_date | DATE | completed_tasks.due_date | completed_tasks.due_date | completed_tasks |
| completed_tasks__id | NUMERIC | completed_tasks.id | completed_tasks.id | completed_tasks |
| completed_tasks__outcome_id | NUMERIC | completed_tasks.outcome_id | completed_tasks.outcome_id | completed_tasks |
| completed_tasks__owner_id | NUMERIC | completed_tasks.owner_id | completed_tasks.owner_id | completed_tasks |
| completed_tasks__status | NUMERIC | completed_tasks.status | completed_tasks.status | completed_tasks |
| completed_tasks__targetable_id | NUMERIC | completed_tasks.targetable_id | completed_tasks.targetable_id | completed_tasks |
| completed_tasks__targetable_type | TEXT | completed_tasks.targetable_type | completed_tasks.targetable_type | completed_tasks |
| completed_tasks__targetables | OBJECT | completed_tasks.targetables | completed_tasks.targetables | completed_tasks |
| completed_tasks__task_type_id | NUMERIC | completed_tasks.task_type_id | completed_tasks.task_type_id | completed_tasks |
| completed_tasks__title | TEXT | completed_tasks.title | completed_tasks.title | completed_tasks |
| completed_tasks__updated_at | DATE | completed_tasks.updated_at | completed_tasks.updated_at | completed_tasks |
| completed_tasks__updater_id | NUMERIC | completed_tasks.updater_id | completed_tasks.updater_id | completed_tasks |
| contacts__active_sales_sequences | TEXT | contacts.active_sales_sequences | contacts.active_sales_sequences | contacts |
| contacts__address | TEXT | contacts.address | contacts.address | contacts |
| contacts__avatar | TEXT | contacts.avatar | contacts.avatar | contacts |
| contacts__campaign_id | NUMERIC | contacts.campaign_id | contacts.campaign_id | contacts |
| contacts__city | CITY | contacts.city | contacts.city | contacts |
| contacts__completed_sales_sequences | TEXT | contacts.completed_sales_sequences | contacts.completed_sales_sequences | contacts |
| contacts__contact_status_id | NUMERIC | contacts.contact_status_id | contacts.contact_status_id | contacts |
| contacts__country | COUNTRY | contacts.country | contacts.country | contacts |
| contacts__created_at | DATE | contacts.created_at | contacts.created_at | contacts |
| contacts__custom_field | OBJECT | contacts.custom_field | contacts.custom_field | contacts |
| contacts__customer_fit | NUMERIC | contacts.customer_fit | contacts.customer_fit | contacts |
| contacts__display_name | TEXT | contacts.display_name | contacts.display_name | contacts |
| contacts__email | TEXT | contacts.email | contacts.email | contacts |
| contacts__emails | OBJECT | contacts.emails | contacts.emails | contacts |
| contacts__external_id | TEXT | contacts.external_id | contacts.external_id | contacts |
| contacts__facebook | TEXT | contacts.facebook | contacts.facebook | contacts |
| contacts__first_campaign | TEXT | contacts.first_campaign | contacts.first_campaign | contacts |
| contacts__first_medium | TEXT | contacts.first_medium | contacts.first_medium | contacts |
| contacts__first_name | TEXT | contacts.first_name | contacts.first_name | contacts |
| contacts__first_seen_chat | DATE | contacts.first_seen_chat | contacts.first_seen_chat | contacts |
| contacts__first_source | TEXT | contacts.first_source | contacts.first_source | contacts |
| contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
| contacts__is_deleted | BOOLEAN | contacts.is_deleted | contacts.is_deleted | contacts |
| contacts__job_title | TEXT | contacts.job_title | contacts.job_title | contacts |
| contacts__keyword | TEXT | contacts.keyword | contacts.keyword | contacts |
| contacts__last_assigned_at | DATE | contacts.last_assigned_at | contacts.last_assigned_at | contacts |
| contacts__last_campaign | TEXT | contacts.last_campaign | contacts.last_campaign | contacts |
| contacts__last_contacted | DATE | contacts.last_contacted | contacts.last_contacted | contacts |
| contacts__last_contacted_mode | TEXT | contacts.last_contacted_mode | contacts.last_contacted_mode | contacts |
| contacts__last_contacted_sales_activity_mode | TEXT | contacts.last_contacted_sales_activity_mode | contacts.last_contacted_sales_activity_mode | contacts |
| contacts__last_contacted_via_sales_activity | TEXT | contacts.last_contacted_via_sales_activity | contacts.last_contacted_via_sales_activity | contacts |
| contacts__last_medium | TEXT | contacts.last_medium | contacts.last_medium | contacts |
| contacts__last_name | TEXT | contacts.last_name | contacts.last_name | contacts |
| contacts__last_seen | DATE | contacts.last_seen | contacts.last_seen | contacts |
| contacts__last_seen_chat | DATE | contacts.last_seen_chat | contacts.last_seen_chat | contacts |
| contacts__last_source | TEXT | contacts.last_source | contacts.last_source | contacts |
| contacts__latest_campaign | TEXT | contacts.latest_campaign | contacts.latest_campaign | contacts |
| contacts__latest_medium | TEXT | contacts.latest_medium | contacts.latest_medium | contacts |
| contacts__latest_source | TEXT | contacts.latest_source | contacts.latest_source | contacts |
| contacts__lead_score | NUMERIC | contacts.lead_score | contacts.lead_score | contacts |
| contacts__lead_source_id | NUMERIC | contacts.lead_source_id | contacts.lead_source_id | contacts |
| contacts__lifecycle_stage_id | NUMERIC | contacts.lifecycle_stage_id | contacts.lifecycle_stage_id | contacts |
| contacts__linkedin | TEXT | contacts.linkedin | contacts.linkedin | contacts |
| contacts__links | OBJECT | contacts.links | contacts.links | contacts |
| contacts__locale | TEXT | contacts.locale | contacts.locale | contacts |
| contacts__mcr_id | NUMERIC | contacts.mcr_id | contacts.mcr_id | contacts |
| contacts__medium | TEXT | contacts.medium | contacts.medium | contacts |
| contacts__mobile_number | TEXT | contacts.mobile_number | contacts.mobile_number | contacts |
| contacts__open_deals_amount | TEXT | contacts.open_deals_amount | contacts.open_deals_amount | contacts |
| contacts__open_deals_count | NUMERIC | contacts.open_deals_count | contacts.open_deals_count | contacts |
| contacts__other_unsubscription_reason | TEXT | contacts.other_unsubscription_reason | contacts.other_unsubscription_reason | contacts |
| contacts__owner_id | NUMERIC | contacts.owner_id | contacts.owner_id | contacts |
| contacts__phone_numbers | OBJECT | contacts.phone_numbers | contacts.phone_numbers | contacts |
| contacts__recent_note | TEXT | contacts.recent_note | contacts.recent_note | contacts |
| contacts__sales_account_id | NUMERIC | contacts.sales_account_id | contacts.sales_account_id | contacts |
| contacts__sales_accounts | OBJECT | contacts.sales_accounts | contacts.sales_accounts | contacts |
| contacts__sms_subscription_status | NUMERIC | contacts.sms_subscription_status | contacts.sms_subscription_status | contacts |
| contacts__state | TEXT | contacts.state | contacts.state | contacts |
| contacts__subscription_status | NUMERIC | contacts.subscription_status | contacts.subscription_status | contacts |
| contacts__subscription_types | TEXT | contacts.subscription_types | contacts.subscription_types | contacts |
| contacts__system_tags | OBJECT | contacts.system_tags | contacts.system_tags | contacts |
| contacts__tags | OBJECT | contacts.tags | contacts.tags | contacts |
| contacts__team_user_ids | TEXT | contacts.team_user_ids | contacts.team_user_ids | contacts |
| contacts__territory_id | NUMERIC | contacts.territory_id | contacts.territory_id | contacts |
| contacts__time_zone | TEXT | contacts.time_zone | contacts.time_zone | contacts |
| contacts__total_sessions | TEXT | contacts.total_sessions | contacts.total_sessions | contacts |
| contacts__twitter | TEXT | contacts.twitter | contacts.twitter | contacts |
| contacts__unsubscription_reason | TEXT | contacts.unsubscription_reason | contacts.unsubscription_reason | contacts |
| contacts__updated_at | DATE | contacts.updated_at | contacts.updated_at | contacts |
| contacts__web_form_ids | TEXT | contacts.web_form_ids | contacts.web_form_ids | contacts |
| contacts__whatsapp_subscription_status | NUMERIC | contacts.whatsapp_subscription_status | contacts.whatsapp_subscription_status | contacts |
| contacts__won_deals_amount | TEXT | contacts.won_deals_amount | contacts.won_deals_amount | contacts |
| contacts__won_deals_count | NUMERIC | contacts.won_deals_count | contacts.won_deals_count | contacts |
| contacts__work_email | TEXT | contacts.work_email | contacts.work_email | contacts |
| contacts__work_number | TEXT | contacts.work_number | contacts.work_number | contacts |
| contacts__zipcode | TEXT | contacts.zipcode | contacts.zipcode | contacts |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| lost_deals__active_sales_sequences | TEXT | lost_deals.active_sales_sequences | lost_deals.active_sales_sequences | lost_deals |
| lost_deals__age | NUMERIC | lost_deals.age | lost_deals.age | lost_deals |
| lost_deals__amount | TEXT | lost_deals.amount | lost_deals.amount | lost_deals |
| lost_deals__avatar | TEXT | lost_deals.avatar | lost_deals.avatar | lost_deals |
| lost_deals__base_currency_amount | TEXT | lost_deals.base_currency_amount | lost_deals.base_currency_amount | lost_deals |
| lost_deals__campaign_id | NUMERIC | lost_deals.campaign_id | lost_deals.campaign_id | lost_deals |
| lost_deals__closed_date | DATE | lost_deals.closed_date | lost_deals.closed_date | lost_deals |
| lost_deals__collaboration | OBJECT | lost_deals.collaboration | lost_deals.collaboration | lost_deals |
| lost_deals__completed_sales_sequences | TEXT | lost_deals.completed_sales_sequences | lost_deals.completed_sales_sequences | lost_deals |
| lost_deals__created_at | DATE | lost_deals.created_at | lost_deals.created_at | lost_deals |
| lost_deals__currency_id | NUMERIC | lost_deals.currency_id | lost_deals.currency_id | lost_deals |
| lost_deals__custom_field | OBJECT | lost_deals.custom_field | lost_deals.custom_field | lost_deals |
| lost_deals__deal_payment_status_id | NUMERIC | lost_deals.deal_payment_status_id | lost_deals.deal_payment_status_id | lost_deals |
| lost_deals__deal_pipeline_id | NUMERIC | lost_deals.deal_pipeline_id | lost_deals.deal_pipeline_id | lost_deals |
| lost_deals__deal_prediction | NUMERIC | lost_deals.deal_prediction | lost_deals.deal_prediction | lost_deals |
| lost_deals__deal_prediction_last_updated_at | DATE | lost_deals.deal_prediction_last_updated_at | lost_deals.deal_prediction_last_updated_at | lost_deals |
| lost_deals__deal_product_id | NUMERIC | lost_deals.deal_product_id | lost_deals.deal_product_id | lost_deals |
| lost_deals__deal_reason_id | NUMERIC | lost_deals.deal_reason_id | lost_deals.deal_reason_id | lost_deals |
| lost_deals__deal_stage_id | NUMERIC | lost_deals.deal_stage_id | lost_deals.deal_stage_id | lost_deals |
| lost_deals__deal_type_id | NUMERIC | lost_deals.deal_type_id | lost_deals.deal_type_id | lost_deals |
| lost_deals__expected_close | TEXT | lost_deals.expected_close | lost_deals.expected_close | lost_deals |
| lost_deals__expected_deal_value | TEXT | lost_deals.expected_deal_value | lost_deals.expected_deal_value | lost_deals |
| lost_deals__fc_widget_collaboration | OBJECT | lost_deals.fc_widget_collaboration | lost_deals.fc_widget_collaboration | lost_deals |
| lost_deals__forecast_category | NUMERIC | lost_deals.forecast_category | lost_deals.forecast_category | lost_deals |
| lost_deals__freddy_forecast_metrics | TEXT | lost_deals.freddy_forecast_metrics | lost_deals.freddy_forecast_metrics | lost_deals |
| lost_deals__has_products | BOOLEAN | lost_deals.has_products | lost_deals.has_products | lost_deals |
| lost_deals__id | NUMERIC | lost_deals.id | lost_deals.id | lost_deals |
| lost_deals__is_deleted | BOOLEAN | lost_deals.is_deleted | lost_deals.is_deleted | lost_deals |
| lost_deals__last_assigned_at | DATE | lost_deals.last_assigned_at | lost_deals.last_assigned_at | lost_deals |
| lost_deals__last_contacted_sales_activity_mode | TEXT | lost_deals.last_contacted_sales_activity_mode | lost_deals.last_contacted_sales_activity_mode | lost_deals |
| lost_deals__last_contacted_via_sales_activity | TEXT | lost_deals.last_contacted_via_sales_activity | lost_deals.last_contacted_via_sales_activity | lost_deals |
| lost_deals__last_deal_prediction | TEXT | lost_deals.last_deal_prediction | lost_deals.last_deal_prediction | lost_deals |
| lost_deals__lead_source_id | NUMERIC | lost_deals.lead_source_id | lost_deals.lead_source_id | lost_deals |
| lost_deals__links | OBJECT | lost_deals.links | lost_deals.links | lost_deals |
| lost_deals__name | TEXT | lost_deals.name | lost_deals.name | lost_deals |
| lost_deals__owner_id | NUMERIC | lost_deals.owner_id | lost_deals.owner_id | lost_deals |
| lost_deals__probability | NUMERIC | lost_deals.probability | lost_deals.probability | lost_deals |
| lost_deals__products | TEXT | lost_deals.products | lost_deals.products | lost_deals |
| lost_deals__recent_note | TEXT | lost_deals.recent_note | lost_deals.recent_note | lost_deals |
| lost_deals__rotten_days | NUMERIC | lost_deals.rotten_days | lost_deals.rotten_days | lost_deals |
| lost_deals__sales_account_id | NUMERIC | lost_deals.sales_account_id | lost_deals.sales_account_id | lost_deals |
| lost_deals__stage_updated_time | DATE | lost_deals.stage_updated_time | lost_deals.stage_updated_time | lost_deals |
| lost_deals__tags | OBJECT | lost_deals.tags | lost_deals.tags | lost_deals |
| lost_deals__team_user_ids | TEXT | lost_deals.team_user_ids | lost_deals.team_user_ids | lost_deals |
| lost_deals__territory_id | NUMERIC | lost_deals.territory_id | lost_deals.territory_id | lost_deals |
| lost_deals__upcoming_activities_time | TIMESTAMP | lost_deals.upcoming_activities_time | lost_deals.upcoming_activities_time | lost_deals |
| lost_deals__updated_at | DATE | lost_deals.updated_at | lost_deals.updated_at | lost_deals |
| lost_deals__web_form_id | NUMERIC | lost_deals.web_form_id | lost_deals.web_form_id | lost_deals |
| open_deals__active_sales_sequences | TEXT | open_deals.active_sales_sequences | open_deals.active_sales_sequences | open_deals |
| open_deals__age | NUMERIC | open_deals.age | open_deals.age | open_deals |
| open_deals__amount | TEXT | open_deals.amount | open_deals.amount | open_deals |
| open_deals__avatar | TEXT | open_deals.avatar | open_deals.avatar | open_deals |
| open_deals__base_currency_amount | TEXT | open_deals.base_currency_amount | open_deals.base_currency_amount | open_deals |
| open_deals__campaign_id | NUMERIC | open_deals.campaign_id | open_deals.campaign_id | open_deals |
| open_deals__closed_date | DATE | open_deals.closed_date | open_deals.closed_date | open_deals |
| open_deals__collaboration | OBJECT | open_deals.collaboration | open_deals.collaboration | open_deals |
| open_deals__completed_sales_sequences | TEXT | open_deals.completed_sales_sequences | open_deals.completed_sales_sequences | open_deals |
| open_deals__created_at | DATE | open_deals.created_at | open_deals.created_at | open_deals |
| open_deals__currency_id | NUMERIC | open_deals.currency_id | open_deals.currency_id | open_deals |
| open_deals__custom_field | OBJECT | open_deals.custom_field | open_deals.custom_field | open_deals |
| open_deals__deal_payment_status_id | NUMERIC | open_deals.deal_payment_status_id | open_deals.deal_payment_status_id | open_deals |
| open_deals__deal_pipeline_id | NUMERIC | open_deals.deal_pipeline_id | open_deals.deal_pipeline_id | open_deals |
| open_deals__deal_prediction | NUMERIC | open_deals.deal_prediction | open_deals.deal_prediction | open_deals |
| open_deals__deal_prediction_last_updated_at | DATE | open_deals.deal_prediction_last_updated_at | open_deals.deal_prediction_last_updated_at | open_deals |
| open_deals__deal_product_id | NUMERIC | open_deals.deal_product_id | open_deals.deal_product_id | open_deals |
| open_deals__deal_reason_id | NUMERIC | open_deals.deal_reason_id | open_deals.deal_reason_id | open_deals |
| open_deals__deal_stage_id | NUMERIC | open_deals.deal_stage_id | open_deals.deal_stage_id | open_deals |
| open_deals__deal_type_id | NUMERIC | open_deals.deal_type_id | open_deals.deal_type_id | open_deals |
| open_deals__expected_close | TEXT | open_deals.expected_close | open_deals.expected_close | open_deals |
| open_deals__expected_deal_value | TEXT | open_deals.expected_deal_value | open_deals.expected_deal_value | open_deals |
| open_deals__fc_widget_collaboration | OBJECT | open_deals.fc_widget_collaboration | open_deals.fc_widget_collaboration | open_deals |
| open_deals__forecast_category | NUMERIC | open_deals.forecast_category | open_deals.forecast_category | open_deals |
| open_deals__freddy_forecast_metrics | TEXT | open_deals.freddy_forecast_metrics | open_deals.freddy_forecast_metrics | open_deals |
| open_deals__has_products | BOOLEAN | open_deals.has_products | open_deals.has_products | open_deals |
| open_deals__id | NUMERIC | open_deals.id | open_deals.id | open_deals |
| open_deals__is_deleted | BOOLEAN | open_deals.is_deleted | open_deals.is_deleted | open_deals |
| open_deals__last_assigned_at | DATE | open_deals.last_assigned_at | open_deals.last_assigned_at | open_deals |
| open_deals__last_contacted_sales_activity_mode | TEXT | open_deals.last_contacted_sales_activity_mode | open_deals.last_contacted_sales_activity_mode | open_deals |
| open_deals__last_contacted_via_sales_activity | TEXT | open_deals.last_contacted_via_sales_activity | open_deals.last_contacted_via_sales_activity | open_deals |
| open_deals__last_deal_prediction | TEXT | open_deals.last_deal_prediction | open_deals.last_deal_prediction | open_deals |
| open_deals__lead_source_id | NUMERIC | open_deals.lead_source_id | open_deals.lead_source_id | open_deals |
| open_deals__links | OBJECT | open_deals.links | open_deals.links | open_deals |
| open_deals__name | TEXT | open_deals.name | open_deals.name | open_deals |
| open_deals__owner_id | NUMERIC | open_deals.owner_id | open_deals.owner_id | open_deals |
| open_deals__probability | NUMERIC | open_deals.probability | open_deals.probability | open_deals |
| open_deals__products | TEXT | open_deals.products | open_deals.products | open_deals |
| open_deals__recent_note | TEXT | open_deals.recent_note | open_deals.recent_note | open_deals |
| open_deals__rotten_days | NUMERIC | open_deals.rotten_days | open_deals.rotten_days | open_deals |
| open_deals__sales_account_id | NUMERIC | open_deals.sales_account_id | open_deals.sales_account_id | open_deals |
| open_deals__stage_updated_time | DATE | open_deals.stage_updated_time | open_deals.stage_updated_time | open_deals |
| open_deals__tags | OBJECT | open_deals.tags | open_deals.tags | open_deals |
| open_deals__team_user_ids | TEXT | open_deals.team_user_ids | open_deals.team_user_ids | open_deals |
| open_deals__territory_id | NUMERIC | open_deals.territory_id | open_deals.territory_id | open_deals |
| open_deals__upcoming_activities_time | TIMESTAMP | open_deals.upcoming_activities_time | open_deals.upcoming_activities_time | open_deals |
| open_deals__updated_at | DATE | open_deals.updated_at | open_deals.updated_at | open_deals |
| open_deals__web_form_id | NUMERIC | open_deals.web_form_id | open_deals.web_form_id | open_deals |
| open_tasks__Possible | TEXT | open_tasks.Possible | open_tasks.Possible | open_tasks |
| open_tasks__completed_date | DATE | open_tasks.completed_date | open_tasks.completed_date | open_tasks |
| open_tasks__created_at | DATE | open_tasks.created_at | open_tasks.created_at | open_tasks |
| open_tasks__creater_id | NUMERIC | open_tasks.creater_id | open_tasks.creater_id | open_tasks |
| open_tasks__description | TEXT | open_tasks.description | open_tasks.description | open_tasks |
| open_tasks__due_date | DATE | open_tasks.due_date | open_tasks.due_date | open_tasks |
| open_tasks__id | NUMERIC | open_tasks.id | open_tasks.id | open_tasks |
| open_tasks__outcome_id | NUMERIC | open_tasks.outcome_id | open_tasks.outcome_id | open_tasks |
| open_tasks__owner_id | NUMERIC | open_tasks.owner_id | open_tasks.owner_id | open_tasks |
| open_tasks__status | NUMERIC | open_tasks.status | open_tasks.status | open_tasks |
| open_tasks__targetable_id | NUMERIC | open_tasks.targetable_id | open_tasks.targetable_id | open_tasks |
| open_tasks__targetable_type | TEXT | open_tasks.targetable_type | open_tasks.targetable_type | open_tasks |
| open_tasks__targetables | OBJECT | open_tasks.targetables | open_tasks.targetables | open_tasks |
| open_tasks__task_type_id | NUMERIC | open_tasks.task_type_id | open_tasks.task_type_id | open_tasks |
| open_tasks__title | TEXT | open_tasks.title | open_tasks.title | open_tasks |
| open_tasks__updated_at | DATE | open_tasks.updated_at | open_tasks.updated_at | open_tasks |
| open_tasks__updater_id | NUMERIC | open_tasks.updater_id | open_tasks.updater_id | open_tasks |
| past_appointments__End | TEXT | past_appointments.End | past_appointments.End | past_appointments |
| past_appointments__Possible | TEXT | past_appointments.Possible | past_appointments.Possible | past_appointments |
| past_appointments__Start | TEXT | past_appointments.Start | past_appointments.Start | past_appointments |
| past_appointments__appointment_attendees_attributes | OBJECT | past_appointments.appointment_attendees_attributes | past_appointments.appointment_attendees_attributes | past_appointments |
| past_appointments__can_checkin | BOOLEAN | past_appointments.can_checkin | past_appointments.can_checkin | past_appointments |
| past_appointments__can_checkin_checkout | BOOLEAN | past_appointments.can_checkin_checkout | past_appointments.can_checkin_checkout | past_appointments |
| past_appointments__checkedin_at | DATE | past_appointments.checkedin_at | past_appointments.checkedin_at | past_appointments |
| past_appointments__checkedin_duration | TEXT | past_appointments.checkedin_duration | past_appointments.checkedin_duration | past_appointments |
| past_appointments__checkedout_at | DATE | past_appointments.checkedout_at | past_appointments.checkedout_at | past_appointments |
| past_appointments__checkedout_latitude | TEXT | past_appointments.checkedout_latitude | past_appointments.checkedout_latitude | past_appointments |
| past_appointments__checkedout_location | TEXT | past_appointments.checkedout_location | past_appointments.checkedout_location | past_appointments |
| past_appointments__checkedout_longitude | TEXT | past_appointments.checkedout_longitude | past_appointments.checkedout_longitude | past_appointments |
| past_appointments__conference_id | TEXT | past_appointments.conference_id | past_appointments.conference_id | past_appointments |
| past_appointments__created_at | DATE | past_appointments.created_at | past_appointments.created_at | past_appointments |
| past_appointments__creater_id | NUMERIC | past_appointments.creater_id | past_appointments.creater_id | past_appointments |
| past_appointments__date | DATE | past_appointments.date | past_appointments.date | past_appointments |
| past_appointments__description | TEXT | past_appointments.description | past_appointments.description | past_appointments |
| past_appointments__end_date | DATE | past_appointments.end_date | past_appointments.end_date | past_appointments |
| past_appointments__from_date | DATE | past_appointments.from_date | past_appointments.from_date | past_appointments |
| past_appointments__id | NUMERIC | past_appointments.id | past_appointments.id | past_appointments |
| past_appointments__is_allday | BOOLEAN | past_appointments.is_allday | past_appointments.is_allday | past_appointments |
| past_appointments__latitude | TEXT | past_appointments.latitude | past_appointments.latitude | past_appointments |
| past_appointments__location | TEXT | past_appointments.location | past_appointments.location | past_appointments |
| past_appointments__longitude | TEXT | past_appointments.longitude | past_appointments.longitude | past_appointments |
| past_appointments__outcome_id | NUMERIC | past_appointments.outcome_id | past_appointments.outcome_id | past_appointments |
| past_appointments__provider | TEXT | past_appointments.provider | past_appointments.provider | past_appointments |
| past_appointments__targetable_id | NUMERIC | past_appointments.targetable_id | past_appointments.targetable_id | past_appointments |
| past_appointments__targetable_type | TEXT | past_appointments.targetable_type | past_appointments.targetable_type | past_appointments |
| past_appointments__targetables | OBJECT | past_appointments.targetables | past_appointments.targetables | past_appointments |
| past_appointments__time_zone | TEXT | past_appointments.time_zone | past_appointments.time_zone | past_appointments |
| past_appointments__title | TEXT | past_appointments.title | past_appointments.title | past_appointments |
| past_appointments__updated_at | DATE | past_appointments.updated_at | past_appointments.updated_at | past_appointments |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| upcoming_appointments__End | TEXT | upcoming_appointments.End | upcoming_appointments.End | upcoming_appointments |
| upcoming_appointments__Possible | TEXT | upcoming_appointments.Possible | upcoming_appointments.Possible | upcoming_appointments |
| upcoming_appointments__Start | TEXT | upcoming_appointments.Start | upcoming_appointments.Start | upcoming_appointments |
| upcoming_appointments__appointment_attendees_attributes | OBJECT | upcoming_appointments.appointment_attendees_attributes | upcoming_appointments.appointment_attendees_attributes | upcoming_appointments |
| upcoming_appointments__can_checkin | BOOLEAN | upcoming_appointments.can_checkin | upcoming_appointments.can_checkin | upcoming_appointments |
| upcoming_appointments__can_checkin_checkout | BOOLEAN | upcoming_appointments.can_checkin_checkout | upcoming_appointments.can_checkin_checkout | upcoming_appointments |
| upcoming_appointments__checkedin_at | DATE | upcoming_appointments.checkedin_at | upcoming_appointments.checkedin_at | upcoming_appointments |
| upcoming_appointments__checkedin_duration | TEXT | upcoming_appointments.checkedin_duration | upcoming_appointments.checkedin_duration | upcoming_appointments |
| upcoming_appointments__checkedout_at | DATE | upcoming_appointments.checkedout_at | upcoming_appointments.checkedout_at | upcoming_appointments |
| upcoming_appointments__checkedout_latitude | TEXT | upcoming_appointments.checkedout_latitude | upcoming_appointments.checkedout_latitude | upcoming_appointments |
| upcoming_appointments__checkedout_location | TEXT | upcoming_appointments.checkedout_location | upcoming_appointments.checkedout_location | upcoming_appointments |
| upcoming_appointments__checkedout_longitude | TEXT | upcoming_appointments.checkedout_longitude | upcoming_appointments.checkedout_longitude | upcoming_appointments |
| upcoming_appointments__conference_id | TEXT | upcoming_appointments.conference_id | upcoming_appointments.conference_id | upcoming_appointments |
| upcoming_appointments__created_at | DATE | upcoming_appointments.created_at | upcoming_appointments.created_at | upcoming_appointments |
| upcoming_appointments__creater_id | NUMERIC | upcoming_appointments.creater_id | upcoming_appointments.creater_id | upcoming_appointments |
| upcoming_appointments__date | DATE | upcoming_appointments.date | upcoming_appointments.date | upcoming_appointments |
| upcoming_appointments__description | TEXT | upcoming_appointments.description | upcoming_appointments.description | upcoming_appointments |
| upcoming_appointments__end_date | DATE | upcoming_appointments.end_date | upcoming_appointments.end_date | upcoming_appointments |
| upcoming_appointments__from_date | DATE | upcoming_appointments.from_date | upcoming_appointments.from_date | upcoming_appointments |
| upcoming_appointments__id | NUMERIC | upcoming_appointments.id | upcoming_appointments.id | upcoming_appointments |
| upcoming_appointments__is_allday | BOOLEAN | upcoming_appointments.is_allday | upcoming_appointments.is_allday | upcoming_appointments |
| upcoming_appointments__latitude | TEXT | upcoming_appointments.latitude | upcoming_appointments.latitude | upcoming_appointments |
| upcoming_appointments__location | TEXT | upcoming_appointments.location | upcoming_appointments.location | upcoming_appointments |
| upcoming_appointments__longitude | TEXT | upcoming_appointments.longitude | upcoming_appointments.longitude | upcoming_appointments |
| upcoming_appointments__outcome_id | NUMERIC | upcoming_appointments.outcome_id | upcoming_appointments.outcome_id | upcoming_appointments |
| upcoming_appointments__provider | TEXT | upcoming_appointments.provider | upcoming_appointments.provider | upcoming_appointments |
| upcoming_appointments__targetable_id | NUMERIC | upcoming_appointments.targetable_id | upcoming_appointments.targetable_id | upcoming_appointments |
| upcoming_appointments__targetable_type | TEXT | upcoming_appointments.targetable_type | upcoming_appointments.targetable_type | upcoming_appointments |
| upcoming_appointments__targetables | OBJECT | upcoming_appointments.targetables | upcoming_appointments.targetables | upcoming_appointments |
| upcoming_appointments__time_zone | TEXT | upcoming_appointments.time_zone | upcoming_appointments.time_zone | upcoming_appointments |
| upcoming_appointments__title | TEXT | upcoming_appointments.title | upcoming_appointments.title | upcoming_appointments |
| upcoming_appointments__updated_at | DATE | upcoming_appointments.updated_at | upcoming_appointments.updated_at | upcoming_appointments |
| won_deals__active_sales_sequences | TEXT | won_deals.active_sales_sequences | won_deals.active_sales_sequences | won_deals |
| won_deals__age | NUMERIC | won_deals.age | won_deals.age | won_deals |
| won_deals__amount | TEXT | won_deals.amount | won_deals.amount | won_deals |
| won_deals__avatar | TEXT | won_deals.avatar | won_deals.avatar | won_deals |
| won_deals__base_currency_amount | TEXT | won_deals.base_currency_amount | won_deals.base_currency_amount | won_deals |
| won_deals__campaign_id | NUMERIC | won_deals.campaign_id | won_deals.campaign_id | won_deals |
| won_deals__closed_date | DATE | won_deals.closed_date | won_deals.closed_date | won_deals |
| won_deals__collaboration | OBJECT | won_deals.collaboration | won_deals.collaboration | won_deals |
| won_deals__completed_sales_sequences | TEXT | won_deals.completed_sales_sequences | won_deals.completed_sales_sequences | won_deals |
| won_deals__created_at | DATE | won_deals.created_at | won_deals.created_at | won_deals |
| won_deals__currency_id | NUMERIC | won_deals.currency_id | won_deals.currency_id | won_deals |
| won_deals__custom_field | OBJECT | won_deals.custom_field | won_deals.custom_field | won_deals |
| won_deals__deal_payment_status_id | NUMERIC | won_deals.deal_payment_status_id | won_deals.deal_payment_status_id | won_deals |
| won_deals__deal_pipeline_id | NUMERIC | won_deals.deal_pipeline_id | won_deals.deal_pipeline_id | won_deals |
| won_deals__deal_prediction | NUMERIC | won_deals.deal_prediction | won_deals.deal_prediction | won_deals |
| won_deals__deal_prediction_last_updated_at | DATE | won_deals.deal_prediction_last_updated_at | won_deals.deal_prediction_last_updated_at | won_deals |
| won_deals__deal_product_id | NUMERIC | won_deals.deal_product_id | won_deals.deal_product_id | won_deals |
| won_deals__deal_reason_id | NUMERIC | won_deals.deal_reason_id | won_deals.deal_reason_id | won_deals |
| won_deals__deal_stage_id | NUMERIC | won_deals.deal_stage_id | won_deals.deal_stage_id | won_deals |
| won_deals__deal_type_id | NUMERIC | won_deals.deal_type_id | won_deals.deal_type_id | won_deals |
| won_deals__expected_close | TEXT | won_deals.expected_close | won_deals.expected_close | won_deals |
| won_deals__expected_deal_value | TEXT | won_deals.expected_deal_value | won_deals.expected_deal_value | won_deals |
| won_deals__fc_widget_collaboration | OBJECT | won_deals.fc_widget_collaboration | won_deals.fc_widget_collaboration | won_deals |
| won_deals__forecast_category | NUMERIC | won_deals.forecast_category | won_deals.forecast_category | won_deals |
| won_deals__freddy_forecast_metrics | TEXT | won_deals.freddy_forecast_metrics | won_deals.freddy_forecast_metrics | won_deals |
| won_deals__has_products | BOOLEAN | won_deals.has_products | won_deals.has_products | won_deals |
| won_deals__id | NUMERIC | won_deals.id | won_deals.id | won_deals |
| won_deals__is_deleted | BOOLEAN | won_deals.is_deleted | won_deals.is_deleted | won_deals |
| won_deals__last_assigned_at | DATE | won_deals.last_assigned_at | won_deals.last_assigned_at | won_deals |
| won_deals__last_contacted_sales_activity_mode | TEXT | won_deals.last_contacted_sales_activity_mode | won_deals.last_contacted_sales_activity_mode | won_deals |
| won_deals__last_contacted_via_sales_activity | TEXT | won_deals.last_contacted_via_sales_activity | won_deals.last_contacted_via_sales_activity | won_deals |
| won_deals__last_deal_prediction | TEXT | won_deals.last_deal_prediction | won_deals.last_deal_prediction | won_deals |
| won_deals__lead_source_id | NUMERIC | won_deals.lead_source_id | won_deals.lead_source_id | won_deals |
| won_deals__links | OBJECT | won_deals.links | won_deals.links | won_deals |
| won_deals__name | TEXT | won_deals.name | won_deals.name | won_deals |
| won_deals__owner_id | NUMERIC | won_deals.owner_id | won_deals.owner_id | won_deals |
| won_deals__probability | NUMERIC | won_deals.probability | won_deals.probability | won_deals |
| won_deals__products | TEXT | won_deals.products | won_deals.products | won_deals |
| won_deals__recent_note | TEXT | won_deals.recent_note | won_deals.recent_note | won_deals |
| won_deals__rotten_days | NUMERIC | won_deals.rotten_days | won_deals.rotten_days | won_deals |
| won_deals__sales_account_id | NUMERIC | won_deals.sales_account_id | won_deals.sales_account_id | won_deals |
| won_deals__stage_updated_time | DATE | won_deals.stage_updated_time | won_deals.stage_updated_time | won_deals |
| won_deals__tags | OBJECT | won_deals.tags | won_deals.tags | won_deals |
| won_deals__team_user_ids | TEXT | won_deals.team_user_ids | won_deals.team_user_ids | won_deals |
| won_deals__territory_id | NUMERIC | won_deals.territory_id | won_deals.territory_id | won_deals |
| won_deals__upcoming_activities_time | TIMESTAMP | won_deals.upcoming_activities_time | won_deals.upcoming_activities_time | won_deals |
| won_deals__updated_at | DATE | won_deals.updated_at | won_deals.updated_at | won_deals |
| won_deals__web_form_id | NUMERIC | won_deals.web_form_id | won_deals.web_form_id | won_deals |