QuickBooks

Explore the interactive ERD

Table & Field Reference

item

Column	Type	Keys
`id`	String	PK
`asset_account_id`	String	FK
`expense_account_id`	String	FK
`income_account_id`	String	FK
`parent_item_id`	String	FK
`purchase_tax_code_id`	String	FK
`sales_tax_code_id`	String	FK
`active`	Boolean
`created_at`	Instant
`description`	String
`fully_qualified_name`	String
`inventory_start_date`	LocalDate
`level`	Long
`name`	String
`purchase_cost`	BigDecimal
`purchase_description`	String
`purchase_tax_included`	Boolean
`quantity_on_hand`	BigDecimal
`sales_tax_included`	Boolean
`stock_keeping_unit`	String
`sub_item`	Boolean
`sync_token`	String
`taxable`	Boolean
`track_quantity_on_hand`	Boolean
`type`	String
`unit_price`	BigDecimal
`updated_at`	Instant

bill_payment_line_linked_txn

Column	Type	Keys
`line_index`	Long	PK
`txn_id`	String	PK
`txn_type`	String	PK
`bill_payment_id`	String	PKFK

purchase_order_linked_txn

Column	Type	Keys
`index`	Long	PK
`purchase_order_id`	String	PKFK
`bill_id`	String	FK
`purchase_id`	String	FK
`vendor_credit_id`	String	FK

deposit

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`cash_back_account_id`	String	FK
`currency_id`	String	FK
`department_id`	String	FK
`cash_back_amount`	BigDecimal
`cash_back_memo`	String
`created_at`	Instant
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_total_amount`	BigDecimal
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`transaction_date`	LocalDate
`transaction_source`	String
`transaction_status`	String
`updated_at`	Instant

vendor

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`currency_id`	String	FK
`term_id`	String	FK
`account_number`	String
`active`	Boolean
`alternate_phone`	String
`balance`	BigDecimal
`company_name`	String
`created_at`	Instant
`display_name`	String
`email`	String
`family_name`	String
`fax_number`	String
`given_name`	String
`middle_name`	String
`mobile_phone`	String
`other_contacts`	Json
`primary_phone`	String
`print_on_check_name`	String
`suffix`	String
`sync_token`	String
`tax_identifier`	String
`title`	String
`updated_at`	Instant
`vendor_1099`	Boolean
`web_url`	String

refund_receipt_line

Column	Type	Keys
`index`	Long	PK
`refund_id`	String	PKFK
`bundle_id`	String	FK
`description_tax_code_id`	String	FK
`discount_account_id`	String	FK
`discount_class_id`	String	FK
`discount_tax_code_id`	String	FK
`sales_item_account_id`	String	FK
`sales_item_class_id`	String	FK
`sales_item_item_id`	String	FK
`sales_item_tax_code_id`	String	FK
`sub_total_item_id`	String	FK
`amount`	BigDecimal
`bundle_quantity`	BigDecimal
`description`	String
`description_service_date`	LocalDate
`discount_discount_percent`	BigDecimal
`discount_percent_based`	Boolean
`sales_item_discount_amount`	BigDecimal
`sales_item_discount_rate`	BigDecimal
`sales_item_quantity`	BigDecimal
`sales_item_service_date`	LocalDate
`sales_item_unit_price`	BigDecimal

invoice_linked_txn

Column	Type	Keys
`index`	Long	PK
`invoice_id`	String	PKFK
`estimate_id`	String	FK
`payment_id`	String	FK
`time_activity_id`	String	FK
`charge_credit_id`	String
`reimburse_charge_id`	String
`statement_charge_id`	String

transfer

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`from_account_id`	String	FK
`to_account_id`	String	FK
`amount`	BigDecimal
`created_at`	Instant
`exchange_rate`	BigDecimal
`private_note`	String
`sync_token`	String
`transaction_date`	LocalDate
`updated_at`	Instant

invoice_tax_line

Column	Type	Keys
`index`	Long	PK
`invoice_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

invoice

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`class_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`deposit_to_account_id`	String	FK
`sales_term_id`	String	FK
`shipping_address_id`	String	FK
`tax_code_id`	String	FK
`allow_ipnpayment`	Boolean
`allow_online_achpayment`	Boolean
`allow_online_credit_card_payment`	Boolean
`allow_online_payment`	Boolean
`apply_tax_after_discount`	Boolean
`balance`	BigDecimal
`billing_bcc_email`	String
`billing_cc_email`	String
`billing_email`	String
`created_at`	Instant
`customer_memo`	String
`delivery_time`	LocalDate
`delivery_type`	String
`deposit`	BigDecimal
`doc_number`	String
`due_date`	LocalDate
`email_status`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_balance`	BigDecimal
`home_total_amount`	BigDecimal
`print_status`	String
`private_note`	String
`ship_date`	LocalDate
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`tracking_number`	String
`transaction_date`	LocalDate
`transaction_source`	String
`updated_at`	Instant

credit_memo_line_bundle

Column	Type	Keys
`index`	Long	PK
`credit_memo_id`	String	PKFK
`credit_memo_line_index`	Long	PKFK
`account_id`	String	FK
`class_id`	String	FK
`item_id`	String	FK
`tax_code_id`	String	FK
`amount`	BigDecimal
`description`	String
`discount_amount`	BigDecimal
`discount_rate`	BigDecimal
`line_num`	Long
`quantity`	BigDecimal
`service_date`	LocalDate
`unit_price`	BigDecimal

estimate_line_bundle

Column	Type	Keys
`index`	Long	PK
`estimate_id`	String	PKFK
`estimate_line_index`	Long	PKFK
`account_id`	String	FK
`class_id`	String	FK
`item_id`	String	FK
`tax_code_id`	String	FK
`amount`	BigDecimal
`description`	String
`discount_amount`	BigDecimal
`discount_rate`	BigDecimal
`line_num`	Long
`quantity`	BigDecimal
`service_date`	LocalDate
`unit_price`	BigDecimal

purchase_order_tax_line

Column	Type	Keys
`index`	Long	PK
`purchase_order_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

bill_line

Column	Type	Keys
`index`	Long	PK
`bill_id`	String	PKFK
`account_expense_account_id`	String	FK
`account_expense_class_id`	String	FK
`account_expense_customer_id`	String	FK
`account_expense_tax_code_id`	String	FK
`item_expense_class_id`	String	FK
`item_expense_customer_id`	String	FK
`item_expense_item_id`	String	FK
`item_expense_tax_code_id`	String	FK
`account_expense_billable_status`	String
`account_expense_tax_amount`	BigDecimal
`amount`	BigDecimal
`description`	String
`item_expense_billable_status`	String
`item_expense_quantity`	BigDecimal
`item_expense_unit_price`	BigDecimal

credit_memo_custom_field

Column	Type	Keys
`definition_id`	String	PK
`index`	Long	PK
`credit_memo_id`	String	PKFK
`name`	String

sales_receipt

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`class_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`deposit_to_account_id`	String	FK
`payment_method_id`	String	FK
`payment_reference_number`	String	FK
`shipping_address_id`	String	FK
`tax_code_id`	String	FK
`apply_tax_after_discount`	Boolean
`balance`	BigDecimal
`bill_email`	String
`created_at`	Instant
`credit_card_amount`	BigDecimal
`credit_card_auth_code`	String
`credit_card_billing_address_street`	String
`credit_card_cc_expiry_month`	Long
`credit_card_cc_expiry_year`	Long
`credit_card_cctrans_id`	String
`credit_card_name_on_account`	String
`credit_card_postal_code`	String
`credit_card_process_payment`	Boolean
`credit_card_status`	String
`credit_card_transaction_authorization_time`	LocalDate
`credit_card_type`	String
`customer_memo`	String
`delivery_time`	LocalDate
`delivery_type`	String
`doc_number`	String
`email_status`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_balance`	BigDecimal
`home_total_amount`	BigDecimal
`print_status`	String
`private_note`	String
`ship_date`	LocalDate
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`tracking_number`	String
`transaction_date`	LocalDate
`transaction_source`	String
`updated_at`	Instant

estimate_linked_txn

Column	Type	Keys
`index`	Long	PK
`estimate_id`	String	PKFK
`invoice_id`	String	FK

estimate_tax_line

Column	Type	Keys
`index`	Long	PK
`estimate_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

