e-conomic

Explore the interactive ERD

Table & Field Reference

customer_template_invoice

Column	Type	Keys
`customer_number`	Unknown	PKFK
`delivery_location_number`	Unknown	FK
`currency`	Unknown
`date`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`recipientcustomer_contact_number`	Unknown
`recipientself`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown

app_setting_user

Column	Type	Keys
`setting_key`	Unknown	PK
`content`	Unknown
`self`	Unknown

app_setting_agreement

Column	Type	Keys
`setting_key`	Unknown	PKFK
`content`	Unknown
`self`	Unknown

employee

Column	Type	Keys
`employee_number`	Unknown	PK
`barred`	Unknown
`booked_invoices`	Unknown
`customers`	Unknown
`draft_invoices`	Unknown
`email`	Unknown
`group_number`	Unknown
`name`	Unknown
`phone`	Unknown
`self`	Unknown

accounting_year_period

Column	Type	Keys
`period_number`	Unknown	PK
`closed`	Unknown
`entries`	Unknown
`from_date`	Unknown
`self`	Unknown
`to_date`	Unknown
`totals`	Unknown
`year`	Unknown

required_module

Column	Type	Keys
`module_number`	Unknown	PK
`app_role_role_number`	Unknown	PKFK
`self`	Unknown

app_role

Column	Type	Keys
`role_number`	Unknown	PK
`name`	Unknown

journal_entry

Column	Type	Keys
`journal_entry_number`	Unknown	PK
`journal_number`	Unknown	PKFK
`account_number`	Unknown	FK
`customer_number`	Unknown	FK
`departmental_distribution_number`	Unknown	FK
`employee_number`	Unknown	FK
`payment_type_number`	Unknown	FK
`supplier_number`	Unknown	FK
`unit_1_number`	Unknown	FK
`unit_2_number`	Unknown	FK
`voucher_accounting_year`	Unknown	FK
`amount`	Unknown
`amount_default_currency`	Unknown
`contra_vat_account_code`	Unknown
`contra_vat_account_self`	Unknown
`contra_vat_amount`	Unknown
`contra_vat_amount_in_base_currency`	Unknown
`cost_type_number`	Unknown
`cost_type_self`	Unknown
`currency_code`	Unknown
`currency_self`	Unknown
`customer_invoice`	Unknown
`date`	LocalDate
`due_date`	LocalDate
`entry_type`	Unknown
`exchange_rate`	Unknown
`project_number`	Unknown
`project_self`	Unknown
`quantity_1`	Unknown
`quantity_2`	Unknown
`remainder`	Unknown
`remainder_in_default_currency`	Unknown
`self`	Unknown
`supplier_invoice_number`	Unknown
`template_account`	Unknown
`template_account_and_contra_account`	Unknown
`template_contra_account`	Unknown
`template_contra_payment`	Unknown
`text`	Unknown
`voucher_number`	Unknown
`voucher_self`	Unknown

journal

Column	Type	Keys
`journal_number`	Unknown	PK
`entries`	Unknown
`maximum_voucher_number`	Unknown
`minimum_voucher_number`	Unknown
`name`	Unknown
`self`	Unknown
`vouchers`	Unknown

journal_customer_invoice

Column	Type	Keys
`customer_number`	Unknown	PKFK
`journal_journal_number`	Unknown	PKFK
`self`	Unknown

accounting_year

Column	Type	Keys
`year`	Unknown	PK
`closed`	Unknown
`entries`	Unknown
`from_date`	Unknown
`periods`	Unknown
`self`	Unknown
`to_date`	Unknown
`totals`	Unknown
`vouchers`	Unknown

supplier

