ERD for Quickbooks

34 tables

Loading diagram…

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

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

txn_date

date

currency_ref_value

string

currency_ref_name

string

_weld_synced

date

payment_line

payment_id

string

amount

double

index

int

payment_line_linked_txn

payment_id

string

line_index

int

txn_id

string

txn_type

string

txn_line_id

string

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

string

country

string

company_addr_city

string

company_addr_country

string

company_addr_line_1

string

company_addr_postal_code

string

company_addr_country_sub_division_code

string

company_addr_id

string

sparse

boolean

web_addr_uri

string

fiscal_year_start_month

string

customer_communication_addr_city

string

customer_communication_addr_country

string

customer_communication_addr_line_1

string

customer_communication_addr_postal_code

string

customer_communication_addr_country_sub_division_code

string

customer_communication_addr_id

string

primary_phone_free_form_number

string

legal_name

string

company_start_date

date

email_address

string

meta_data_create_time

date

meta_data_last_updated_time

date

_weld_synced

date

company_name_value

company_id

string

name

string

value

string

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

currency_ref_value

string

currency_ref_name

string

txn_tax_detail_total_tax

double

customer_ref_value

string

customer_ref_name

string

customer_memo_value

string

bill_addr_id

string

bill_addr_line_1

string

bill_addr_line_2

string

bill_addr_line_3

string

bill_addr_line_4

string

bill_addr_lat

string

bill_addr_long

string

ship_addr_id

string

ship_addr_line_1

string

ship_addr_city

string

ship_addr_country_sub_division_code

string

ship_addr_postal_code

string

ship_addr_lat

string

ship_addr_long

string

total_amt

double

apply_tax_after_discount

boolean

print_status

string

email_status

string

bill_email_address

string

balance

double

_weld_synced

date

credit_memo_custom_field

credit_memo_id

string

definition_id

string

name

string

type

string

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

tax_classification_ref_name

string

tax_classification_ref_value

string

markup_info_price_level_ref_name

string

markup_info_price_level_ref_value

string

markup_info_mark_up_income_account_ref_name

string

markup_info_mark_up_income_account_ref_value

string

tax_exclusive_amt

double

discount_amt

double

markup_info_percent

double

service_date

date

discount_rate

double

unit_price

double

qty

double

amount

double

line_num

int

description

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

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

credit_memo_sub_total_line

string

credit_memo_id

string

item_ref_name

string

item_ref_value

string

amount

double

line_num

int

description

string

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

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

tax_classification_ref_name

string

tax_classification_ref_value

string

markup_info_price_level_ref_name

string

markup_info_price_level_ref_value

string

markup_info_mark_up_income_account_ref_name

string

markup_info_mark_up_income_account_ref_value

string

tax_exclusive_amt

double

discount_amt

double

markup_info_percent

double

service_date

date

discount_rate

double

unit_price

double

qty

double

amount

double

line_num

int

description

string

group_line_id

string

journal_entry

string

adjustment

boolean

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

txn_date

date

currency_ref_value

string

currency_ref_name

string

private_note

string

txn_tax_detail_txn_tax_code_ref_name

string

txn_tax_detail_txn_tax_code_ref_value

string

txn_tax_detail_total_tax

double

_weld_synced

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_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

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

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

doc_number

string

txn_date

string

currency_ref_value

string

currency_ref_name

string

_weld_synced

date

bill_payment_line

bill_payment_id

string

index

int

amount

double

bill_payment_line_linked_txn

bill_payment_id

string

bill_payment_line_index

int

txn_id

string

txn_type

string

invoice

string

txn_date

date

domain

string

print_status

string

sales_term_ref_value

string

total_amt

double

due_date

date

apply_tax_after_discount

boolean

doc_number

string

sparse

boolean

customer_memo_value

string

project_ref_value

string

deposit

double

balance

double

customer_ref_name

string

customer_ref_value

string

txn_tax_detail_txn_tax_code_ref_value

string

txn_tax_detail_total_tax

double

sync_token

string

bill_email_address

string

ship_addr_city

string

ship_addr_line_1

string

ship_addr_postal_code

string

ship_addr_lat

string

ship_addr_long

string

ship_addr_country_sub_division_code

string

ship_addr_id

string

email_status

string

bill_addr_line_4

string

bill_addr_line_3

string

bill_addr_line_2

string

bill_addr_line_1

string

bill_addr_long

string

bill_addr_lat

string

bill_addr_id

string

meta_data_create_time

date

meta_data_last_updated_time

date

_weld_synced

date

invoice_custom_field

invoice_id

string

definition_id

string

string_value

string

type

string

name

string

invoice_line

string

invoice_id

string

description

string

detail_type

string

sales_item_line_detail_tax_code_ref_value

string

sales_item_line_detail_qty

double

sales_item_line_detail_unit_price

double

sales_item_line_detail_item_ref_name

string

sales_item_line_detail_item_ref_value

string

line_num

double

amount

double

invoice_linked_txn

invoice_id

string

txn_id

string

txn_type

string

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

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

currency_ref_value

string

currency_ref_name

string

vendor_ref_value

string

vendor_ref_name

string

ap_account_ref_value

string

ap_account_ref_name

string

total_amt

double

_weld_synced

date

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

markup_info_price_level_ref_name

string

markup_info_price_level_ref_value

string

markup_info_mark_up_income_account_ref_name

string

markup_info_mark_up_income_account_ref_value

string

tax_amount

double

tax_exclusive_amt

double

markup_info_percent

double

billable_status

string

line_num

int

description

string

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

tax_code_ref_name

string

tax_code_ref_value

string

markup_info_price_level_ref_name

string

markup_info_price_level_ref_value

string

markup_info_mark_up_income_account_ref_name

string

markup_info_mark_up_income_account_ref_value

string

tax_exclusive_amt

double

markup_info_percent

double

billable_status

string

qty

double

unit_price

double

amount

double

line_num

int

description

string

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

domain

string

sparse

boolean

sync_token

string

meta_data_create_time

date

meta_data_last_updated_time

date

txn_date

string

currency_ref_value

string

currency_ref_name

string

_weld_synced

date

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

entity_name

string

entity_value

string

project_ref_name

string

project_ref_value

string

check_num

string

tax_applicable_on

string

txn_type

string

amount

double

custom_field_definition_id

string

custom_field_string_value

string

custom_field_name

string

custom_field_type

string

line_num

int

description

string

index

int

deposit_line_txn

deposit_id

string

deposit_line_index

int

txn_id

string

txn_type

string

txn_line_id

string

balance_sheet_report

account_id

string

date

account

string

total

double

_weld_synced

date

trial_balance_report

account_id

string

date

account

string

credit

double

debit

double

_weld_synced

date

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

sparse

boolean

meta_data_create_time

date

meta_data_last_updated_time

date

account_type

string

current_balance

double

active

boolean

sync_token

string

sub_account

boolean

_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

split_acc_id

string

subt_nat_amount

string

rbal_nat_amount

string

account_name

string

_weld_synced

date

Table

Sub table