# sevdesk schema ERD

Table and field reference for the Fivetran sevdesk connector.

## Table & Field Reference

### contact_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_custom_field_setting_id | Unknown | FK |
| contact_id | Unknown | FK |
| created_at | Unknown |  |
| sev_client_id | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### check_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| accounting_number | Unknown |  |
| auto_map_transactions | Unknown |  |
| auto_sync_transactions | Unknown |  |
| balance | Unknown |  |
| bank_server | Unknown |  |
| base_account | Unknown |  |
| bic | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| default_account | Unknown |  |
| iban | Unknown |  |
| import_type | Unknown |  |
| last_sync | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| sev_client_id | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |

### voucher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | FK |
| cost_centre_id | Unknown |  |
| created_at | Instant |  |
| credit_debit | Unknown |  |
| currency | Unknown |  |
| delivery_date | Json |  |
| delivery_date_until | Json |  |
| description | Unknown |  |
| document_id | Unknown |  |
| enshrined | Unknown |  |
| map_all | Unknown |  |
| paid_amount | Unknown |  |
| pay_date | Unknown |  |
| payment_deadline | Json |  |
| property_exchange_rate | Unknown |  |
| property_foreign_currency_deadline | Unknown |  |
| recurring_end_date | Unknown |  |
| recurring_interval | Unknown |  |
| recurring_last_voucher | Unknown |  |
| recurring_next_voucher | Unknown |  |
| recurring_start_date | Unknown |  |
| sev_client_id | Unknown |  |
| status | Unknown |  |
| sum_discounts | Unknown |  |
| sum_discounts_foreign_currency | Unknown |  |
| sum_gross | Unknown |  |
| sum_gross_accounting | Unknown |  |
| sum_net | Unknown |  |
| sum_net_accounting | Unknown |  |
| sum_tax | Unknown |  |
| sum_tax_accounting | Unknown |  |
| tax_rule_id | Unknown |  |
| tax_set_id | Unknown |  |
| tax_type | Unknown |  |
| updated_at | Instant |  |
| voucher_type | Unknown |  |

### part

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown |  |
| created_at | Instant |  |
| internal_comment | Unknown |  |
| name | Unknown |  |
| part_number | Unknown |  |
| price | Unknown |  |
| price_gross | Unknown |  |
| price_net | Unknown |  |
| price_purchase | Unknown |  |
| sev_client_id | Unknown |  |
| status | Unknown |  |
| stock | Unknown |  |
| stock_enabled | Unknown |  |
| tax_rate | Unknown |  |
| text | Unknown |  |
| unity_id | Unknown |  |
| updated_at | Instant |  |

### tag_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| additional_information | Unknown |  |
| created_at | Instant |  |
| name | Unknown |  |
| sev_client_id | Unknown |  |

### order_pos

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| part_id | Unknown | FK |
| created_at | Instant |  |
| discount | Unknown |  |
| name | Unknown |  |
| optional | Unknown |  |
| position_number | Unknown |  |
| price | Unknown |  |
| price_gross | Unknown |  |
| price_net | Unknown |  |
| price_tax | Unknown |  |
| quantity | Unknown |  |
| sev_client_id | Unknown |  |
| sum_discount | Unknown |  |
| tax_rate | Unknown |  |
| text | Unknown |  |
| unity_id | Unknown |  |
| updated_at | Unknown |  |

### tag_relation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tag_id | Unknown | FK |
| additional_information | Unknown |  |
| created_at | Instant |  |
| object_id | Unknown |  |
| object_type | Unknown |  |
| sev_client_id | Unknown |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| address | Unknown |  |
| address_country_id | Unknown |  |
| contact_person_id | Unknown |  |
| create_user_id | Unknown |  |
| created_at | Instant |  |
| credit_note_date | Unknown |  |
| credit_note_number | Unknown |  |
| currency | Unknown |  |
| customer_internal_note | Unknown |  |
| delivery_date | Unknown |  |
| foot_text | Unknown |  |
| head_text | Unknown |  |
| header | Unknown |  |
| send_date | Unknown |  |
| send_type | Unknown |  |
| sev_client_id | Unknown |  |
| show_net | Unknown |  |
| small_settlement | Unknown |  |
| status | Unknown |  |
| sum_discounts | Unknown |  |
| sum_discounts_foreign_currency | Unknown |  |
| sum_gross | Unknown |  |
| sum_gross_foreign_currency | Unknown |  |
| sum_net | Unknown |  |
| sum_net_foreign_currency | Unknown |  |
| sum_tax | Unknown |  |
| sum_tax_foreign_currency | Unknown |  |
| tax_rate | Unknown |  |
| tax_rule_id | Unknown |  |
| tax_set_id | Unknown |  |
| tax_text | Unknown |  |
| tax_type | Unknown |  |
| updated_at | Instant |  |