Column	Type	Keys
`supplier_number`	Unknown	PK
`layout_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`supplier_group_number`	Unknown	FK
`vat_zone_number`	Unknown	FK
`account_number`	Unknown
`address`	Unknown
`bank_account`	Unknown
`city`	Unknown
`contacts`	Unknown
`corporate_identification_number`	Unknown
`creditor_id`	Unknown
`currency`	Unknown
`default_invoice_text`	Unknown
`employee_number`	Unknown
`name`	Unknown
`phone`	Unknown
`self`	Unknown
`supplier_contact_number`	Unknown
`zip`	Unknown

currency

Column	Type	Keys
`code`	Unknown	PK
`iso_number`	Unknown
`name`	Unknown
`self`	Unknown

product_group

Column	Type	Keys
`product_group_number`	Unknown	PK
`account_number`	Unknown	FK
`name`	Unknown
`products`	Unknown
`sales_accounts`	Unknown
`self`	Unknown

order_archived

Column	Type	Keys
`order_number`	Unknown	PK
`customer_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`attentioncustomer_contact_number`	Unknown
`attentionself`	Unknown
`cost_price_in_base_currency`	Unknown
`currency`	Unknown
`date`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`gross_amount`	Unknown
`gross_amount_in_base_currency`	Unknown
`heading`	Unknown
`margin_in_base_currency`	Unknown
`margin_percentage`	Unknown
`net_amount`	Unknown
`net_amount_in_base_currency`	Unknown
`project_number`	Unknown
`recipient_address`	Unknown
`recipient_city`	Unknown
`recipient_country`	Unknown
`recipient_cvr`	Unknown
`recipient_ean`	Unknown
`recipient_name`	Unknown
`recipient_nem_handel_type`	Unknown
`recipient_public_entry_number`	Unknown
`recipient_zip`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`rounding_amount`	Unknown
`sales_personemployee_number`	Unknown
`sales_personself`	Unknown
`self`	Unknown
`sent`	Unknown
`soapid`	Unknown
`text_line_1`	Unknown
`text_line_2`	Unknown
`vat_amount`	Unknown
`vendoremployee_number`	Unknown
`vendorself`	Unknown

product

Column	Type	Keys
`product_number`	Unknown	PK
`departmental_distribution_number`	Unknown	FK
`product_group_number`	Unknown	FK
`unit_number`	Unknown	FK
`available`	Unknown
`bar_code`	Unknown
`barred`	Unknown
`cost_price`	Unknown
`distribution_type`	Unknown
`gross_weight`	Unknown
`in_stock`	Unknown
`invoices_booked`	Unknown
`invoices_drafts`	Unknown
`invoices_self`	Unknown
`last_updated`	Unknown
`name`	Unknown
`net_weight`	Unknown
`ordered_by_customers`	Unknown
`ordered_from_suppliers`	Unknown
`package_volume`	Unknown
`recommended_cost_price`	Unknown
`recommended_price`	Unknown
`sales_price`	Unknown
`self`	Unknown

invoice_booked_line

Column	Type	Keys
`line_number`	Unknown	PK
`booked_invoice_number`	Unknown	PKFK
`departmental_distribution_number`	Unknown	FK
`product_number`	Unknown	FK
`unit_number`	Unknown	FK
`delivery_date`	LocalDate
`description`	Unknown
`discount_percentage`	Unknown
`quantity`	Unknown
`sort_key`	Unknown
`total_net_amount`	Unknown
`unit_cost_price`	Unknown
`unit_net_price`	Unknown
`vat_amount`	Unknown
`vat_rate`	Unknown

invoice_booked

