ERD for E-conomic

14 tables

Loading diagram…

journals

name

string

settings_voucherNumbers_minimumVoucherNumber

int

settings_voucherNumbers_maximumVoucherNumber

int

settings_entryTypeRestrictedTo

enum

settings_contraAccounts_customerPayments_accountNumber

int

settings_contraAccounts_supplierPayments_accountNumber

int

settings_contraAccounts_financeVouchers_accountNumber

int

journalNumber

int

_weld_synced

date

journal_entries

account_accountNumber

int

journal_journalNumber

double

customer_customerNumber

int

customerInvoice

int

supplier_supplierNumber

int

supplierInvoiceNumber

string

paymentDetails_paymentType_paymentTypeNumber

int

dueDate

date

text

string

amount

double

contraAccount_accountNumber

int

vatAccount_vatCode

string

contraVatAccount_vatCode

string

contraVatAccount_ratePercentage

double

contraVatAmount

double

contraVatAmountInBaseCurrency

double

currency_code

string

date

departmentalDistribution_departmentalDistributionNumber

int

departmentalDistribution_distributionType

string

employee_employeeNumber

int

exchangeRate

double

entryType

enum

voucher_accountingYear_year

string

voucher_voucherNumber

double

amountDefaultCurrency

double

remainder

double

remainderDefaultCurrency

double

journalEntryNumber

int

quantity1

double

quantity2

double

unit1_unitNumber

int

unit2_unitNumber

int

customers

address

string

balance

double

barred

boolean

city

string

corporateIdentificationNumber

string

pNumber

string

country

string

creditLimit

double

currency

string

customerNumber

int

ean

string

lastUpdated

date

name

string

publicEntryNumber

string

telephoneAndFaxNumber

string

mobilePhone

string

eInvoicingDisabledByDefault

boolean

vatNumber

string

website

string

zip

string

defaultDeliveryLocation_deliveryLocationNumber

int

attention_customerContactNumber

int

customerContact_customerContactNumber

int

customerGroup_customerGroupNumber

int

layout_layoutNumber

int

paymentTerms_paymentTermsNumber

int

salesPerson_employeeNumber

int

vatZone_vatZoneNumber

int

_weld_synced

date

accounting_years

fromDate

date

toDate

date

closed

boolean

year

string

_weld_synced

date

booked_invoices

lines

array

invoiceNumber

int

invoiceType

string

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

grossAmount

double

grossAmountInBaseCurrency

double

vatAmount

double

roundingAmount

double

remainder

double

remainderInBaseCurrency

double

dueDate

date

paymentTerms_paymentTermsNumber

int

paymentTerms_daysOfCredit

int

paymentTerms_name

string

paymentTerms_paymentTermsType

enum

customer_customerNumber

int

recipient_name

string

recipient_address

string

recipient_zip

string

recipient_city

string

recipient_country

string

recipient_ean

string

recipient_publicEntryNumber

string

recipient_attention_customerContactNumber

int

recipient_vatZone_vatZoneNumber

int

recipient_cvr

string

deliveryLocation_deliveryLocationNumber

int

delivery_address

string

delivery_zip

string

delivery_city

string

delivery_country

string

delivery_deliveryTerms

string

delivery_deliveryDate

date

notes_heading

string

notes_textLine1

string

notes_textLine2

string

references_customerContact_customerContactNumber

int

references_customerContact_customer_customerNumber

int

references_salesPerson_employeeNumber

int

references_vendorReference_employeeNumber

int

references_other

string

layout_layoutNumber

int

project_projectNumber

int

_weld_synced

date

draft_invoices

lines

array

invoiceNumber

int

invoiceType

string

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

grossAmount

double

grossAmountInBaseCurrency

double

vatAmount

double

roundingAmount

double

remainder

double

remainderInBaseCurrency

double

dueDate

date

paymentTerms_paymentTermsNumber

int

paymentTerms_daysOfCredit

int

paymentTerms_name

string

paymentTerms_paymentTermsType

enum

customer_customerNumber

int

recipient_name

string

recipient_address

string

recipient_zip

string

recipient_city

string

recipient_country

string

recipient_ean

string

recipient_publicEntryNumber

string

recipient_attention_customerContactNumber

int

recipient_vatZone_vatZoneNumber

int

recipient_cvr

string

deliveryLocation_deliveryLocationNumber

int

delivery_address

string

delivery_zip

string

delivery_city

string

delivery_country

string

delivery_deliveryTerms

string

delivery_deliveryDate

date

notes_heading

string

notes_textLine1

string

notes_textLine2

string

references_customerContact_customerContactNumber

int

references_customerContact_customer_customerNumber

int

references_salesPerson_employeeNumber

int

references_vendorReference_employeeNumber

int

references_other

string

layout_layoutNumber

int

project_projectNumber

int

_weld_synced

date

suppliers

address

string

attention_supplierContactNumber

int

bankAccount

string

barred

boolean

city

string

corporateIdentificationNumber

string

