# Campfire schema ERD

Table and field reference for the Fivetran Campfire connector.

## Table & Field Reference

### contract_product_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_product_id | Unknown | PK, FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| parent_name | Unknown |  |

### contract_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department | Unknown | FK |
| revenue_account | Unknown | FK |
| anrok_item_id | Unknown |  |
| apply_dept_tag_to_invoice_journals | Unknown |  |
| ar_account | Unknown |  |
| ar_account_name | Unknown |  |
| avalara_item_data | Unknown |  |
| avalara_item_id | Unknown |  |
| avalara_tax_code | Unknown |  |
| cost | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| exclude_from_mrr | Unknown |  |
| invoice_account | Unknown |  |
| invoice_account_name | Unknown |  |
| invoice_unbilled_account | Unknown |  |
| invoice_unbilled_account_name | Unknown |  |
| is_deleted | Unknown |  |
| is_taxable | Unknown |  |
| last_modified_at | Instant |  |
| price | Unknown |  |
| product_description | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| revenue_account_name | Unknown |  |
| stripe_product_id | Unknown |  |
| tax_account_name | Unknown |  |

### vendor_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| last_name | Unknown |  |
| mobile_number | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |

### balance_sheet

| Column | Type | Keys |
| --- | --- | --- |
| start_date | Unknown | PK |
| account_id | Unknown | PK, FK |
| parent | Unknown | FK |
| end_date | Unknown |  |
| has_children_balances | Unknown |  |
| hierarchy | Json |  |

### revenue_transaction_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| revenue_transaction_id | Unknown | PK, FK |
| customer | Unknown | FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### revenue_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client | Unknown | FK |
| contract | Unknown | FK |
| contract_subscription | Unknown | FK |
| department | Unknown | FK |
| journal_entry | Unknown | FK |
| product | Unknown | FK |
| accounting_period | Unknown |  |
| amount | Unknown |  |
| anrok_item_id | Unknown |  |
| balance_adjustment | Unknown |  |
| contract_bundle | Unknown |  |
| contract_external_id | Unknown |  |
| contract_milestone | Unknown |  |
| contract_subscription_external_id | Unknown |  |
| contract_usage | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| discount | Unknown |  |
| entity | Unknown |  |
| entity_currency | Unknown |  |
| exchange_rate | Unknown |  |
| exchange_rate_book | Unknown |  |
| external_id | Unknown |  |
| gross_amount | Unknown |  |
| invoice | Unknown |  |
| invoice_date | LocalDate |  |
| invoice_number | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| mrr | Unknown |  |
| non_contract_subscription | Unknown |  |
| non_contract_usage | Unknown |  |
| platform_fees | Unknown |  |
| processing_fees | Unknown |  |
| product_external_id | Unknown |  |
| quantity | Unknown |  |
| rate | Unknown |  |
| recognized | Unknown |  |
| refunds | Unknown |  |
| renewall | Unknown |  |
| revenue_type | Unknown |  |
| source | Unknown |  |
| tax | Unknown |  |
| transaction_date | LocalDate |  |
| transaction_end_date | LocalDate |  |
| transfers | Unknown |  |
| usage_tier | Unknown |  |
| usage_tier_name | Unknown |  |

### journal_entry_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| account | Unknown | FK |
| department | Unknown | FK |
| parent_department | Unknown | FK |
| transaction_id | Unknown | FK |
| vendor | Unknown | FK |
| amount | Unknown |  |
| balance_after_transaction | Unknown |  |
| balance_before_transaction | Unknown |  |
| credit_amount | Unknown |  |
| date_month | Unknown |  |
| date_year | Unknown |  |
| debit_amount | Unknown |  |
| entity | Unknown |  |
| entity_currency | Unknown |  |
| entity_name | Unknown |  |
| journal_memo | Unknown |  |
| journal_order | Unknown |  |
| journal_type | Unknown |  |

