sevdesk

Explore the interactive ERD

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	PKFK
`receipt_guidance_for_all_account_account_datev_id`	Unknown	PKFK
`tax_rate`	Unknown

receipt_guidance_allowed_tax_rule

Column	Type	Keys
`id`	Unknown	PK
`receipt_guidance_for_all_account_account_datev_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown

receipt_guidance_allowed_receipt_type

Column	Type	Keys
`index`	Unknown	PK
`receipt_guidance_for_all_account_account_datev_id`	Unknown	PKFK
`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