acq.all_fund_spent_balance (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

Column	Type	Nullable	Notes
fund	`integer`	Yes
amount	`numeric`	Yes

fund

integer

Yes

amount

numeric

Yes

View Definition

 SELECT c.fund,
    c.amount - d.amount AS amount
   FROM acq.all_fund_allocation_total c
     LEFT JOIN acq.all_fund_spent_total d USING (fund);