# Exact Online schema ERD

Table and field reference for the Fivetran Exact Online connector.

## Table & Field Reference

### gl_account_classification_mapping

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| classification | Unknown | FK |
| division_id | Unknown | FK |
| classification_code | Unknown |  |
| classification_description | Unknown |  |
| gl_account | Unknown |  |
| gl_account_code | Unknown |  |
| gl_account_description | Unknown |  |
| gl_scheme_code | Unknown |  |
| gl_scheme_description | Unknown |  |
| gl_scheme_id | Unknown |  |
| metadata_** |  |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division | Unknown | FK |
| block_entry | Unknown |  |
| cancellation_date | Unknown |  |
| classification | Unknown |  |
| classification_code | Unknown |  |
| classification_description | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| currency | Unknown |  |
| customer_po_number | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| invoice_day | Unknown |  |
| invoice_to | Unknown |  |
| invoice_to_contact_person | Unknown |  |
| invoice_to_contact_person_full_name | Unknown |  |
| invoice_to_name | Unknown |  |
| invoiced_to | Unknown |  |
| invoicing_start_date | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| ordered_by | Unknown |  |
| ordered_by_contact_person | Unknown |  |
| ordered_by_contact_person_full_name | Unknown |  |
| ordered_by_name | Unknown |  |
| payment_condition | Unknown |  |
| payment_condition_description | Unknown |  |
| printed | Unknown |  |
| project | Unknown |  |
| reason_cancelled | Unknown |  |
| reason_cancelled_code | Unknown |  |
| reason_cancelled_description | Unknown |  |
| start_date | Unknown |  |
| subscription_type | Unknown |  |
| subscription_type_code | Unknown |  |
| subscription_type_description | Unknown |  |
| timestamps | Unknown |  |
| metadata_** |  |  |

### sales_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount_dc | Unknown |  |
| amount_fc | Unknown |  |
| cost_center | Unknown |  |
| cost_center_description | Unknown |  |
| cost_unit | Unknown |  |
| cost_unit_description | Unknown |  |
| custom_field | Unknown |  |
| customer_item_code | Unknown |  |
| delivery_date | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| division | Unknown |  |
| employee | Unknown |  |
| employee_full_name | Unknown |  |
| end_time | Unknown |  |
| extra_duty_amount_fc | Unknown |  |
| extra_duty_percentage | Unknown |  |
| gl_account | Unknown |  |
| gl_account_description | Unknown |  |
| invoice_id | Unknown |  |
| item | Unknown |  |
| item_code | Unknown |  |
| item_description | Unknown |  |
| line_number | Unknown |  |
| net_price | Unknown |  |
| notes | Unknown |  |
| pricelist | Unknown |  |
| pricelist_description | Unknown |  |
| project | Unknown |  |
| project_description | Unknown |  |
| project_wbs | Unknown |  |
| project_wbs_description | Unknown |  |
| quantity | Unknown |  |
| sales_order | Unknown |  |
| sales_order_line | Unknown |  |
| sales_order_line_number | Unknown |  |
| sales_order_number | Unknown |  |
| start_time | Unknown |  |
| subscription | Unknown |  |
| subscription_description | Unknown |  |
| system_division_id | Unknown |  |
| tax_schedule | Unknown |  |
| tax_schedule_code | Unknown |  |
| tax_schedule_description | Unknown |  |
| unit_code | Unknown |  |
| unit_description | Unknown |  |
| unit_price | Unknown |  |
| vat_amount_dc | Unknown |  |
| vat_amount_fc | Unknown |  |
| vat_code | Unknown |  |
| vat_code_description | Unknown |  |
| vat_percentage | Unknown |  |
| metadata_** |  |  |

### receivables_list

| Column | Type | Keys |
| --- | --- | --- |
| hid | Unknown | PK |
| account_id | Unknown | FK |
| account_code | Unknown |  |
| account_name | Unknown |  |
| amount | Unknown |  |
| amount_in_transit | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| entry_number | Unknown |  |
| id | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| journal_code | Unknown |  |
| journal_description | Unknown |  |
| system_division_id | Unknown |  |
| your_ref | Unknown |  |

