Total transactions amount
SQL query for Bank Transactions
Calculate the total amount of all transactions (booked and pending).
SELECT SUM(amount) FROM BookedTransactions UNION ALL SELECT SUM(amount) FROM PendingTransactions;
Bank Transactions data model
Booked Transactions
View 15 columns
ValueDateDate-time
DebtorNameString
BookingDateDate-time
CreditorNameString
TransactionIdString
DebtorAccount_ibanString
BankTransactionCodeString
CreditorAccount_ibanString
InternalTransactionIdString
DebtorAccount_currencyString
CreditorAccount_currencyString
TransactionAmount_amountDate-time
TransactionAmount_currencyString
ProprietaryBankTransactionCodeString
RemittanceInformationUnstructuredString
Pending Transactions
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