# FreshBooks schema ERD

Table and field reference for the Fivetran FreshBooks connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| client_id | Unknown | FK |
| credit_id | Unknown | FK |
| invoice_id | Unknown | FK |
| amount | Unknown |  |
| amount_currecy_code | Unknown |  |
| bulk_payment_id | Unknown |  |
| date | Unknown |  |
| from_credit | Unknown |  |
| gateway | Unknown |  |
| note | Unknown |  |
| order_id | Unknown |  |
| overpayment_id | Unknown |  |
| send_client_notification | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| vis_state | Unknown |  |

### credit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| client_id | Unknown | FK |
| amount | Unknown |  |
| city | Unknown |  |
| code | Unknown |  |
| country | Unknown |  |
| create_date | Unknown |  |
| credit_number | Unknown |  |
| credit_type | Unknown |  |
| currency_code | Unknown |  |
| current_organization | Unknown |  |
| description | Unknown |  |
| display_status | Unknown |  |
| dispute_status | Unknown |  |
| ext_archive | Unknown |  |
| first_name | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| last_order_status | Unknown |  |
| organization | Unknown |  |
| paid_amount | Unknown |  |
| paid_currency_code | Unknown |  |
| payment_status | Unknown |  |
| payment_type | Unknown |  |
| province | Unknown |  |
| sent_id | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| template | Unknown |  |
| term | Unknown |  |
| vat_name | Unknown |  |
| vat_number | Unknown |  |
| vis_state | Unknown |  |

### project_service

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| service_id | Unknown | PK, FK |

### project_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| identity_id | Unknown | FK |
| active | Unknown |  |
| comapny | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| role | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client_id | Unknown | FK |
| active | Unknown |  |
| billed_amount | Unknown |  |
| billed_status | Unknown |  |
| billing_method | Unknown |  |
| budget | Unknown |  |
| business_id | Unknown |  |
| complete | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| expense_markup | Unknown |  |
| fixed_price | Unknown |  |
| group_id | Unknown |  |
| group_pending_invitation | Json |  |
| internal | Unknown |  |
| logged_duration | Unknown |  |
| project_manager_id | Unknown |  |
| project_type | Unknown |  |
| rate | Unknown |  |
| retainer_id | Unknown |  |
| sample | Unknown |  |
| service_estimate_type | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| amount | Unknown |  |
| compound | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| updated | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| client_id | Unknown | FK |
| estimate_id | Unknown | FK |
| project_id | Json | FK |
| address | Unknown |  |
| allowed_gateway | Json |  |
| allowed_gateway_id | Json |  |
| attachment | Json |  |
| audit_log | Json |  |
| auto_bill | Unknown |  |
| autobill_status | Unknown |  |
| basecamp_id | Unknown |  |
| city | Unknown |  |
| client_audit | Json |  |
| code | Unknown |  |
| comment | Json |  |
| contact | Json |  |
| country | Unknown |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| current_organization | Unknown |  |
| date_paid | Unknown |  |
| deposit_amount | Unknown |  |
| deposit_amount_currency_code | Unknown |  |
| deposit_percentage | Unknown |  |
| deposit_status | Unknown |  |
| description | Unknown |  |
| direct_link | Json |  |
| discount_description | Unknown |  |
| discount_total_amount | Unknown |  |
| discount_total_currency_code | Unknown |  |
| discount_value | Unknown |  |
| display_status | Unknown |  |
| dispute_status | Unknown |  |
| due_date | Unknown |  |
| due_offset_day | Unknown |  |
| email_recipient | Json |  |
| first_name | Unknown |  |
| fulfillment_date | Unknown |  |
| generation_date | Unknown |  |
| gmail | Unknown |  |
| invoice_number | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| last_order_status | Unknown |  |
| late_reminder | Json |  |
| line | Json |  |
| net_paid_amount | Unknown |  |
| net_paid_amount_currency_code | Unknown |  |
| note | Unknown |  |
| organization | Unknown |  |
| outstanding_amount | Unknown |  |
| outstanding_currency_code | Unknown |  |
| owner_id | Unknown |  |
| paid_amount | Unknown |  |
| paid_code | Unknown |  |
| parent | Unknown |  |
| payment_detail | Unknown |  |
| payment_schedule | Json |  |
| payment_status | Unknown |  |
| po_number | Unknown |  |
| project_total_amount | Json |  |
| province | Unknown |  |
| sent_id | Unknown |  |
| show_attachment | Unknown |  |
| status | Unknown |  |
| store_client_preference | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| support_id | Json |  |
| term | Unknown |  |
| total_amount | Unknown |  |
| updated | Instant |  |
| use_default_presentation | Unknown |  |
| uuid | Unknown |  |
| v_3_status | Unknown |  |
| vat_name | Unknown |  |
| vat_number | Unknown |  |
| version | Unknown |  |
| vis_state | Unknown |  |