### division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_division | Unknown |  |
| customer_code | Unknown |  |
| division_customer | Unknown |  |
| division_customer_code | Unknown |  |
| division_customer_name | Unknown |  |
| division_customer_siret_number | Unknown |  |
| division_customer_vat_number | Unknown |  |
| dossier_division | Unknown |  |
| email | Unknown |  |
| employee_id | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| initials | Unknown |  |
| is_client_user | Unknown |  |
| is_employee_self_service_user | Unknown |  |
| is_my_firm_lite_user | Unknown |  |
| is_my_firm_portal_user | Unknown |  |
| is_starter_user | Unknown |  |
| language_code | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| legislation | Unknown |  |
| middle_name | Unknown |  |
| mobile | Unknown |  |
| nationality | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |
| picture_url | Unknown |  |
| server_time | Unknown |  |
| server_utc_offset | Unknown |  |
| thumbnail_picture | Unknown |  |
| thumbnail_picture_format | Unknown |  |
| title | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |
| metadata_** |  |  |

### revenue_list

| Column | Type | Keys |
| --- | --- | --- |
| period | Unknown | PK |
| year | Unknown | PK |
| amount | Unknown |  |
| system_division_id | Unknown |  |
| metadata_** |  |  |

### bank

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_name | Unknown |  |
| bic_code | Unknown |  |
| country | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| format | Unknown |  |
| home_page_address | Unknown |  |
| modified | Unknown |  |
| status | Unknown |  |
| system_division_id | Unknown |  |
| metadata_** |  |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| division_id | Unknown | FK |
| account_is_customer | Unknown |  |
| account_is_supplier | Unknown |  |
| account_main_contact | Unknown |  |
| account_name | Unknown |  |
| address_line_2 | Unknown |  |
| address_street | Unknown |  |
| address_street_number_suffix | Unknown |  |
| allow_mailing | Unknown |  |
| birth_date | Unknown |  |
| birth_name | Unknown |  |
| birth_name_prefix | Unknown |  |
| birth_place | Unknown |  |
| business_email | Unknown |  |
| business_fax | Unknown |  |
| business_mobile | Unknown |  |
| business_phone | Unknown |  |
| business_phone_extension | Unknown |  |
| city | Unknown |  |
| code | Unknown |  |
| country | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| custom_field | Unknown |  |
| email | Unknown |  |
| end_date | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| hid | Unknown |  |
| identification_date | Unknown |  |
| identification_document | Unknown |  |
| identification_user | Unknown |  |
| initials | Unknown |  |
| is_anonymised | Unknown |  |
| is_mailing_excluded | Unknown |  |
| is_main_contact | Unknown |  |
| job_title_description | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| lead_purpose | Unknown |  |
| lead_source | Unknown |  |
| marketing_notes | Unknown |  |
| middle_name | Unknown |  |
| mobile | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| nationality | Unknown |  |
| notes | Unknown |  |
| partner_name | Unknown |  |
| partner_name_prefix | Unknown |  |
| person | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |
| picture | Unknown |  |
| picture_name | Unknown |  |
| picture_thumbnail_url | Unknown |  |
| picture_url | Unknown |  |
| postcode | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| timestamps | Unknown |  |
| title | Unknown |  |
| title_abbreviation | Unknown |  |
| title_description | Unknown |  |
| metadata_** |  |  |

### gl_classification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| abstract | Unknown |  |
| balance | Unknown |  |
| code | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| description | Unknown |  |
| is_tuple_sub_element | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| name | Unknown |  |
| nillable | Unknown |  |
| parent | Unknown |  |
| period_type | Unknown |  |
| substitution_group | Unknown |  |
| taxonomy_namespace | Unknown |  |
| taxonomy_namespace_description | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |
| metadata_** |  |  |

