Skip to main content

Peliqan

Try for free
Request a demo

Zenvoices

Average transaction amount

SQL query for Zenvoices

Calculate the average amount of transactions (booked and pending).

SELECT AVG(amount) FROM BookedTransactions UNION ALL SELECT AVG(amount) FROM PendingTransactions;

Try this query now in Zenvoices

Zenvoices data model

Zenvoices
Administrations

Zenvoices
Administration Details

Zenvoices
Financial Transactions

Zenvoices
Financial Transaction Details

Zenvoices
Users

Zenvoices
User Details

Zenvoices
Available Accountingsystem Connectors

Zenvoices
Webhook Subscriptions

Zenvoices
Available Webhooks

Zenvoices
Purchaseorders

Zenvoices
Products

Zenvoices
Employees

Zenvoices
Fiscalperiods

Zenvoices
Paymentconditions

Zenvoices
Commitments

Zenvoices
Projects

Zenvoices
Projectitems

Zenvoices
Projectstages

Zenvoices
Taxcodes

Zenvoices
Taxscenarios

Zenvoices
Currencies

Zenvoices
Costunits

Zenvoices
Costcentres

Zenvoices
Allocationcodes

Zenvoices
Ledgeraccounts

Zenvoices
Accounts

Zenvoices
Country

Zenvoices
Inbox

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed