aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_transactions_folio_item_change
Parameters
Name
Type
Mode
Definition
BEGIN IF (NEW.folio_id IS NULL) OR (TG_OP = 'UPDATE') THEN NEW.folio_id := (SELECT folio_id FROM folio_items WHERE item_id = NEW.folio_item); END IF; RETURN NEW; END