# Maxio SaaSOptics schema ERD

Table and field reference for the Fivetran Maxio SaaSOptics connector.

## Table & Field Reference

### register

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| chargify_register | Unknown |  |
| committed_invoice_number_prefix | Unknown |  |
| currency_code | Unknown |  |
| default_qb_ar_account | Unknown |  |
| do_not_sync | Unknown |  |
| do_not_sync_associated_customers | Unknown |  |
| generated_invoice_number_prefix | Unknown |  |
| modified | LocalDateTime |  |
| name | Unknown |  |
| custom_** |  |  |

### payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| intacct_id | Unknown |  |
| intacct_modified | Unknown |  |
| intacct_record_no | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| netsuite_id | Unknown |  |
| num_days | Unknown |  |
| num_months | Unknown |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_profile_payment_term_id | Unknown | FK |
| customer_id | Unknown | FK |
| register_id | Unknown | FK |
| billing_profile_account_number | Unknown |  |
| billing_profile_address_1 | Unknown |  |
| billing_profile_address_2 | Unknown |  |
| billing_profile_address_3 | Unknown |  |
| billing_profile_alt_contact | Unknown |  |
| billing_profile_alt_phone | Unknown |  |
| billing_profile_city | Unknown |  |
| billing_profile_company_name | Unknown |  |
| billing_profile_contact | Unknown |  |
| billing_profile_country | Unknown |  |
| billing_profile_currency | Unknown |  |
| billing_profile_customer_type_ref_fullname | Unknown |  |
| billing_profile_default_credit_memo_template | Unknown |  |
| billing_profile_default_invoice_template | Unknown |  |
| billing_profile_edit_sequence | Unknown |  |
| billing_profile_email | Unknown |  |
| billing_profile_entity_use_code | Unknown |  |
| billing_profile_fax | Unknown |  |
| billing_profile_first_name | Unknown |  |
| billing_profile_full_name | Unknown |  |
| billing_profile_invoice_email_preference | Unknown |  |
| billing_profile_invoice_print_preference | Unknown |  |
| billing_profile_is_active | Unknown |  |
| billing_profile_job_description | Unknown |  |
| billing_profile_job_end_date | Unknown |  |
| billing_profile_job_projected_end_date | Unknown |  |
| billing_profile_job_start_date | Unknown |  |
| billing_profile_job_status | Unknown |  |
| billing_profile_job_type | Unknown |  |
| billing_profile_last_name | Unknown |  |
| billing_profile_name | Unknown |  |
| billing_profile_parent_id | Unknown |  |
| billing_profile_phone | Unknown |  |
| billing_profile_resale_number | Unknown |  |
| billing_profile_sales_rep | Unknown |  |
| billing_profile_salutation | Unknown |  |
| billing_profile_shipping_address_1 | Unknown |  |
| billing_profile_shipping_address_2 | Unknown |  |
| billing_profile_shipping_address_3 | Unknown |  |
| billing_profile_shipping_city | Unknown |  |
| billing_profile_shipping_country | Unknown |  |
| billing_profile_shipping_state | Unknown |  |
| billing_profile_shipping_zip_code | Unknown |  |
| billing_profile_state | Unknown |  |
| billing_profile_zip_code | Unknown |  |
| channel | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| email | Unknown |  |
| entry_date | Unknown |  |
| is_job | Unknown |  |
| lead_date | Unknown |  |
| lead_source | Unknown |  |
| modified | LocalDateTime |  |
| modified_by | Unknown |  |
| modified_by_name | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| number_field_1 | Unknown |  |
| number_field_2 | Unknown |  |
| qb_job_id | Unknown |  |
| sf_id | Unknown |  |
| text_field_1 | Unknown |  |
| text_field_2 | Unknown |  |
| unbalanced_revenue_exception | Unknown |  |