### journal_entry_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| app | Unknown |  |
| created_at | Instant |  |
| created_by | Unknown |  |
| created_by_email | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| model | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| s_3_content_length | Unknown |  |
| s_3_content_type | Unknown |  |
| s_3_path | Unknown |  |
| url | Unknown |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| created_automatically | Unknown |  |
| currency | Unknown |  |
| date | LocalDate |  |
| deleted_at | Instant |  |
| entity | Unknown |  |
| intercompany_journal | Unknown |  |
| invoice | Unknown |  |
| is_deleted | Unknown |  |
| journal_id | Unknown |  |
| last_modified_at | Instant |  |
| memo | Unknown |  |
| order_id | Unknown |  |
| ref_number | Unknown |  |
| reversal_of | Unknown |  |
| source | Unknown |  |
| type | Unknown |  |

### cost_allocation_line_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cost_allocation_line_id | Unknown | PK, FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### cost_allocation_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cost_allocation_id | Unknown | PK, FK |
| account | Unknown | FK |
| department | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| percentage | Unknown |  |

### cost_allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |

### chart_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent | Unknown | FK |
| account_cashflow_classification | Unknown |  |
| account_id | Unknown |  |
| account_subtype | Unknown |  |
| account_type | Unknown |  |
| balance_ytd | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| description | Unknown |  |
| include_in_eliminations | Unknown |  |
| include_in_revaluations | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| last_recompute_balance_at | Instant |  |
| lineage | Json |  |
| lock_recompute_balance_key | Unknown |  |
| name | Unknown |  |
| name_and_number | Unknown |  |
| nickname | Unknown |  |
| number | Unknown |  |
| parent_bank_account | Unknown |  |
| protected | Unknown |  |
| reconciliation_ending_balance | Unknown |  |
| reconciliation_ending_date | LocalDate |  |
| skip_subledger_validation | Unknown |  |
| sort_key | Unknown |  |
| status | Unknown |  |

### vendor_associated_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vendor_id | Unknown | PK, FK |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent | Unknown | FK |
| abbreviation | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| anrok_customer_id | Unknown |  |
| bill_vendor_id | Unknown |  |
| billing_address_street_1 | Unknown |  |
| billing_address_street_2 | Unknown |  |
| billing_addressee | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_state | Unknown |  |
| billing_zip_code | Unknown |  |
| business_id_ssn | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Instant |  |
| custom_field_1 | Unknown |  |
| custom_field_1_name | Unknown |  |
| custom_field_account_manager | Unknown |  |
| customer | Unknown |  |
| dba | Unknown |  |
| default_expense_category | Unknown |  |
| deleted_at | Instant |  |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| invoice_message | Unknown |  |
| is_1099 | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| last_name | Unknown |  |
| lineage_array | Json |  |
| mobile_number | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| payment_term | Unknown |  |
| payment_term_name_display | Unknown |  |
| phone_number | Unknown |  |
| search_text | Unknown |  |
| search_vector | Unknown |  |
| shipping_addressee | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| stripe_connection | Unknown |  |
| stripe_connection_entity | Unknown |  |
| stripe_connection_name | Unknown |  |
| stripe_connection_portal_enabled | Unknown |  |
| stripe_connection_portal_url | Unknown |  |
| stripe_customer_id | Unknown |  |
| terms | Unknown |  |
| type | Unknown |  |
| use_stripe_auto_bill | Unknown |  |
| vat_number | Unknown |  |
| website | Unknown |  |
| zip_code | Unknown |  |

### department_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_id | Unknown | PK, FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent | Unknown | FK |
| active | Unknown |  |
| code | Unknown |  |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### income_statement

| Column | Type | Keys |
| --- | --- | --- |
| start_date | Unknown | PK |
| account_id | Unknown | PK, FK |
| parent | Unknown | FK |
| amount | Unknown |  |
| end_date | Unknown |  |
| has_children_balances | Unknown |  |
| hierarchy | Json |  |

### trial_balance

| Column | Type | Keys |
| --- | --- | --- |
| start_date | Unknown | PK |
| id | Unknown | PK, FK |
| parent | Unknown | FK |
| credit | Unknown |  |
| debit | Unknown |  |
| department | Json |  |
| end_date | Unknown |  |
| entities | Json |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app | Unknown |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| display_order | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| is_required | Unknown |  |
| label | Unknown |  |
| last_modified_at | Instant |  |
| model | Unknown |  |
| name | Unknown |  |
| options | Json |  |
| type | Unknown |  |
| updated_at | Instant |  |

