Windsor brings all your Harvest data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Harvest Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| billable_rates__amount | NUMERIC | billable_rates.amount | billable_rates.amount | billable_rates |
| billable_rates__created_at | TEXT | billable_rates.created_at | billable_rates.created_at | billable_rates |
| billable_rates__end_date | TEXT | billable_rates.end_date | billable_rates.end_date | billable_rates |
| billable_rates__id | NUMERIC | billable_rates.id | billable_rates.id | billable_rates |
| billable_rates__parent_id | NUMERIC | billable_rates.parent_id | billable_rates.parent_id | billable_rates |
| billable_rates__start_date | TEXT | billable_rates.start_date | billable_rates.start_date | billable_rates |
| billable_rates__updated_at | TEXT | billable_rates.updated_at | billable_rates.updated_at | billable_rates |
| clients__address | TEXT | clients.address | clients.address | clients |
| clients__created_at | TEXT | clients.created_at | clients.created_at | clients |
| clients__currency | TEXT | clients.currency | clients.currency | clients |
| clients__id | NUMERIC | clients.id | clients.id | clients |
| clients__is_active | BOOLEAN | clients.is_active | clients.is_active | clients |
| clients__name | TEXT | clients.name | clients.name | clients |
| clients__statement_key | TEXT | clients.statement_key | clients.statement_key | clients |
| clients__updated_at | TEXT | clients.updated_at | clients.updated_at | clients |
| company__approval_required | BOOLEAN | company.approval_required | company.approval_required | company |
| company__base_uri | TEXT | company.base_uri | company.base_uri | company |
| company__clock | TEXT | company.clock | company.clock | company |
| company__color_scheme | TEXT | company.color_scheme | company.color_scheme | company |
| company__decimal_symbol | TEXT | company.decimal_symbol | company.decimal_symbol | company |
| company__estimate_feature | BOOLEAN | company.estimate_feature | company.estimate_feature | company |
| company__expense_feature | BOOLEAN | company.expense_feature | company.expense_feature | company |
| company__full_domain | TEXT | company.full_domain | company.full_domain | company |
| company__invoice_feature | BOOLEAN | company.invoice_feature | company.invoice_feature | company |
| company__is_active | BOOLEAN | company.is_active | company.is_active | company |
| company__name | TEXT | company.name | company.name | company |
| company__plan_type | TEXT | company.plan_type | company.plan_type | company |
| company__thousands_separator | TEXT | company.thousands_separator | company.thousands_separator | company |
| company__time_format | TEXT | company.time_format | company.time_format | company |
| company__wants_timestamp_timers | BOOLEAN | company.wants_timestamp_timers | company.wants_timestamp_timers | company |
| company__week_start_day | TEXT | company.week_start_day | company.week_start_day | company |
| company__weekly_capacity | NUMERIC | company.weekly_capacity | company.weekly_capacity | company |
| contacts__client | OBJECT | contacts.client | contacts.client | contacts |
| contacts__created_at | TEXT | contacts.created_at | contacts.created_at | contacts |
| contacts__email | TEXT | contacts.email | contacts.email | contacts |
| contacts__fax | TEXT | contacts.fax | contacts.fax | contacts |
| contacts__first_name | TEXT | contacts.first_name | contacts.first_name | contacts |
| contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
| contacts__last_name | TEXT | contacts.last_name | contacts.last_name | contacts |
| contacts__phone_mobile | TEXT | contacts.phone_mobile | contacts.phone_mobile | contacts |
| contacts__phone_office | TEXT | contacts.phone_office | contacts.phone_office | contacts |
| contacts__title | TEXT | contacts.title | contacts.title | contacts |
| contacts__updated_at | TEXT | contacts.updated_at | contacts.updated_at | contacts |
| cost_rates__amount | NUMERIC | cost_rates.amount | cost_rates.amount | cost_rates |
| cost_rates__created_at | TEXT | cost_rates.created_at | cost_rates.created_at | cost_rates |
| cost_rates__end_date | TEXT | cost_rates.end_date | cost_rates.end_date | cost_rates |
| cost_rates__id | NUMERIC | cost_rates.id | cost_rates.id | cost_rates |
| cost_rates__parent_id | NUMERIC | cost_rates.parent_id | cost_rates.parent_id | cost_rates |
| cost_rates__start_date | TEXT | cost_rates.start_date | cost_rates.start_date | cost_rates |
| cost_rates__updated_at | TEXT | cost_rates.updated_at | cost_rates.updated_at | cost_rates |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| estimate_item_categories__created_at | TEXT | estimate_item_categories.created_at | estimate_item_categories.created_at | estimate_item_categories |
| estimate_item_categories__id | NUMERIC | estimate_item_categories.id | estimate_item_categories.id | estimate_item_categories |
| estimate_item_categories__name | TEXT | estimate_item_categories.name | estimate_item_categories.name | estimate_item_categories |
| estimate_item_categories__updated_at | TEXT | estimate_item_categories.updated_at | estimate_item_categories.updated_at | estimate_item_categories |
| estimate_messages__body | TEXT | estimate_messages.body | estimate_messages.body | estimate_messages |
| estimate_messages__created_at | TEXT | estimate_messages.created_at | estimate_messages.created_at | estimate_messages |
| estimate_messages__event_type | TEXT | estimate_messages.event_type | estimate_messages.event_type | estimate_messages |
| estimate_messages__id | NUMERIC | estimate_messages.id | estimate_messages.id | estimate_messages |
| estimate_messages__parent_id | NUMERIC | estimate_messages.parent_id | estimate_messages.parent_id | estimate_messages |
| estimate_messages__recipients | OBJECT | estimate_messages.recipients | estimate_messages.recipients | estimate_messages |
| estimate_messages__send_me_a_copy | BOOLEAN | estimate_messages.send_me_a_copy | estimate_messages.send_me_a_copy | estimate_messages |
| estimate_messages__sent_by | TEXT | estimate_messages.sent_by | estimate_messages.sent_by | estimate_messages |
| estimate_messages__sent_by_email | TEXT | estimate_messages.sent_by_email | estimate_messages.sent_by_email | estimate_messages |
| estimate_messages__sent_from | TEXT | estimate_messages.sent_from | estimate_messages.sent_from | estimate_messages |
| estimate_messages__sent_from_email | TEXT | estimate_messages.sent_from_email | estimate_messages.sent_from_email | estimate_messages |
| estimate_messages__subject | TEXT | estimate_messages.subject | estimate_messages.subject | estimate_messages |
| estimate_messages__updated_at | TEXT | estimate_messages.updated_at | estimate_messages.updated_at | estimate_messages |
| estimates__accepted_at | TEXT | estimates.accepted_at | estimates.accepted_at | estimates |
| estimates__amount | NUMERIC | estimates.amount | estimates.amount | estimates |
| estimates__client | OBJECT | estimates.client | estimates.client | estimates |
| estimates__client_key | TEXT | estimates.client_key | estimates.client_key | estimates |
| estimates__created_at | TEXT | estimates.created_at | estimates.created_at | estimates |
| estimates__creator | OBJECT | estimates.creator | estimates.creator | estimates |
| estimates__currency | TEXT | estimates.currency | estimates.currency | estimates |
| estimates__declined_at | TEXT | estimates.declined_at | estimates.declined_at | estimates |
| estimates__discount | NUMERIC | estimates.discount | estimates.discount | estimates |
| estimates__discount_amount | NUMERIC | estimates.discount_amount | estimates.discount_amount | estimates |
| estimates__id | NUMERIC | estimates.id | estimates.id | estimates |
| estimates__issue_date | TEXT | estimates.issue_date | estimates.issue_date | estimates |
| estimates__line_items | OBJECT | estimates.line_items | estimates.line_items | estimates |
| estimates__notes | TEXT | estimates.notes | estimates.notes | estimates |
| estimates__number | TEXT | estimates.number | estimates.number | estimates |
| estimates__purchase_order | TEXT | estimates.purchase_order | estimates.purchase_order | estimates |
| estimates__sent_at | TEXT | estimates.sent_at | estimates.sent_at | estimates |
| estimates__state | TEXT | estimates.state | estimates.state | estimates |
| estimates__subject | TEXT | estimates.subject | estimates.subject | estimates |
| estimates__tax | NUMERIC | estimates.tax | estimates.tax | estimates |
| estimates__tax2 | NUMERIC | estimates.tax2 | estimates.tax2 | estimates |
| estimates__tax2_amount | NUMERIC | estimates.tax2_amount | estimates.tax2_amount | estimates |
| estimates__tax_amount | NUMERIC | estimates.tax_amount | estimates.tax_amount | estimates |
| estimates__updated_at | TEXT | estimates.updated_at | estimates.updated_at | estimates |
| expense_categories__created_at | TEXT | expense_categories.created_at | expense_categories.created_at | expense_categories |
| expense_categories__id | NUMERIC | expense_categories.id | expense_categories.id | expense_categories |
| expense_categories__is_active | BOOLEAN | expense_categories.is_active | expense_categories.is_active | expense_categories |
| expense_categories__name | TEXT | expense_categories.name | expense_categories.name | expense_categories |
| expense_categories__unit_name | TEXT | expense_categories.unit_name | expense_categories.unit_name | expense_categories |
| expense_categories__unit_price | NUMERIC | expense_categories.unit_price | expense_categories.unit_price | expense_categories |
| expense_categories__updated_at | TEXT | expense_categories.updated_at | expense_categories.updated_at | expense_categories |
| expenses__billable | BOOLEAN | expenses.billable | expenses.billable | expenses |
| expenses__client | OBJECT | expenses.client | expenses.client | expenses |
| expenses__created_at | TEXT | expenses.created_at | expenses.created_at | expenses |
| expenses__expense_category | OBJECT | expenses.expense_category | expenses.expense_category | expenses |
| expenses__id | NUMERIC | expenses.id | expenses.id | expenses |
| expenses__invoice | OBJECT | expenses.invoice | expenses.invoice | expenses |
| expenses__is_billed | BOOLEAN | expenses.is_billed | expenses.is_billed | expenses |
| expenses__is_closed | BOOLEAN | expenses.is_closed | expenses.is_closed | expenses |
| expenses__is_locked | BOOLEAN | expenses.is_locked | expenses.is_locked | expenses |
| expenses__locked_reason | TEXT | expenses.locked_reason | expenses.locked_reason | expenses |
| expenses__notes | TEXT | expenses.notes | expenses.notes | expenses |
| expenses__project | OBJECT | expenses.project | expenses.project | expenses |
| expenses__receipt | OBJECT | expenses.receipt | expenses.receipt | expenses |
| expenses__spent_date | TEXT | expenses.spent_date | expenses.spent_date | expenses |
| expenses__total_cost | NUMERIC | expenses.total_cost | expenses.total_cost | expenses |
| expenses__units | NUMERIC | expenses.units | expenses.units | expenses |
| expenses__updated_at | TEXT | expenses.updated_at | expenses.updated_at | expenses |
| expenses__user | OBJECT | expenses.user | expenses.user | expenses |
| expenses__user_assignment | OBJECT | expenses.user_assignment | expenses.user_assignment | expenses |
| expenses_categories__billable_amount | NUMERIC | expenses_categories.billable_amount | expenses_categories.billable_amount | expenses_categories |
| expenses_categories__currency | TEXT | expenses_categories.currency | expenses_categories.currency | expenses_categories |
| expenses_categories__expense_category_id | NUMERIC | expenses_categories.expense_category_id | expenses_categories.expense_category_id | expenses_categories |
| expenses_categories__expense_category_name | TEXT | expenses_categories.expense_category_name | expenses_categories.expense_category_name | expenses_categories |
| expenses_categories__from | TEXT | expenses_categories.from | expenses_categories.from | expenses_categories |
| expenses_categories__to | TEXT | expenses_categories.to | expenses_categories.to | expenses_categories |
| expenses_categories__total_amount | NUMERIC | expenses_categories.total_amount | expenses_categories.total_amount | expenses_categories |
| expenses_clients__billable_amount | NUMERIC | expenses_clients.billable_amount | expenses_clients.billable_amount | expenses_clients |
| expenses_clients__client_id | NUMERIC | expenses_clients.client_id | expenses_clients.client_id | expenses_clients |
| expenses_clients__client_name | TEXT | expenses_clients.client_name | expenses_clients.client_name | expenses_clients |
| expenses_clients__currency | TEXT | expenses_clients.currency | expenses_clients.currency | expenses_clients |
| expenses_clients__from | TEXT | expenses_clients.from | expenses_clients.from | expenses_clients |
| expenses_clients__to | TEXT | expenses_clients.to | expenses_clients.to | expenses_clients |
| expenses_clients__total_amount | NUMERIC | expenses_clients.total_amount | expenses_clients.total_amount | expenses_clients |
| expenses_projects__billable_amount | NUMERIC | expenses_projects.billable_amount | expenses_projects.billable_amount | expenses_projects |
| expenses_projects__client_id | NUMERIC | expenses_projects.client_id | expenses_projects.client_id | expenses_projects |
| expenses_projects__client_name | TEXT | expenses_projects.client_name | expenses_projects.client_name | expenses_projects |
| expenses_projects__currency | TEXT | expenses_projects.currency | expenses_projects.currency | expenses_projects |
| expenses_projects__from | TEXT | expenses_projects.from | expenses_projects.from | expenses_projects |
| expenses_projects__project_id | NUMERIC | expenses_projects.project_id | expenses_projects.project_id | expenses_projects |
| expenses_projects__project_name | TEXT | expenses_projects.project_name | expenses_projects.project_name | expenses_projects |
| expenses_projects__to | TEXT | expenses_projects.to | expenses_projects.to | expenses_projects |
| expenses_projects__total_amount | NUMERIC | expenses_projects.total_amount | expenses_projects.total_amount | expenses_projects |
| expenses_team__billable_amount | NUMERIC | expenses_team.billable_amount | expenses_team.billable_amount | expenses_team |
| expenses_team__currency | TEXT | expenses_team.currency | expenses_team.currency | expenses_team |
| expenses_team__from | TEXT | expenses_team.from | expenses_team.from | expenses_team |
| expenses_team__is_contractor | BOOLEAN | expenses_team.is_contractor | expenses_team.is_contractor | expenses_team |
| expenses_team__to | TEXT | expenses_team.to | expenses_team.to | expenses_team |
| expenses_team__total_amount | NUMERIC | expenses_team.total_amount | expenses_team.total_amount | expenses_team |
| expenses_team__user_id | NUMERIC | expenses_team.user_id | expenses_team.user_id | expenses_team |
| expenses_team__user_name | TEXT | expenses_team.user_name | expenses_team.user_name | expenses_team |
| invoice_item_categories__created_at | TEXT | invoice_item_categories.created_at | invoice_item_categories.created_at | invoice_item_categories |
| invoice_item_categories__id | NUMERIC | invoice_item_categories.id | invoice_item_categories.id | invoice_item_categories |
| invoice_item_categories__name | TEXT | invoice_item_categories.name | invoice_item_categories.name | invoice_item_categories |
| invoice_item_categories__updated_at | TEXT | invoice_item_categories.updated_at | invoice_item_categories.updated_at | invoice_item_categories |
| invoice_item_categories__use_as_expense | BOOLEAN | invoice_item_categories.use_as_expense | invoice_item_categories.use_as_expense | invoice_item_categories |
| invoice_item_categories__use_as_service | BOOLEAN | invoice_item_categories.use_as_service | invoice_item_categories.use_as_service | invoice_item_categories |
| invoice_messages__attach_pdf | BOOLEAN | invoice_messages.attach_pdf | invoice_messages.attach_pdf | invoice_messages |
| invoice_messages__body | TEXT | invoice_messages.body | invoice_messages.body | invoice_messages |
| invoice_messages__created_at | TEXT | invoice_messages.created_at | invoice_messages.created_at | invoice_messages |
| invoice_messages__event_type | TEXT | invoice_messages.event_type | invoice_messages.event_type | invoice_messages |
| invoice_messages__id | NUMERIC | invoice_messages.id | invoice_messages.id | invoice_messages |
| invoice_messages__include_link_to_client_invoice | BOOLEAN | invoice_messages.include_link_to_client_invoice | invoice_messages.include_link_to_client_invoice | invoice_messages |
| invoice_messages__parent_id | NUMERIC | invoice_messages.parent_id | invoice_messages.parent_id | invoice_messages |
| invoice_messages__recipients | OBJECT | invoice_messages.recipients | invoice_messages.recipients | invoice_messages |
| invoice_messages__reminder | BOOLEAN | invoice_messages.reminder | invoice_messages.reminder | invoice_messages |
| invoice_messages__send_me_a_copy | BOOLEAN | invoice_messages.send_me_a_copy | invoice_messages.send_me_a_copy | invoice_messages |
| invoice_messages__send_reminder_on | TEXT | invoice_messages.send_reminder_on | invoice_messages.send_reminder_on | invoice_messages |
| invoice_messages__sent_by | TEXT | invoice_messages.sent_by | invoice_messages.sent_by | invoice_messages |
| invoice_messages__sent_by_email | TEXT | invoice_messages.sent_by_email | invoice_messages.sent_by_email | invoice_messages |
| invoice_messages__sent_from | TEXT | invoice_messages.sent_from | invoice_messages.sent_from | invoice_messages |
| invoice_messages__sent_from_email | TEXT | invoice_messages.sent_from_email | invoice_messages.sent_from_email | invoice_messages |
| invoice_messages__subject | TEXT | invoice_messages.subject | invoice_messages.subject | invoice_messages |
| invoice_messages__thank_you | BOOLEAN | invoice_messages.thank_you | invoice_messages.thank_you | invoice_messages |
| invoice_messages__updated_at | TEXT | invoice_messages.updated_at | invoice_messages.updated_at | invoice_messages |
| invoice_payments__amount | NUMERIC | invoice_payments.amount | invoice_payments.amount | invoice_payments |
| invoice_payments__created_at | TEXT | invoice_payments.created_at | invoice_payments.created_at | invoice_payments |
| invoice_payments__id | NUMERIC | invoice_payments.id | invoice_payments.id | invoice_payments |
| invoice_payments__notes | TEXT | invoice_payments.notes | invoice_payments.notes | invoice_payments |
| invoice_payments__paid_at | TEXT | invoice_payments.paid_at | invoice_payments.paid_at | invoice_payments |
| invoice_payments__paid_date | TEXT | invoice_payments.paid_date | invoice_payments.paid_date | invoice_payments |
| invoice_payments__parent_id | NUMERIC | invoice_payments.parent_id | invoice_payments.parent_id | invoice_payments |
| invoice_payments__payment_gateway | OBJECT | invoice_payments.payment_gateway | invoice_payments.payment_gateway | invoice_payments |
| invoice_payments__recorded_by | TEXT | invoice_payments.recorded_by | invoice_payments.recorded_by | invoice_payments |
| invoice_payments__recorded_by_email | TEXT | invoice_payments.recorded_by_email | invoice_payments.recorded_by_email | invoice_payments |
| invoice_payments__transaction_id | TEXT | invoice_payments.transaction_id | invoice_payments.transaction_id | invoice_payments |
| invoice_payments__updated_at | TEXT | invoice_payments.updated_at | invoice_payments.updated_at | invoice_payments |
| invoices__amount | NUMERIC | invoices.amount | invoices.amount | invoices |
| invoices__client | OBJECT | invoices.client | invoices.client | invoices |
| invoices__client_key | TEXT | invoices.client_key | invoices.client_key | invoices |
| invoices__closed_at | TEXT | invoices.closed_at | invoices.closed_at | invoices |
| invoices__created_at | TEXT | invoices.created_at | invoices.created_at | invoices |
| invoices__creator | OBJECT | invoices.creator | invoices.creator | invoices |
| invoices__currency | TEXT | invoices.currency | invoices.currency | invoices |
| invoices__discount | NUMERIC | invoices.discount | invoices.discount | invoices |
| invoices__discount_amount | NUMERIC | invoices.discount_amount | invoices.discount_amount | invoices |
| invoices__due_amount | NUMERIC | invoices.due_amount | invoices.due_amount | invoices |
| invoices__due_date | TEXT | invoices.due_date | invoices.due_date | invoices |
| invoices__estimate | TEXT | invoices.estimate | invoices.estimate | invoices |
| invoices__id | NUMERIC | invoices.id | invoices.id | invoices |
| invoices__issue_date | TEXT | invoices.issue_date | invoices.issue_date | invoices |
| invoices__line_items | OBJECT | invoices.line_items | invoices.line_items | invoices |
| invoices__notes | TEXT | invoices.notes | invoices.notes | invoices |
| invoices__number | TEXT | invoices.number | invoices.number | invoices |
| invoices__paid_at | TEXT | invoices.paid_at | invoices.paid_at | invoices |
| invoices__paid_date | TEXT | invoices.paid_date | invoices.paid_date | invoices |
| invoices__payment_options | OBJECT | invoices.payment_options | invoices.payment_options | invoices |
| invoices__payment_term | TEXT | invoices.payment_term | invoices.payment_term | invoices |
| invoices__period_end | TEXT | invoices.period_end | invoices.period_end | invoices |
| invoices__period_start | TEXT | invoices.period_start | invoices.period_start | invoices |
| invoices__purchase_order | TEXT | invoices.purchase_order | invoices.purchase_order | invoices |
| invoices__recurring_invoice_id | TEXT | invoices.recurring_invoice_id | invoices.recurring_invoice_id | invoices |
| invoices__retainer | TEXT | invoices.retainer | invoices.retainer | invoices |
| invoices__sent_at | TEXT | invoices.sent_at | invoices.sent_at | invoices |
| invoices__state | TEXT | invoices.state | invoices.state | invoices |
| invoices__subject | TEXT | invoices.subject | invoices.subject | invoices |
| invoices__tax | NUMERIC | invoices.tax | invoices.tax | invoices |
| invoices__tax2 | NUMERIC | invoices.tax2 | invoices.tax2 | invoices |
| invoices__tax2_amount | NUMERIC | invoices.tax2_amount | invoices.tax2_amount | invoices |
| invoices__tax_amount | NUMERIC | invoices.tax_amount | invoices.tax_amount | invoices |
| invoices__updated_at | TEXT | invoices.updated_at | invoices.updated_at | invoices |
| project_assignments__budget | NUMERIC | project_assignments.budget | project_assignments.budget | project_assignments |
| project_assignments__client | OBJECT | project_assignments.client | project_assignments.client | project_assignments |
| project_assignments__created_at | TEXT | project_assignments.created_at | project_assignments.created_at | project_assignments |
| project_assignments__hourly_rate | NUMERIC | project_assignments.hourly_rate | project_assignments.hourly_rate | project_assignments |
| project_assignments__id | NUMERIC | project_assignments.id | project_assignments.id | project_assignments |
| project_assignments__is_active | BOOLEAN | project_assignments.is_active | project_assignments.is_active | project_assignments |
| project_assignments__is_project_manager | BOOLEAN | project_assignments.is_project_manager | project_assignments.is_project_manager | project_assignments |
| project_assignments__parent_id | NUMERIC | project_assignments.parent_id | project_assignments.parent_id | project_assignments |
| project_assignments__project | OBJECT | project_assignments.project | project_assignments.project | project_assignments |
| project_assignments__task_assignments | OBJECT | project_assignments.task_assignments | project_assignments.task_assignments | project_assignments |
| project_assignments__updated_at | TEXT | project_assignments.updated_at | project_assignments.updated_at | project_assignments |
| project_assignments__use_default_rates | BOOLEAN | project_assignments.use_default_rates | project_assignments.use_default_rates | project_assignments |
| project_budget__budget | NUMERIC | project_budget.budget | project_budget.budget | project_budget |
| project_budget__budget_by | TEXT | project_budget.budget_by | project_budget.budget_by | project_budget |
| project_budget__budget_is_monthly | BOOLEAN | project_budget.budget_is_monthly | project_budget.budget_is_monthly | project_budget |
| project_budget__budget_remaining | NUMERIC | project_budget.budget_remaining | project_budget.budget_remaining | project_budget |
| project_budget__budget_spent | NUMERIC | project_budget.budget_spent | project_budget.budget_spent | project_budget |
| project_budget__client_id | NUMERIC | project_budget.client_id | project_budget.client_id | project_budget |
| project_budget__client_name | TEXT | project_budget.client_name | project_budget.client_name | project_budget |
| project_budget__from | TEXT | project_budget.from | project_budget.from | project_budget |
| project_budget__is_active | BOOLEAN | project_budget.is_active | project_budget.is_active | project_budget |
| project_budget__project_id | NUMERIC | project_budget.project_id | project_budget.project_id | project_budget |
| project_budget__project_name | TEXT | project_budget.project_name | project_budget.project_name | project_budget |
| project_budget__to | TEXT | project_budget.to | project_budget.to | project_budget |
| projects__bill_by | TEXT | projects.bill_by | projects.bill_by | projects |
| projects__budget | NUMERIC | projects.budget | projects.budget | projects |
| projects__budget_by | TEXT | projects.budget_by | projects.budget_by | projects |
| projects__budget_is_monthly | BOOLEAN | projects.budget_is_monthly | projects.budget_is_monthly | projects |
| projects__client | OBJECT | projects.client | projects.client | projects |
| projects__code | TEXT | projects.code | projects.code | projects |
| projects__cost_budget | NUMERIC | projects.cost_budget | projects.cost_budget | projects |
| projects__cost_budget_include_expenses | BOOLEAN | projects.cost_budget_include_expenses | projects.cost_budget_include_expenses | projects |
| projects__created_at | TEXT | projects.created_at | projects.created_at | projects |
| projects__ends_on | TEXT | projects.ends_on | projects.ends_on | projects |
| projects__fee | NUMERIC | projects.fee | projects.fee | projects |
| projects__hourly_rate | NUMERIC | projects.hourly_rate | projects.hourly_rate | projects |
| projects__id | NUMERIC | projects.id | projects.id | projects |
| projects__is_active | BOOLEAN | projects.is_active | projects.is_active | projects |
| projects__is_billable | BOOLEAN | projects.is_billable | projects.is_billable | projects |
| projects__is_fixed_fee | BOOLEAN | projects.is_fixed_fee | projects.is_fixed_fee | projects |
| projects__name | TEXT | projects.name | projects.name | projects |
| projects__notes | TEXT | projects.notes | projects.notes | projects |
| projects__notify_when_over_budget | BOOLEAN | projects.notify_when_over_budget | projects.notify_when_over_budget | projects |
| projects__over_budget_notification_date | TEXT | projects.over_budget_notification_date | projects.over_budget_notification_date | projects |
| projects__over_budget_notification_percentage | NUMERIC | projects.over_budget_notification_percentage | projects.over_budget_notification_percentage | projects |
| projects__show_budget_to_all | BOOLEAN | projects.show_budget_to_all | projects.show_budget_to_all | projects |
| projects__starts_on | TEXT | projects.starts_on | projects.starts_on | projects |
| projects__updated_at | TEXT | projects.updated_at | projects.updated_at | projects |
| roles__created_at | TEXT | roles.created_at | roles.created_at | roles |
| roles__id | NUMERIC | roles.id | roles.id | roles |
| roles__name | TEXT | roles.name | roles.name | roles |
| roles__updated_at | TEXT | roles.updated_at | roles.updated_at | roles |
| roles__user_ids | OBJECT | roles.user_ids | roles.user_ids | roles |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| task_assignments__billable | BOOLEAN | task_assignments.billable | task_assignments.billable | task_assignments |
| task_assignments__budget | TEXT | task_assignments.budget | task_assignments.budget | task_assignments |
| task_assignments__created_at | TEXT | task_assignments.created_at | task_assignments.created_at | task_assignments |
| task_assignments__hourly_rate | NUMERIC | task_assignments.hourly_rate | task_assignments.hourly_rate | task_assignments |
| task_assignments__id | NUMERIC | task_assignments.id | task_assignments.id | task_assignments |
| task_assignments__is_active | BOOLEAN | task_assignments.is_active | task_assignments.is_active | task_assignments |
| task_assignments__project | OBJECT | task_assignments.project | task_assignments.project | task_assignments |
| task_assignments__task | OBJECT | task_assignments.task | task_assignments.task | task_assignments |
| task_assignments__updated_at | TEXT | task_assignments.updated_at | task_assignments.updated_at | task_assignments |
| tasks__billable_by_default | BOOLEAN | tasks.billable_by_default | tasks.billable_by_default | tasks |
| tasks__created_at | TEXT | tasks.created_at | tasks.created_at | tasks |
| tasks__default_hourly_rate | NUMERIC | tasks.default_hourly_rate | tasks.default_hourly_rate | tasks |
| tasks__id | NUMERIC | tasks.id | tasks.id | tasks |
| tasks__is_active | BOOLEAN | tasks.is_active | tasks.is_active | tasks |
| tasks__is_default | BOOLEAN | tasks.is_default | tasks.is_default | tasks |
| tasks__name | TEXT | tasks.name | tasks.name | tasks |
| tasks__updated_at | TEXT | tasks.updated_at | tasks.updated_at | tasks |
| time_clients__billable_amount | NUMERIC | time_clients.billable_amount | time_clients.billable_amount | time_clients |
| time_clients__billable_hours | NUMERIC | time_clients.billable_hours | time_clients.billable_hours | time_clients |
| time_clients__client_id | NUMERIC | time_clients.client_id | time_clients.client_id | time_clients |
| time_clients__client_name | TEXT | time_clients.client_name | time_clients.client_name | time_clients |
| time_clients__currency | TEXT | time_clients.currency | time_clients.currency | time_clients |
| time_clients__from | TEXT | time_clients.from | time_clients.from | time_clients |
| time_clients__to | TEXT | time_clients.to | time_clients.to | time_clients |
| time_clients__total_hours | NUMERIC | time_clients.total_hours | time_clients.total_hours | time_clients |
| time_entries__billable | BOOLEAN | time_entries.billable | time_entries.billable | time_entries |
| time_entries__billable_rate | NUMERIC | time_entries.billable_rate | time_entries.billable_rate | time_entries |
| time_entries__budgeted | BOOLEAN | time_entries.budgeted | time_entries.budgeted | time_entries |
| time_entries__client | OBJECT | time_entries.client | time_entries.client | time_entries |
| time_entries__cost_rate | NUMERIC | time_entries.cost_rate | time_entries.cost_rate | time_entries |
| time_entries__created_at | TEXT | time_entries.created_at | time_entries.created_at | time_entries |
| time_entries__ended_time | TEXT | time_entries.ended_time | time_entries.ended_time | time_entries |
| time_entries__external_reference | TEXT | time_entries.external_reference | time_entries.external_reference | time_entries |
| time_entries__hours | NUMERIC | time_entries.hours | time_entries.hours | time_entries |
| time_entries__hours_without_timer | NUMERIC | time_entries.hours_without_timer | time_entries.hours_without_timer | time_entries |
| time_entries__id | NUMERIC | time_entries.id | time_entries.id | time_entries |
| time_entries__invoice | OBJECT | time_entries.invoice | time_entries.invoice | time_entries |
| time_entries__is_billed | BOOLEAN | time_entries.is_billed | time_entries.is_billed | time_entries |
| time_entries__is_closed | BOOLEAN | time_entries.is_closed | time_entries.is_closed | time_entries |
| time_entries__is_locked | BOOLEAN | time_entries.is_locked | time_entries.is_locked | time_entries |
| time_entries__is_running | BOOLEAN | time_entries.is_running | time_entries.is_running | time_entries |
| time_entries__locked_reason | TEXT | time_entries.locked_reason | time_entries.locked_reason | time_entries |
| time_entries__notes | TEXT | time_entries.notes | time_entries.notes | time_entries |
| time_entries__project | OBJECT | time_entries.project | time_entries.project | time_entries |
| time_entries__rounded_hours | NUMERIC | time_entries.rounded_hours | time_entries.rounded_hours | time_entries |
| time_entries__spent_date | TEXT | time_entries.spent_date | time_entries.spent_date | time_entries |
| time_entries__started_time | TEXT | time_entries.started_time | time_entries.started_time | time_entries |
| time_entries__task | OBJECT | time_entries.task | time_entries.task | time_entries |
| time_entries__task_assignment | OBJECT | time_entries.task_assignment | time_entries.task_assignment | time_entries |
| time_entries__timer_started_at | TEXT | time_entries.timer_started_at | time_entries.timer_started_at | time_entries |
| time_entries__updated_at | TEXT | time_entries.updated_at | time_entries.updated_at | time_entries |
| time_entries__user | OBJECT | time_entries.user | time_entries.user | time_entries |
| time_entries__user_assignment | OBJECT | time_entries.user_assignment | time_entries.user_assignment | time_entries |
| time_projects__billable_amount | NUMERIC | time_projects.billable_amount | time_projects.billable_amount | time_projects |
| time_projects__billable_hours | NUMERIC | time_projects.billable_hours | time_projects.billable_hours | time_projects |
| time_projects__client_id | NUMERIC | time_projects.client_id | time_projects.client_id | time_projects |
| time_projects__client_name | TEXT | time_projects.client_name | time_projects.client_name | time_projects |
| time_projects__currency | TEXT | time_projects.currency | time_projects.currency | time_projects |
| time_projects__from | TEXT | time_projects.from | time_projects.from | time_projects |
| time_projects__project_id | NUMERIC | time_projects.project_id | time_projects.project_id | time_projects |
| time_projects__project_name | TEXT | time_projects.project_name | time_projects.project_name | time_projects |
| time_projects__to | TEXT | time_projects.to | time_projects.to | time_projects |
| time_projects__total_hours | NUMERIC | time_projects.total_hours | time_projects.total_hours | time_projects |
| time_tasks__billable_amount | NUMERIC | time_tasks.billable_amount | time_tasks.billable_amount | time_tasks |
| time_tasks__billable_hours | NUMERIC | time_tasks.billable_hours | time_tasks.billable_hours | time_tasks |
| time_tasks__currency | TEXT | time_tasks.currency | time_tasks.currency | time_tasks |
| time_tasks__from | TEXT | time_tasks.from | time_tasks.from | time_tasks |
| time_tasks__task_id | NUMERIC | time_tasks.task_id | time_tasks.task_id | time_tasks |
| time_tasks__task_name | TEXT | time_tasks.task_name | time_tasks.task_name | time_tasks |
| time_tasks__to | TEXT | time_tasks.to | time_tasks.to | time_tasks |
| time_tasks__total_hours | NUMERIC | time_tasks.total_hours | time_tasks.total_hours | time_tasks |
| time_team__billable_amount | NUMERIC | time_team.billable_amount | time_team.billable_amount | time_team |
| time_team__billable_hours | NUMERIC | time_team.billable_hours | time_team.billable_hours | time_team |
| time_team__currency | TEXT | time_team.currency | time_team.currency | time_team |
| time_team__from | TEXT | time_team.from | time_team.from | time_team |
| time_team__is_contractor | BOOLEAN | time_team.is_contractor | time_team.is_contractor | time_team |
| time_team__to | TEXT | time_team.to | time_team.to | time_team |
| time_team__total_hours | NUMERIC | time_team.total_hours | time_team.total_hours | time_team |
| time_team__user_id | NUMERIC | time_team.user_id | time_team.user_id | time_team |
| time_team__user_name | TEXT | time_team.user_name | time_team.user_name | time_team |
| today | DATE | Today | Today's date | |
| uninvoiced__client_id | NUMERIC | uninvoiced.client_id | uninvoiced.client_id | uninvoiced |
| uninvoiced__client_name | TEXT | uninvoiced.client_name | uninvoiced.client_name | uninvoiced |
| uninvoiced__currency | TEXT | uninvoiced.currency | uninvoiced.currency | uninvoiced |
| uninvoiced__from | TEXT | uninvoiced.from | uninvoiced.from | uninvoiced |
| uninvoiced__project_id | NUMERIC | uninvoiced.project_id | uninvoiced.project_id | uninvoiced |
| uninvoiced__project_name | TEXT | uninvoiced.project_name | uninvoiced.project_name | uninvoiced |
| uninvoiced__to | TEXT | uninvoiced.to | uninvoiced.to | uninvoiced |
| uninvoiced__total_hours | NUMERIC | uninvoiced.total_hours | uninvoiced.total_hours | uninvoiced |
| uninvoiced__uninvoiced_amount | NUMERIC | uninvoiced.uninvoiced_amount | uninvoiced.uninvoiced_amount | uninvoiced |
| uninvoiced__uninvoiced_expenses | NUMERIC | uninvoiced.uninvoiced_expenses | uninvoiced.uninvoiced_expenses | uninvoiced |
| uninvoiced__uninvoiced_hours | NUMERIC | uninvoiced.uninvoiced_hours | uninvoiced.uninvoiced_hours | uninvoiced |
| user_assignments__budget | NUMERIC | user_assignments.budget | user_assignments.budget | user_assignments |
| user_assignments__created_at | TEXT | user_assignments.created_at | user_assignments.created_at | user_assignments |
| user_assignments__hourly_rate | NUMERIC | user_assignments.hourly_rate | user_assignments.hourly_rate | user_assignments |
| user_assignments__id | NUMERIC | user_assignments.id | user_assignments.id | user_assignments |
| user_assignments__is_active | BOOLEAN | user_assignments.is_active | user_assignments.is_active | user_assignments |
| user_assignments__is_project_manager | BOOLEAN | user_assignments.is_project_manager | user_assignments.is_project_manager | user_assignments |
| user_assignments__project | OBJECT | user_assignments.project | user_assignments.project | user_assignments |
| user_assignments__updated_at | TEXT | user_assignments.updated_at | user_assignments.updated_at | user_assignments |
| user_assignments__use_default_rates | BOOLEAN | user_assignments.use_default_rates | user_assignments.use_default_rates | user_assignments |
| user_assignments__user | OBJECT | user_assignments.user | user_assignments.user | user_assignments |
| users__avatar_url | TEXT | users.avatar_url | users.avatar_url | users |
| users__calendar_integration_enabled | BOOLEAN | users.calendar_integration_enabled | users.calendar_integration_enabled | users |
| users__calendar_integration_source | TEXT | users.calendar_integration_source | users.calendar_integration_source | users |
| users__can_create_invoices | BOOLEAN | users.can_create_invoices | users.can_create_invoices | users |
| users__can_create_projects | BOOLEAN | users.can_create_projects | users.can_create_projects | users |
| users__can_see_rates | BOOLEAN | users.can_see_rates | users.can_see_rates | users |
| users__cost_rate | NUMERIC | users.cost_rate | users.cost_rate | users |
| users__created_at | TEXT | users.created_at | users.created_at | users |
| users__default_hourly_rate | NUMERIC | users.default_hourly_rate | users.default_hourly_rate | users |
| users__email | TEXT | users.email | users.email | users |
| users__first_name | TEXT | users.first_name | users.first_name | users |
| users__has_access_to_all_future_projects | BOOLEAN | users.has_access_to_all_future_projects | users.has_access_to_all_future_projects | users |
| users__id | NUMERIC | users.id | users.id | users |
| users__is_active | BOOLEAN | users.is_active | users.is_active | users |
| users__is_admin | BOOLEAN | users.is_admin | users.is_admin | users |
| users__is_contractor | BOOLEAN | users.is_contractor | users.is_contractor | users |
| users__is_project_manager | BOOLEAN | users.is_project_manager | users.is_project_manager | users |
| users__last_name | TEXT | users.last_name | users.last_name | users |
| users__roles | OBJECT | users.roles | users.roles | users |
| users__telephone | TEXT | users.telephone | users.telephone | users |
| users__timezone | TEXT | users.timezone | users.timezone | users |
| users__updated_at | TEXT | users.updated_at | users.updated_at | users |
| users__weekly_capacity | NUMERIC | users.weekly_capacity | users.weekly_capacity | users |