Let AI do the work for you
Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.
Total revenue by division
SQL query for Exact Online (Private app)
Calculate the total revenue for each division.
SELECT Divisions.Name, SUM(SalesInvoiceLines.Quantity * SalesInvoiceLines.Price) AS TotalRevenue FROM Divisions JOIN SalesInvoices ON Divisions.ID = SalesInvoices.DivisionID JOIN SalesInvoiceLines ON SalesInvoices.ID = SalesInvoiceLines.InvoiceID GROUP BY Divisions.Name
Exact Online (Private app) data model
Table Transactiontype
Name: StringNumber: Integer
Table Glaccounttype
Name: StringNumber: Integer
Table Entitytype
Name: StringNumber: Integer
Table Divisions
Table Accounts
Table Sales Invoice Lines
Table Items
Table Costunits
Table Addresses
Table Bank Accounts
Table Payment Conditions
Table G L Accounts
Table Sales Invoices
Table Purchase Invoices
Table Purchase Invoice Lines
Table G L Classifications
Table Reporting Balance
Table Purchase Entries
Table Sales Entries
Table Document Attachments
Table Documents
Table Transaction Lines
Table Financial Periods
Table G L Account Classification Mappings
Table Aging Payables List
Table Payables List
Table Goods Deliveries Sync
Table Goods Deliveries
Table Goods Delivery Lines
Table Goods Delivery Lines Sync
Table Sales Orders
Table Sales Order Lines
Table Aging Receivables List
Table Receivables List
Table Costcenters
Table Shop Orders
Table Workcenters
Table Time Transactions
Table Timed Time Transactions
Table Material Issues
Table Shop Order Routing Step Plans
Table Shop Order Material Plans
Table Purchase Orders
Table Purchase Order Lines
Table Warehouse Transfers
Table Warehouse Transfer Lines
Table Selection Codes
Table Account Classifications
Table Contacts
Table Cashflow Payments
Table Subscriptions
Table Subscription Lines
Table Subscription Types
Table Subscription Reason Codes
Table Receivables
Table Assets
Table Journals
Table Default Mailbox
Table Preferred Mailbox
Table Preferred Mailbox For Operation
Table Mailboxes
Table Mail Messages Sent
Table Mail Message Attachments
Table Opening Balance After Entry
Table Deleted
Table Account Classes
Table Account Classification Names
Table Projects
Table Project Classifications
Table Cost Transactions
Table Cost Types
Table W B S Expenses
Table Cash Entries
Table Cash Entry Lines
Table Batch Numbers
Table Item Warehouse Storage Locations
Table Goods Receipt Lines
Table G L Accounts Bulk
Table Account Owners
Table Account Involved Accounts
Table Involved User Roles
Table Involved Users
Table Bulk Sales Orders
Table Bulk Sales Order Lines
Table Bulk Sales Invoices
Table Bulk Sales Invoice Lines
Table Purchase Return Lines
Table Item Groups
Table Quotations
Table Quotation Lines
Table Stock Batch Numbers
Table V A T Codes
Table Banks
Table User Roles
Table User Roles Per Division
Table General Journal Entries
Table General Journal Entry Lines
Table Payment Terms
Table Events
Table Quotation Headers Sync
Table Quotation Lines Sync
Table Absence Registrations Sync
Table Absence Registration Transactions Sync
Table Leave Absence Hours By Day Sync
Table Leave Build Up Registrations Sync
Table Leave Registrations Sync
Table Schedule Entries Sync
Table Schedules Sync
Table Item Storage Locations Sync
Table Item Warehouses Sync
Table Serial Batch Numbers Sync
Table Stock Positions Sync
Table Stock Serial Batch Numbers Sync
Table Storage Location Stock Positions Sync
Table Purchase Item Prices Sync
Table Sales Item Prices Sync
Table Supplier Item Sync
Table Bill Of Material Materials Sync
Table Bill Of Material Versions Sync
Table Material Issues Sync
Table Shop Order Material Plans Sync
Table Shop Order Purchase Planning Sync
Table Shop Order Routing Step Plans Sync
Table Shop Orders Sync
Table Shop Order Sub Orders Sync
Table Bank Accounts Sync
Table Employees Sync
Table Employment C L As Sync
Table Employment Contracts Sync
Table Employment Organizations Sync
Table Employments Sync
Table Employment Salaries Sync
Table Employment Tax Authorities General Sync
Table Project Planning Sync
Table Projects Sync
Table Project W B S Sync
Table Time Cost Transactions Sync
Table Purchase Orders Sync
Table Sales Price List Volume Discounts Sync
Table Subscription Lines Sync
Table Subscriptions Sync
Table Sales Order Headers Sync
Table Contacts Sync
Table Item Sales Prices
Table X M L Item Sales Prices
Table X M L National Holidays
Table Active Employments
Table Assembly Orders
Table Budgets
Table Budget Scenarios
Table Communication Notes
Table Departments
Table Employment End Reasons
Table Employment Internal Rates
Table Employment Organizations
Table Employments
Table Employment Salaries
Table Exchange Rates
Table G L Transaction Types
Table Invoice Terms
Table Item Assortment
Table Item Assortment Property
Table Item Warehouse Planning Details
Table Item Warehouses
Table Job Groups
Table Job Titles
Table Lead Sources
Table Planned Sales Return Lines
Table Planned Sales Returns
Table Project Budget Types
Table Project Hour Budgets
Table Project Planning
Table Project Planning Recurring
Table Project Restriction Employees
Table Project Restriction Items
Table Project Restriction Rebillings
Table Sales Price List Linked Accounts
Table Sales Price List Periods
Table W B S Activities
Table W B S Deliverables
Table Sales Price Lists
Table Warehouses
Table Returns
Table Project W B S
Table Hour Cost Types
Table X M L Bill Of Materials
Magical SQL for Exact Online (Private app) with Peliqan.io
Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.
- Power BI
- Metabase
- Tableau