bill_tax_line_detail

Column	Type	Keys
`index`	Long	PK
`bill_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

journal_entry_line

Column	Type	Keys
`index`	Long	PK
`journal_entry_id`	String	PKFK
`account_id`	String	FK
`class_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`description_tax_code_id`	String	FK
`employee_id`	String	FK
`tax_code_id`	String	FK
`vendor_id`	String	FK
`amount`	BigDecimal
`billable_status`	String
`description`	String
`description_service_date`	LocalDate
`posting_type`	String
`tax_amount`	BigDecimal
`tax_applicable_on`	String

bundle

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`description`	String
`fully_qualified_name`	String
`name`	String
`print_grouped_items`	Boolean
`purchase_cost`	BigDecimal
`sync_token`	String
`taxable`	Boolean
`unit_price`	BigDecimal
`updated_at`	Instant

tax_rate_detail

Column	Type	Keys
`tax_code_id`	String	PKFK
`tax_rate_id`	String	PKFK
`tax_order`	Long
`tax_type_applicable`	String
`type`	String

estimate

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`class_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`sales_term_id`	String	FK
`shipping_address_id`	String	FK
`tax_code_id`	String	FK
`accepted_by`	String
`accepted_date`	LocalDate
`apply_tax_after_discount`	Boolean
`bill_email`	String
`created_at`	Instant
`customer_memo`	String
`delivery_type`	String
`doc_number`	String
`due_date`	LocalDate
`email_status`	String
`exchange_rate`	BigDecimal
`expiration_date`	LocalDate
`global_tax_calculation`	String
`home_total_amount`	BigDecimal
`print_status`	String
`private_note`	String
`ship_date`	LocalDate
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`transaction_date`	LocalDate
`transaction_status`	String
`updated_at`	Instant

credit_memo_line

Column	Type	Keys
`index`	Long	PK
`credit_memo_id`	String	PKFK
`bundle_id`	String	FK
`description_tax_code_id`	String	FK
`discount_account_id`	String	FK
`discount_class_id`	String	FK
`discount_tax_code_id`	String	FK
`sales_item_account_id`	String	FK
`sales_item_class_id`	String	FK
`sales_item_item_id`	String	FK
`sales_item_tax_code_id`	String	FK
`sub_total_item_id`	String	FK
`amount`	BigDecimal
`bundle_quantity`	BigDecimal
`description`	String
`description_service_date`	LocalDate
`discount_discount_percent`	BigDecimal
`discount_percent_based`	Boolean
`sales_item_discount_amount`	BigDecimal
`sales_item_discount_rate`	BigDecimal
`sales_item_quantity`	BigDecimal
`sales_item_service_date`	LocalDate
`sales_item_unit_price`	BigDecimal

bill_payment

Column	Type	Keys
`id`	String	PK
`check_bank_account_id`	String	FK
`credit_card_account_id`	String	FK
`currency_id`	String	FK
`department_id`	String	FK
`payable_account_id`	String	FK
`vendor_id`	String	FK
`check_print_status`	String
`created_at`	Instant
`doc_number`	String
`exchange_rate`	BigDecimal
`pay_type`	String
`private_note`	String
`process_bill_payment`	Boolean
`sync_token`	String
`total_amount`	BigDecimal
`transaction_date`	LocalDate
`updated_at`	Instant

invoice_line

Column	Type	Keys
`index`	Long	PK
`invoice_id`	String	PK
`bundle_id`	String	FK
`description_tax_code_id`	String	FK
`discount_account_id`	String	FK
`discount_class_id`	String	FK
`discount_tax_code_id`	String	FK
`sales_item_account_id`	String	FK
`sales_item_class_id`	String	FK
`sales_item_item_id`	String	FK
`sales_item_tax_code_id`	String	FK
`sub_total_item_id`	String	FK
`amount`	BigDecimal
`bundle_quantity`	BigDecimal
`description`	String
`description_service_date`	LocalDate
`detail_type`	String
`discount_discount_percent`	BigDecimal
`discount_percent_based`	Boolean
`id`	String
`line_num`	Long
`sales_item_discount_amount`	BigDecimal
`sales_item_discount_rate`	BigDecimal
`sales_item_quantity`	BigDecimal
`sales_item_service_date`	LocalDate
`sales_item_unit_price`	BigDecimal

customer

Column	Type	Keys
`id`	String	PK
`ar_account_id`	String	FK
`bill_address_id`	String	FK
`currency_id`	String	FK
`customer_type_id`	String	FK
`default_tax_code_id`	String	FK
`parent_customer_id`	String	FK
`payment_method_id`	String	FK
`sales_term_id`	String	FK
`shipping_address_id`	String	FK
`active`	Boolean
`alternate_phone_number`	String
`balance`	BigDecimal
`balance_with_jobs`	BigDecimal
`bill_with_parent`	Boolean
`company_name`	String
`created_at`	Instant
`display_name`	String
`email`	String
`family_name`	String
`fax_number`	String
`fully_qualified_name`	String
`given_name`	String
`job`	Boolean
`level`	Long
`middle_name`	String
`mobile_number`	String
`notes`	String
`open_balance_date`	LocalDate
`phone_number`	String
`preferred_delivery_method`	String
`print_on_check_name`	String
`resale_number`	String
`suffix`	String
`sync_token`	String
`tax_exemption_reason_id`	String
`taxable`	Boolean
`title`	String
`updated_at`	Instant
`website`	String

purchase_order_line

Column	Type	Keys
`index`	Long	PK
`purchase_order_id`	String	PKFK
`account_expense_account_id`	String	FK
`account_expense_class_id`	String	FK
`account_expense_customer_id`	String	FK
`account_expense_tax_code_id`	String	FK
`item_expense_class_id`	String	FK
`item_expense_customer_id`	String	FK
`item_expense_item_id`	String	FK
`item_expense_tax_code_id`	String	FK
`account_expense_billable_status`	String
`account_expense_tax_amount`	BigDecimal
`amount`	BigDecimal
`description`	String
`item_expense_billable_status`	String
`item_expense_quantity`	BigDecimal
`item_expense_unit_price`	BigDecimal

payment_method

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`name`	String
`sync_token`	String
`type`	String
`updated_at`	Instant

exchange_rate

Column	Type	Keys
`as_of_date`	LocalDate	PK
`source_currency_code`	String	PK
`target_currency_code`	String	PK
`created_at`	Instant
`rate`	BigDecimal
`updated_at`	Instant

tax_rate

Column	Type	Keys
`id`	String	PK
`tax_agency_id`	String	FK
`active`	Boolean
`created_at`	Instant
`description`	String
`display_type`	String
`effective_tax_rate`	Json
`name`	String
`rate_value`	BigDecimal
`special_tax_type`	String
`sync_token`	String
`updated_at`	Instant

purchase_tax_line

Column	Type	Keys
`index`	Long	PK
`purchase_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

