aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_recalc_folio_balance
Parameters
Name
Type
Mode
folio_item
integer
IN
Definition
UPDATE folio_items fi SET balance = (SELECT sum(iif(t.tran_type = 'C', -t.amount, t.amount) * t.qty) FROM transactions t WHERE t.folio_item = $1 AND t.active) WHERE fi.item_id = $1 RETURNING balance;