costAccount_accountNumber

int

country

string

currency

string

defaultInvoiceText

string

layout_layoutNumber

int

name

string

paymentTerms_paymentTermsNumber

int

phone

string

remittanceAdvice_creditorId

string

remittanceAdvice_paymentType_paymentTypeNumber

int

salesPerson_employeeNumber

int

supplierContact_supplierContactNumber

int

supplierGroup_supplierGroupNumber

int

supplierNumber

int

vatZone_vatZoneNumber

int

zip

string

_weld_synced

date

vat_accounts

account_accountNumber

int

contraAccount_accountNumber

int

vatType_vatTypeNumber

int

vatType_name

string

barred

boolean

name

string

ratePercentage

double

vatCode

string

_weld_synced

date

orders

lines

array

orderNumber

int

orderType

string

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

grossAmount

double

grossAmountInBaseCurrency

double

marginInBaseCurrency

double

marginPercentage

double

vatAmount

double

roundingAmount

double

costPriceInBaseCurrency

double

dueDate

date

paymentTerms_paymentTermsNumber

int

paymentTerms_daysOfCredit

int

paymentTerms_name

string

paymentTerms_paymentTermsType

string

customer_customerNumber

int

recipient_name

string

recipient_address

string

recipient_zip

string

recipient_city

string

recipient_country

string

recipient_ean

string

recipient_publicEntryNumber

string

recipient_attention_customerContactNumber

int

recipient_vatZone_vatZoneNumber

int

recipient_cvr

string

deliveryLocation_deliveryLocationNumber

int

delivery_address

string

delivery_zip

string

delivery_city

string

delivery_country

string

delivery_deliveryTerms

string

delivery_deliveryDate

date

notes_heading

string

notes_textLine1

string

notes_textLine2

string

references_customerContact_customerContactNumber

int

references_customerContact_customer_customerNumber

int

references_salesPerson_employeeNumber

int

references_vendorReference_employeeNumber

int

references_other

string

project_projectNumber

int

soap_orderHandle_id

int

_weld_synced

date

products

productNumber

string

description

string

name

string

costPrice

double

recommendedPrice

double

salesPrice

double

barCode

string

barred

boolean

lastUpdated

date

inventory_available

double

inventory_inStock

double

inventory_orderedByCustomers

double

inventory_orderedFromSuppliers

double

inventory_packageVolume

double

inventory_grossWeight

double

inventory_netWeight

double

inventory_inventoryLastUpdated

date

inventory_recommendedCostPrice

double

unit_unitNumber

int

unit_name

string

productGroup_productGroupNumber

int

productGroup_name

string

productGroup_inventoryEnabled

boolean

productGroup_accrual_accountNumber

int

productGroup_accrual_accountType

enum

productGroup_accrual_balance

double

productGroup_accrual_draftBalance

double

productGroup_accrual_barred

boolean

productGroup_accrual_blockDirectEntries

boolean

productGroup_accrual_contraAccount_accountNumber

int

productGroup_accrual_debitCredit

enum

productGroup_accrual_name

string

productGroup_accrual_vatAccount_vatCode

string

productGroup_accrual_accountsSummed

string

productGroup_accrual_totalFromAccount_accountNumber

int

departmentalDistribution_departmentalDistributionNumber

int

departmentalDistribution_distributionType

string

_weld_synced

date

product_groups

productGroupNumber

int

name

string

inventoryEnabled

boolean

accrual_accountNumber

int

accrual_accountType

enum

accrual_balance

double

accrual_draftBalance

double

accrual_barred

boolean

accrual_blockDirectEntries

boolean

accrual_contraAccount_accountNumber

int

accrual_debitCredit

enum

accrual_name

string

accrual_vatAccount_vatCode

string

accrual_accountsSummed

string

accrual_totalFromAccount_accountNumber

int

_weld_synced

date

entries

account_accountNumber

int

amount

double

supplierInvoiceNumber

string

amountInBaseCurrency

double

currency

string

date

dueDate

date

departmentalDistribution_departmentalDistributionNumber

int

project_projectNumber

int

costType_costTypeNumber

int

entryNumber

int

text

string

entryType

enum

vatAccount_vatCode

string

customer_customerNumber

int

supplier_supplierNumber

int

unit1_unitNumber

int

unit2_unitNumber

int

quantity1

double

quantity2

double

voucherNumber

int

bookedInvoice_bookedInvoiceNumber

int

invoiceNumber

int

remainder

double

remainderInBaseCurrency

double

paymentDetails_paymentType_paymentTypeNumber

int

_weld_synced

date

currencies

name

string

code

string

isoNumber

string

_weld_synced

date

accounts

accountNumber

int

accountType

enum

balance

double

draftBalance

double

barred

boolean

blockDirectEntries

boolean

contraAccount_accountNumber

int

debitCredit

enum

name

string

vatAccount_vatCode

string

accountsSummed

string

totalFromAccount_accountNumber

int

_weld_synced

date

Table

Sub table