### client

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| allow_email_include_pdf | Unknown |  |
| billing_city | Unknown |  |
| billing_code | Unknown |  |
| billing_country | Unknown |  |
| billing_province | Unknown |  |
| billing_street | Unknown |  |
| billing_street_2 | Unknown |  |
| bus_phone | Unknown |  |
| company_industry | Unknown |  |
| company_size | Unknown |  |
| contact | Json |  |
| credit_balance | Json |  |
| currency_code | Unknown |  |
| direct_link_token | Unknown |  |
| draft_balance | Json |  |
| email | Unknown |  |
| exceeds_client_limit | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| grand_total_balance | Json |  |
| has_retainer | Unknown |  |
| home_phone | Unknown |  |
| languages | Unknown |  |
| last_activity | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| late_reminder | Json |  |
| mobile_phone | Unknown |  |
| note | Unknown |  |
| number_login | Unknown |  |
| organization | Unknown |  |
| outstanding_balance | Json |  |
| overdue_balance | Json |  |
| preferred_contact | Json |  |
| preferred_gateway | Json |  |
| prefers_email | Unknown |  |
| prefers_gmail | Unknown |  |
| recent_contact | Json |  |
| retainer_id | Unknown |  |
| role | Unknown |  |
| shipping_city | Unknown |  |
| shipping_code | Unknown |  |
| shipping_country | Unknown |  |
| shipping_province | Unknown |  |
| shipping_street | Unknown |  |
| shipping_street_2 | Unknown |  |
| signup_date | Unknown |  |
| subdomain | Unknown |  |
| updated | Unknown |  |
| username | Unknown |  |
| uuid | Unknown |  |
| vat_name | Unknown |  |
| vat_number | Unknown |  |
| visibility_state | Unknown |  |

### time_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client_id | Unknown | FK |
| identity_id | Unknown | FK |
| project_id | Unknown | FK |
| service_id | Unknown | FK |
| active | Unknown |  |
| billable | Unknown |  |
| billed | Unknown |  |
| business_id | Unknown |  |
| created_at | Instant |  |
| duration | Unknown |  |
| internal | Unknown |  |
| is_logged | Unknown |  |
| local_started_at | Unknown |  |
| local_timezone | Unknown |  |
| note | Unknown |  |
| pending_client | Unknown |  |
| pending_project | Unknown |  |
| pending_task | Unknown |  |
| retainer_id | Unknown |  |
| started_at | Unknown |  |
| task_id | Unknown |  |
| timer_id | Unknown |  |
| timer_is_running | Unknown |  |

### expense

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| category_id | Unknown | FK |
| client_id | Unknown | FK |
| invoice_id | Unknown | FK |
| project_id | Unknown | FK |
| account_name | Unknown |  |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| background_job_id | Unknown |  |
| bank_name | Unknown |  |
| bill_match | Json |  |
| billable | Unknown |  |
| date | Unknown |  |
| expense_account_id | Unknown |  |
| ext_account_id | Unknown |  |
| ext_invoice_id | Unknown |  |
| ext_system_id | Unknown |  |
| from_bulk_import | Unknown |  |
| has_receipt | Unknown |  |
| include_receipt | Unknown |  |
| is_cog | Unknown |  |
| is_duplicate | Unknown |  |
| markup_percent | Unknown |  |
| note | Unknown |  |
| potential_bill_payment | Unknown |  |
| profile_id | Unknown |  |
| staff_id | Unknown |  |
| status | Unknown |  |
| tax_amount_1 | Unknown |  |
| tax_amount_1_currency_code | Unknown |  |
| tax_amount_2 | Unknown |  |
| tax_name_1 | Unknown |  |
| tax_name_2 | Unknown |  |
| tax_percent_1 | Unknown |  |
| tax_percent_2 | Unknown |  |
| transaction_id | Unknown |  |
| updated | Instant |  |
| vendor | Unknown |  |
| version | Unknown |  |
| vis_state | Unknown |  |