### cash_flow

| Column | Type | Keys |
| --- | --- | --- |
| start_date | Unknown | PK |
| account_id | Unknown | PK, FK |
| parent | Unknown | FK |
| end_date | Unknown |  |
| hierarchy | Json |  |
| starting_balance | Unknown |  |
| ending_balances_** |  |  |
| transaction_activity_** |  |  |

### contract_journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| journal_entry | Unknown | FK |

### contract_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | PK, FK |
| customer | Unknown | FK |
| app | Unknown |  |
| created_at | Instant |  |
| created_by | Unknown |  |
| created_by_email | Unknown |  |
| created_by_name | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| model | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| s_3_content_length | Unknown |  |
| s_3_content_type | Unknown |  |
| s_3_path | Unknown |  |
| url | Unknown |  |

### contract_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | PK, FK |
| customer | Unknown | FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| parent_name | Unknown |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| department | Unknown | FK |
| parent_department | Unknown | FK |
| auto_renew | Unknown |  |
| auto_renew_duration | Unknown |  |
| auto_renew_invoice | Unknown |  |
| billing_frequency | Unknown |  |
| client | Unknown |  |
| client_name | Unknown |  |
| client_terms | Unknown |  |
| closed_date | LocalDate |  |
| consultant | Unknown |  |
| contract_end_date | LocalDate |  |
| contract_link | Unknown |  |
| contract_start_date | LocalDate |  |
| created_at | Instant |  |
| crm_link | Unknown |  |
| currency | Unknown |  |
| deal_id | Unknown |  |
| deal_name | Unknown |  |
| deleted_at | Instant |  |
| entity | Unknown |  |
| entity_name | Unknown |  |
| exchange_rate | Unknown |  |
| exchange_rate_book | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| search_text | Unknown |  |
| search_vector | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| total_billed | Unknown |  |
| total_contract_value | Unknown |  |
| total_deferred_revenue | Unknown |  |
| total_outstanding | Unknown |  |
| total_paid | Unknown |  |
| total_unbilled | Unknown |  |
| usage_tiers | Unknown |  |

### intercompany_journal_reversal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| intercompany_journal_id | Unknown | PK, FK |

### intercompany_journal_transaction_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| intercompany_journal_transaction_id | Unknown | PK, FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### intercompany_journal_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| intercompany_journal_id | Unknown | PK, FK |
| account | Unknown | FK |
| department | Unknown | FK |
| parent_department | Unknown | FK |
| transaction_id | Unknown | FK |
| vendor | Unknown | FK |
| amount | Unknown |  |
| balance_after_transaction | Unknown |  |
| balance_before_transaction | Unknown |  |
| bank_account | Unknown |  |
| bank_description | Unknown |  |
| created_at | Instant |  |
| credit_amount | Unknown |  |
| date_month | Unknown |  |
| date_year | Unknown |  |
| debit_amount | Unknown |  |
| deleted_at | Instant |  |
| entity | Unknown |  |
| intercompany_journal | Unknown |  |
| is_deleted | Unknown |  |
| journal | Unknown |  |
| journal_memo | Unknown |  |
| journal_order | Unknown |  |
| journal_type | Unknown |  |
| last_modified_at | Instant |  |
| posted_at | Instant |  |

### intercompany_journal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| created_automatically | Unknown |  |
| currency | Unknown |  |
| customer | Unknown |  |
| date | LocalDate |  |
| deleted_at | Instant |  |
| entity_currency | Unknown |  |
| entity_name | Unknown |  |
| is_deleted | Unknown |  |
| journal_id | Unknown |  |
| last_modified_at | Instant |  |
| memo | Unknown |  |
| order_id | Unknown |  |
| ref_number | Unknown |  |
| reversal_of | Unknown |  |
| reversal_of_order | Unknown |  |
| type | Unknown |  |

### contract_customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_customer_id | Unknown | PK, FK |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |

### contract_customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| parent | Unknown | FK |
| abbreviation | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| anrok_customer_id | Unknown |  |
| bill_vendor_id | Unknown |  |
| billing_address_street_1 | Unknown |  |
| billing_address_street_2 | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_state | Unknown |  |
| billing_zip_code | Unknown |  |
| business_id_ssn | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Instant |  |
| default_expense_category | Unknown |  |
| deleted_at | Instant |  |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| invoice_message | Unknown |  |
| is_1099 | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| last_name | Unknown |  |
| lineage_array | Json |  |
| mobile_number | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| payment_term | Unknown |  |
| payment_term_name_display | Unknown |  |
| phone_number | Unknown |  |
| source | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| stripe_connection | Unknown |  |
| stripe_connection_entity | Unknown |  |
| stripe_connection_name | Unknown |  |
| stripe_connection_portal_enabled | Unknown |  |
| stripe_connection_portal_url | Unknown |  |
| stripe_customer_id | Unknown |  |
| terms | Unknown |  |
| use_stripe_auto_bill | Unknown |  |
| vat_number | Unknown |  |
| vendor_custom_field | Unknown |  |
| vendor_custom_field_name | Unknown |  |
| vendor_type | Unknown |  |
| website | Unknown |  |
| zip_code | Unknown |  |

### contract_subscription_contract_product_bundle_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_subscription_id | Unknown | PK, FK |
| amount | Unknown |  |
| original_percentage | Unknown |  |
| percentage | Unknown |  |
| product | Unknown |  |
| product_name | Unknown |  |

### contract_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract | Unknown | FK |
| customer | Unknown | FK |
| product | Unknown | FK |
| catchup_date | LocalDate |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| end_date | LocalDate |  |
| is_contract_amendment | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| lines | Unknown |  |
| modified_subscription | Unknown |  |
| mrr | Unknown |  |
| notes | Unknown |  |
| product_bundle | Unknown |  |
| product_bundle_currency | Unknown |  |
| product_bundle_id | Unknown |  |
| product_bundle_name | Unknown |  |
| product_bundle_source_bundle | Unknown |  |
| product_bundle_source_bundle_name | Unknown |  |
| quantity | Unknown |  |
| rate | Unknown |  |
| start_date | LocalDate |  |
| total_value | Unknown |  |
| use_catchup | Unknown |  |
| use_daily_accounting | Unknown |  |

### chart_transaction_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chart_transaction_id | Unknown | PK, FK |
| parent | Unknown | FK |
| created_at | Instant |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| group_name | Unknown |  |
| groups | Unknown |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |

### chart_transaction_journal_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chart_transaction_id | Unknown | PK, FK |
| app | Unknown |  |
| created_at | Instant |  |
| created_by | Unknown |  |
| created_by_email | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| deleted_at | Instant |  |
| is_deleted | Unknown |  |
| last_modified_at | Instant |  |
| model | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| s_3_content_length | Unknown |  |
| s_3_content_type | Unknown |  |
| s_3_path | Unknown |  |
| url | Unknown |  |

### chart_transaction_amortization_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chart_transaction_id | Unknown | PK, FK |
| amortization | Unknown |  |
| amount | Unknown |  |
| bill_line | Unknown |  |
| customer | Unknown |  |
| date | LocalDate |  |
| journal_entry | Unknown |  |
| journal_entry_order | Unknown |  |
| posted | Unknown |  |
| transaction | Unknown |  |

### chart_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown | FK |
| department | Unknown | FK |
| parent_department | Unknown | FK |
| vendor | Unknown | FK |
| amount | Unknown |  |
| balance_after_transaction | Unknown |  |
| balance_before_transaction | Unknown |  |
| bank_account | Unknown |  |
| bill | Unknown |  |
| created_at | Instant |  |
| credit_amount | Unknown |  |
| date_month | Unknown |  |
| date_year | Unknown |  |
| debit_amount | Unknown |  |
| entity_currency | Unknown |  |
| entity_name | Unknown |  |
| invoice | Unknown |  |
| journal | Unknown |  |
| journal_memo | Unknown |  |
| journal_order | Unknown |  |
| journal_type | Unknown |  |
| last_modified_at | Instant |  |
| transaction_id | Unknown |  |

## Relationships