### system_division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| archive_date | Unknown |  |
| blocking_status | Unknown |  |
| business_type_code | Unknown |  |
| business_type_description | Unknown |  |
| chamber_of_commerce_establishment | Unknown |  |
| chamber_of_commerce_number | Unknown |  |
| city | Unknown |  |
| class_01 | Unknown |  |
| class_02 | Unknown |  |
| class_03 | Unknown |  |
| class_04 | Unknown |  |
| class_05 | Unknown |  |
| company_size_code | Unknown |  |
| company_size_description | Unknown |  |
| country | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| currency | Unknown |  |
| current | Unknown |  |
| customer | Unknown |  |
| customer_code | Unknown |  |
| customer_name | Unknown |  |
| date_v_accountant_number | Unknown |  |
| date_v_client_number | Unknown |  |
| description | Unknown |  |
| division_hr_link_unlink_date | Unknown |  |
| division_move_date | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| hid | Unknown |  |
| is_dossier_division | Unknown |  |
| is_hr_division | Unknown |  |
| is_main_division | Unknown |  |
| is_practice_division | Unknown |  |
| legislation | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| ob_number | Unknown |  |
| phone | Unknown |  |
| postcode | Unknown |  |
| sbi_code | Unknown |  |
| sbi_description | Unknown |  |
| sector_code | Unknown |  |
| sector_description | Unknown |  |
| share_capital | Unknown |  |
| siret_number | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| subsector_code | Unknown |  |
| subsector_description | Unknown |  |
| tax_office_number | Unknown |  |
| tax_reference_number | Unknown |  |
| template_code | Unknown |  |
| vat_number | Unknown |  |
| website | Unknown |  |
| metadata_** |  |  |

### lead_purpose

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| code | Unknown |  |
| description | Unknown |  |
| division_company_coc_number | Unknown |  |
| division_company_iban_number | Unknown |  |
| division_company_name | Unknown |  |
| division_company_rsin_number | Unknown |  |
| division_company_vat_number | Unknown |  |
| division_company_wage_tax_number | Unknown |  |
| division_label | Unknown |  |
| division_name | Unknown |  |
| division_owner_company_name | Unknown |  |
| division_owner_company_number | Unknown |  |
| division_short_name | Unknown |  |

### gl_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| allow_costs_in_sales | Unknown |  |
| assimilated_vatbox | Unknown |  |
| balance_side | Unknown |  |
| balance_type | Unknown |  |
| belcotax_type | Unknown |  |
| code | Unknown |  |
| compress | Unknown |  |
| cost_center | Unknown |  |
| cost_center_description | Unknown |  |
| costunit | Unknown |  |
| costunit_description | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_fullname | Unknown |  |
| custom_field | Unknown |  |
| deductibility_percentages_deferred_uri | Unknown |  |
| description | Unknown |  |
| description_term_id | Unknown |  |
| exclude_vat_listing | Unknown |  |
| expense_non_deductible_percentage | Unknown |  |
| is_blocked | Unknown |  |
| matching | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| private_gl_account | Unknown |  |
| private_percentage | Unknown |  |
| reporting_code | Unknown |  |
| revalue_currency | Unknown |  |
| search_code | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |
| type_description | Unknown |  |
| use_cost_center | Unknown |  |
| use_costunit | Unknown |  |
| vat_code | Unknown |  |
| vat_description | Unknown |  |
| vat_gl_account_type | Unknown |  |
| vat_non_deductible_gl_account | Unknown |  |
| vat_non_deductible_percentage | Unknown |  |
| vat_system | Unknown |  |
| year_end_cost_gl_account | Unknown |  |
| year_end_reflection_gl_account | Unknown |  |
| metadata_** |  |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| account | Unknown |  |
| account_name | Unknown |  |
| bank | Unknown |  |
| bank_account | Unknown |  |
| bank_account_holder_name | Unknown |  |
| bank_description | Unknown |  |
| bank_name | Unknown |  |
| bic_code | Unknown |  |
| blocked | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| description | Unknown |  |
| format | Unknown |  |
| iban | Unknown |  |
| main | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| payment_service_account | Unknown |  |
| type | Unknown |  |
| type_description | Unknown |  |
| metadata_** |  |  |

