Campfire

Explore the interactive ERD

Table & Field Reference

contract_product_tag

Column	Type	Keys
`id`	Unknown	PK
`contract_product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`vendor_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`journal_entry`	Unknown	FK

contract_attachment

Column	Type	Keys
`id`	Unknown	PK
`contract_id`	Unknown	PKFK
`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	PKFK
`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	PKFK

intercompany_journal_transaction_tag

Column	Type	Keys
`id`	Unknown	PK
`intercompany_journal_transaction_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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