### transaction_renewal_of_set

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| renewal_of_set | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| autorenewal_profile_id | Unknown | FK |
| billing_method_id | Unknown | FK |
| contract_id | Unknown | FK |
| item_id | Unknown | FK |
| renew_using_item_id | Unknown | FK |
| renewal_billing_method_id | Unknown | FK |
| advanced_billing_subscription_id | Unknown |  |
| advanced_billing_subscription_line_id | Unknown |  |
| always_use_amount_as_normalized_amount | Unknown |  |
| auditentry_created | Unknown |  |
| auditentry_created_by | Unknown |  |
| auditentry_created_by_name | Unknown |  |
| auditentry_modified | LocalDateTime |  |
| auditentry_modified_by | Unknown |  |
| auditentry_modified_by_name | Unknown |  |
| automatically_update_revenue | Unknown |  |
| c_primary_persona | Unknown |  |
| c_proactive | Unknown |  |
| c_renewal_opportunities | Unknown |  |
| cancelled | Unknown |  |
| conversion | Unknown |  |
| crm_opportunity_id | Unknown |  |
| crm_opportunity_line_item_id | Unknown |  |
| different_invoice_item_permitted | Unknown |  |
| duration | Unknown |  |
| end_date | Unknown |  |
| flagged | Unknown |  |
| foreign_exchange_rate | Unknown |  |
| home_amount | Unknown |  |
| home_arr_amount | Unknown |  |
| home_normalized_amount | Unknown |  |
| home_normalized_rate | Unknown |  |
| home_rate | Unknown |  |
| hubspot_renewal_deal_rule | Unknown |  |
| ili_qb_class | Unknown |  |
| invoice_description | Unknown |  |
| is_autorenewal | Unknown |  |
| item_class | Unknown |  |
| local_amount | Unknown |  |
| local_arr_amount | Unknown |  |
| local_normalized_amount | Unknown |  |
| local_normalized_rate | Unknown |  |
| local_rate | Unknown |  |
| modified | LocalDateTime |  |
| notes | Unknown |  |
| number | Unknown |  |
| number_field_1 | Unknown |  |
| number_field_2 | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| project | Unknown |  |
| quantity | Unknown |  |
| recognize | Unknown |  |
| reconcile_required | Unknown |  |
| renewal_amount | Unknown |  |
| renewal_amount_percentage | Unknown |  |
| renewal_amount_value | Unknown |  |
| renewal_duration | Unknown |  |
| renewal_factor | Unknown |  |
| renewal_probability | Unknown |  |
| renewal_quantity | Unknown |  |
| revenue_amount | Unknown |  |
| revenue_notes | Unknown |  |
| sales_manager | Unknown |  |
| sales_rep | Unknown |  |
| sf_group_id | Unknown |  |
| sf_id | Unknown |  |
| sf_opportunity_id | Unknown |  |
| sf_opportunity_line_item_id | Unknown |  |
| sf_renewal_opportunity_id | Unknown |  |
| sf_renewal_opportunity_line_item_id | Unknown |  |
| sf_renewal_opportunity_rule | Unknown |  |
| start_date | Unknown |  |
| term_number | Unknown |  |
| text_field_1 | Unknown |  |
| text_field_2 | Unknown |  |
| unbalanced_revenue_exception | Unknown |  |

### billing_description

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| transaction_id | Unknown | FK |
| created | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| deleted_in_qb | Unknown |  |
| exported_date | Unknown |  |
| external_id | Unknown |  |
| home_amount | Unknown |  |
| local_amount | Unknown |  |
| modified | Unknown |  |
| modified_by | Unknown |  |
| modified_by_name | Unknown |  |
| no_transaction_permitted | Unknown |  |
| notes | Unknown |  |
| qb_class | Unknown |  |
| qb_time_modified | Unknown |  |
| qb_txn_line_id | Unknown |  |
| quantity | Unknown |  |
| recurly_id | Unknown |  |
| refund_of | Unknown |  |
| refund_of_stripe_id | Unknown |  |
| sf_id | Unknown |  |
| stripe_id | Unknown |  |
| sync_date | Unknown |  |