### reporting_balance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division | Unknown | FK |
| amount | Unknown |  |
| amount_credit | Unknown |  |
| amount_debit | Unknown |  |
| balance_type | Unknown |  |
| cost_center_code | Unknown |  |
| cost_center_description | Unknown |  |
| cost_unit_code | Unknown |  |
| cost_unit_description | Unknown |  |
| count | Unknown |  |
| gl_account | Unknown |  |
| gl_account_code | Unknown |  |
| gl_account_description | Unknown |  |
| reporting_period | Unknown |  |
| reporting_year | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| metadata_** |  |  |

### transaction_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| account_code | Unknown |  |
| account_name | Unknown |  |
| amount_dc | Unknown |  |
| amount_fc | Unknown |  |
| amount_vat_base_fc | Unknown |  |
| amount_vat_fc | Unknown |  |
| asset | Unknown |  |
| asset_code | Unknown |  |
| asset_description | Unknown |  |
| cost_center | Unknown |  |
| cost_center_description | Unknown |  |
| cost_unit | Unknown |  |
| cost_unit_description | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| currency | Unknown |  |
| custom_field | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| division | Unknown |  |
| document | Unknown |  |
| document_number | Unknown |  |
| document_subject | Unknown |  |
| due_date | Unknown |  |
| entry_id | Unknown |  |
| entry_number | Unknown |  |
| exchange_rate | Unknown |  |
| external_link_description | Unknown |  |
| external_link_reference | Unknown |  |
| extra_duty_amount_fc | Unknown |  |
| extra_duty_percentage | Unknown |  |
| financial_period | Unknown |  |
| financial_year | Unknown |  |
| gl_account | Unknown |  |
| gl_account_code | Unknown |  |
| gl_account_description | Unknown |  |
| invoice_number | Unknown |  |
| item | Unknown |  |
| item_code | Unknown |  |
| item_description | Unknown |  |
| journal_code | Unknown |  |
| journal_description | Unknown |  |
| line_number | Unknown |  |
| line_type | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| notes | Unknown |  |
| offset_id | Unknown |  |
| order_number | Unknown |  |
| payment_discount_amount | Unknown |  |
| payment_reference | Unknown |  |
| project | Unknown |  |
| project_code | Unknown |  |
| project_description | Unknown |  |
| quantity | Unknown |  |
| serial_number | Unknown |  |
| shop_order | Unknown |  |
| status | Unknown |  |
| subscription | Unknown |  |
| subscription_description | Unknown |  |
| system_division_id | Unknown |  |
| tracking_number | Unknown |  |
| tracking_number_description | Unknown |  |
| type | Unknown |  |
| vat_code | Unknown |  |
| vat_code_description | Unknown |  |
| vat_percentage | Unknown |  |
| vat_type | Unknown |  |
| your_ref | Unknown |  |
| metadata_** |  |  |

### profit_loss_overview

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| costs_current_period | Unknown |  |
| costs_current_year | Unknown |  |
| costs_previous_year | Unknown |  |
| costs_previous_year_period | Unknown |  |
| currency_code | Unknown |  |
| current_period | Unknown |  |
| current_year | Unknown |  |
| metadata_type | Unknown |  |
| metadata_uri | Unknown |  |
| previous_year | Unknown |  |
| previous_year_period | Unknown |  |
| result_current_period | Unknown |  |
| result_current_year | Unknown |  |
| result_previous_year | Unknown |  |
| result_previous_year_period | Unknown |  |
| revenue_current_period | Unknown |  |
| revenue_current_year | Unknown |  |
| revenue_previous_year | Unknown |  |
| revenue_previous_year_period | Unknown |  |
| system_division_id | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| account | Unknown |  |
| account_city | Unknown |  |
| account_code | Unknown |  |
| account_is_supplier | Unknown |  |
| account_logo_thumbnail_url | Unknown |  |
| account_name | Unknown |  |
| account_status | Unknown |  |
| created | Unknown |  |
| created_utc | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| division_company_coc_number | Unknown |  |
| division_company_iban_number | Unknown |  |
| division_company_name | Unknown |  |
| division_company_rsin_number | Unknown |  |
| division_company_vat_number | Unknown |  |
| division_company_wage_tax_number | Unknown |  |
| division_label | Unknown |  |
| division_name | Unknown |  |
| division_owner_company_name | Unknown |  |
| division_owner_company_number | Unknown |  |
| division_short_name | Unknown |  |
| involved_user_role | Unknown |  |
| involved_user_role_description | Unknown |  |
| is_main_contact | Unknown |  |
| modified | Unknown |  |
| modified_utc | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| person_email | Unknown |  |
| person_phone | Unknown |  |
| person_phone_extension | Unknown |  |
| person_picture_thumbnail_url | Unknown |  |
| user_full_name | Unknown |  |
| users | Unknown |  |