payment

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`customer_id`	String	FK
`deposit_to_account_id`	String	FK
`payment_method_id`	String	FK
`receivable_account_id`	String	FK
`created_at`	Instant
`credit_card_amount`	BigDecimal
`credit_card_auth_code`	String
`credit_card_billing_address_street`	String
`credit_card_cc_expiry_month`	Long
`credit_card_cc_expiry_year`	Long
`credit_card_cctrans_id`	String
`credit_card_name_on_account`	String
`credit_card_postal_code`	String
`credit_card_process_payment`	Boolean
`credit_card_status`	String
`credit_card_transaction_authorization_time`	LocalDate
`credit_card_type`	String
`exchange_rate`	BigDecimal
`private_note`	String
`process_payment`	Boolean
`reference_number`	String
`sync_token`	String
`total_amount`	BigDecimal
`transaction_date`	LocalDate
`transaction_source`	String
`transaction_status`	String
`unapplied_amount`	BigDecimal
`updated_at`	Instant

refund_receipt

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`class_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`deposit_to_account_id`	String	FK
`payment_method_id`	String	FK
`payment_reference_number`	String	FK
`shipping_address_id`	String	FK
`tax_code_id`	String	FK
`apply_tax_after_discount`	Boolean
`balance`	BigDecimal
`bill_email`	String
`created_at`	Instant
`credit_card_amount`	BigDecimal
`credit_card_auth_code`	String
`credit_card_billing_address_street`	String
`credit_card_cc_expiry_month`	Long
`credit_card_cc_expiry_year`	Long
`credit_card_cctrans_id`	String
`credit_card_name_on_account`	String
`credit_card_postal_code`	String
`credit_card_process_payment`	Boolean
`credit_card_status`	String
`credit_card_transaction_authorization_time`	LocalDate
`credit_card_type`	String
`customer_memo`	String
`doc_number`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_balance`	BigDecimal
`home_total_amount`	BigDecimal
`payment_type`	String
`print_status`	String
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`transaction_date`	LocalDate
`transaction_source`	String
`updated_at`	Instant
`check_payment_`

