Dataset catalog
Ready-made datasets for each connector. Add one as it is, or read its SQL and adapt it for a company.
e-conomic
Cash Position
Every cash movement on the bank, payment-provider and overdraft accounts, from posted entries and both legs of draft vouchers, with each account's kind, so gross cash, overdraft drawn and net cash can be told apart.
Chart of Accounts
Every account in the chart with its type, the chart's own section heading, a classifier guess for P&L accounts and the current balance.
Customers
The customer master with lifetime booked invoice count, last invoice date and gross invoiced per invoice currency.
Invoices
Booked sales invoices with customer, amounts in invoice currency, open remainder and payment status.
Ledger
Every posted entry and both legs of every draft voucher, with account name, type and chart section.
Monthly P&L
Monthly P&L by classifier section, from e-conomic's period totals.
Monthly Trial Balance
Month by month movement and closing balance for every P&L and balance-sheet account, from e-conomic's period totals.
Suppliers
The supplier master with open balance, payment terms and VAT zone.
VAT by Code
Posted base amounts and VAT per VAT code and month, with the code's rate, type and reverse-charge flag.
Add a template to a company
Templates marked Added when you connect are created for a company when it connects that source, and fill in after its first sync. To add one to a company that connected earlier, or any other template, ask an AI assistant on a Read/write MCP connection:
Add the e-conomic Cash Position view for Acme ApS.
The assistant checks that the company's data has every column the template reads before it creates anything, and leaves alone a view the company already has.
Adapt a template into your own view
- Open the template and read its SQL and AI context.
- Replace __SCHEMA__ with the company's schema, as the SQL workspace lists it, and change what your company needs.
- Save it as a view in the SQL workspace, as Datasets and SQL describes, or give it to your AI assistant to create.