### subscription_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division | Unknown | FK |
| amount_dc | Unknown |  |
| amount_fc | Unknown |  |
| cost_center | Unknown |  |
| costunit | Unknown |  |
| custom_field | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| entry_id | Unknown |  |
| from_date | Unknown |  |
| item | Unknown |  |
| item_description | Unknown |  |
| line_number | Unknown |  |
| line_type | Unknown |  |
| line_type_description | Unknown |  |
| modified | Unknown |  |
| net_price | Unknown |  |
| note | Unknown |  |
| quantity | Unknown |  |
| subscription_number | Unknown |  |
| timestamps | Unknown |  |
| to_date | Unknown |  |
| unit_code | Unknown |  |
| unit_description | Unknown |  |
| unit_price | Unknown |  |
| vat_amount_fc | Unknown |  |
| vat_code | Unknown |  |
| vat_code_description | Unknown |  |
| metadata_** |  |  |

### account_classification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| account_classification_name | Unknown |  |
| account_classification_name_description | Unknown |  |
| code | Unknown |  |
| created | Unknown |  |
| created_utc | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| description | Unknown |  |
| division_company_coc_number | Unknown |  |
| division_company_iban_number | Unknown |  |
| division_company_name | Unknown |  |
| division_company_rsin_number | Unknown |  |
| division_company_vat_number | Unknown |  |
| division_company_wage_tax_number | Unknown |  |
| division_label | Unknown |  |
| division_name | Unknown |  |
| division_owner_company_name | Unknown |  |
| division_owner_company_number | Unknown |  |
| division_short_name | Unknown |  |
| modified | Unknown |  |
| modified_utc | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |

### return