### communication_way_key

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| name | Unknown |  |
| translation_code | Unknown |  |
| updated_at | Instant |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| academic_title | Unknown |  |
| additional_information | Unknown |  |
| bank_account | Unknown |  |
| bank_number | Unknown |  |
| birthday | Unknown |  |
| buyer_reference | Unknown |  |
| category_id | Unknown |  |
| created_at | Instant |  |
| customer_number | Unknown |  |
| default_cashback_percent | Unknown |  |
| default_cashback_time | Unknown |  |
| default_discount_amount | Unknown |  |
| default_discount_percentage | Unknown |  |
| default_time_to_pay | Unknown |  |
| description | Unknown |  |
| exempt_vat | Unknown |  |
| familyname | Unknown |  |
| gender | Unknown |  |
| government_agency | Unknown |  |
| name | Unknown |  |
| name_2 | Unknown |  |
| sev_client_id | Unknown |  |
| status | Unknown |  |
| surename | Unknown |  |
| tax_number | Unknown |  |
| tax_office | Unknown |  |
| titel | Unknown |  |
| updated_at | Instant |  |
| vat_number | Unknown |  |

### contact_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| category_id | Unknown |  |
| city | Unknown |  |
| country_id | Unknown |  |
| created_at | Instant |  |
| name | Unknown |  |
| name_2 | Unknown |  |
| name_3 | Unknown |  |
| name_4 | Unknown |  |
| sev_client_id | Unknown |  |
| street | Unknown |  |
| updated_at | Instant |  |
| zip | Unknown |  |

### invoice_pos

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | FK |
| part_id | Unknown | FK |
| created_at | Instant |  |
| discount | Unknown |  |
| name | Unknown |  |
| position_number | Unknown |  |
| price | Unknown |  |
| price_gross | Unknown |  |
| price_net | Unknown |  |
| price_tax | Unknown |  |
| quantity | Unknown |  |
| sev_client_id | Unknown |  |
| sum_discount | Unknown |  |
| sum_gross_accounting | Unknown |  |
| sum_net_accounting | Unknown |  |
| sum_tax_accounting | Unknown |  |
| tax_rate | Unknown |  |
| text | Unknown |  |
| unity_id | Unknown |  |
| updated_at | Instant |  |

### accounting_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_at | Instant |  |
| creditor_number | Unknown |  |
| debitor_number | Unknown |  |
| sev_client_id | Unknown |  |
| updated_at | Instant |  |

### order_get_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| object_id | Unknown | FK |
| created_at | Instant |  |
| is_net | Unknown |  |
| percentage | Unknown |  |
| sev_client_id | Unknown |  |
| text | Unknown |  |
| updated_at | Instant |  |
| value | Unknown |  |

### order_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| address_country_id | Unknown |  |
| contact_id | Unknown |  |
| contact_person_id | Unknown |  |
| create_user_id | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| customer_internal_note | Unknown |  |
| delivery_terms | Unknown |  |
| foot_text | Unknown |  |
| head_text | Unknown |  |
| header | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| order_type | Unknown |  |
| origin_id | Unknown |  |
| payment_terms | Unknown |  |
| send_date | Unknown |  |
| send_type | Unknown |  |
| sev_client_id | Unknown |  |
| show_net | Unknown |  |
| small_settlement | Unknown |  |
| status | Unknown |  |
| sum_discounts | Unknown |  |
| sum_discounts_foreign_currency | Unknown |  |
| sum_gross | Unknown |  |
| sum_gross_foreign_currency | Unknown |  |
| sum_net | Unknown |  |
| sum_net_foreign_currency | Unknown |  |
| sum_tax | Unknown |  |
| sum_tax_foreign_currency | Unknown |  |
| tax_rate | Unknown |  |
| tax_rule_id | Unknown |  |
| tax_set_id | Unknown |  |
| tax_text | Unknown |  |
| tax_type | Unknown |  |
| updated_at | Instant |  |
| version | Unknown |  |

