E-conomic schema

20 tables

About the connector Start free

20 tables

Joins between these tables aren't mapped yet.

Loading diagram…

booked_invoices

draft_invoices

journals

accounting_years

5

fromDate

date

toDate

date

closed

boolean

year

string

_weld_synced

date

accounts

13

accountNumber

int

accountType

enum

balance

double

draftBalance

double

barred

boolean

blockDirectEntries

boolean

contraAccount_accountNumber

int

debitCredit

enum

booked_invoices

48

lines

array

invoiceNumber

int

invoiceType

string

date

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

booked_invoice_lines

15

invoiceNumber

double

lineNumber

double

sortKey

double

quantity

double

unitNetPrice

double

discountPercentage

double

unitCostPrice

double

vatRate

double

currencies

4

name

string

code

string

isoNumber

string

_weld_synced

date

customers

30

address

string

balance

double

barred

boolean

city

string

corporateIdentificationNumber

string

pNumber

string

country

string

creditLimit

double

dimension_values

6

dimension_number

double

key

double

name

string

active

boolean

object_version

string

_weld_synced

date

dimensions

5

number

double

name

string

active

boolean

object_version

string

_weld_synced

date

dimension_booked_entries

6

entry_number

double

dimension_number

double

dimension_key

double

is_distribution

boolean

object_version

string

_weld_synced

date

dimension_draft_entries

7

journal_number

double

entry_number

double

dimension_number

double

dimension_key

double

is_distribution

boolean

object_version

string

_weld_synced

date

draft_invoices

48

lines

array

invoiceNumber

int

invoiceType

string

date

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

draft_invoice_lines

15

invoiceNumber

double

lineNumber

double

sortKey

double

quantity

double

unitNetPrice

double

discountPercentage

double

unitCostPrice

double

vatRate

double

entries

27

account_accountNumber

int

amount

double

supplierInvoiceNumber

string

amountInBaseCurrency

double

currency

string

date

date

dueDate

date

departmentalDistribution_departmentalDistributionNumber

int

journals

9

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

34

account_accountNumber

int

journal_journalNumber

double

customer_customerNumber

int

customerInvoice

int

supplier_supplierNumber

int

supplierInvoiceNumber

string

paymentDetails_paymentType_paymentTypeNumber

int

dueDate

date

orders

49

lines

array

orderNumber

int

orderType

string

date

date

currency

string

exchangeRate

double

netAmount

double

netAmountInBaseCurrency

double

product_groups

16

productGroupNumber

int

name

string

inventoryEnabled

boolean

accrual_accountNumber

int

accrual_accountType

enum

accrual_balance

double

accrual_draftBalance

double

accrual_barred

boolean

products

38

productNumber

string

description

string

name

string

costPrice

double

recommendedPrice

double

salesPrice

double

barCode

string

barred

boolean

suppliers

24

address

string

attention_supplierContactNumber

int

bankAccount

string

barred

boolean

city

string

corporateIdentificationNumber

string

costAccount_accountNumber

int

country

string

vat_accounts

9

account_accountNumber

int

contraAccount_accountNumber

int

vatType_vatTypeNumber

int

vatType_name

string

barred

boolean

name

string

ratePercentage

double

vatCode

string

_weld_synced

date