### invoice_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| description | Unknown |  |
| local_amount | Unknown |  |
| rate | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | FK |
| applied_amount | Unknown |  |
| auditentry_created | Unknown |  |
| auditentry_created_by | Unknown |  |
| auditentry_created_by_name | Unknown |  |
| auditentry_modified | LocalDateTime |  |
| auditentry_modified_by | Unknown |  |
| auditentry_modified_by_name | Unknown |  |
| auditentry_qb_created | Unknown |  |
| auditentry_qb_modified | Unknown |  |
| avatax_commit_timestamp | Unknown |  |
| avatax_id | Unknown |  |
| avatax_modify_timestamp | Unknown |  |
| avatax_reconciliation_status | Unknown |  |
| avatax_status | Unknown |  |
| balance | Unknown |  |
| billing_address_1 | Unknown |  |
| billing_address_2 | Unknown |  |
| billing_address_3 | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_state | Unknown |  |
| billing_zip_code | Unknown |  |
| committed | Unknown |  |
| committed_timestamp | Unknown |  |
| date | LocalDate |  |
| deleted_in_qb | Unknown |  |
| do_not_sync | Unknown |  |
| due_date | Unknown |  |
| ei_theme | Unknown |  |
| einvoicing_url | Unknown |  |
| einvoicing_url_no_click_tracking | Unknown |  |
| email_from_so | Unknown |  |
| enable_ach_payment | Unknown |  |
| enable_cc_payment | Unknown |  |
| exported_date | Unknown |  |
| external_id | Unknown |  |
| foreign_exchange_rate | Unknown |  |
| home_amount | Unknown |  |
| ignore_date_when_syncing | Unknown |  |
| is_paid | Unknown |  |
| last_clicked | Unknown |  |
| last_emailed | Unknown |  |
| last_opened | Unknown |  |
| local_amount | Unknown |  |
| memo | Unknown |  |
| number | Unknown |  |
| other | Unknown |  |
| po_number | Unknown |  |
| qb_ar_account | Unknown |  |
| qb_class | Unknown |  |
| qb_currency | Unknown |  |
| qb_customer_message | Unknown |  |
| qb_number | Unknown |  |
| qb_payment_terms | Unknown |  |
| qb_sales_rep | Unknown |  |
| qb_template | Unknown |  |
| qb_txn_id | Unknown |  |
| recurly_id | Unknown |  |
| refund_of | Unknown |  |
| sales_tax | Unknown |  |
| sales_tax_percentage | Unknown |  |
| sf_id | Unknown |  |
| ship_date | Unknown |  |
| shipping_address_1 | Unknown |  |
| shipping_address_2 | Unknown |  |
| shipping_address_3 | Unknown |  |
| shipping_city | Unknown |  |
| shipping_country | Unknown |  |
| shipping_state | Unknown |  |
| shipping_zip_code | Unknown |  |
| stripe_id | Unknown |  |
| stripe_refund_id | Unknown |  |
| subtotal | Unknown |  |
| sync_date | Unknown |  |
| to_be_emailed | Unknown |  |
| to_be_printed | Unknown |  |
| type | Unknown |  |

### currency_code

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| name | Unknown |  |

### revenue_recognition_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### billing_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_account_id | Unknown | FK |
| billing_method_id | Unknown | FK |
| income_account_id | Unknown | FK |
| liability_account_id | Unknown | FK |
| revenue_recognition_method_id | Unknown | FK |
| avatax_id | Unknown |  |
| avatax_sales_tax_code | Unknown |  |
| billing_description | Unknown |  |
| chargify_component_kind | Unknown |  |
| chargify_family_id | Unknown |  |
| chargify_id | Unknown |  |
| chargify_modified | Unknown |  |
| code | Unknown |  |
| commodity_code | Unknown |  |
| create_revenue | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| default_duration | Unknown |  |
| description | Unknown |  |
| do_not_sync | Unknown |  |
| edit_sequence | Unknown |  |
| enable_create_transaction | Unknown |  |
| enforce_start_date_after_end_date | Unknown |  |
| gl_created | Unknown |  |
| gl_description | Unknown |  |
| gl_is_active | Unknown |  |
| gl_modified | Unknown |  |
| gl_name | Unknown |  |
| gl_tax_rate | Unknown |  |
| intacct_id | Unknown |  |
| intacct_modified | Unknown |  |
| intacct_record_no | Unknown |  |
| is_active | Unknown |  |
| is_discount | Unknown |  |
| is_sales_tax | Unknown |  |
| is_taxable | Unknown |  |
| long_term_liability_account | Unknown |  |
| modified | LocalDateTime |  |
| modified_by | Unknown |  |
| modified_by_name | Unknown |  |
| name | Unknown |  |
| needs_so_profile | Unknown |  |
| netsuite_id | Unknown |  |
| netsuite_modified | Unknown |  |
| normalized_term | Unknown |  |
| product_family | Unknown |  |
| qb_account | Unknown |  |
| qb_id | Unknown |  |
| qb_only | Unknown |  |
| qb_sales_tax_code | Unknown |  |
| recurly_id | Unknown |  |
| recurring | Unknown |  |
| renew_all_open_transactions | Unknown |  |
| renew_using_same_item | Unknown |  |
| sf_do_not_sync | Unknown |  |
| source_system | Unknown |  |
| stripe_id | Unknown |  |
| sync_invoice | Unknown |  |
| transaction_end_date | Unknown |  |
| transaction_start_date | Unknown |  |
| unit_name | Unknown |  |
| use_chargify_start_and_end_dates | Unknown |  |
| wizard_enabled | Unknown |  |
| xero_code | Unknown |  |
| xero_id | Unknown |  |
| xero_modified | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| gl_number | Unknown |  |
| intacct_id | Unknown |  |
| intacct_modified | Unknown |  |
| intacct_record_no | Unknown |  |
| name | Unknown |  |
| netsuite_id | Unknown |  |
| source_system | Unknown |  |