### check_account_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| check_account_id | Unknown | FK |
| source_transaction_id | Unknown | FK |
| target_transaction_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Instant |  |
| enshrined | Unknown |  |
| entry_date | Unknown |  |
| entry_text | Unknown |  |
| gv_code | Unknown |  |
| payee_payer_acct_no | Unknown |  |
| payee_payer_bank_code | Unknown |  |
| payee_payer_name | Unknown |  |
| paymt_purpose | Unknown |  |
| prima_nota_no | Unknown |  |
| sev_client_id | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |
| value_date | Unknown |  |

### private_transaction_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| counterpart_name | Unknown |  |
| created_at | Instant |  |
| payment_purpose | Unknown |  |
| sev_client_id | Unknown |  |
| updated_at | Instant |  |

### receipt_guidance_tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receipt_guidance_allowed_tax_rule_id | Unknown | PK, FK |
| receipt_guidance_for_all_account_account_datev_id | Unknown | PK, FK |
| tax_rate | Unknown |  |

### receipt_guidance_allowed_tax_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| receipt_guidance_for_all_account_account_datev_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### receipt_guidance_allowed_receipt_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receipt_guidance_for_all_account_account_datev_id | Unknown | PK, FK |
| receipt_type | Unknown |  |

### receipt_guidance_for_all_account

| Column | Type | Keys |
| --- | --- | --- |
| account_datev_id | Unknown | PK |
| account_name | Unknown |  |
| account_number | Unknown |  |
| description | Unknown |  |

### voucher_pos

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| voucher_id | Unknown | FK |
| account_datev_id | Unknown |  |
| accounting_type_id | Unknown |  |
| comment | Unknown |  |
| created_at | Instant |  |
| estimated_accounting_type_id | Unknown |  |
| is_asset | Unknown |  |
| net | Unknown |  |
| sev_client_id | Unknown |  |
| sum_gross | Unknown |  |
| sum_gross_accounting | Unknown |  |
| sum_net | Unknown |  |
| sum_net_accounting | Unknown |  |
| sum_tax | Unknown |  |
| sum_tax_accounting | Unknown |  |
| tax_rate | Unknown |  |
| updated_at | Instant |  |

### order_get_related_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| created_at | Instant |  |
| discount | Unknown |  |
| name | Unknown |  |
| object_name | Unknown |  |
| optional | Unknown |  |
| part_id | Unknown |  |
| position_number | Unknown |  |
| price | Unknown |  |
| price_gross | Unknown |  |
| price_net | Unknown |  |
| price_tax | Unknown |  |
| quantity | Unknown |  |
| sev_client_id | Unknown |  |
| sum_discount | Unknown |  |
| tax_rate | Unknown |  |
| text | Unknown |  |
| unity_id | Unknown |  |
| updated_at | Instant |  |

