# QuickBooks schema ERD

Table and field reference for the Fivetran QuickBooks connector.

## 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 | PK, FK |

### purchase_order_linked_txn

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| purchase_order_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| credit_memo_line_index | Long | PK, FK |
| 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 | PK, FK |
| estimate_line_index | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| invoice_id | String | FK |

### estimate_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| estimate_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| tax_rate_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| invoice_line_index | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| refund_receipt_line_index | Long | PK, FK |
| 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 | PK, FK |
| purchase_order_line_index | Long | PK, FK |
| txn_line_id | String |  |

### deposit_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| deposit_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| sales_receipt_line_index | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| item_id | String | PK, FK |
| 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 |  |

## Relationships

- item(asset_account_id) → account(id)
- item(income_account_id) → account(id)
- item(expense_account_id) → account(id)
- item(parent_item_id) → item(id)
- item(sales_tax_code_id) → tax_code(id)
- item(purchase_tax_code_id) → tax_code(id)
- bill_payment_line_linked_txn(bill_payment_id) → bill_payment(id)
- purchase_order_linked_txn(purchase_order_id) → purchase_order(id)
- purchase_order_linked_txn(bill_id) → bill(id)
- purchase_order_linked_txn(purchase_id) → purchase(id)
- purchase_order_linked_txn(vendor_credit_id) → vendor_credit(id)
- deposit(currency_id) → currency(id)
- deposit(cash_back_account_id) → account(id)
- deposit(department_id) → department(id)
- deposit(account_id) → account(id)
- vendor(billing_address_id) → address(id)
- vendor(currency_id) → currency(id)
- vendor(term_id) → term(id)
- refund_receipt_line(refund_id) → refund_receipt(id)
- refund_receipt_line(sales_item_item_id) → item(id)
- refund_receipt_line(sales_item_class_id) → class(id)
- refund_receipt_line(sales_item_account_id) → account(id)
- refund_receipt_line(sales_item_tax_code_id) → tax_code(id)
- refund_receipt_line(bundle_id) → bundle(id)
- refund_receipt_line(description_tax_code_id) → tax_code(id)
- refund_receipt_line(discount_account_id) → account(id)
- refund_receipt_line(discount_class_id) → class(id)
- refund_receipt_line(discount_tax_code_id) → tax_code(id)
- refund_receipt_line(sub_total_item_id) → item(id)
- invoice_linked_txn(invoice_id) → invoice(id)
- invoice_linked_txn(payment_id) → payment(id)
- invoice_linked_txn(estimate_id) → estimate(id)
- invoice_linked_txn(time_activity_id) → time_activity(id)
- transfer(currency_id) → currency(id)
- transfer(to_account_id) → account(id)
- transfer(from_account_id) → account(id)
- invoice_tax_line(invoice_id) → invoice(id)
- invoice_tax_line(tax_rate_id) → tax_rate(id)
- invoice(currency_id) → currency(id)
- invoice(tax_code_id) → tax_code(id)
- invoice(shipping_address_id) → address(id)
- invoice(billing_address_id) → address(id)
- invoice(department_id) → department(id)
- invoice(sales_term_id) → term(id)
- invoice(customer_id) → customer(id)
- invoice(class_id) → class(id)
- invoice(deposit_to_account_id) → account(id)
- credit_memo_line_bundle(item_id) → item(id)
- credit_memo_line_bundle(class_id) → class(id)
- credit_memo_line_bundle(account_id) → account(id)
- credit_memo_line_bundle(tax_code_id) → tax_code(id)
- credit_memo_line_bundle(credit_memo_id) → credit_memo(id)
- credit_memo_line_bundle(credit_memo_line_index) → credit_memo_line(credit_memo_id)
- estimate_line_bundle(item_id) → item(id)
- estimate_line_bundle(class_id) → class(id)
- estimate_line_bundle(account_id) → account(id)
- estimate_line_bundle(tax_code_id) → tax_code(id)
- estimate_line_bundle(estimate_id) → estimate(id)
- estimate_line_bundle(estimate_line_index) → estimate_line(estimate_id)
- purchase_order_tax_line(purchase_order_id) → purchase_order(id)
- purchase_order_tax_line(tax_rate_id) → tax_rate(id)
- bill_line(item_expense_tax_code_id) → tax_code(id)
- bill_line(item_expense_item_id) → item(id)
- bill_line(item_expense_class_id) → class(id)
- bill_line(item_expense_customer_id) → customer(id)
- bill_line(account_expense_class_id) → class(id)
- bill_line(account_expense_tax_code_id) → tax_code(id)
- bill_line(account_expense_account_id) → account(id)
- bill_line(account_expense_customer_id) → customer(id)
- bill_line(bill_id) → bill(id)
- credit_memo_custom_field(credit_memo_id) → credit_memo(id)
- sales_receipt(currency_id) → currency(id)
- sales_receipt(shipping_address_id) → address(id)
- sales_receipt(billing_address_id) → address(id)
- sales_receipt(tax_code_id) → tax_code(id)
- sales_receipt(payment_reference_number) → payment(id)
- sales_receipt(payment_method_id) → payment_method(id)
- sales_receipt(deposit_to_account_id) → account(id)
- sales_receipt(customer_id) → customer(id)
- sales_receipt(department_id) → department(id)
- sales_receipt(class_id) → class(id)
- estimate_linked_txn(estimate_id) → estimate(id)
- estimate_linked_txn(invoice_id) → invoice(id)
- estimate_tax_line(estimate_id) → estimate(id)
- estimate_tax_line(tax_rate_id) → tax_rate(id)
- bill_tax_line_detail(bill_id) → bill(id)
- bill_tax_line_detail(tax_rate_id) → tax_rate(id)
- journal_entry_line(journal_entry_id) → journal_entry(id)
- journal_entry_line(customer_id) → customer(id)
- journal_entry_line(vendor_id) → vendor(id)
- journal_entry_line(employee_id) → employee(id)
- journal_entry_line(class_id) → class(id)
- journal_entry_line(account_id) → account(id)
- journal_entry_line(department_id) → department(id)
- journal_entry_line(tax_code_id) → tax_code(id)
- journal_entry_line(description_tax_code_id) → tax_code(id)
- tax_rate_detail(tax_code_id) → tax_code(id)
- tax_rate_detail(tax_rate_id) → tax_rate(id)
- estimate(currency_id) → currency(id)
- estimate(tax_code_id) → tax_code(id)
- estimate(shipping_address_id) → address(id)
- estimate(billing_address_id) → address(id)
- estimate(department_id) → department(id)
- estimate(customer_id) → customer(id)
- estimate(class_id) → class(id)
- estimate(sales_term_id) → term(id)
- credit_memo_line(credit_memo_id) → credit_memo(id)
- credit_memo_line(sales_item_item_id) → item(id)
- credit_memo_line(sales_item_class_id) → class(id)
- credit_memo_line(sales_item_account_id) → account(id)
- credit_memo_line(sales_item_tax_code_id) → tax_code(id)
- credit_memo_line(bundle_id) → bundle(id)
- credit_memo_line(description_tax_code_id) → tax_code(id)
- credit_memo_line(discount_account_id) → account(id)
- credit_memo_line(discount_class_id) → class(id)
- credit_memo_line(discount_tax_code_id) → tax_code(id)
- credit_memo_line(sub_total_item_id) → item(id)
- bill_payment(currency_id) → currency(id)
- bill_payment(credit_card_account_id) → account(id)
- bill_payment(check_bank_account_id) → account(id)
- bill_payment(department_id) → department(id)
- bill_payment(vendor_id) → vendor(id)
- bill_payment(payable_account_id) → account(id)
- invoice_line(sales_item_item_id) → item(id)
- invoice_line(sales_item_class_id) → class(id)
- invoice_line(sales_item_account_id) → account(id)
- invoice_line(sales_item_tax_code_id) → tax_code(id)
- invoice_line(bundle_id) → bundle(id)
- invoice_line(description_tax_code_id) → tax_code(id)
- invoice_line(discount_account_id) → account(id)
- invoice_line(discount_class_id) → class(id)
- invoice_line(discount_tax_code_id) → tax_code(id)
- invoice_line(sub_total_item_id) → item(id)
- customer(currency_id) → currency(id)
- customer(shipping_address_id) → address(id)
- customer(bill_address_id) → address(id)
- customer(customer_type_id) → customer_type(id)
- customer(payment_method_id) → payment_method(id)
- customer(parent_customer_id) → customer(id)
- customer(default_tax_code_id) → tax_code(id)
- customer(sales_term_id) → term(id)
- customer(ar_account_id) → account(id)
- purchase_order_line(item_expense_tax_code_id) → tax_code(id)
- purchase_order_line(item_expense_item_id) → item(id)
- purchase_order_line(item_expense_class_id) → class(id)
- purchase_order_line(item_expense_customer_id) → customer(id)
- purchase_order_line(account_expense_class_id) → class(id)
- purchase_order_line(account_expense_tax_code_id) → tax_code(id)
- purchase_order_line(account_expense_account_id) → account(id)
- purchase_order_line(account_expense_customer_id) → customer(id)
- purchase_order_line(purchase_order_id) → purchase_order(id)
- tax_rate(tax_agency_id) → tax_agency(id)
- purchase_tax_line(purchase_id) → purchase(id)
- purchase_tax_line(tax_rate_id) → tax_rate(id)
- payment(currency_id) → currency(id)
- payment(receivable_account_id) → account(id)
- payment(payment_method_id) → payment_method(id)
- payment(customer_id) → customer(id)
- payment(deposit_to_account_id) → account(id)
- refund_receipt(currency_id) → currency(id)
- refund_receipt(tax_code_id) → tax_code(id)
- refund_receipt(billing_address_id) → address(id)
- refund_receipt(shipping_address_id) → address(id)
- refund_receipt(payment_reference_number) → payment(id)
- refund_receipt(deposit_to_account_id) → account(id)
- refund_receipt(department_id) → department(id)
- refund_receipt(payment_method_id) → payment_method(id)
- refund_receipt(customer_id) → customer(id)
- refund_receipt(class_id) → class(id)
- payment_line(payment_id) → payment(id)
- payment_line(journal_entry_id) → journal_entry(id)
- payment_line(credit_memo_id) → credit_memo(id)
- payment_line(invoice_id) → invoice(id)
- payment_line(deposit_id) → deposit(id)
- department(parent_department_id) → department(id)
- deposit_tax_line_detail(deposit_id) → deposit(id)
- deposit_tax_line_detail(tax_rate_id) → tax_rate(id)
- invoice_line_bundle(item_id) → item(id)
- invoice_line_bundle(class_id) → class(id)
- invoice_line_bundle(account_id) → account(id)
- invoice_line_bundle(tax_code_id) → tax_code(id)
- invoice_line_bundle(invoice_id) → invoice(id)
- invoice_line_bundle(invoice_line_index) → invoice_line(invoice_id)
- purchase_order(currency_id) → currency(id)
- purchase_order(vendor_address_id) → address(id)
- purchase_order(shipping_address_id) → address(id)
- purchase_order(tax_code_id) → tax_code(id)
- purchase_order(payable_account_id) → account(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(class_id) → class(id)
- purchase_order(sales_term_id) → term(id)
- bill_linked_txn(bill_id) → bill(id)
- bill_linked_txn(bill_payment_id) → bill_payment(id)
- company_info(company_addr_id) → address(id)
- company_info(legal_addr_id) → address(id)
- company_info(customer_communication_addr_id) → address(id)
- purchase(currency_id) → currency(id)
- purchase(customer_id) → customer(id)
- purchase(vendor_id) → vendor(id)
- purchase(employee_id) → employee(id)
- purchase(remit_to_address_id) → address(id)
- purchase(tax_code_id) → tax_code(id)
- purchase(account_id) → account(id)
- purchase(department_id) → department(id)
- purchase(payment_method_id) → payment_method(id)
- time_activity(employee_id) → employee(id)
- time_activity(item_id) → item(id)
- time_activity(customer_id) → customer(id)
- time_activity(department_id) → department(id)
- time_activity(vendor_id) → vendor(id)
- time_activity(class_id) → class(id)
- credit_memo_tax_line_detail(credit_memo_id) → credit_memo(id)
- credit_memo_tax_line_detail(tax_rate_id) → tax_rate(id)
- employee(address_id) → address(id)
- estimate_line(estimate_id) → estimate(id)
- estimate_line(sales_item_item_id) → item(id)
- estimate_line(sales_item_class_id) → class(id)
- estimate_line(sales_item_account_id) → account(id)
- estimate_line(sales_item_tax_code_id) → tax_code(id)
- estimate_line(bundle_id) → bundle(id)
- estimate_line(description_tax_code_id) → tax_code(id)
- estimate_line(discount_account_id) → account(id)
- estimate_line(discount_class_id) → class(id)
- estimate_line(discount_tax_code_id) → tax_code(id)
- estimate_line(sub_total_item_id) → item(id)
- purchase_line(purchase_id) → purchase(id)
- purchase_line(item_expense_tax_code_id) → tax_code(id)
- purchase_line(item_expense_item_id) → item(id)
- purchase_line(item_expense_class_id) → class(id)
- purchase_line(item_expense_customer_id) → customer(id)
- purchase_line(account_expense_class_id) → class(id)
- purchase_line(account_expense_tax_code_id) → tax_code(id)
- purchase_line(account_expense_account_id) → account(id)
- purchase_line(account_expense_customer_id) → customer(id)
- sales_receipt_tax_line(sales_receipt_id) → sales_receipt(id)
- sales_receipt_tax_line(tax_rate_id) → tax_rate(id)
- journal_entry(currency_id) → currency(id)
- journal_entry(tax_code_id) → tax_code(id)
- sales_receipt_line(sales_receipt_id) → sales_receipt(id)
- sales_receipt_line(sales_item_item_id) → item(id)
- sales_receipt_line(sales_item_class_id) → class(id)
- sales_receipt_line(sales_item_account_id) → account(id)
- sales_receipt_line(sales_item_tax_code_id) → tax_code(id)
- sales_receipt_line(bundle_id) → bundle(id)
- sales_receipt_line(description_tax_code_id) → tax_code(id)
- sales_receipt_line(discount_account_id) → account(id)
- sales_receipt_line(discount_class_id) → class(id)
- sales_receipt_line(discount_tax_code_id) → tax_code(id)
- sales_receipt_line(sub_total_item_id) → item(id)
- credit_memo(currency_id) → currency(id)
- credit_memo(shipping_address_id) → address(id)
- credit_memo(billing_address_id) → address(id)
- credit_memo(customer_id) → customer(id)
- credit_memo(department_id) → department(id)
- credit_memo(sales_term_id) → term(id)
- credit_memo(class_id) → class(id)
- credit_memo(payment_method_id) → payment_method(id)
- bill_payment_line(bill_payment_id) → bill_payment(id)
- bill_payment_line(bill_id) → bill(id)
- bill_payment_line(vendor_credit_id) → vendor_credit(id)
- bill_payment_line(journal_entry_id) → journal_entry(id)
- bill_payment_line(deposit_id) → deposit(id)
- bill_payment_line(linked_bill_payment_id) → bill_payment(id)
- bill_payment_line(purchase_id) → purchase(id)
- vendor_credit(currency_id) → currency(id)
- vendor_credit(payable_account_id) → account(id)
- vendor_credit(vendor_id) → vendor(id)
- vendor_credit(department_id) → department(id)
- journal_entry_tax_line(journal_entry_id) → journal_entry(id)
- journal_entry_tax_line(tax_rate_id) → tax_rate(id)
- refund_receipt_line_bundle(item_id) → item(id)
- refund_receipt_line_bundle(class_id) → class(id)
- refund_receipt_line_bundle(account_id) → account(id)
- refund_receipt_line_bundle(tax_code_id) → tax_code(id)
- refund_receipt_line_bundle(refund_receipt_id) → refund_receipt(id)
- refund_receipt_line_bundle(refund_receipt_line_index) → refund_receipt_line(refund_id)
- purchase_order_line_linked_txn(purchase_order_id) → purchase_order(id)
- purchase_order_line_linked_txn(purchase_order_line_index) → purchase_order_line(index)
- deposit_line(deposit_id) → deposit(id)
- deposit_line(deposit_tax_code_id) → tax_code(id)
- deposit_line(deposit_class_id) → class(id)
- deposit_line(deposit_payment_method_id) → payment_method(id)
- deposit_line(deposit_account_id) → account(id)
- deposit_line(deposit_customer_id) → customer(id)
- deposit_line(transfer_id) → transfer(id)
- deposit_line(payment_id) → payment(id)
- deposit_line(sales_receipt_id) → sales_receipt(id)
- deposit_line(refund_receipt_id) → refund_receipt(id)
- deposit_line(journal_entry_id) → journal_entry(id)
- deposit_line(purchase_id) → purchase(id)
- deposit_line(invoice_id) → invoice(id)
- deposit_line(vendor_credit_id) → vendor_credit(id)
- deposit_line(bill_id) → bill(id)
- refund_receipt_tax_line(refund_receipt_id) → refund_receipt(id)
- refund_receipt_tax_line(tax_rate_id) → tax_rate(id)
- budget_detail(budget_id) → budget(id)
- budget_detail(account_id) → account(id)
- budget_detail(customer_id) → customer(id)
- budget_detail(class_id) → class(id)
- budget_detail(department_id) → department(id)
- sales_receipt_line_bundle(item_id) → item(id)
- sales_receipt_line_bundle(class_id) → class(id)
- sales_receipt_line_bundle(account_id) → account(id)
- sales_receipt_line_bundle(tax_code_id) → tax_code(id)
- sales_receipt_line_bundle(sales_receipt_id) → sales_receipt(id)
- sales_receipt_line_bundle(sales_receipt_line_index) → sales_receipt_line(sales_receipt_id)
- bill(currency_id) → currency(id)
- bill(payable_account_id) → account(id)
- bill(sales_term_id) → term(id)
- bill(vendor_id) → vendor(id)
- bill(department_id) → department(id)
- credit_card_payment_txn(currency_id) → currency(id)
- credit_card_payment_txn(bank_account_id) → account(id)
- credit_card_payment_txn(credit_card_account_id) → account(id)
- vendor_credit_line(vendor_credit_id) → vendor_credit(id)
- vendor_credit_line(item_expense_tax_code_id) → tax_code(id)
- vendor_credit_line(item_expense_item_id) → item(id)
- vendor_credit_line(item_expense_class_id) → class(id)
- vendor_credit_line(item_expense_customer_id) → customer(id)
- vendor_credit_line(account_expense_class_id) → class(id)
- vendor_credit_line(account_expense_tax_code_id) → tax_code(id)
- vendor_credit_line(account_expense_account_id) → account(id)
- vendor_credit_line(account_expense_customer_id) → customer(id)
- account(currency_id) → currency(id)
- account(parent_account_id) → account(id)
- account(tax_code_id) → tax_code(id)
- class(parent_class_id) → class(id)
- bundle_item(bundle_id) → bundle(id)
- bundle_item(item_id) → item(id)