### sales_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| affected_transaction | Unknown |  |
| created | Unknown |  |
| created_by_username | Unknown |  |
| invoice_billing_address_1 | Unknown |  |
| invoice_billing_address_2 | Unknown |  |
| invoice_billing_address_3 | Unknown |  |
| invoice_billing_city | Unknown |  |
| invoice_billing_country | Unknown |  |
| invoice_billing_state | Unknown |  |
| invoice_billing_zip_code | Unknown |  |
| invoice_cadence_template | Unknown |  |
| invoice_date | Unknown |  |
| invoice_do_not_sync | Unknown |  |
| invoice_ei_combine_all_description | Unknown |  |
| invoice_ei_combine_lines | Unknown |  |
| invoice_ei_theme | Unknown |  |
| invoice_email_from_so | Unknown |  |
| invoice_enable_ach_payment | Unknown |  |
| invoice_enable_cc_payment | Unknown |  |
| invoice_ignore_date_when_syncing | Unknown |  |
| invoice_memo | Unknown |  |
| invoice_other | Unknown |  |
| invoice_payment_terms | Unknown |  |
| invoice_qb_class | Unknown |  |
| invoice_qb_customer_message | Unknown |  |
| invoice_qb_sales_rep | Unknown |  |
| invoice_qb_template | Unknown |  |
| invoice_ship_date | Unknown |  |
| invoice_shipping_address_1 | Unknown |  |
| invoice_shipping_address_2 | Unknown |  |
| invoice_shipping_address_3 | Unknown |  |
| invoice_shipping_city | Unknown |  |
| invoice_shipping_country | Unknown |  |
| invoice_shipping_state | Unknown |  |
| invoice_shipping_zip_code | Unknown |  |
| invoice_suppress_zero_value_line_items | Unknown |  |
| invoice_to_be_emailed | Unknown |  |
| invoice_to_be_printed | Unknown |  |
| line_item_id | Unknown |  |
| processed | Unknown |  |
| renewed_transaction | Unknown |  |
| sfdc_object_type | Unknown |  |
| transaction_action | Unknown |  |
| transaction_amount | Unknown |  |
| transaction_amount_after_discount | Unknown |  |
| transaction_arr_amount | Unknown |  |
| transaction_billing_method | Unknown |  |
| transaction_c_primary_persona | Unknown |  |
| transaction_c_proactive | Unknown |  |
| transaction_c_renewal_opportunities | Unknown |  |
| transaction_conversion | Unknown |  |
| transaction_crm_opportunity_id | Unknown |  |
| transaction_crm_opportunity_line_item_id | Unknown |  |
| transaction_discount_amount | Unknown |  |
| transaction_duration | Unknown |  |
| transaction_effective_change_date | Unknown |  |
| transaction_effective_end_date | Unknown |  |
| transaction_end_date | Unknown |  |
| transaction_flagged | Unknown |  |
| transaction_foreign_exchange_rate | Unknown |  |
| transaction_generate_invoices | Unknown |  |
| transaction_generate_revenue | Unknown |  |
| transaction_ili_description | Unknown |  |
| transaction_ili_qb_class | Unknown |  |
| transaction_invoice_end_date | Unknown |  |
| transaction_invoice_quantity | Unknown |  |
| transaction_invoice_start_date | Unknown |  |
| transaction_item_class_name | Unknown |  |
| transaction_item_code | Unknown |  |
| transaction_item_name | Unknown |  |
| transaction_monthly_rate | Unknown |  |
| transaction_normalized_amount | Unknown |  |
| transaction_normalized_term | Unknown |  |
| transaction_notes | Unknown |  |
| transaction_number_field_1 | Unknown |  |
| transaction_number_field_2 | Unknown |  |
| transaction_order_date | Unknown |  |
| transaction_quantity | Unknown |  |
| transaction_recognize | Unknown |  |
| transaction_renew_using_item | Unknown |  |
| transaction_renewal_amount | Unknown |  |
| transaction_renewal_amount_percentage | Unknown |  |
| transaction_renewal_billing_method | Unknown |  |
| transaction_renewal_duration | Unknown |  |
| transaction_renewal_factor | Unknown |  |
| transaction_renewal_probability | Unknown |  |
| transaction_renewal_quantity | Unknown |  |
| transaction_revenue_amount | Unknown |  |
| transaction_revenue_end_date | Unknown |  |
| transaction_revenue_recognition_method | Unknown |  |
| transaction_revenue_start_date | Unknown |  |
| transaction_sales_manager | Unknown |  |
| transaction_sales_rep | Unknown |  |
| transaction_sf_group_id | Unknown |  |
| transaction_sf_id | Unknown |  |
| transaction_sf_renewal_opportunitiy_rule | Unknown |  |
| transaction_start_date | Unknown |  |
| transaction_text_field_1 | Unknown |  |
| transaction_text_field_2 | Unknown |  |
| transaction_unbalanced_revenue_exception | Unknown |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| close_date | Unknown |  |
| contract_channel | Unknown |  |
| contract_email | Unknown |  |
| contract_entry_date | Unknown |  |
| contract_is_job | Unknown |  |
| contract_lead_date | Unknown |  |
| contract_lead_source | Unknown |  |
| contract_notes | Unknown |  |
| contract_number | Unknown |  |
| contract_number_field_1 | Unknown |  |
| contract_number_field_2 | Unknown |  |
| contract_register_name | Unknown |  |
| contract_sf_id | Unknown |  |
| contract_text_field_1 | Unknown |  |
| contract_text_field_2 | Unknown |  |
| contract_unbalanced_revenue_exception | Unknown |  |
| created | Unknown |  |
| created_by_username | Unknown |  |
| customer_account_number | Unknown |  |
| customer_alt_contact | Unknown |  |
| customer_alt_phone | Unknown |  |
| customer_autopay_enrollment | Unknown |  |
| customer_billing_address_3 | Unknown |  |
| customer_billing_city | Unknown |  |
| customer_billing_country | Unknown |  |
| customer_billing_state | Unknown |  |
| customer_billing_street | Unknown |  |
| customer_billing_zip_code | Unknown |  |
| customer_c_concierge_hot_platform | Unknown |  |
| customer_c_concierge_inferno_platform | Unknown |  |
| customer_c_concierge_spicy_platform | Unknown |  |
| customer_c_concierge_user_license | Unknown |  |
| customer_c_crm | Unknown |  |
| customer_c_cs_owner | Unknown |  |
| customer_c_drop_down_field_1 | Unknown |  |
| customer_c_instant_booker_hot_user_licenses | Unknown |  |
| customer_c_instant_booker_spicy_user_licenses | Unknown |  |
| customer_c_non_renewable_customer | Unknown |  |
| customer_c_optout_clause | Unknown |  |
| customer_c_q_4_22_am_text_field | Unknown |  |
| customer_c_ultimate_parent_id | Unknown |  |
| customer_chargify_id | Unknown |  |
| customer_city | Unknown |  |
| customer_code | Unknown |  |
| customer_contact | Unknown |  |
| customer_country | Unknown |  |
| customer_crm_id | Unknown |  |
| customer_currency | Unknown |  |
| customer_default_autorenewal_profile | Unknown |  |
| customer_default_cadence_template | Unknown |  |
| customer_default_email_from_so | Unknown |  |
| customer_default_enable_ach_payment | Unknown |  |
| customer_default_enable_cc_payment | Unknown |  |
| customer_default_invoice_template | Unknown |  |
| customer_default_payment_method | Unknown |  |
| customer_default_theme | Unknown |  |
| customer_do_not_sync | Unknown |  |
| customer_email | Unknown |  |
| customer_entity_use_code | Unknown |  |
| customer_fax | Unknown |  |
| customer_first_name | Unknown |  |
| customer_gl_tax_rate | Unknown |  |
| customer_industry | Unknown |  |
| customer_invoice_email_preference | Unknown |  |
| customer_invoice_print_preference | Unknown |  |
| customer_item_sales_tax | Unknown |  |
| customer_last_name | Unknown |  |
| customer_market | Unknown |  |
| customer_name | Unknown |  |
| customer_notes | Unknown |  |
| customer_number | Unknown |  |
| customer_number_field_1 | Unknown |  |
| customer_number_field_2 | Unknown |  |
| customer_number_field_3 | Unknown |  |
| customer_parent | Unknown |  |
| customer_payment_term | Unknown |  |
| customer_phone | Unknown |  |
| customer_resale_number | Unknown |  |
| customer_sales_rep | Unknown |  |
| customer_sales_tax_code | Unknown |  |
| customer_salutation | Unknown |  |
| customer_segment | Unknown |  |
| customer_sf_default_renewal_opportunity_rule | Unknown |  |
| customer_sf_opportunity_price_book_id | Unknown |  |
| customer_sf_owner_id | Unknown |  |
| customer_sfdc_object_id | Unknown |  |
| customer_shipping_address_3 | Unknown |  |
| customer_shipping_city | Unknown |  |
| customer_shipping_country | Unknown |  |
| customer_shipping_state | Unknown |  |
| customer_shipping_street | Unknown |  |
| customer_shipping_zip_code | Unknown |  |
| customer_state | Unknown |  |
| customer_subsegment | Unknown |  |
| customer_text_field_1 | Unknown |  |
| customer_text_field_2 | Unknown |  |
| customer_text_field_3 | Unknown |  |
| customer_type | Unknown |  |
| customer_unbalanced_revenue_exception | Unknown |  |
| name | Unknown |  |
| order_notes | Unknown |  |
| order_total | Unknown |  |
| project_name | Unknown |  |
| project_template | Unknown |  |
| quickbooks_job_account_number | Unknown |  |
| quickbooks_job_address_1 | Unknown |  |
| quickbooks_job_address_2 | Unknown |  |
| quickbooks_job_address_3 | Unknown |  |
| quickbooks_job_alt_contact | Unknown |  |
| quickbooks_job_alt_phone | Unknown |  |
| quickbooks_job_city | Unknown |  |
| quickbooks_job_company_name | Unknown |  |
| quickbooks_job_contact | Unknown |  |
| quickbooks_job_country | Unknown |  |
| quickbooks_job_default_credit_memo_template | Unknown |  |
| quickbooks_job_default_invoice_template | Unknown |  |
| quickbooks_job_description | Unknown |  |
| quickbooks_job_email | Unknown |  |
| quickbooks_job_end_date | Unknown |  |
| quickbooks_job_fax | Unknown |  |
| quickbooks_job_first_name | Unknown |  |
| quickbooks_job_invoice_email_preference | Unknown |  |
| quickbooks_job_invoice_print_preference | Unknown |  |
| quickbooks_job_is_active | Unknown |  |
| quickbooks_job_last_name | Unknown |  |
| quickbooks_job_name | Unknown |  |
| quickbooks_job_payment_term | Unknown |  |
| quickbooks_job_payment_terms | Unknown |  |
| quickbooks_job_phone | Unknown |  |
| quickbooks_job_projected_end_date | Unknown |  |
| quickbooks_job_resale_number | Unknown |  |
| quickbooks_job_sales_rep | Unknown |  |
| quickbooks_job_salutation | Unknown |  |
| quickbooks_job_shipping_address_1 | Unknown |  |
| quickbooks_job_shipping_address_2 | Unknown |  |
| quickbooks_job_shipping_address_3 | Unknown |  |
| quickbooks_job_shipping_city | Unknown |  |
| quickbooks_job_shipping_country | Unknown |  |
| quickbooks_job_shipping_state | Unknown |  |
| quickbooks_job_shipping_zip_code | Unknown |  |
| quickbooks_job_start_date | Unknown |  |
| quickbooks_job_state | Unknown |  |
| quickbooks_job_status | Unknown |  |
| quickbooks_job_type | Unknown |  |
| quickbooks_job_zip_code | Unknown |  |
| sales_order_id | Unknown |  |
| stage_name | Unknown |  |
| transaction_renwal_quantity | Unknown |  |
| transaction_sf_renewal_opportunity_rule | Unknown |  |
| transaction_term_number | Unknown |  |
| transaction_unbalanced_revenue_exemption | Unknown |  |
| type | Unknown |  |