### communication_way

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| communication_way_type | Unknown |  |
| created_at | Instant |  |
| key_id | Unknown |  |
| main | Unknown |  |
| sev_client_id | Unknown |  |
| updated_at | Instant |  |
| value | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| account_intervall | Unknown |  |
| account_next_invoice | Unknown |  |
| address | Unknown |  |
| address_country_id | Unknown |  |
| contact_person_id | Unknown |  |
| cost_centre_id | Unknown |  |
| create_user_id | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| customer_internal_note | Unknown |  |
| datev_connect_online | Json |  |
| delivery_date | Unknown |  |
| delivery_date_until | Unknown |  |
| discount | Unknown |  |
| discount_time | Unknown |  |
| dunning_level | Unknown |  |
| enshrined | Unknown |  |
| foot_text | Unknown |  |
| head_text | Unknown |  |
| header | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| invoice_type | Unknown |  |
| origin_id | Unknown |  |
| paid_amount | Unknown |  |
| pay_date | Unknown |  |
| payment_method_id | Unknown |  |
| reminder_charge | Unknown |  |
| reminder_deadline | Unknown |  |
| reminder_debit | Unknown |  |
| reminder_total | Unknown |  |
| send_date | Unknown |  |
| send_payment_received_notification_date | Unknown |  |
| send_type | Unknown |  |
| sev_client_id | Unknown |  |
| show_net | Unknown |  |
| small_settlement | Unknown |  |
| status | Unknown |  |
| sum_discounts | Unknown |  |
| sum_discounts_foreign_currency | Unknown |  |
| sum_gross | Unknown |  |
| sum_gross_accounting | Unknown |  |
| sum_gross_foreign_currency | Unknown |  |
| sum_net | Unknown |  |
| sum_net_accounting | Unknown |  |
| sum_net_foreign_currency | Unknown |  |
| sum_tax | Unknown |  |
| sum_tax_accounting | Unknown |  |
| sum_tax_foreign_currency | Unknown |  |
| tax_rate | Unknown |  |
| tax_rule_id | Unknown |  |
| tax_set_id | Unknown |  |
| tax_text | Unknown |  |
| tax_type | Unknown |  |
| time_to_pay | Unknown |  |
| updated_at | Instant |  |

### credit_note_pos

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | FK |
| part_id | Unknown | FK |
| created_at | Instant |  |
| discount | Unknown |  |
| name | Unknown |  |
| optional | Unknown |  |
| position_number | Unknown |  |
| price | Unknown |  |
| price_gross | Unknown |  |
| price_net | Unknown |  |
| price_tax | Unknown |  |
| quantity | Unknown |  |
| sev_client_id | Unknown |  |
| sum_discount | Unknown |  |
| tax_rate | Unknown |  |
| text | Unknown |  |
| unity_id | Unknown |  |
| updated_at | Instant |  |

### contact_custom_field_setting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| identifier | Unknown |  |
| name | Unknown |  |
| sev_client_id | Unknown |  |
| updated_at | Instant |  |

## Relationships

- contact_custom_field(contact_id) → contact(id)
- contact_custom_field(contact_custom_field_setting_id) → contact_custom_field_setting(id)
- voucher(supplier_id) → contact(id)
- order_pos(part_id) → part(id)
- order_pos(order_id) → order_operation(id)
- tag_relation(tag_id) → tag_operation(id)
- credit_note(contact_id) → contact(id)
- contact(parent_id) → contact(id)
- contact_address(contact_id) → contact(id)
- invoice_pos(part_id) → part(id)
- invoice_pos(invoice_id) → invoice(id)
- accounting_contact(contact_id) → contact(id)
- order_get_discount(object_id) → order_operation(id)
- check_account_transaction(source_transaction_id) → check_account_transaction(id)
- check_account_transaction(check_account_id) → check_account(id)
- check_account_transaction(target_transaction_id) → check_account_transaction(id)
- receipt_guidance_tax_rate(receipt_guidance_allowed_tax_rule_id) → receipt_guidance_allowed_tax_rule(id)
- receipt_guidance_tax_rate(receipt_guidance_for_all_account_account_datev_id) → receipt_guidance_for_all_account(account_datev_id)
- receipt_guidance_allowed_tax_rule(receipt_guidance_for_all_account_account_datev_id) → receipt_guidance_for_all_account(account_datev_id)
- receipt_guidance_allowed_receipt_type(receipt_guidance_for_all_account_account_datev_id) → receipt_guidance_for_all_account(account_datev_id)
- voucher_pos(voucher_id) → voucher(id)
- order_get_related_object(order_id) → order_operation(id)
- communication_way(contact_id) → contact(id)
- invoice(contact_id) → contact(id)
- credit_note_pos(part_id) → part(id)
- credit_note_pos(credit_note_id) → credit_note(id)