Quickbooks schema and ERD

59 tables

Loading diagram…

bill

bill_payment

company

credit_memo

deposit

invoice

journal_entry

journal_report

payment

profit_and_loss_report

purchase

sales_receipt

vendor_credit

account

string

fully_qualified_name

string

domain

string

name

string

classification

string

account_sub_type

string

currency_ref_name

string

currency_ref_value

string

current_balance_with_sub_accounts

double

balance_sheet_report

account_id

string

date

account

string

total

double

_weld_synced

date

bill

string

due_date

string

balance

double

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

txn_date

string

bill_account_based_expense_line

string

bill_id

string

account_ref_name

string

account_ref_value

string

customer_ref_name

string

customer_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

bill_account_based_expense_line_linked_txn

bill_id

string

bill_account_based_expense_line_id

string

txn_id

string

txn_type

string

_weld_synced

date

bill_item_based_expense_line

string

bill_id

string

item_ref_name

string

item_ref_value

string

customer_ref_name

string

customer_ref_value

string

price_level_ref_name

string

price_level_ref_value

string

class_ref_name

string

class_ref_value

string

bill_item_based_expense_line_linked_txn

bill_id

string

bill_item_based_expense_line_id

string

txn_id

string

txn_type

string

_weld_synced

date

bill_linked_txn

bill_id

string

txn_id

string

txn_type

string

_weld_synced

date

bill_payment

string

vendor_ref_value

string

vendor_ref_name

string

pay_type

string

credit_card_payment_cc_account_ref_value

string

credit_card_payment_cc_account_ref_name

string

total_amt

double

domain

string

sparse

boolean

bill_payment_line

bill_payment_id

string

index

int

amount

double

_weld_synced

date

bill_payment_line_linked_txn

bill_payment_id

string

bill_payment_line_index

int

txn_id

string

txn_type

string

_weld_synced

date

class

string

name

string

fully_qualified_name

string

sub_class

boolean

parent_ref_name

string

parent_ref_value

string

active

boolean

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

_weld_synced

date

company

string

domain

string

legal_addr_city

string

legal_addr_country

string

legal_addr_line_1

string

legal_addr_postal_code

string

legal_addr_country_sub_division_code

string

legal_addr_id

string

supported_languages

string

company_name_value

company_id

string

name

string

value

string

_weld_synced

date

credit_memo

string

remaining_credit

double

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

doc_number

string

txn_date

string

credit_memo_custom_field

credit_memo_id

string

definition_id

string

name

string

type

string

_weld_synced

date

credit_memo_sales_item_line

string

credit_memo_id

string

item_ref_name

string

item_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

item_account_ref_name

string

item_account_ref_value

string

credit_memo_description_only_line

string

credit_memo_id

string

tax_code_ref_name

string

tax_code_ref_value

string

service_date

date

amount

double

line_num

int

description

string

_weld_synced

date

credit_memo_discount_line

string

credit_memo_id

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

discount_account_ref_name

string

discount_account_ref_value

string

percent_based

boolean

discount_percent

double

amount

double

line_num

int

description

string

_weld_synced

date

credit_memo_sub_total_line

string

credit_memo_id

string

item_ref_name

string

item_ref_value

string

amount

double

index

int

line_num

int

description

string

_weld_synced

date

credit_memo_group_line

string

credit_memo_id

string

quantity

double

group_item_ref_name

string

group_item_ref_value

string

line_num

int

description

string

_weld_synced

date

credit_memo_group_line_sales_item_line

string

credit_memo_id

string

item_ref_name

string

item_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

item_account_ref_name

string

item_account_ref_value

string

customer

string

display_name

string

fully_qualified_name

string

company_name

string

print_on_check_name

string

title

string

given_name

string

middle_name

string

family_name

string

department

string

name

string

fully_qualified_name

string

sub_department

boolean

parent_ref_name

string

parent_ref_value

string

active

boolean

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

_weld_synced

date

deposit

string

deposit_to_account_ref_value

string

deposit_to_account_ref_name

string

cash_back_account_ref_value

string

cash_back_account_ref_name

string

cash_back_amount

double

cash_back_memo

string

total_amt

double

home_total_amt

double

deposit_line

string

deposit_id

string

account_ref_name

string

account_ref_value

string

payment_method_ref_name

string

payment_method_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

deposit_line_txn

deposit_id

string

deposit_line_index

int

txn_id

string

txn_type

string

txn_line_id

string

_weld_synced

date

general_ledger_report

account_id

string

tx_date

date

txn_type

string

txn_type_id

string

doc_num

string

name

string

name_id

string

memo

string

split_acc

string

invoice

string

class_ref_name

string

class_ref_value

string

txn_date

date

domain

string

print_status

string

sales_term_ref_value

string

total_amt

double

currency_ref_name

string

invoice_custom_field

invoice_id

string

definition_id

string

string_value

string

type

string

name

string

_weld_synced

date

invoice_linked_txn

invoice_id

string

txn_id

string

txn_type

string

_weld_synced

date

invoice_txn_tax_detail_tax_line

invoice_id

string

index

int

amount

double

detail_type

string

tax_line_detail_tax_rate_ref_value

string

tax_line_detail_percent_based

boolean

tax_line_detail_tax_percent

double

tax_line_detail_net_amount_taxable

double

