visma e-conomic data model
Accounts
View 13 columns
NameString
BarredBoolean
BalanceNumber
AccountTypeString
DebitCreditString
DraftBalanceNumber
AccountNumberInteger
AccountsSummedArray
AccountingYearsString
BlockDirectEntriesBoolean
VatAccount_vatCodeString
ContraAccount_accountNumberInteger
TotalFromAccount_accountNumberInteger
Customers
View 38 columns
EanString
ZipString
CityString
NameString
EmailString
BarredBoolean
AddressString
BalanceNumber
CountryString
PNumberString
WebsiteString
ContactsString
CurrencyString
DueAmountNumber
VatNumberString
CreditLimitNumber
LastUpdatedDate-time
MobilePhoneString
Totals_bookedString
Totals_draftsString
CustomerNumberInteger
Invoices_bookedString
Invoices_draftsString
DeliveryLocationsString
PublicEntryNumberString
Templates_invoiceString
Layout_layoutNumberInteger
TelephoneAndFaxNumberString
Templates_invoiceLineString
VatZone_vatZoneNumberInteger
SalesPerson_employeeNumberInteger
EInvoicingDisabledByDefaultBoolean
CorporateIdentificationNumberString
Attention_customerContactNumberInteger
PaymentTerms_paymentTermsNumberInteger
CustomerGroup_customerGroupNumberInteger
CustomerContact_customerContactNumberInteger
DefaultDeliveryLocation_deliveryLocationNumberInteger
Customer Groups
View 13 columns
NameString
CustomersString
Layout_nameString
Account_nameString
Layout_deletedBoolean
Account_balanceNumber
Account_accountTypeString
Account_debitCreditString
CustomerGroupNumberInteger
Layout_layoutNumberInteger
Account_accountNumberInteger
Account_accountingYearsString
Account_blockDirectEntriesBoolean
Journals
View 12 columns
NameString
EntriesString
VouchersString
JournalNumberInteger
Templates_financeVoucherString
Settings_entryTypeRestrictedToString
Templates_manualCustomerInvoiceString
Settings_voucherNumbers_maximumVoucherNumberInteger
Settings_voucherNumbers_minimumVoucherNumberInteger
Settings_contraAccounts_financeVouchers_accountNumberInteger
Settings_contraAccounts_customerPayments_accountNumberInteger
Settings_contraAccounts_supplierPayments_accountNumberInteger
Invoices Sent
View 9 columns
IdInteger
SendByString
StatusString
CreatedByString
CreationDateDate-time
Recipient_eanString
Recipient_nameString
Recipient_mobilePhoneString
Invoice_bookedInvoiceNumberInteger
Invoices Paid
View 45 columns
DateDate-time
SentString
DueDateDate-time
CurrencyString
NetAmountNumber
RemainderNumber
VatAmountNumber
GrossAmountNumber
Delivery_zipString
Pdf_downloadString
Delivery_cityString
Notes_headingString
Recipient_cvrString
Recipient_eanString
Recipient_zipString
Recipient_cityString
Recipient_nameString
RoundingAmountNumber
Notes_textLine1String
Notes_textLine2String
Delivery_addressString
Delivery_countryString
References_otherString
PaymentTerms_nameString
Recipient_addressString
Recipient_countryString
BookedInvoiceNumberInteger
Layout_layoutNumberInteger
Delivery_deliveryDateDate-time
Project_projectNumberInteger
Delivery_deliveryTermsString
Customer_customerNumberInteger
NetAmountInBaseCurrencyNumber
RemainderInBaseCurrencyNumber
PaymentTerms_daysOfCreditInteger
Recipient_publicEntryNumberString
PaymentTerms_paymentTermsTypeString
PaymentTerms_paymentTermsNumberInteger
Recipient_vatZone_vatZoneNumberInteger
References_salesPerson_employeeNumberInteger
DeliveryLocation_deliveryLocationNumberInteger
Recipient_attention_customerContactNumberInteger
References_vendorReference_employeeNumberInteger
References_customerContact_customerContactNumberInteger
References_customerContact_customer_customerNumberInteger
Orders Sent
View 49 columns
DateDate-time
DueDateDate-time
CurrencyString
NetAmountNumber
VatAmountNumber
GrossAmountNumber
LastUpdatedDate-time
OrderNumberInteger
Delivery_zipString
ExchangeRateNumber
Pdf_downloadString
Delivery_cityString
Notes_headingString
Recipient_cvrString
Recipient_eanString
Recipient_zipString
Recipient_cityString
Recipient_nameString
RoundingAmountNumber
Notes_textLine1String
Notes_textLine2String
Delivery_addressString
Delivery_countryString
MarginPercentageNumber
References_otherString
PaymentTerms_nameString
Recipient_addressString
Recipient_countryString
Soap_orderHandle_idInteger
MarginInBaseCurrencyNumber
Delivery_deliveryDateDate-time
Project_projectNumberInteger
Delivery_deliveryTermsString
CostPriceInBaseCurrencyNumber
Customer_customerNumberInteger
NetAmountInBaseCurrencyNumber
GrossAmountInBaseCurrencyNumber
PaymentTerms_daysOfCreditInteger
Recipient_publicEntryNumberString
PaymentTerms_paymentTermsTypeString
Templates_upgradeInstructionsString
PaymentTerms_paymentTermsNumberInteger
Recipient_vatZone_vatZoneNumberInteger
References_salesPerson_employeeNumberInteger
DeliveryLocation_deliveryLocationNumberInteger
Recipient_attention_customerContactNumberInteger
References_vendorReference_employeeNumberInteger
References_customerContact_customerContactNumberInteger
References_customerContact_customer_customerNumberInteger
Orders Drafts
View 49 columns
DateDate-time
DueDateDate-time
CurrencyString
NetAmountNumber
VatAmountNumber
GrossAmountNumber
LastUpdatedDate-time
OrderNumberInteger
Delivery_zipString
ExchangeRateNumber
Pdf_downloadString
Delivery_cityString
Notes_headingString
Recipient_cvrString
Recipient_eanString
Recipient_zipString
Recipient_cityString
Recipient_nameString
RoundingAmountNumber
Notes_textLine1String
Notes_textLine2String
Delivery_addressString
Delivery_countryString
MarginPercentageNumber
References_otherString
PaymentTerms_nameString
Recipient_addressString
Recipient_countryString
Soap_orderHandle_idInteger
MarginInBaseCurrencyNumber
Delivery_deliveryDateDate-time
Project_projectNumberInteger
Delivery_deliveryTermsString
CostPriceInBaseCurrencyNumber
Customer_customerNumberInteger
NetAmountInBaseCurrencyNumber
GrossAmountInBaseCurrencyNumber
PaymentTerms_daysOfCreditInteger
Recipient_publicEntryNumberString
PaymentTerms_paymentTermsTypeString
Templates_upgradeInstructionsString
PaymentTerms_paymentTermsNumberInteger
Recipient_vatZone_vatZoneNumberInteger
References_salesPerson_employeeNumberInteger
DeliveryLocation_deliveryLocationNumberInteger
Recipient_attention_customerContactNumberInteger
References_vendorReference_employeeNumberInteger
References_customerContact_customerContactNumberInteger
References_customerContact_customer_customerNumberInteger
Account Entries
View 26 columns
DateDate-time
TextString
AmountNumber
DueDateDate-time
CurrencyString
EntryTypeString
Quantity1Number
Quantity2Number
RemainderNumber
EntryNumberInteger
InvoiceNumberString
VoucherNumberInteger
Unit1_unitNumberInteger
Unit2_unitNumberInteger
VatAccount_vatCodeString
AmountInBaseCurrencyNumber
Account_accountNumberInteger
Project_projectNumberInteger
SupplierInvoiceNumberString
CostType_costTypeNumberInteger
Customer_customerNumberInteger
RemainderInBaseCurrencyNumber
Supplier_supplierNumberInteger
BookedInvoice_bookedInvoiceNumberInteger
PaymentDetails_paymentType_paymentTypeNumberInteger
DepartmentalDistribution_departmentalDistributionNumberInteger
Products
Invoices Unpaid
Invoices Overdue
Invoices Booked
Invoices Booked Lines
Orders Sent Lines
Orders Drafts Lines
Orders Archived
Orders Archived Lines
Vouchers
Journal Entries
Accounting Years
Suppliers
Booked Entries
Draft Entries
Built with enterprise-grade security and compliance.
One platform instead of a data stack
ELT, a built-in warehouse, transformations, reverse ETL and an MCP endpoint in one governed place.
- 14-day free trial
- No credit card needed