payment_line

Column	Type	Keys
`index`	Long	PK
`payment_id`	String	PKFK
`credit_memo_id`	String	FK
`deposit_id`	String	FK
`invoice_id`	String	FK
`journal_entry_id`	String	FK
`amount`	BigDecimal
`check_id`	String
`credit_card_charge_id`	String
`credit_card_credit_id`	String
`expense_id`	String

department

Column	Type	Keys
`id`	String	PK
`parent_department_id`	String	FK
`active`	Boolean
`created_at`	Instant
`fully_qualified_name`	String
`name`	String
`sub_department`	Boolean
`sync_token`	String
`updated_at`	Instant

deposit_tax_line_detail

Column	Type	Keys
`index`	Long	PK
`deposit_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

invoice_line_bundle

Column	Type	Keys
`index`	Long	PK
`invoice_id`	String	PKFK
`invoice_line_index`	Long	PKFK
`account_id`	String	FK
`class_id`	String	FK
`item_id`	String	FK
`tax_code_id`	String	FK
`amount`	BigDecimal
`description`	String
`discount_amount`	BigDecimal
`discount_rate`	BigDecimal
`line_num`	Long
`quantity`	BigDecimal
`service_date`	LocalDate
`unit_price`	BigDecimal

purchase_order

Column	Type	Keys
`id`	String	PK
`class_id`	String	FK
`currency_id`	String	FK
`payable_account_id`	String	FK
`sales_term_id`	String	FK
`shipping_address_id`	String	FK
`tax_code_id`	String	FK
`vendor_address_id`	String	FK
`vendor_id`	String	FK
`created_at`	Instant
`doc_number`	String
`due_date`	LocalDate
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`memo`	String
`private_note`	String
`status`	String
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`transaction_date`	LocalDate
`updated_at`	Instant

bill_linked_txn

Column	Type	Keys
`index`	Long	PK
`bill_id`	String	PKFK
`bill_payment_id`	String	FK

company_info

Column	Type	Keys
`id`	String	PK
`company_addr_id`	String	FK
`customer_communication_addr_id`	String	FK
`legal_addr_id`	String	FK
`company_name`	String
`company_start_date`	LocalDate
`country`	String
`created_at`	Instant
`customer_communication_email`	String
`email`	String
`employer_id`	String
`fiscal_year_start_month`	String
`legal_name`	String
`name_value`	Json
`primary_phone_free_form_number`	String
`supported_languages`	String
`updated_at`	Instant
`web_addr_uri`	String

purchase

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`employee_id`	String	FK
`payment_method_id`	String	FK
`remit_to_address_id`	String	FK
`tax_code_id`	String	FK
`vendor_id`	String	FK
`created_at`	Instant
`credit`	Boolean
`doc_number`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`payment_type`	String
`print_status`	String
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`transaction_date`	LocalDate
`transaction_source`	String
`updated_at`	Instant

time_activity

Column	Type	Keys
`id`	String	PK
`class_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`employee_id`	String	FK
`item_id`	String	FK
`vendor_id`	String	FK
`billable_status`	String
`break_hours`	Double
`break_minutes`	Double
`created_at`	Instant
`description`	String
`end_time`	Instant
`hourly_rate`	BigDecimal
`hours`	Double
`minutes`	Double
`name_of`	String
`start_time`	Instant
`sync_token`	String
`taxable`	Boolean
`transaction_date`	LocalDate
`updated_at`	Instant