_weld_synced

date

invoice_line

string

invoice_id

string

sales_item_line_detail_class_ref_name

string

sales_item_line_detail_class_ref_value

string

sales_item_line_detail_item_account_ref_name

string

sales_item_line_detail_item_account_ref_value

string

discount_line_detail_class_ref_name

string

discount_line_detail_class_ref_value

string

discount_line_detail_discount_account_ref_name

string

discount_line_detail_discount_account_ref_value

string

item

string

name

string

fully_qualified_name

string

sku

string

description

string

type

string

item_category_type

string

active

boolean

sub_item

boolean

journal_entry

string

doc_number

string

adjustment

boolean

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

txn_date

date

journal_entry_line

string

journal_entry_id

string

description

string

amount

double

detail_type

string

journal_entry_line_detail_posting_type

string

journal_entry_line_detail_account_ref_value

string

journal_entry_line_detail_account_ref_name

string

journal_entry_line_detail_entity_type

string

journal_entry_line_detail_entity_entity_ref_name

string

journal_entry_tax_line

journal_entry_id

string

detail_type

string

amount

double

tax_line_detail_tax_rate_ref_value

string

tax_line_detail_tax_rate_ref_name

string

tax_line_detail_net_amount_taxable

double

tax_line_detail_percent_based

boolean

tax_line_detail_tax_inclusive_amount

double

tax_line_detail_override_delta_amount

double

tax_line_detail_tax_percent

double

_weld_synced

date

journal_report

account_id

string

date

transaction_type

string

transaction_id

string

num

string

name

string

memo_description

string

account

string

debit

double

credit

double

name_id

string

_weld_synced

date

journal_report_line

account_id

string

index

int

journal_transaction_id

string

journal_num

string

memo_description

string

account

string

debit

double

credit

double

_weld_synced

date

payment

string

customer_ref_value

string

customer_ref_name

string

deposit_to_account_ref_value

string

total_amt

double

unapplied_amt

double

process_payment

boolean

domain

string

sparse

boolean

payment_line

payment_id

string

amount

double

index

int

_weld_synced

date

payment_line_linked_txn

payment_id

string

line_index

int

txn_id

string

txn_type

string

txn_line_id

string

_weld_synced

date

profit_and_loss_report

account_id

string

date

account

string

total

double

_weld_synced

date

profit_and_loss_report_summary

date

group

string

account

string

total

double

_weld_synced

date

purchase

string

txn_date

date

doc_number

string

payment_type

string

account_ref_name

string

account_ref_value

string

entity_ref_name

string

entity_ref_value

string

entity_ref_type

string

purchase_account_based_expense_line

string

purchase_id

string

account_ref_name

string

account_ref_value

string

customer_ref_name

string

customer_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

purchase_item_based_expense_line

string

purchase_id

string

item_ref_name

string

item_ref_value

string

customer_ref_name

string

customer_ref_value

string

price_level_ref_name

string

price_level_ref_value

string

class_ref_name

string

class_ref_value

string

sales_receipt

string

txn_date

date

doc_number

string

customer_ref_name

string

customer_ref_value

string

class_ref_name

string

class_ref_value

string

department_ref_name

string

department_ref_value

string

sales_receipt_sales_item_line

string

sales_receipt_id

string

item_ref_name

string

item_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

item_account_ref_name

string

item_account_ref_value

string

sales_receipt_discount_line

string

sales_receipt_id

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

discount_account_ref_name

string

discount_account_ref_value

string

percent_based

boolean

discount_percent

double

amount

double

line_num

int

description

string

_weld_synced

date

sales_receipt_description_only_line

string

sales_receipt_id

string

tax_code_ref_name

string

tax_code_ref_value

string

service_date

date

amount

double

line_num

int

description

string

_weld_synced

date

sales_receipt_sub_total_line

string

sales_receipt_id

string

item_ref_name

string

item_ref_value

string

amount

double

index

int

line_num

int

description

string

_weld_synced

date

sales_receipt_group_line

string

sales_receipt_id

string

quantity

double

group_item_ref_name

string

group_item_ref_value

string

line_num

int

description

string

_weld_synced

date

sales_receipt_group_line_sales_item_line

string

sales_receipt_id

string

item_ref_name

string

item_ref_value

string

class_ref_name

string

class_ref_value

string

tax_code_ref_name

string

tax_code_ref_value

string

item_account_ref_name

string

item_account_ref_value

string

trial_balance_report

account_id

string

date

account

string

credit

double

debit

double

_weld_synced

date

vendor

string

display_name

string

company_name

string

print_on_check_name

string

title

string

given_name

string

middle_name

string

family_name

string

suffix

string

vendor_credit

string

sync_token

string

domain

string

sparse

boolean

doc_number

string

txn_date

date

vendor_ref_name

string

vendor_ref_value

string

vendor_addr_line_1

string

vendor_credit_account_based_expense_line

string

vendor_credit_id

string

line_num

int

description

string

amount

double

detail_type

string

billable_status

string

tax_code_ref_name

string

tax_code_ref_value

string

customer_ref_name

string

vendor_credit_item_based_expense_line

string

vendor_credit_id

string

line_num

int

description

string

amount

double

detail_type

string

billable_status

string

tax_code_ref_name

string

tax_code_ref_value

string

customer_ref_name

string