Column	Type	Keys
`booked_invoice_number`	Unknown	PK
`customer_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`attentioncustomer_contact_number`	Unknown
`attentionself`	Unknown
`currency`	Unknown
`date`	LocalDate
`due_date`	LocalDate
`exchange_rate`	Unknown
`gross_amount`	Unknown
`gross_amount_in_base_currency`	Unknown
`heading`	Unknown
`net_amount`	Unknown
`net_amount_in_base_currency`	Unknown
`project_number`	Unknown
`recipient_address`	Unknown
`recipient_city`	Unknown
`recipient_country`	Unknown
`recipient_cvr`	Unknown
`recipient_ean`	Unknown
`recipient_name`	Unknown
`recipient_nem_handel_type`	Unknown
`recipient_public_entry_number`	Unknown
`recipient_zip`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`rounding_amount`	Unknown
`sales_personemployee_number`	Unknown
`sales_personself`	Unknown
`self`	Unknown
`sent`	Unknown
`text_line_1`	Unknown
`text_line_2`	Unknown
`vat_amount`	Unknown
`vendoremployee_number`	Unknown
`vendorself`	Unknown

payment_term

Column	Type	Keys
`payment_terms_number`	Unknown	PK
`cardcustomer_number`	Unknown
`cardself`	Unknown
`days_of_credit`	Unknown
`name`	Unknown
`payment_terms_type`	Unknown
`percentage_for_prepaid_amount`	Unknown
`percentage_for_remainder_amount`	Unknown
`prepaidaccount_number`	Unknown
`prepaidself`	Unknown
`remainderaccount_number`	Unknown
`remainderself`	Unknown
`self`	Unknown

customer_template_invoice_line

Column	Type	Keys
`product_number`	Unknown	PK
`customer_number`	Unknown	PKFK
`description`	Unknown
`self`	Unknown

accounting_year_period_entry

Column	Type	Keys
`entry_number`	Unknown	PK
`accounting_year_period_period_number`	Unknown	PKFK
`accounting_year_year`	Unknown	PKFK
`account_number`	Unknown	FK
`booked_invoice_number`	Unknown	FK
`departmental_distribution_number`	Unknown	FK
`payment_type_number`	Unknown	FK
`supplier_number`	Unknown	FK
`unit_1_number`	Unknown	FK
`unit_2_number`	Unknown	FK
`vat_code`	Unknown	FK
`amount`	Unknown
`amount_in_base_currency`	Unknown
`cost_type_number`	Unknown
`currency`	Unknown
`customer`	Unknown
`date`	Unknown
`due_date`	Unknown
`entry_type`	Unknown
`invoice_number`	Unknown
`project_number`	Unknown
`quantity_1`	Unknown
`quantity_2`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`self`	Unknown
`supplier_invoice_number`	Unknown
`text`	Unknown
`voucher_number`	Unknown

invoice_draft

Column	Type	Keys
`draft_invoice_number`	Unknown	PK
`customer_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`attentioncustomer_contact_number`	Unknown
`attentionself`	Unknown
`cost_price_in_base_currency`	Unknown
`currency`	Unknown
`date`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`gross_amount`	Unknown
`gross_amount_in_base_currency`	Unknown
`heading`	Unknown
`margin_in_base_currency`	Unknown
`margin_percentage`	Unknown
`net_amount`	Unknown
`net_amount_in_base_currency`	Unknown
`project_number`	Unknown
`recipient_address`	Unknown
`recipient_city`	Unknown
`recipient_country`	Unknown
`recipient_cvr`	Unknown
`recipient_ean`	Unknown
`recipient_name`	Unknown
`recipient_nem_handel_type`	Unknown
`recipient_public_entry_number`	Unknown
`recipient_zip`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`rounding_amount`	Unknown
`sales_personemployee_number`	Unknown
`sales_personself`	Unknown
`self`	Unknown
`sent`	Unknown
`soapid`	Unknown
`text_line_1`	Unknown
`text_line_2`	Unknown
`vat_amount`	Unknown
`vendoremployee_number`	Unknown
`vendorself`	Unknown

customer_contact

Column	Type	Keys
`contact_number`	Unknown	PK
`customer_number`	Unknown
`deleted`	Unknown
`e_invoice_id`	Unknown
`email`	Unknown
`email_notifications`	Json
`name`	Unknown
`notes`	Unknown
`phone`	Unknown
`self`	Unknown
`sort_key`	Unknown

vat_zone

Column	Type	Keys
`vat_zone_number`	Unknown	PK
`enabled_for_customer`	Unknown
`enabled_for_supplier`	Unknown
`name`	Unknown
`self`	Unknown

product_sales_price

Column	Type	Keys
`price`	Unknown	PK
`currency_code`	Unknown	FK
`product_number`	Unknown	FK
`self`	Unknown

layout

Column	Type	Keys
`layout_number`	Unknown	PK
`deleted`	Unknown
`name`	Unknown
`self`	Unknown

payment_type

Column	Type	Keys
`payment_type_number`	Unknown	PK
`name`	Unknown
`self`	Unknown

unit

Column	Type	Keys
`unit_number`	Unknown	PK
`name`	Unknown
`products`	Unknown
`self`	Unknown

customer_group

Column	Type	Keys
`customer_group_number`	Unknown	PK
`account_number`	Unknown	FK
`customers`	Unknown
`layout_number`	Unknown
`name`	Unknown
`self`	Unknown

vat_account

Column	Type	Keys
`vat_code`	Unknown	PK
`vat_type_number`	Unknown	FK
`account_number`	Unknown
`barred`	Unknown
`name`	Unknown
`rate_percentage`	Unknown
`self`	Unknown

customer_location

Column	Type	Keys
`customer_number`	Unknown	PK
`delivery_location_number`	Unknown	PK
`address`	Unknown
`barred`	Unknown
`city`	Unknown
`country`	Unknown
`postal_code`	Unknown
`self`	Unknown
`sort_key`	Unknown
`terms_of_delivery`	Unknown

department

Column	Type	Keys
`department_number`	Unknown	PK
`percentage`	Unknown
`self`	Unknown

department_distribution

Column	Type	Keys
`departmental_distribution_number`	Unknown	PK
`barred`	Unknown
`distribution_type`	Unknown
`name`	Unknown
`self`	Unknown

order_draft

