money.usr_circulation_summary (view)
|
This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly. |
Columns
| Column | Type | Nullable | Notes |
|---|---|---|---|
usr |
|
Yes |
|
total_paid |
|
Yes |
|
total_owed |
|
Yes |
|
balance_owed |
|
Yes |
View Definition
SELECT billable_xact_summary.usr,
sum(billable_xact_summary.total_paid) AS total_paid,
sum(billable_xact_summary.total_owed) AS total_owed,
sum(billable_xact_summary.balance_owed) AS balance_owed
FROM money.billable_xact_summary
WHERE billable_xact_summary.xact_type = 'circulation'::name
GROUP BY billable_xact_summary.usr;