Maxio SaaSOptics

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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