| Column | Type | Keys |
| --- | --- | --- |
| document_id | Unknown | PK |
| amount | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| document_view_url | Unknown |  |
| due_date | Unknown |  |
| frequency | Unknown |  |
| metadata_type | Unknown |  |
| metadata_uri | Unknown |  |
| payroll_declaration_type | Unknown |  |
| period | Unknown |  |
| period_description | Unknown |  |
| request | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| system_division_id | Unknown |  |
| type | Unknown |  |
| year | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| account_manager | Unknown |  |
| account_manager_full_name | Unknown |  |
| account_manager_hid | Unknown |  |
| accountant | Unknown |  |
| activity_sector | Unknown |  |
| activity_sub_sector | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| address_source | Unknown |  |
| bankaccounts_deferred_uri | Unknown |  |
| blocked | Unknown |  |
| brin | Unknown |  |
| bsn | Unknown |  |
| business_type | Unknown |  |
| can_drop_ship | Unknown |  |
| chamber_of_commerce | Unknown |  |
| city | Unknown |  |
| classification | Unknown |  |
| classification_1 | Unknown |  |
| classification_2 | Unknown |  |
| classification_3 | Unknown |  |
| classification_4 | Unknown |  |
| classification_5 | Unknown |  |
| classification_6 | Unknown |  |
| classification_7 | Unknown |  |
| classification_8 | Unknown |  |
| classification_description | Unknown |  |
| code | Unknown |  |
| code_at_supplier | Unknown |  |
| company_size | Unknown |  |
| consolidation_scenario | Unknown |  |
| controlled_date | Unknown |  |
| cost_center | Unknown |  |
| cost_center_description | Unknown |  |
| cost_paid | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| credit_line_purchase | Unknown |  |
| credit_line_sales | Unknown |  |
| currency | Unknown |  |
| custom_field | Unknown |  |
| customer_since | Unknown |  |
| datev_creditor_code | Unknown |  |
| datev_debtor_code | Unknown |  |
| delivery_advice | Unknown |  |
| discount_purchase | Unknown |  |
| discount_sales | Unknown |  |
| document | Unknown |  |
| duns_number | Unknown |  |
| email | Unknown |  |
| enable_sales_payment_link | Unknown |  |
| end_date | Unknown |  |
| eori_number | Unknown |  |
| established_date | Unknown |  |
| fax | Unknown |  |
| gl_account_purchase | Unknown |  |
| gl_account_sales | Unknown |  |
| glap | Unknown |  |
| glar | Unknown |  |
| gln_number | Unknown |  |
| has_withholding_tax_sales | Unknown |  |
| ignore_datev_warning_message | Unknown |  |
| incoterm_address_purchase | Unknown |  |
| incoterm_address_sales | Unknown |  |
| incoterm_code_purchase | Unknown |  |
| incoterm_code_sales | Unknown |  |
| incoterm_version_purchase | Unknown |  |
| incoterm_version_sales | Unknown |  |
| intra_stat_area | Unknown |  |
| intra_stat_delivery_term | Unknown |  |
| intra_stat_system | Unknown |  |
| intra_stat_transaction_a | Unknown |  |
| intra_stat_transaction_b | Unknown |  |
| intra_stat_transport_method | Unknown |  |
| invoice_account | Unknown |  |
| invoice_account_code | Unknown |  |
| invoice_account_name | Unknown |  |
| invoice_attachment_type | Unknown |  |
| invoicing_method | Unknown |  |
| is_accountant | Unknown |  |
| is_agency | Unknown |  |
| is_anonymised | Unknown |  |
| is_bank | Unknown |  |
| is_competitor | Unknown |  |
| is_extra_duty | Unknown |  |
| is_mailing | Unknown |  |
| is_member | Unknown |  |
| is_pilot | Unknown |  |
| is_purchase | Unknown |  |
| is_reseller | Unknown |  |
| is_sales | Unknown |  |
| is_supplier | Unknown |  |
| language_description | Unknown |  |
| languages | Unknown |  |
| latitude | Unknown |  |
| lead_purpose | Unknown |  |
| lead_source | Unknown |  |
| logo | Unknown |  |
| logo_file_name | Unknown |  |
| logo_thumbnail_url | Unknown |  |
| logo_url | Unknown |  |
| longitude | Unknown |  |
| main_contact | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| name | Unknown |  |
| oin_number | Unknown |  |
| parent | Unknown |  |
| pay_as_you_earn | Unknown |  |
| payment_condition_purchase | Unknown |  |
| payment_condition_purchase_description | Unknown |  |
| payment_condition_sales | Unknown |  |
| payment_condition_sales_description | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |
| postcode | Unknown |  |
| price_list | Unknown |  |
| purchase_currency | Unknown |  |
| purchase_currency_description | Unknown |  |
| purchase_lead_days | Unknown |  |
| purchase_v_a_t_code | Unknown |  |
| purchase_v_a_t_code_description | Unknown |  |
| recepient_of_commissions | Unknown |  |
| remarks | Unknown |  |
| reseller | Unknown |  |
| reseller_code | Unknown |  |
| reseller_name | Unknown |  |
| rsin | Unknown |  |
| sales_currency | Unknown |  |
| sales_currency_description | Unknown |  |
| sales_tax_schedule | Unknown |  |
| sales_tax_schedule_code | Unknown |  |
| sales_tax_schedule_description | Unknown |  |
| sales_v_a_t_code | Unknown |  |
| sales_v_a_t_code_description | Unknown |  |
| search_code | Unknown |  |
| security_level | Unknown |  |
| separate_inv_per_project | Unknown |  |
| separate_inv_per_subscription | Unknown |  |
| shipping_lead_days | Unknown |  |
| shipping_method | Unknown |  |
| show_remark_for_sales | Unknown |  |
| source | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| state_name | Unknown |  |
| status | Unknown |  |
| status_since | Unknown |  |
| timestamps | Unknown |  |
| trade_name | Unknown |  |
| type | Unknown |  |
| unique_taxpayer_reference | Unknown |  |
| vat_liability | Unknown |  |
| vat_number | Unknown |  |
| website | Unknown |  |
| metadata_** |  |  |

