Total amount of outstanding debtor transactions
SQL query for Uniconta
Calculate the total amount of outstanding debtor transactions.
SELECT SUM(AmountCur) FROM DebtorTransOpenClient
Uniconta data model
Bank Import Format Client
Bank Statement
Bank Statement Line Client
Company Finance Year Client
Company Number Client
Company S M T P Client
Creditor Client
Creditor Payment Format Client
Creditor Trans Client
Creditor Trans Open Client
D C Previous Address Client
Debtor Client
Debtor Invoice Client
Debtor Invoice Lines
Debtor Layout Group Client
Debtor Order Client
Debtor Order Line Client
Debtor Trans Client
Debtor Trans Open Client
Document Folder Client
G L Account Client
G L Budget Client
G L Budget Line Client
G L Charge Group Client
G L Daily Journal Client
G L Daily Journal Posted Client
G L Dim Type Client
G L Report Line Client
G L Report Template Client
G L Trans Client
G L Trans Deleted Client
G L Trans Type Client
G L Vat Client
Inv Item Client
Inv Item Storage Client
Inv Journal Client
Inv Journal Posted Client
Inv Trans Client
Number Serie Client
Pr Category Client
Pr Standard Client
Pr Type Client
Project Budget Client
Project Budget Line Client
Project Client
Project Journal Client
Project Task Client
Project Trans Client
T M Approval Setup Client
T M Emp Calendar Client
T M Emp Calendar Line Client
T M Emp Calendar Setup Client
Table Fields Client
User Profile Client
User Profile Control Client
User Profile User Client
E Delivery Tag Type Client
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