FreshBooks

Explore the interactive ERD

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	PKFK
`service_id`	Unknown	PKFK

project_group_member

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`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