credit_memo_tax_line_detail

Column	Type	Keys
`index`	Long	PK
`credit_memo_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

employee

Column	Type	Keys
`id`	String	PK
`address_id`	String	FK
`active`	Boolean
`bill_rate`	BigDecimal
`billable_time`	Boolean
`birth_date`	LocalDate
`created_at`	Instant
`display_name`	String
`email`	String
`employee_number`	String
`family_name`	String
`gender`	String
`given_name`	String
`hired_date`	LocalDate
`middle_name`	String
`mobile_phone`	String
`organization`	Boolean
`phone_number`	String
`print_on_check_name`	String
`released_date`	LocalDate
`social_security_number`	String
`suffix`	String
`sync_token`	String
`title`	String
`updated_at`	Instant

estimate_line

Column	Type	Keys
`index`	Long	PK
`estimate_id`	String	PKFK
`bundle_id`	String	FK
`description_tax_code_id`	String	FK
`discount_account_id`	String	FK
`discount_class_id`	String	FK
`discount_tax_code_id`	String	FK
`sales_item_account_id`	String	FK
`sales_item_class_id`	String	FK
`sales_item_item_id`	String	FK
`sales_item_tax_code_id`	String	FK
`sub_total_item_id`	String	FK
`amount`	BigDecimal
`bundle_quantity`	BigDecimal
`description`	String
`description_service_date`	LocalDate
`discount_discount_percent`	BigDecimal
`discount_percent_based`	Boolean
`sales_item_discount_amount`	BigDecimal
`sales_item_discount_rate`	BigDecimal
`sales_item_quantity`	BigDecimal
`sales_item_service_date`	LocalDate
`sales_item_unit_price`	BigDecimal

purchase_line

Column	Type	Keys
`index`	Long	PK
`purchase_id`	String	PKFK
`account_expense_account_id`	String	FK
`account_expense_class_id`	String	FK
`account_expense_customer_id`	String	FK
`account_expense_tax_code_id`	String	FK
`item_expense_class_id`	String	FK
`item_expense_customer_id`	String	FK
`item_expense_item_id`	String	FK
`item_expense_tax_code_id`	String	FK
`account_expense_billable_status`	String
`account_expense_tax_amount`	BigDecimal
`amount`	BigDecimal
`description`	String
`item_expense_billable_status`	String
`item_expense_quantity`	BigDecimal
`item_expense_unit_price`	BigDecimal

sales_receipt_tax_line

Column	Type	Keys
`index`	Long	PK
`sales_receipt_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

journal_entry

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`tax_code_id`	String	FK
`adjustment`	Boolean
`created_at`	Instant
`doc_number`	String
`exchange_rate`	BigDecimal
`home_total_amount`	BigDecimal
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	BigDecimal
`transaction_date`	LocalDate
`updated_at`	Instant

address

Column	Type	Keys
`id`	String	PK
`city`	String
`country`	String
`country_sub_division_code`	String
`latitude`	String
`line_1`	String
`line_2`	String
`line_3`	String
`line_4`	String
`line_5`	String
`longitude`	String
`postal_code`	String

sales_receipt_line

Column	Type	Keys
`index`	Long	PK
`sales_receipt_id`	String	PKFK
`bundle_id`	String	FK
`description_tax_code_id`	String	FK
`discount_account_id`	String	FK
`discount_class_id`	String	FK
`discount_tax_code_id`	String	FK
`sales_item_account_id`	String	FK
`sales_item_class_id`	String	FK
`sales_item_item_id`	String	FK
`sales_item_tax_code_id`	String	FK
`sub_total_item_id`	String	FK
`amount`	BigDecimal
`bundle_quantity`	BigDecimal
`description`	String
`description_service_date`	LocalDate
`discount_discount_percent`	BigDecimal
`discount_percent_based`	Boolean
`sales_item_discount_amount`	BigDecimal
`sales_item_discount_rate`	BigDecimal
`sales_item_quantity`	BigDecimal
`sales_item_service_date`	LocalDate
`sales_item_unit_price`	BigDecimal

