Distribution formula fund rollover setting
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 200.schema.acq.sql
2013-03-13 Bill EricksonDistribution formula fund rollover setting
2013-03-13 Lebbeous Fogle-WeekleyAcq: Line item batch update API method
2013-03-13 Bill EricksonACQ lineitem order identifier SQL/IDL
2013-03-13 Bill EricksonExtract multiple like values from lineitem
2013-03-11 Bill EricksonDefault number of ACQ copies per provider
2012-08-01 Bill EricksonACQ lineitem summary moved to real DB view
2012-07-31 Lebbeous Fogle-WeekleyFinishing off rollover-without-money feature
2012-07-31 Mike RylanderAllow propagation of encumbrances without funds
2012-07-24 Bill EricksonAdd constraint to ACQ PO state value
2012-05-23 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
2012-05-21 Dan ScottMerge branch 'master' of git.evergreen-ils.org:Evergree...
2012-03-23 Lebbeous Fogle-WeekleyAcq: improve General Search's ability to find invoices
2012-03-19 Mike RylanderVandelay-based record matching and import for Acquisitions
2012-03-13 Bill EricksonACQ+Vandelay schema and IDL changes w/ upgrade script
2011-09-22 Bill EricksonStamped upgrade script for ACQ fund view repairs
2011-09-22 James FournieAddresses LP#800477 where some acq views calculate...
2011-08-29 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-29 Bill EricksonMerge branch 'template-toolkit-opac' of git.evergreen...
2011-08-25 Bill EricksonMerge branch 'master' of git.evergreen-ils.org:Evergree...
2011-08-25 Bill EricksonColumn to track ACQ copy (lineitem_detail) receiver
2011-04-18 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-18 gmcminor improvements to database object comments
2011-04-15 Mike RylanderMerge branch 'opac-tt-poc' of git+ssh://yeti.esilibrary...
2011-04-15 Mike RylanderMerge branch 'master' of git+ssh://yeti.esilibrary...
2011-04-14 ericksonrely on search_path to locate the extract_marc_field...
2010-11-02 gmcadd definition for UPC line item attribute
2010-11-02 gmcdon't break up title and author when ingesting acquisit...
2010-11-01 gmclet libraries allow funds to be overcommitted
2010-09-27 scottmk1. Turn some ints into bigints.
2010-09-22 scottmkIn acq.fund_transfer: drop the NOT NULL constraint...
2010-09-16 scottmkMake acq.provider_contact.name NOT NULL.
2010-08-16 atz0372 - acq.edi_message.vendacct
2010-08-04 mikerallow ACQ-driven ordering and claiming of serial items
2010-08-03 dbsCorrect DDL for creating a fresh schema - match upgrade...
2010-08-02 mikercreate correct primary key constraints for some view...
2010-07-06 mikerintegrate serial.unit by relaxing fkeys against asset...
2010-05-26 mikerafter nearly 280 schema updates, we had a little drift...
2010-05-21 mikerPatch from Jason Stephenson which adds "IF EXISTS"...
2010-05-18 scottmkFix a typo in a previous commit to the acq schema....
2010-05-17 scottmkTwo changes to acq.edi_message:
2010-05-13 phasefxfix syntax
2010-05-12 scottmkAdd purchase_order column to acq.edi_message.
2010-04-28 scottmkAdd a po_item column, pointing to acq.po_item, to acq...
2010-04-28 scottmkAdd keep_debits column to acq.cancel_reason.
2010-04-27 scottmkAdd acq.po_item table.
2010-04-16 ericksonadded column to indicate that an invoice is complete...
2010-04-09 senatorAcq: Improved invoice-linking and -viewing features...
2010-04-08 scottmkAdding amount_paid columns to acq.invoice_item, acq...
2010-04-08 scottmkAdd three columns to acq.invoice, plus a
2010-04-07 scottmkAdd fund column to acq.invoice_item.
2010-04-07 scottmkAdd boolean column "prorate" to acq.invoice_item_type.
2010-03-29 phasefxreorder these so that they work
2010-03-29 scottmkWhen propagating funds: propagate the balance_warning_p...
2010-03-25 mikercapture multiple values (on pg 8.4) of an attr def
2010-03-25 scottmkReplace acq.lineitem.claim_interval and acq.provider...
2010-03-25 scottmkCreate two tables in acq schema: claim_policy and claim...
2010-03-17 mikersyntax error in fkey cascade
2010-03-17 scottmkAdd four tables in acq schema: claim, claim_type, claim...
2010-03-11 scottmkAdd boolean column prepayment_required to acq.purchase_...
2010-03-11 scottmkAdded boolean column vendor_public to acq.lineitem_note...
2010-03-10 scottmkAdd "ON DELETE CASCADE" clauses to foreign keys pointing to
2010-03-09 scottmk1. Add estimated_unit_price column to acq.lineitem.
2010-03-08 scottmkAdd a cancel_reason column to acq.user_request, pointin...
2010-03-04 scottmkAdd a cancel_reason column to acq.lineitem_detail,...
2010-03-04 scottmkCreate new table acq.cancel_reason.
2010-03-04 scottmkAdd two columns, both intervals, both nullable:
2010-02-25 scottmkAdded five new views to the acq schema:
2010-02-24 scottmkCreated a new table acq.provider_note, similar to acq...
2010-02-24 scottmkAdd fax number, phone, url, email to certain provider...
2010-02-17 scottmkAdd a boolean column prepayment_required to acq.provider.
2010-02-16 mikerthese have been moved to the seed-data file
2010-02-16 mikerinitial invoicing schema
2010-02-15 phasefxmissing underscore in column name
2010-02-15 scottmkIn acq.lineitem_alert_text: add owning_lib column....
2010-02-12 scottmk1. New table, acq.lineitem_alert_text.
2010-02-10 mikerbackend to support collection of patron purchase reques...
2010-02-09 ericksonlineitem item_count was changed to a virtual field...
2010-02-09 senatorRecord applications of distribution formulas to lineite...
2010-02-08 scottmkAdd "active" column to acq.provider; bool not null...
2010-02-05 scottmkNew columns to acq.fund: balance_wqarning_percent and...
2010-02-05 scottmk1. Add two new columns to actor.org_unit: spend_warning...
2010-02-04 scottmkAdd a function acq.attribute_debits() to attribute...
2010-02-03 scottmk1. Back off the function acq.attribute_debits, along...
2010-02-02 scottmkAdd a function acq.transfer_fund to transfer money...
2010-02-02 scottmkAdd the acq.fund_allocation_percent table.
2010-02-02 scottmkAdd active flag to acq.fund table. If a fund is not...
2010-01-29 mikerthis papers over the transitional differences in XML...
2010-01-29 scottmkAdd machinery for attributing debits to funding source...
2010-01-28 scottmkOops: need to coalesce before summing, not after.
2010-01-27 scottmkRedefine the view acq.fund_debit_total:
2010-01-15 ericksonPatch from Joe Atzberger, with some IDL additions,...
2010-01-11 scottmkAdd a boolean "propagate" column to acq.fund, to denote...
2010-01-04 scottmkAdd a new column funding_source_credit to the acq.fund_...
2009-12-28 scottmkAdd new view acq.ordered_funding_source_credit, to...
2009-12-28 scottmkAdd an effective_date column to acq.funding_source_credit.
2009-12-23 scottmkAdd a boolean "rollover" column to acq.fund, to denote
2009-12-21 scottmkAdd new table acq.fund_transfer
2009-12-16 scottmkAdd a deadline_date column to acq.funding_source_credit
2009-12-15 scottmk1. Create a default entry in acq.fiscal_calendar.
2009-11-02 ericksonremoved reference to 'percent' on fund allocation....
next