### auto_renewal_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| days | Unknown |  |
| generate_revenue | Unknown |  |
| months | Unknown |  |
| name | Unknown |  |
| new_contract | Unknown |  |
| recognize | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_profile_currency_code | Unknown | FK |
| billing_profile_payment_term_id | Unknown | FK |
| auditentry_created | Unknown |  |
| auditentry_created_by | Unknown |  |
| auditentry_created_by_name | Unknown |  |
| auditentry_modified | Unknown |  |
| auditentry_modified_by | Unknown |  |
| auditentry_modified_by_name | Unknown |  |
| autopay_enrollment | Unknown |  |
| billing_profile_account_number | Unknown |  |
| billing_profile_address_1 | Unknown |  |
| billing_profile_address_2 | Unknown |  |
| billing_profile_address_3 | Unknown |  |
| billing_profile_alt_contact | Unknown |  |
| billing_profile_alt_phone | Unknown |  |
| billing_profile_avatax_address_validation_timestamp | Unknown |  |
| billing_profile_city | Unknown |  |
| billing_profile_company_name | Unknown |  |
| billing_profile_contact | Unknown |  |
| billing_profile_country | Unknown |  |
| billing_profile_customer_type | Unknown |  |
| billing_profile_default_class | Unknown |  |
| billing_profile_default_credit_memo_template | Unknown |  |
| billing_profile_default_invoice_template | Unknown |  |
| billing_profile_edit_sequence | Unknown |  |
| billing_profile_email | Unknown |  |
| billing_profile_entity_use_code | Unknown |  |
| billing_profile_fax | Unknown |  |
| billing_profile_first_name | Unknown |  |
| billing_profile_invoice_email_preference | Unknown |  |
| billing_profile_invoice_print_preference | Unknown |  |
| billing_profile_is_active | Unknown |  |
| billing_profile_item_sales_tax | Unknown |  |
| billing_profile_last_name | Unknown |  |
| billing_profile_last_updated_by_qb | Unknown |  |
| billing_profile_name | Unknown |  |
| billing_profile_payment_method | Unknown |  |
| billing_profile_phone | Unknown |  |
| billing_profile_resale_number | Unknown |  |
| billing_profile_sales_rep | Unknown |  |
| billing_profile_sales_rep_full_name | Unknown |  |
| billing_profile_sales_tax_code | Unknown |  |
| billing_profile_salutation | Unknown |  |
| billing_profile_shipping_address_1 | Unknown |  |
| billing_profile_shipping_address_2 | Unknown |  |
| billing_profile_shipping_address_3 | Unknown |  |
| billing_profile_shipping_city | Unknown |  |
| billing_profile_shipping_country | Unknown |  |
| billing_profile_shipping_state | Unknown |  |
| billing_profile_shipping_zip_code | Unknown |  |
| billing_profile_state | Unknown |  |
| billing_profile_zip_code | Unknown |  |
| c_concierge_hot_platform | Unknown |  |
| c_concierge_inferno_platform | Unknown |  |
| c_concierge_spicy_platform | Unknown |  |
| c_concierge_user_licenses | Unknown |  |
| c_crm | Unknown |  |
| c_cs_owner | Unknown |  |
| c_drop_down_field_1 | Unknown |  |
| c_instant_booker_hot_user_licenses | Unknown |  |
| c_instant_booker_spicy_user_licenses | Unknown |  |
| c_non_renewable_customer | Unknown |  |
| c_optout_clause | Unknown |  |
| c_q_4_22_am_text_field | Unknown |  |
| c_ultimate_parent_id | Unknown |  |
| cc_email | Unknown |  |
| code | Unknown |  |
| crm_id | Unknown |  |
| default_autorenewal_profile | Unknown |  |
| default_email_from_so | Unknown |  |
| default_enable_ach_payment | Unknown |  |
| default_enable_cc_payment | Unknown |  |
| default_theme | Unknown |  |
| do_not_sync | Unknown |  |
| domain | Unknown |  |
| einvoicing_id | Unknown |  |
| email | Unknown |  |
| enable_autopay | Unknown |  |
| escalation_email | Unknown |  |
| industry | Unknown |  |
| is_active | Unknown |  |
| market | Unknown |  |
| modified | LocalDateTime |  |
| name | Unknown |  |
| notes | Unknown |  |
| number | Unknown |  |
| number_field_1 | Unknown |  |
| number_field_2 | Unknown |  |
| number_field_3 | Unknown |  |
| parent | Unknown |  |
| qb_id | Unknown |  |
| recurly_id | Unknown |  |
| segment | Unknown |  |
| sf_default_renewal_opportunity_rule | Unknown |  |
| sf_id | Unknown |  |
| sf_opportunity_price_book_id | Unknown |  |
| sf_owner_id | Unknown |  |
| stripe_id | Unknown |  |
| subsegment | Unknown |  |
| text_field_1 | Unknown |  |
| text_field_2 | Unknown |  |
| text_field_3 | Unknown |  |
| unbalanced_revenue_exception | Unknown |  |
| custom_** |  |  |

