X-Git-Url: https://git.evergreen-ils.org/?p=working%2FEvergreen.git;a=blobdiff_plain;f=Open-ILS%2Fsrc%2Fsql%2FPg%2F200.schema.acq.sql;h=42414f37b7b011751dff0072929de83a6681d75a;hp=ad7880996c8b7904ec54b97ec059a5528dc19bfc;hb=b02d411ffd335a646d0f597fde8740b34bfa4f55;hpb=ee5ad1cf9327e8a06c800bfe506ad388a5e8b3d5 diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index ad7880996c..42414f37b7 100644 --- 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), - actual_cost NUMERIC(8,2) + actual_cost NUMERIC(8,2), + fund INT REFERENCES acq.fund (id) + DEFERRABLE INITIALLY DEFERRED ); -- Patron requests