Exact Online

Total purchases per division

SQL query for Exact Online

Get the total purchases amount for each division.

SELECT Divisions.DivisionCode, SUM(PurchaseEntries.AmountFC) AS TotalPurchasesAmount FROM PurchaseEntries JOIN Divisions ON PurchaseEntries.Division = Divisions.ID GROUP BY Divisions.DivisionCode

Exact Online data model

Exact Online
Table Transactiontype
Name: String
Number: Integer

Exact Online
Table Glaccounttype
Name: String
Number: Integer

Exact Online
Table Entitytype
Name: String
Number: Integer

Exact Online
Table Sales Invoices

Exact Online
Table Sales Invoice Lines

Exact Online
Table Purchase Invoices

Exact Online
Table Purchase Invoice Lines

Exact Online
Table G L Accounts

Exact Online
Table G L Classifications

Exact Online
Table Reporting Balance

Exact Online
Table Costunits

Exact Online
Table Purchase Entries

Exact Online
Table Sales Entries

Exact Online
Table Document Attachments

Exact Online
Table Documents

Exact Online
Table Accounts

Exact Online
Table Transaction Lines

Exact Online
Table Financial Periods

Exact Online
Table G L Account Classification Mappings

Exact Online
Table Aging Payables List

Exact Online
Table Payables List

Exact Online
Table Divisions

Exact Online
Table Items

Exact Online
Table Goods Deliveries Sync

Exact Online
Table Goods Deliveries

Exact Online
Table Goods Delivery Lines

Exact Online
Table Goods Delivery Lines Sync

Exact Online
Table Sales Orders

Exact Online
Table Sales Order Lines

Exact Online
Table Addresses

Exact Online
Table Aging Receivables List

Exact Online
Table Receivables List

Exact Online
Table Costcenters

Exact Online
Table Shop Orders

Exact Online
Table Workcenters

Exact Online
Table Time Transactions

Exact Online
Table Timed Time Transactions

Exact Online
Table Material Issues

Exact Online
Table Shop Order Routing Step Plans

Exact Online
Table Shop Order Material Plans

Exact Online
Table Purchase Order Lines

Exact Online
Table Warehouse Transfers

Exact Online
Table Warehouse Transfer Lines

Exact Online
Table Selection Codes

Exact Online
Table Account Classifications

Exact Online
Table Contacts

Exact Online
Table Payments

Exact Online
Table Subscriptions

Exact Online
Table Subscription Lines

Exact Online
Table Subscription Types

Exact Online
Table Subscription Reason Codes

Exact Online
Table Receivables

Exact Online
Table Assets

Exact Online
Table Opening Balance After Entry

Exact Online
Table Deleted

Use SQL on all your SaaS data

Magical SQL for Exact Online 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.

Peliqan Ask AI willl write your SQL queries from plain English

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.