### revenue_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | FK |
| end_date | Unknown |  |
| home_amount | Unknown |  |
| local_amount | Unknown |  |
| modified | LocalDateTime |  |
| start_date | Unknown |  |

### country_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| name | Unknown |  |

## Relationships

- contract(customer_id) → customer(id)
- contract(register_id) → register(id)
- contract(billing_profile_payment_term_id) → payment_term(id)
- transaction_renewal_of_set(transaction_id) → transaction(id)
- transaction(billing_method_id) → billing_method(id)
- transaction(renew_using_item_id) → item(id)
- transaction(renewal_billing_method_id) → billing_method(id)
- transaction(contract_id) → contract(id)
- transaction(item_id) → item(id)
- transaction(autorenewal_profile_id) → auto_renewal_profile(id)
- invoice_line_item(item_id) → item(id)
- invoice_line_item(transaction_id) → transaction(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_tax_line(invoice_id) → invoice(id)
- invoice(contract_id) → contract(id)
- item(billing_method_id) → billing_method(id)
- item(income_account_id) → account(id)
- item(asset_account_id) → account(id)
- item(liability_account_id) → account(id)
- item(revenue_recognition_method_id) → revenue_recognition_method(id)
- sales_order_line_item(sales_order_id) → sales_order(id)
- customer(billing_profile_currency_code) → currency_code(code)
- customer(billing_profile_payment_term_id) → payment_term(id)
- revenue_entry(transaction_id) → transaction(id)