egdb3_12_9
.auditor
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
audit_acq_invoice_entry_func()
Parameters
Name
Type
Mode
IN
Definition
BEGIN INSERT INTO auditor.acq_invoice_entry_history ( audit_id, audit_time, audit_action, audit_user, audit_ws, id, invoice, purchase_order, lineitem, inv_item_count, phys_item_count, note, billed_per_item, cost_billed, actual_cost, amount_paid ) SELECT nextval('auditor.acq_invoice_entry_pkey_seq'), now(), SUBSTR(TG_OP,1,1), eg_user, eg_ws, OLD.id, OLD.invoice, OLD.purchase_order, OLD.lineitem, OLD.inv_item_count, OLD.phys_item_count, OLD.note, OLD.billed_per_item, OLD.cost_billed, OLD.actual_cost, OLD.amount_paid FROM auditor.get_audit_info(); RETURN NULL; END;