### expense_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| account_id | Unknown |  |
| category | Unknown |  |
| created_at | Unknown |  |
| is_cog | Unknown |  |
| is_editable | Unknown |  |
| transaction_posted | Unknown |  |
| updated_at | Unknown |  |
| vis_state | Unknown |  |

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_id | Unknown | FK |
| billable | Unknown |  |
| name | Unknown |  |
| project_default | Unknown |  |
| vis_state | Unknown |  |

### other_income_tax

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| other_income_id | Unknown | FK |
| amount | Unknown |  |
| name | Unknown |  |

### other_income

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client_id | Unknown | FK |
| account_id | Unknown |  |
| amount | Unknown |  |
| category_name | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| date | Unknown |  |
| net_paid_amount | Unknown |  |
| net_paid_amount_code | Unknown |  |
| note | Unknown |  |
| payment_type | Unknown |  |
| source | Unknown |  |
| source_id | Unknown |  |
| updated_at | Unknown |  |
| vis_state | Unknown |  |

### business_client

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| membership_id | Unknown | FK |
| user_id | Unknown | FK |
| client_account | Unknown |  |
| client_business_id | Unknown |  |

### user_business

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | FK |
| account_id | Unknown |  |
| active | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_id | Unknown |  |
| address_postal_code | Unknown |  |
| address_province | Unknown |  |
| address_street | Unknown |  |
| address_street_2 | Unknown |  |
| advanced_accounting_enabled | Unknown |  |
| business_id | Unknown |  |
| date_format | Unknown |  |
| fasttrack_token | Unknown |  |
| first_day_of_week | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| phone_number_id | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| unacknowledged_change | Unknown |  |
| uuid | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| confirmed_at | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| identity_origin | Unknown |  |
| identity_uuid | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| profession_company | Unknown |  |
| profession_designation | Unknown |  |
| profession_id | Unknown |  |
| profession_title | Unknown |  |
| setup_complete | Unknown |  |
| timezone | Unknown |  |
| unconfirmed_email | Unknown |  |

### estimate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| client_id | Unknown | FK |
| accepted | Unknown |  |
| address | Unknown |  |
| amount_currency_code | Unknown |  |
| city | Unknown |  |
| code | Unknown |  |
| country | Unknown |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| current_organization | Unknown |  |
| description | Unknown |  |
| discount_total_amount | Unknown |  |
| discount_total_currency_code | Unknown |  |
| discount_value | Unknown |  |
| display_status | Unknown |  |
| estimate_number | Unknown |  |
| first_name | Unknown |  |
| invoiced | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| modern_project_id | Unknown |  |
| note | Unknown |  |
| organization | Unknown |  |
| owner_id | Unknown |  |
| po_number | Unknown |  |
| province | Unknown |  |
| require_client_signature | Unknown |  |
| rich_proposal | Unknown |  |
| sent_id | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| term | Unknown |  |
| total_amount | Unknown |  |
| ui_status | Unknown |  |
| updated | Unknown |  |
| vat_name | Unknown |  |
| vat_number | Unknown |  |
| vis_state | Unknown |  |

## Relationships

- payment(credit_id) → credit(id)
- payment(invoice_id) → invoice(id)
- payment(account_id) → user_business(account_id)
- payment(client_id) → client(id)
- credit(account_id) → user_business(account_id)
- credit(client_id) → client(id)
- project_service(service_id) → service(id)
- project_service(project_id) → project(id)
- project_group_member(identity_id) → users(id)
- project_group_member(project_id) → project(id)
- project(client_id) → client(id)
- tax(account_id) → user_business(account_id)
- invoice(project_id) → project(id)
- invoice(account_id) → user_business(account_id)
- invoice(estimate_id) → estimate(id)
- invoice(client_id) → client(id)
- client(account_id) → user_business(account_id)
- time_entry(service_id) → service(id)
- time_entry(identity_id) → users(id)
- time_entry(project_id) → project(id)
- time_entry(client_id) → client(id)
- expense(category_id) → expense_category(id)
- expense(invoice_id) → invoice(id)
- expense(project_id) → project(id)
- expense(account_id) → user_business(account_id)
- expense(client_id) → client(id)
- expense_category(parent_id) → expense_category(id)
- service(business_id) → user_business(business_id)
- other_income_tax(other_income_id) → other_income(id)
- other_income(client_id) → client(id)
- business_client(user_id) → users(id)
- business_client(membership_id) → user_business(id)
- user_business(users_id) → users(id)
- estimate(account_id) → user_business(account_id)
- estimate(client_id) → client(id)