### sales_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount_dc | Unknown |  |
| amount_discount | Unknown |  |
| amount_discount_excl_vat | Unknown |  |
| amount_fc | Unknown |  |
| amount_fc_excl_vat | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| creator_full_name | Unknown |  |
| currency | Unknown |  |
| deliver_to | Unknown |  |
| deliver_to_address | Unknown |  |
| deliver_to_contact_person | Unknown |  |
| deliver_to_contact_person_full_name | Unknown |  |
| deliver_to_name | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| discount_type | Unknown |  |
| division | Unknown |  |
| document | Unknown |  |
| document_number | Unknown |  |
| document_subject | Unknown |  |
| due_date | Unknown |  |
| extra_duty_amount_fc | Unknown |  |
| g_account_amount_fc | Unknown |  |
| incoterm_address | Unknown |  |
| incoterm_code | Unknown |  |
| incoterm_version | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| invoice_to | Unknown |  |
| invoice_to_contact_person | Unknown |  |
| invoice_to_contact_person_full_name | Unknown |  |
| invoice_to_name | Unknown |  |
| is_extra_duty | Unknown |  |
| journal | Unknown |  |
| journal_description | Unknown |  |
| modified | Unknown |  |
| modifier | Unknown |  |
| modifier_full_name | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| ordered_by | Unknown |  |
| ordered_by_contact_person | Unknown |  |
| ordered_by_contact_person_full_name | Unknown |  |
| ordered_by_name | Unknown |  |
| payment_condition | Unknown |  |
| payment_condition_description | Unknown |  |
| payment_reference | Unknown |  |
| remarks | Unknown |  |
| sales_channel | Unknown |  |
| sales_channel_code | Unknown |  |
| sales_channel_description | Unknown |  |
| sales_invoice_lines | Unknown |  |
| salesperson | Unknown |  |
| salesperson_full_name | Unknown |  |
| selection_code | Unknown |  |
| selection_code_code | Unknown |  |
| selection_code_description | Unknown |  |
| shipping_method | Unknown |  |
| shipping_method_code | Unknown |  |
| shipping_method_description | Unknown |  |
| starter_sales_invoice_status | Unknown |  |
| starter_sales_invoice_status_description | Unknown |  |
| status | Unknown |  |
| status_description | Unknown |  |
| system_division_id | Unknown |  |
| tax_schedule | Unknown |  |
| tax_schedule_code | Unknown |  |
| tax_schedule_description | Unknown |  |
| type | Unknown |  |
| type_description | Unknown |  |
| vat_amount_dc | Unknown |  |
| vat_amount_fc | Unknown |  |
| warehouse | Unknown |  |
| withholding_tax_amount_fc | Unknown |  |
| withholding_tax_base_amount | Unknown |  |
| withholding_tax_percentage | Unknown |  |
| your_ref | Unknown |  |
| metadata_** |  |  |

## Relationships

- gl_account_classification_mapping(division_id) → system_division(id)
- gl_account_classification_mapping(classification) → gl_classification(id)
- subscription(division) → division(id)
- receivables_list(account_id) → account(id)
- contact(division_id) → system_division(id)
- contact(account_id) → account(id)
- gl_classification(division_id) → system_division(id)
- system_division(id) → division(id)
- lead_purpose(division_id) → division(id)
- gl_account(division_id) → division(id)
- bank_account(division_id) → division(id)
- reporting_balance(division) → division(id)
- users(division_id) → division(id)
- subscription_line(division) → division(id)
- account_classification(division_id) → system_division(id)
- account(division_id) → system_division(id)