Exact Online

Balance by Financial Period

SQL query for Exact Online

Get the balance by financial period.

SELECT FinancialPeriods.Period, ReportingBalance.Balance FROM ReportingBalance JOIN FinancialPeriods ON ReportingBalance.FinancialPeriod = FinancialPeriods.Period

Exact Online data model

Exact Online
Table Transactiontype
Name: String
Number: Integer

Exact Online
Table Glaccounttype
Name: String
Number: Integer

Exact Online
Table Sales Invoices

Exact Online
Table Purchase Invoices

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

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.

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.

Peliqan Ask AI willl write your SQL queries from plain English