Column	Type	Keys
`order_number`	Unknown	PK
`customer_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`attentioncustomer_contact_number`	Unknown
`attentionself`	Unknown
`cost_price_in_base_currency`	Unknown
`currency`	Unknown
`date`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`gross_amount`	Unknown
`gross_amount_in_base_currency`	Unknown
`heading`	Unknown
`margin_in_base_currency`	Unknown
`margin_percentage`	Unknown
`net_amount`	Unknown
`net_amount_in_base_currency`	Unknown
`project_number`	Unknown
`recipient_address`	Unknown
`recipient_city`	Unknown
`recipient_country`	Unknown
`recipient_cvr`	Unknown
`recipient_ean`	Unknown
`recipient_name`	Unknown
`recipient_nem_handel_type`	Unknown
`recipient_public_entry_number`	Unknown
`recipient_zip`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`rounding_amount`	Unknown
`sales_personemployee_number`	Unknown
`sales_personself`	Unknown
`self`	Unknown
`sent`	Unknown
`soapid`	Unknown
`text_line_1`	Unknown
`text_line_2`	Unknown
`vat_amount`	Unknown
`vendoremployee_number`	Unknown
`vendorself`	Unknown

vat_type

Column	Type	Keys
`vat_type_number`	Unknown	PK
`name`	Unknown
`self`	Unknown

order_sent

Column	Type	Keys
`order_number`	Unknown	PK
`customer_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`attentioncustomer_contact_number`	Unknown
`attentionself`	Unknown
`cost_price_in_base_currency`	Unknown
`currency`	Unknown
`date`	Unknown
`due_date`	Unknown
`exchange_rate`	Unknown
`gross_amount`	Unknown
`gross_amount_in_base_currency`	Unknown
`heading`	Unknown
`margin_in_base_currency`	Unknown
`margin_percentage`	Unknown
`net_amount`	Unknown
`net_amount_in_base_currency`	Unknown
`project_number`	Unknown
`recipient_address`	Unknown
`recipient_city`	Unknown
`recipient_country`	Unknown
`recipient_cvr`	Unknown
`recipient_ean`	Unknown
`recipient_name`	Unknown
`recipient_nem_handel_type`	Unknown
`recipient_public_entry_number`	Unknown
`recipient_zip`	Unknown
`referencescustomer_contact_number`	Unknown
`referencesself`	Unknown
`remainder`	Unknown
`remainder_in_base_currency`	Unknown
`rounding_amount`	Unknown
`sales_personemployee_number`	Unknown
`sales_personself`	Unknown
`self`	Unknown
`sent`	Unknown
`soapid`	Unknown
`text_line_1`	Unknown
`text_line_2`	Unknown
`vat_amount`	Unknown
`vendoremployee_number`	Unknown
`vendorself`	Unknown

invoice_sent

Column	Type	Keys
`id`	Unknown	PK
`booked_invoice_number`	Unknown	FK
`created_by`	Unknown
`creation_date`	Unknown
`recipient_ean`	Unknown
`recipient_mobile_phone`	Unknown
`recipient_name`	Unknown
`self`	Unknown
`send_by`	Unknown
`status`	Unknown

supplier_group

Column	Type	Keys
`supplier_group_number`	Unknown	PK
`account_number`	Unknown	FK
`name`	Unknown
`self`	Unknown

account

Column	Type	Keys
`account_number`	Unknown	PK
`account_type`	Unknown
`accounting_years`	Unknown
`balance`	Unknown
`barred`	Unknown
`block_direct_entries`	Unknown
`contra_account_account_number`	Unknown
`contra_account_self`	Unknown
`debit_credit`	Unknown
`draft_balance`	Unknown
`from_account_number`	Json
`name`	Unknown
`self`	Unknown
`to_account_number`	Json
`total_from_account_account_number`	Unknown
`total_from_account_self`	Unknown
`vat_code`	Unknown

customer

Column	Type	Keys
`number`	Unknown	PK
`customer_contact_number`	Unknown	FK
`delivery_location_number`	Unknown	FK
`employee_number`	Unknown	FK
`group_number`	Unknown	FK
`layout_number`	Unknown	FK
`payment_terms_number`	Unknown	FK
`vat_zone_number`	Unknown	FK
`attention_contact_number`	Unknown
`balance`	Unknown
`barred`	Unknown
`contacts`	Unknown
`corporate_identification_number`	Unknown
`credit_limit`	Unknown
`currency`	Unknown
`due_amount`	Unknown
`e_invoicing_disabled_by_default`	Unknown
`ean`	Unknown
`last_updated`	Unknown
`p_number`	Unknown
`public_entry_number`	Unknown
`self`	Unknown
`telephone_and_fax_number`	Unknown
`templates_invoice`	Unknown
`templates_invoice_line`	Unknown
`totals_booked`	Unknown
`totals_drafts`	Unknown
`totals_self`	Unknown
`vat_number`	Unknown
`website`	Unknown