credit_memo

Column	Type	Keys
`id`	String	PK
`billing_address_id`	String	FK
`class_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`payment_method_id`	String	FK
`sales_term_id`	String	FK
`shipping_address_id`	String	FK
`apply_tax_after_discount`	Boolean
`balance`	BigDecimal
`bill_email`	String
`created_at`	Instant
`customer_memo`	String
`doc_number`	String
`email_status`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_balance`	BigDecimal
`home_total_amount`	BigDecimal
`print_status`	String
`private_note`	String
`remaining_credit`	BigDecimal
`sync_token`	String
`total_amount`	BigDecimal
`total_tax`	Float
`transaction_date`	LocalDate
`updated_at`	Instant

bill_payment_line

Column	Type	Keys
`index`	Long	PK
`bill_payment_id`	String	PKFK
`bill_id`	String	FK
`deposit_id`	String	FK
`journal_entry_id`	String	FK
`linked_bill_payment_id`	String	FK
`purchase_id`	String	FK
`vendor_credit_id`	String	FK
`amount`	BigDecimal
`bill_payment_credit_card_id`	String
`check_id`	String
`credit_card_charge_id`	String
`credit_card_credit_id`	String
`expense_id`	String

vendor_credit

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`department_id`	String	FK
`payable_account_id`	String	FK
`vendor_id`	String	FK
`balance`	BigDecimal
`created_at`	Instant
`doc_number`	String
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`transaction_date`	LocalDate
`updated_at`	Instant

tax_agency

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`display_name`	String
`sync_token`	String
`tax_registration_number`	String
`tax_tracked_on_purchases`	Boolean
`tax_tracked_on_sales`	Boolean
`updated_at`	Instant

journal_entry_tax_line

