egdb3_13_6
.auditor
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
audit_acq_invoice_item_func()
Parameters
Name
Type
Mode
IN
Definition
BEGIN INSERT INTO auditor.acq_invoice_item_history ( audit_id, audit_time, audit_action, audit_user, audit_ws, id, invoice, purchase_order, fund_debit, inv_item_type, title, author, note, cost_billed, actual_cost, fund, amount_paid, po_item, target ) SELECT nextval('auditor.acq_invoice_item_pkey_seq'), now(), SUBSTR(TG_OP,1,1), eg_user, eg_ws, OLD.id, OLD.invoice, OLD.purchase_order, OLD.fund_debit, OLD.inv_item_type, OLD.title, OLD.author, OLD.note, OLD.cost_billed, OLD.actual_cost, OLD.fund, OLD.amount_paid, OLD.po_item, OLD.target FROM auditor.get_audit_info(); RETURN NULL; END;