- contract_product_tag(parent) → contract_product_tag(id)
- contract_product_tag(contract_product_id) → contract_product(id)
- contract_product(department) → department(id)
- contract_product(revenue_account) → chart_account(id)
- balance_sheet(account_id) → chart_account(id)
- balance_sheet(parent) → balance_sheet(account_id)
- revenue_transaction_tag(customer) → contract_customer(id)
- revenue_transaction_tag(revenue_transaction_id) → revenue_transaction(id)
- revenue_transaction(department) → department(id)
- revenue_transaction(product) → contract_product(id)
- revenue_transaction(contract_subscription) → contract_subscription(id)
- revenue_transaction(contract) → contract(id)
- revenue_transaction(journal_entry) → journal_entry(id)
- revenue_transaction(client) → vendor(id)
- journal_entry_transaction(department) → department(id)
- journal_entry_transaction(vendor) → vendor(id)
- journal_entry_transaction(account) → chart_account(id)
- journal_entry_transaction(parent_department) → department(id)
- journal_entry_transaction(transaction_id) → revenue_transaction(id)
- journal_entry_transaction(journal_entry_id) → journal_entry(id)
- journal_entry_attachment(journal_entry_id) → journal_entry(id)
- cost_allocation_line_tag(parent) → cost_allocation_line_tag(id)
- cost_allocation_line_tag(cost_allocation_line_id) → cost_allocation_line(id)
- cost_allocation_line(department) → department(id)
- cost_allocation_line(account) → chart_account(id)
- cost_allocation_line(cost_allocation_id) → cost_allocation(id)
- cost_allocation(account) → chart_account(id)
- chart_account(parent) → chart_account(id)
- vendor_associated_contact(id) → vendor_contact(id)
- vendor_associated_contact(vendor_id) → vendor(id)
- vendor(parent) → vendor(id)
- department_tag(parent) → department_tag(id)
- department_tag(department_id) → department(id)
- department(parent) → department(id)
- income_statement(account_id) → chart_account(id)
- income_statement(parent) → income_statement(account_id)
- trial_balance(id) → chart_account(id)
- trial_balance(parent) → trial_balance(id)
- cash_flow(account_id) → chart_account(id)
- cash_flow(parent) → cash_flow(account_id)
- contract_journal_entry(journal_entry) → journal_entry(id)
- contract_journal_entry(contract_id) → contract(id)
- contract_attachment(customer) → contract_customer(id)
- contract_attachment(contract_id) → contract(id)
- contract_tag(parent) → contract_tag(id)
- contract_tag(customer) → contract_customer(id)
- contract_tag(contract_id) → contract(id)
- contract(department) → department(id)
- contract(parent_department) → department(id)
- contract(customer) → contract_customer(id)
- intercompany_journal_reversal(intercompany_journal_id) → intercompany_journal(id)
- intercompany_journal_transaction_tag(parent) → intercompany_journal_transaction_tag(id)
- intercompany_journal_transaction_tag(intercompany_journal_transaction_id) → intercompany_journal_transaction(id)
- intercompany_journal_transaction(department) → department(id)
- intercompany_journal_transaction(account) → chart_account(id)
- intercompany_journal_transaction(parent_department) → department(id)
- intercompany_journal_transaction(transaction_id) → revenue_transaction(id)
- intercompany_journal_transaction(intercompany_journal_id) → intercompany_journal(id)
- intercompany_journal_transaction(vendor) → vendor(id)
- contract_customer_contact(contract_customer_id) → contract_customer(id)
- contract_customer(parent) → contract_customer(id)
- contract_customer(customer) → contract_customer(id)
- contract_subscription_contract_product_bundle_line(contract_subscription_id) → contract_subscription(id)
- contract_subscription(product) → contract_product(id)
- contract_subscription(contract) → contract(id)
- contract_subscription(customer) → contract_customer(id)
- chart_transaction_tag(parent) → chart_transaction_tag(id)
- chart_transaction_tag(chart_transaction_id) → chart_transaction(id)
- chart_transaction_journal_attachment(chart_transaction_id) → chart_transaction(id)
- chart_transaction_amortization_schedule(chart_transaction_id) → chart_transaction(id)
- chart_transaction(department) → department(id)
- chart_transaction(vendor) → vendor(id)
- chart_transaction(account) → chart_account(id)
- chart_transaction(parent_department) → department(id)