Add fund column to acq.invoice_item.

[working/Evergreen.git] / Open-ILS / src / sql / Pg / 200.schema.acq.sql

diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql
index ad78809..42414f3 100644 (file)
--- a/Open-ILS/src/sql/Pg/200.schema.acq.sql
+++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql
@@ -825,7 +825,9 @@ CREATE TABLE acq.invoice_item ( -- for invoice-only debits: taxes/fees/non-bib i
     author          TEXT,
     note            TEXT,
     cost_billed     NUMERIC(8,2),
     author          TEXT,
     note            TEXT,
     cost_billed     NUMERIC(8,2),

-    actual_cost     NUMERIC(8,2)
+    actual_cost     NUMERIC(8,2),
+       fund            INT         REFERENCES acq.fund (id)
+                                   DEFERRABLE INITIALLY DEFERRED

 );
 
 -- Patron requests
 );
 
 -- Patron requests