Column	Type	Keys
`index`	Long	PK
`journal_entry_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

customer_type

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`name`	String
`updated_at`	Instant

refund_receipt_line_bundle

Column	Type	Keys
`index`	Long	PK
`refund_receipt_id`	String	PKFK
`refund_receipt_line_index`	Long	PKFK
`account_id`	String	FK
`class_id`	String	FK
`item_id`	String	FK
`tax_code_id`	String	FK
`amount`	BigDecimal
`description`	String
`discount_amount`	BigDecimal
`discount_rate`	BigDecimal
`line_num`	Long
`quantity`	BigDecimal
`service_date`	LocalDate
`unit_price`	BigDecimal

purchase_order_line_linked_txn

Column	Type	Keys
`txn_id`	String	PK
`txn_type`	String	PK
`purchase_order_id`	String	PKFK
`purchase_order_line_index`	Long	PKFK
`txn_line_id`	String

deposit_line

Column	Type	Keys
`index`	Long	PK
`deposit_id`	String	PKFK
`bill_id`	String	FK
`deposit_account_id`	String	FK
`deposit_class_id`	String	FK
`deposit_customer_id`	String	FK
`deposit_payment_method_id`	String	FK
`deposit_tax_code_id`	String	FK
`invoice_id`	String	FK
`journal_entry_id`	String	FK
`payment_id`	String	FK
`purchase_id`	String	FK
`refund_receipt_id`	String	FK
`sales_receipt_id`	String	FK
`transfer_id`	String	FK
`vendor_credit_id`	String	FK
`amount`	BigDecimal
`deposit_check_number`	String
`deposit_tax_applicable_on`	String
`deposit_transaction_type`	String
`description`	String
`detail_type`	String
`expense_id`	String

refund_receipt_tax_line

Column	Type	Keys
`index`	Long	PK
`refund_receipt_id`	String	PKFK
`tax_rate_id`	String	FK
`amount`	BigDecimal
`net_amount_taxable`	BigDecimal
`override_delta_amount`	BigDecimal
`percent_based`	Boolean
`tax_inclusive_amount`	BigDecimal
`tax_percent`	BigDecimal

budget_detail

Column	Type	Keys
`index`	Long	PK
`budget_id`	String	PKFK
`account_id`	String	FK
`class_id`	String	FK
`customer_id`	String	FK
`department_id`	String	FK
`amount`	BigDecimal
`budget_date`	LocalDate

currency

Column	Type	Keys
`id`	String	PK
`name`	String

sales_receipt_line_bundle

Column	Type	Keys
`index`	Long	PK
`sales_receipt_id`	String	PKFK
`sales_receipt_line_index`	Long	PKFK
`account_id`	String	FK
`class_id`	String	FK
`item_id`	String	FK
`tax_code_id`	String	FK
`amount`	BigDecimal
`description`	String
`discount_amount`	BigDecimal
`discount_rate`	BigDecimal
`line_num`	Long
`quantity`	BigDecimal
`service_date`	LocalDate
`unit_price`	BigDecimal

bill

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`department_id`	String	FK
`payable_account_id`	String	FK
`sales_term_id`	String	FK
`vendor_id`	String	FK
`balance`	BigDecimal
`created_at`	Instant
`doc_number`	String
`due_date`	LocalDate
`exchange_rate`	BigDecimal
`global_tax_calculation`	String
`home_balance`	BigDecimal
`private_note`	String
`sync_token`	String
`total_amount`	BigDecimal
`transaction_date`	LocalDate
`updated_at`	Instant

credit_card_payment_txn

Column	Type	Keys
`id`	String	PK
`bank_account_id`	String	FK
`credit_card_account_id`	String	FK
`currency_id`	String	FK
`amount`	BigDecimal
`created_at`	Instant
`exchange_rate`	BigDecimal
`sync_token`	String
`transaction_date`	LocalDate
`updated_at`	Instant

tax_code

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`description`	String
`name`	String
`sync_token`	String
`tax_group`	Boolean
`taxable`	Boolean
`updated_at`	Instant

vendor_credit_line

Column	Type	Keys
`index`	Long	PK
`vendor_credit_id`	String	PKFK
`account_expense_account_id`	String	FK
`account_expense_class_id`	String	FK
`account_expense_customer_id`	String	FK
`account_expense_tax_code_id`	String	FK
`item_expense_class_id`	String	FK
`item_expense_customer_id`	String	FK
`item_expense_item_id`	String	FK
`item_expense_tax_code_id`	String	FK
`account_expense_billable_status`	String
`account_expense_tax_amount`	BigDecimal
`amount`	BigDecimal
`description`	String
`item_expense_billable_status`	String
`item_expense_quantity`	BigDecimal
`item_expense_unit_price`	BigDecimal
`private_note`	String

account

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`parent_account_id`	String	FK
`tax_code_id`	String	FK
`account_number`	String
`account_sub_type`	String
`account_type`	String
`active`	Boolean
`balance`	BigDecimal
`balance_with_sub_accounts`	BigDecimal
`classification`	String
`created_at`	Instant
`description`	String
`fully_qualified_name`	String
`name`	String
`sub_account`	Boolean
`sync_token`	String
`updated_at`	Instant

class

Column	Type	Keys
`id`	String	PK
`parent_class_id`	String	FK
`active`	Boolean
`created_at`	Instant
`fully_qualified_name`	String
`name`	String
`sub_class`	Boolean
`sync_token`	String
`updated_at`	Instant

bundle_item

Column	Type	Keys
`bundle_id`	String	PKFK
`item_id`	String	PKFK
`item_quantity`	BigDecimal

recurring_transaction

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`recur_data_ref_id`	String
`sync_token`	String
`total_amount`	BigDecimal
`type`	String
`updated_at`	Instant
`recurring_info_`

term

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created_at`	Instant
`day_of_month_due`	Long
`discount_day_of_month`	Long
`discount_days`	Long
`discount_percent`	BigDecimal
`due_days`	Long
`due_next_month_days`	Long
`name`	String
`sync_token`	String
`type`	String
`updated_at`	Instant

budget

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`budget_entry_type`	String
`budget_type`	String
`created_at`	Instant
`end_date`	LocalDate
`name`	String
`start_date`	LocalDate
`sync_token`	String
`updated_at`	Instant