Add alternate serial content from Lebbeous.
authorRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Thu, 6 Jan 2011 19:59:42 +0000 (14:59 -0500)
committerRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Thu, 6 Jan 2011 19:59:42 +0000 (14:59 -0500)
41 files changed:
2.0/appendices/about_this_documentation.xml [new file with mode: 0644]
2.0/appendices/glossary.xml [new file with mode: 0644]
2.0/appendices/installchecklist.xml [new file with mode: 0644]
2.0/appendices/more_info.xml [new file with mode: 0644]
2.0/appendices/schema.xml [new file with mode: 0644]
2.0/intro/intro_intro.xml
2.0/media/batch-receive-apply.png [new file with mode: 0644]
2.0/media/batch-receive-autogen-1.png [new file with mode: 0644]
2.0/media/batch-receive-autogen-2.png [new file with mode: 0644]
2.0/media/batch-receive-choose-iss.png [new file with mode: 0644]
2.0/media/batch-receive-partial.png [new file with mode: 0644]
2.0/media/batch-receive-print-routing.png [new file with mode: 0644]
2.0/media/batch-receive-receive.png [new file with mode: 0644]
2.0/media/batch-receive-received.png [new file with mode: 0644]
2.0/media/batch-receive-simple.png [new file with mode: 0644]
2.0/media/caption-pattern-tab.png [new file with mode: 0644]
2.0/media/create-copy-template.png [new file with mode: 0644]
2.0/media/create-distrib.png [new file with mode: 0644]
2.0/media/create-iss-1.png [new file with mode: 0644]
2.0/media/create-iss-2.png [new file with mode: 0644]
2.0/media/create-many-streams.png [new file with mode: 0644]
2.0/media/create-sub.png [new file with mode: 0644]
2.0/media/distribs-to-streams.png [new file with mode: 0644]
2.0/media/find-copy-template-menu.png [new file with mode: 0644]
2.0/media/generated-iss-delete-dummy.png [new file with mode: 0644]
2.0/media/new-stream.png [new file with mode: 0644]
2.0/media/predict-how-many.png [new file with mode: 0644]
2.0/media/received-items-in-catalog.png [new file with mode: 0644]
2.0/media/routing-list-add.png [new file with mode: 0644]
2.0/media/routing-list-drag.png [new file with mode: 0644]
2.0/media/routing-list-manage.png [new file with mode: 0644]
2.0/media/save-scap.png [new file with mode: 0644]
2.0/media/scap-wiz-page-1.png [new file with mode: 0644]
2.0/media/scap-wiz-page-2.png [new file with mode: 0644]
2.0/media/scap-wiz-page-3.png [new file with mode: 0644]
2.0/media/scap-wiz-page-4.png [new file with mode: 0644]
2.0/media/start-from-catalog.png [new file with mode: 0644]
2.0/media/sub-details.png [new file with mode: 0644]
2.0/media/subscription-manage.png [new file with mode: 0644]
2.0/root.xml
2.0/stafftasks/alternate_serial_control.xml [new file with mode: 0644]

diff --git a/2.0/appendices/about_this_documentation.xml b/2.0/appendices/about_this_documentation.xml
new file mode 100644 (file)
index 0000000..eb3d7ba
--- /dev/null
@@ -0,0 +1,208 @@
+<?xml version='1.0' encoding='UTF-8'?>\r
+<appendix xmlns="http://docbook.org/ns/docbook" xmlns:xi="http://www.w3.org/2001/XInclude"\r
+xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="about_this_documentation">\r
+       <info>\r
+               <title>About this Documentation</title>\r
+       </info>\r
+       <section xml:id="aboutDIG">\r
+               <title>About the Documentation Interest Group (DIG)</title>\r
+               <para>The Evergreen DIG was established in May 2009 at the first Evergreen International Conference, where members of the Evergreen community committed to developing single-source, \r
+               standards-based documentation for Evergreen. Since then, the DIG has been actively working toward that goal.</para>\r
+               <table>\r
+                       <title>Evergreen DIG Participants</title>\r
+                       <tgroup align="left" cols="2" colsep="1" rowsep="1">\r
+                               <colspec colnum="1" colwidth="1.0*"/>\r
+                               <colspec colnum="2" colwidth="1.0*"/>\r
+                               <thead>\r
+                                       <row>\r
+                                               <entry>Name</entry>\r
+                                               <entry>Organization</entry>\r
+                                       </row>\r
+                               </thead>\r
+                               <tbody> \r
+                                       <row>\r
+                                               <entry>Jeremy Buhler</entry>\r
+                                               <entry>SITKA</entry>\r
+                                       </row>                                  \r
+                                       <row>\r
+                                               <entry>Paula Burton </entry>\r
+                                               <entry>King County Library System</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Matt Carlson</entry>\r
+                                               <entry>King County Library System </entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Sarah Childs</entry>\r
+                                               <entry>Hussey-Mayfield Memorial Public Library</entry>\r
+                                       </row>\r
+                                       \r
+                                       <row>\r
+                                               <entry>Anton Chuppin</entry>\r
+                                               <entry>Nova Scotia Provincial Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Marlene Coleman</entry>\r
+                                               <entry>Beaufort Country Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Karen Collier</entry>\r
+                                               <entry>Kent County Public Library </entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Shannon Dineen</entry>\r
+                                               <entry>SITKA</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>George Duimovich</entry>\r
+                                               <entry>NRCan Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Jennifer Durham</entry>\r
+                                               <entry>Statesboro Regional Library System</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Jennifer Finney</entry>\r
+                                               <entry>Florence County Library</entry>\r
+                                       </row>  \r
+                                       <row>\r
+                                               <entry>Lynn Floyd</entry>\r
+                                               <entry>Anderson County Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Sally Fortin</entry>\r
+                                               <entry>Equinox Software</entry>\r
+                                       </row>  \r
+                                       <row>\r
+                                               <entry>Tina Ji</entry>\r
+                                               <entry>SITKA</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Catherine Lemmer</entry>\r
+                                               <entry>Indiana State Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Roma Matott</entry>\r
+                                               <entry>Pioneer Library System</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Andrea Neiman</entry>\r
+                                               <entry>Kent County Public Library</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Kevin Pischke</entry>\r
+                                               <entry>William Jessup University </entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Tara Robertson</entry>\r
+                                               <entry>N/A</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Rod Schiffman</entry>\r
+                                               <entry>Alpha-G Consulting</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Steve Sheppard</entry>\r
+                                               <entry>Open</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Ben Shum</entry>\r
+                                               <entry>Bibliomation</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Robert Soulliere</entry>\r
+                                               <entry>Mohawk College</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Lindsay Stratton</entry>\r
+                                               <entry>Pioneer Library System</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Jenny Turner</entry>\r
+                                               <entry>PALS</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Repke de Vries</entry>\r
+                                               <entry>International Institute for Social History</entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>D. Ceabron Williams</entry>\r
+                                               <entry>Flint River Regional Library System </entry>\r
+                                       </row>\r
+                                       <row>\r
+                                               <entry>Tigran Zargaryan</entry>\r
+                                               <entry>Fundamental Scientific Library of the National Academy of Sciences</entry>\r
+                                       </row>\r
+                               </tbody>\r
+                       </tgroup>\r
+               </table>\r
+               <table>\r
+                       <title>Past DIG Participants</title>\r
+                       <tgroup align="left" cols="2" colsep="1" rowsep="1">\r
+                               <colspec colnum="1" colwidth="1.0*"/>\r
+                               <colspec colnum="2" colwidth="1.0*"/>\r
+                               <thead>\r
+                                       <row>\r
+                                               <entry>Name</entry>\r
+                                               <entry>Organization</entry>\r
+                                               \r
+                                       </row>\r
+                               </thead>\r
+                               <tbody> \r
+                                       <row>\r
+                                               <entry>Paul Weiss </entry>\r
+                                               <entry>Consultant/Sage Library System</entry>\r
+                                       </row>                                  \r
+                                       <row>\r
+                                               <entry>Karen Schneider</entry>\r
+                                               <entry>Equinox Software </entry>\r
+                                       </row>\r
+                               </tbody>\r
+                       </tgroup>\r
+               </table>        \r
+               <para>Special thanks goes to:</para>\r
+               <itemizedlist>\r
+                       <listitem>Jeremy Buhler and SITKA for providing DocBook style sheets, style guides and large portions of content for this documentation.</listitem>\r
+                       <listitem>Dan Scott from Laurentian University for providing large portions of content and many helpful tips.</listitem>\r
+                       <listitem>Mike Rylander, Grace Dunbar, Galen Charleton, Jason Etheridge, Bill Erickson, Joe Atzberger, Scott McKellar and all the other folks at Equinox Software for \r
+                       contributing large portions of content on the wiki.</listitem>\r
+               </itemizedlist>         \r
+               <para>There have been many other who have contributed there time to the Book of Evergreen project. Without their contributions to this community driven project, this documentation \r
+               would not be possible.</para>   \r
+       </section>\r
+       <section xml:id="howtoParticipate">\r
+               <title>How to Participate</title><indexterm><primary>Documentation Interest Group (DIG)</primary></indexterm>\r
+               <para>Contributing to documentation is an excellent way to support Evergreen, even if you are new to documentation. In fact, beginners often have a distinct advantage over the \r
+               experts, more easily spotting the places where documentation is lacking or where it is unclear.</para>\r
+               <para>We welcome your contribution with planning, writing, editing, testing, translating to DocBook, and other tasks. Whatever your background or experience we are keen to \r
+               have your help!</para>  \r
+               <para>What you can do:</para>\r
+               <itemizedlist>\r
+                       <listitem>Join the Evergreen  documentation listserv: <link xl:href="http://list.georgialibraries.org/mailman/listinfo/open-ils-documentation" \r
+                       xl:title="Join the DIG listserv">list.georgialibraries.org/mailman/listinfo/open-ils-documentation</link> . This is the primary way we communicate with each other. \r
+                       Please send an email introducing yourself to the list.</listitem><indexterm><primary>mailing lists</primary></indexterm>\r
+                       <listitem>Add yourself to the <link xl:href="http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen-docs:digparticipants"> participant list</link> \r
+                       if you have an Evergreen DokuWiki account, or send a request to <email>docs@evergreen-ils.org</email>.</listitem>\r
+                       <listitem>Check out the <link xl:href="http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen-docs:outline">documentation outline</link> to see which areas need work, \r
+                       and let the DIG list know in which areas you would like to work.</listitem>\r
+                       <listitem>Review the documentation and report any error or make suggestion using <link xl:href="https://bugs.launchpad.net/evergreen/+filebug">Launchpad</link>.</listitem>\r
+               </itemizedlist>\r
+               <simplesect>\r
+                       <title>Volunteer Roles</title>\r
+                       <para>We are now looking for people to help produce the documentation. If you interested in participating, email the DIG facilitators at <email>docs@evergreen-ils.org</email> \r
+                       or post on the documentation mailing list. We're looking for volunteers to work on the following:</para>\r
+                       <itemizedlist>\r
+                               <listitem>Writing – Produce the documentation (<quote>from scratch,</quote> and/or revised from existing materials). We're open to receiving content in any formats, such as \r
+                               Word or Open Office, but of course, would be most delighted with DocBook xml format.</listitem>\r
+                               <listitem>Testing – Compare the documents with the functions they describe and ensuring that the procedures accomplish the desired results. Even if you are not \r
+                               officially in the DIG, we would appreciate any suggestions you may have for Evergreen documentation.</listitem>\r
+                               <listitem>XML conversion – Convert existing documentation to DocBook format.</listitem>\r
+                               <listitem>Editorial review – Ensuring the documentation is clear and follows <link xl:href="http://docs.evergreen-ils.org/style_guide/html/">Evergreen DIG style \r
+                               guide</link> conventions.</listitem>\r
+                               <listitem>Style and Design – Edit the DocBook style sheets or post style tips and suggestions on the DIG list.</listitem><indexterm><primary>DocBook</primary></indexterm>\r
+                       </itemizedlist>\r
+               </simplesect>\r
+       </section>              \r
+</appendix>\r
+\r
+\r
diff --git a/2.0/appendices/glossary.xml b/2.0/appendices/glossary.xml
new file mode 100644 (file)
index 0000000..1230f84
--- /dev/null
@@ -0,0 +1,713 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<glossary xml:id="Glossary" xmlns="http://docbook.org/ns/docbook" xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:xl="http://www.w3.org/1999/xlink">
+       <title>Glossary</title>
+       <abstract>
+               <para>In this section we expand acronyms, define terms, and generally try
+               to explain concepts used by Evergreen software.</para>
+       </abstract>
+       <glossdiv>
+               <title>A</title>
+               <glossentry id="Apache">
+                       <glossterm>Apache</glossterm>
+                       <indexterm>
+                               <primary>Apache</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Open-source web server software used to serve both static content and
+                               dynamic web pages in a secure and reliable way. More information is available
+                               at <ulink url="http://apache.org">http://apache.org</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>B</title>
+               <glossentry id="Book Bags">
+                       <glossterm>Bookbags</glossterm>
+                       <indexterm>
+                               <primary>bookbags</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Bookbags are lists of items that can be used for any number of
+                               purposes. For example, to keep track of what books you have read, books you
+                               would like to read, to maintain a class reading list, to maintain a reading
+                               list for a book club, to keep a list of books you would like for your
+                               birthday. There are an unlimited number of uses.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>C</title>
+               <glossentry id="CentOS">
+                       <glossterm>CentOS</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>CentOS</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source operating system based on Red Hat Enterprises
+                               <systemitem class="osname">Linux</systemitem> (a.k.a. "RHEL") and often used
+                               for in web servers. More information is available at <ulink url="http://www.centos.org">http://www.centos.org</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="closure">
+                       <glossterm>Closure Compiler</glossterm>
+                       <glossdef>
+                               <para>A suite of open-source tools used to build web applications with
+                               <application>Javascript</application>; originally developed by Google. 
+                               More information is available at 
+                               <ulink url="http://code.google.com/closure/compiler/">
+                               http://code.google.com/closure/compiler/</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="CPAN">
+                       <glossterm>CPAN</glossterm>
+                       <indexterm>
+                               <primary>Perl</primary>
+                               <secondary>CPAN</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>An open-source archive of software modules written in
+                               <application>Perl</application>. More information is available at 
+                               <ulink url="http://www.cpan.org">http://www.cpan.org</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>D</title>
+               <glossentry id="Debian">
+                       <glossterm>Debian</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>Debian</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>One of the most popular open-source operating system using the
+                               <systemitem class="osname">Linux</systemitem> kernel that provides over 25000
+                               useful precompiled software packages. Also known as 
+                               <systemitem class="osname">Debian GNU/Linux</systemitem>. More information is 
+                               available at <ulink url="http://www.debian.org">http://www.debian.org</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry>
+                       <glossterm>Domain name</glossterm>
+                       <indexterm>
+                               <primary>domain name</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A unique set of case-insensitive, alphanumeric strings separated by
+                               periods that are used to name organizations, web sites and addresses on the
+                               Internet (e.g.: <uri>www.esilibrary.com</uri>). Domain names can be reserved
+                               via third-party registration services, and can be associated with a unique IP
+                               address or suite of IP addresses.</para>
+                               <glossseealso otherterm="ipaddress"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>E</title>
+               <glossentry id="ejabberd">
+                       <glossterm>ejabberd</glossterm>
+                       <indexterm>
+                               <primary>ejabberd</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>An open-source Jabber/XMPP instant messaging server that runs under popular
+                               operating systems (e.g., <systemitem class="osname">Mac OSX</systemitem>, 
+                               <systemitem class="osname">GNU/Linux</systemitem>, and
+                               <systemitem class="osname">Microsoft Windows</systemitem>). One popular use is
+                               to provide <application>XMPP</application> messaging services for a
+                               <application>Jabber</application> domain across an extendable cluster of
+                               cheap, easily-replaced machine nodes. More information is available at 
+                               <ulink url="http://www.ejabberd.im/">http://www.ejabberd.im</ulink>.</para>
+                               <glossseealso otherterm="Jabber"/>
+                               <glossseealso otherterm="XMPP"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>F</title>
+               <glossentry></glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>G</title>
+               <glossentry id="Gentoo">
+                       <glossterm>Gentoo</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>Gentoo</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source operating system built on the 
+                               <systemitem class="osname">Linux</systemitem> kernel. More information is available 
+                               at <ulink url="http://www.gentoo.org">http://www.gentoo.org</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>H</title>
+               <glossentry></glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>I</title>
+               <glossentry id="ipaddress">
+                       <glossterm>IP Address</glossterm>
+                       <indexterm>
+                               <primary>IP Address</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>(Internet Protocol address) A numerical label consisting of four numbers
+                               separated by periods (e.g., "192.168.1.15") assigned to individual members of
+                               networked computing systems. It uniquely identifies each system on the network
+                               and allows controlled communication between such systems. The numerical label
+                               scheme must adhere to a strictly defined naming convention that is currently
+                               defined and overseen by the Internet Corporation for Assigned Names and
+                               Numbers ("ICANN").</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="Item Buckets">
+                       <glossterm>Item/copy Buckets</glossterm>
+                       <indexterm>
+                               <primary>copy buckets</primary>
+                               <seealso>item buckets</seealso>
+                       </indexterm>
+                       <indexterm>
+                               <primary>item buckets</primary>
+                               <seealso>copy buckets</seealso>
+                       </indexterm>
+                       <glossdef>
+                               <para>Virtual <quote>containers</quote> to use in batch processing of item or
+                               copy records. They can be used to perform various cataloging/holdings
+                               maintenance tasks in batch.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>J</title>
+               <glossentry id="Jabber">
+                       <glossterm>Jabber</glossterm>
+                       <indexterm>
+                               <primary>jabber</primary>
+                               <seealso>XMPP</seealso>
+                       </indexterm>
+                       <glossdef>
+                               <para>Now known as XMPP (eXtensible Messaging and Presence Protocol), it was
+                               originally named "Jabber".</para>
+                               <glossseealso otherterm="XMPP"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>K</title>
+               <glossentry></glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>L</title>
+               <glossentry></glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>M</title>
+               <glossentry id="MARC">
+                       <glossterm>MARC</glossterm>
+                       <indexterm>
+                               <primary>MARC</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The MARC formats are standards for the representation and communication
+                               of bibliographic and related information in machine-readable form.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="MARCXML">
+                       <glossterm>MARCXML</glossterm>
+                       <indexterm>
+                               <primary>MARCXML</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Framework for working with MARC data in a XML environment.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="McCoy">
+                       <glossterm>McCoy</glossterm>
+                       <glossdef>
+                               <para>An open-source application that allows add-on authors to provide secure
+                               updates to their users. More information is available at 
+                               <ulink url="https://developer.mozilla.org/en/McCoy">
+                               http://developer.mozilla.org/en/McCoy</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="memcached">
+                       <glossterm>memcached</glossterm>
+                       <indexterm>
+                               <primary>memcached</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A general-purpose distributed memory caching system, usually with a
+                               client~server architecture spread over multiple computing systems. It reduces
+                               the number of times a data source (e.g., a database) must be directly accessed
+                               by temporarily caching data in memory, therefore dramatically speeding up
+                               database-driven web applications.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>N</title>
+               <glossentry id="netaddr">
+                       <glossterm>Network address</glossterm>
+                       <indexterm>
+                               <primary>network address</primary>
+                               <seealso>ip address</seealso>
+                       </indexterm>
+                       <glossdef>
+                               <para>Also known as an IP address (Internet Protocol address).</para>
+                               <glossseealso otherterm="ipaddress"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="nsis">
+                       <glossterm>nsis</glossterm>
+                       <glossdef>
+                               <para>An open-source software tool used to create Windows installers. 
+                               More information is available at 
+                               <ulink url="http://nsis.sourceforge.net">http://nsis.sourceforge.net</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>O</title>
+               <glossentry id="OPAC">
+                       <glossterm>OPAC</glossterm>
+                       <indexterm>
+                               <primary>OPAC</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The "Online Public Access Catalog"; an online database of a library's
+                               holdings; used to find resources in their collections; possibly searchable by
+                               keyword, title, author, subject or call number.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="OpenSRF">
+                       <glossterm>OpenSRF</glossterm>
+                       <indexterm>
+                               <primary>OpenSRF</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The "Open Scalable Request Framework" (pronounced 'open surf') is a
+                               stateful, decentralized service architecture that allows developers to create
+                               applications for Evergreen with a minimum of knowledge of its
+                               structure.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>P</title>
+               <glossentry id="PKI">
+                       <glossterm>PKI</glossterm>
+                       <indexterm>
+                               <primary>PKI</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Public Key Infrastructure (PKI) describes the schemes needed to generate
+                               and maintain digital SSL Certificates.</para>
+                               <glossseealso otherterm="SSL Certificate"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="PostgreSQL">
+                       <glossterm>PostgreSQL</glossterm>
+                       <indexterm>
+                               <primary>databases</primary>
+                               <secondary>PostgreSQL</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source object-relational database management system that
+                               underpins Evergreen software.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="putty">
+                       <glossterm>Putty</glossterm>
+                       <indexterm>
+                               <primary>SSH</primary>
+                               <secondary>Putty</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source telnet/ssh client for the Windows and Unix
+                               platforms.  More information is available at
+                               <ulink url="http://www.chiark.greenend.org.uk/~sgtatham/putty/">
+                               http://www.chiark.greenend.org.uk/~sgtatham/putty/</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>Q</title>
+               <glossentry></glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>R</title>
+               <glossentry id="Resource Hacker">
+                       <glossterm>Resource Hacker</glossterm>
+                       <glossdef>
+                               <para>An open-source utility used to view, modify, rename, add, delete and
+                               extract resources in 32bit Windows executables.
+                               More information is available at
+                               <ulink url="http://www.angusj.com/resourcehacker/">Resource Hacker</ulink></para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="RHEL">
+                       <glossterm>RHEL</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>RHEL</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Also known as "Red Hat Enterprises 
+                               <systemitem class="osname">Linux</systemitem>". An official 
+                               <systemitem class="osname">Linux</systemitem> distribution that is targeted 
+                               at  the commercial market. It is the basis of other popular 
+                               <systemitem class="osname">Linux</systemitem> distributions, e.g., 
+                               <systemitem class="osname">CentOS</systemitem>. More information is available
+                               at <ulink url="http://www.redhat.com">http://www.redhat.com</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>S</title>
+               <glossentry id="SIP2">
+                       <glossterm>SIP</glossterm>
+                       <indexterm>
+                               <primary>SIP</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>SIP, standing for Standard Interchange Protocol, was developed by the 3M
+                               Corporation to be a common protocol for data transfer between ILS' and third party
+                               devices.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="srfsh">
+                       <indexterm>
+                               <primary>srfsh</primary>
+                       </indexterm>
+                       <glossterm>srfsh</glossterm>
+                       <glossdef>
+                               <para>A command language interpreter (shell) that executes commands read from the
+                               standard input. It is used to test the Open Service Request Framework (OpenSRF).</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="SRU">
+                       <glossterm>SRU</glossterm>
+                       <indexterm>
+                               <primary>SRU</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>SRU is a standard XML-focused search protocol for Internet search
+                               queries, utilizing CQL (Contextual Query Language), a standard syntax for
+                               representing queries.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="ssh">
+                       <glossterm>SSH</glossterm>
+                       <indexterm>
+                               <primary>SSH</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>An encrypted network protocol using public-key cryptography that allows
+                               secure communications between systems on an insecure network. Typically used
+                               to access shell accounts but also supports tunneling, forwarding TCP ports and
+                               X11 connections, and transferring files.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="sshproxy">
+                       <glossterm>SSH proxy</glossterm>
+                       <indexterm>
+                               <primary>SSH</primary>
+                               <secondary>proxy</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>As used in Evergreen, a method of allowing one or more Staff Clients to
+                               communicate with one or more Evergreen servers over an insecure network by
+                               sending data through a secure SSH tunnel. It also buffers and caches all data
+                               travelling to and from Staff Clients to speed up access to resources on
+                               Evergreen servers.</para>
+                               <glossseealso otherterm="ssh"/>
+                               <glossseealso otherterm="tunneling"/>
+                               <glossseealso otherterm="sshtunnel"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="sshtunnel">
+                       <glossterm>SSH tunnel</glossterm>
+                       <indexterm>
+                               <primary>SSH</primary>
+                               <secondary>tunneling</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>An encrypted data channel existing over an SSH network connection. Used
+                               to securely transfer unencrypted data streams over insecure networks.</para>
+                               <glossseealso otherterm="ssh"/>
+                               <glossseealso otherterm="tunneling"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="SSL Certificate">
+                       <glossterm>SSL Certificate</glossterm>
+                       <indexterm>
+                               <primary>SSL</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>As used in Evergreen, it is a method of ensuring that Staff Clients are
+                               able to connect to legitimate Evergreen servers.</para>
+                               <para>In general, it is a special electronic document used to guarantee
+                               authenticity of a digital message. Also known as a "public key", or "identity"
+                               or "digital" certificate. It combines an identity (of a person or an
+                               organization) and a unique public key to form a so-called digital signature,
+                               and is used to verify that the public key does, in fact, belong with that
+                               particular identity.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>T</title>
+               <glossentry id="tunneling">
+                       <glossterm>tunneling</glossterm>
+                       <indexterm>
+                               <primary>tunneling</primary>
+                               <seealso>SSH tunneling</seealso>
+                       </indexterm>
+                       <glossdef>
+                               <para>As used in Evergreen, it is a method of allowing Staff Clients to securely
+                               connect to legitimate Evergreen servers.</para>
+                               <para>In general, it is a method of encapsulating data provided in one network
+                               protocol (the "delivery"protocol), within data in a different network protocol
+                               (the "tunneling" protocol). Used to provide a secure path and secure
+                               communications through an insecure or incompatible network. Can be used to
+                               bypass firewalls by communicating via a protocol the firewall normally blocks,
+                               but "wrapped" inside a protocol that the firewall does not block.</para>
+                               <glossseealso otherterm="sshtunnel"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>U</title>
+               <glossentry id="Ubuntu">
+                       <glossterm>Ubuntu</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>Ubuntu</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source operating system using the 
+                               <systemitem class="osname">Linux</systemitem> kernel that was originally based on the
+                               <systemitem class="osname">Debian GNU/Linux</systemitem> operating system. 
+                               More information is available at
+                               <ulink url="http://www.ubuntu.com">http://www.ubuntu.com</ulink>.</para>
+                               <glossseealso otherterm="Debian"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>V</title>
+               <glossentry id="virtualization">
+                       <glossterm>Virtualization</glossterm>
+                       <indexterm>
+                               <primary>virtualization</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A method of executing software in a special environment that is partitioned or
+                               separated from the real underlying hardware and software resources. In typical usage, it
+                               allows a <emphasis>host</emphasis> operating system to encapsulate or emulate another
+                               operating system environment in such a way that the emulated environment is completely
+                               unaware of the hosting environment. For instance, it allows a 
+                               <systemitem class="osname">Linux</systemitem> application to execute within a 
+                               <systemitem class="osname">Windows</systemitem> environment.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="virtualbox">
+                       <glossterm>VirtualBox</glossterm>
+                       <indexterm>
+                               <primary>virtualization software</primary>
+                               <secondary>VirtualBox</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular commercial package of virtualization software that emulates the x86
+                               microprocessor architecture. It can be installed on
+                               <systemitem class="osname">Linux</systemitem>, <systemitem class="osname">Mac OS X</systemitem>,
+                               <systemitem class="osname">Windows</systemitem> or 
+                               <systemitem class="osname">Solaris</systemitem> "host" operating systems and allows 
+                               other "guest" (typically including <systemitem class="osname">Linux</systemitem> and 
+                               <systemitem class="osname">Windows</systemitem>) operating systems to be loaded and executed.</para>
+                               <glossseealso otherterm="virtualization"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="virtualpc">
+                       <glossterm>Virtual PC</glossterm>
+                       <indexterm>
+                               <primary>virtualization software</primary>
+                               <secondary>Virtual PC</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular commercial package of virtualization software that emulates the x86
+                               microprocessor architecture. It is installed on a Windows "host" operating system and
+                               allows other "guest" (typically including <systemitem class="osname">Linux</systemitem>
+                               and <systemitem class="osname">Windows</systemitem>) operating systems to be loaded and
+                               executed.</para>
+                               <glossseealso otherterm="virtualization"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="Volume Buckets">
+                       <glossterm>Volume Buckets</glossterm>
+                       <indexterm>
+                               <primary>volume buckets</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>Virtual <quote>containers</quote> to use in batch processing of multiple
+                               volumes. They can be used to perform various cataloging/holdings maintenance
+                               tasks in batch.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="vmware">
+                       <glossterm>VMware</glossterm>
+                       <indexterm>
+                               <primary>virtualization software</primary>
+                               <secondary>VMware</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular commercial package of virtualization software that emulates the x86
+                               microprocessor architecture. It can be installed on
+                               <systemitem class="osname">Linux</systemitem>, 
+                               <systemitem class="osname">Mac OS X</systemitem>,
+                               <systemitem class="osname">Windows</systemitem> or 
+                               <systemitem class="osname">Solaris</systemitem> "host" operating systems and
+                               allows other "guest" (typically including 
+                               <systemitem class="osname">Linux</systemitem> and 
+                               <systemitem class="osname">Windows</systemitem>) operating systems to be
+                               loaded and executed.</para>
+                               <glossseealso otherterm="virtualization"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>W</title>
+               <glossentry id="wine">
+                       <glossterm>Wine</glossterm>
+                       <indexterm>
+                               <primary>Linux</primary>
+                               <secondary>Wine</secondary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A popular open-source application that allows
+                               <systemitem class="osname">Linux</systemitem> and 
+                               <systemitem class="osname">Unix</systemitem>
+                               systems to run <systemitem class="osname">Windows</systemitem> executables. 
+                               More information is available at 
+                               <ulink url="http://www.winehq.org/">http://www.winehq.org/</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>X</title>
+               <glossentry id="xml">
+                       <glossterm>XML</glossterm>
+                       <indexterm>
+                               <primary>XML</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The eXtensible Markup Language, a subset of SGML; a set of rules for
+                               encoding information in a way that is both human- and machine-readable. It is
+                               primarily used to define documents but can also be used to define arbitrary
+                               data structures. It was originally defined by the World Wide Web Consortium
+                               (W3C).</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="XMPP">
+                       <glossterm>XMPP</glossterm>
+                       <indexterm>
+                               <primary>XMPP</primary>
+                               <seealso>jabber</seealso>
+                       </indexterm>
+                       <glossdef>
+                               <para>An open-standard communications protocol, based on XML, used in
+                               message-oriented middleware. It supports the concept of a consistent
+                               <emphasis>domain</emphasis> of message types that flow between software
+                               applications, possibly on different operating systems and architectures. 
+                               More information is available at 
+                               <ulink url="http://xmpp.org">http://xmpp.org</ulink>.</para>
+                               <glossseealso otherterm="Jabber"/>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="xpath">
+                       <glossterm>xpath</glossterm>
+                       <indexterm>
+                               <primary>xpath</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The XML Path Language, a query language based on a tree representation
+                               of an XML document. It is used to programmatically select nodes from an XML
+                               document and to do minor computation involving strings, numbers and Boolean
+                               values. It allows you to identify parts of the XML document tree, to navigate
+                               around the tree, and to uniquely select nodes. The currently version is "XPath
+                               2.0". It was originally defined by the World Wide Web Consortium (W3C).</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="xul">
+                       <glossterm>XUL</glossterm>
+                       <indexterm>
+                               <primary>xUL</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>The XML User Interface Language, a specialized interface language that allows
+                               building cross-platform applications that drive <application>Mozilla</application>
+                               -based browsers such as <application>Firefox</application>. More information is
+                               available at 
+                               <ulink url="https://developer.mozilla.org/en/XUL">
+                               https://developer.mozilla.org/en/XUL</ulink>.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="xulrunner">
+                       <glossterm>xulrunner</glossterm>
+                       <indexterm>
+                               <primary>XULRunner</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A specialized run-time application environment that provides support for
+                               installing, upgrading and uninstalling <application>XUL</application>
+                               applications. It operates with <application>Mozilla</application>-based
+                               applications such as the <application>Firefox</application> browser. 
+                               More information is available at
+                               <ulink url="https://developer.mozilla.org/en/XULRunner">
+                               https://developer.mozilla.org/en/XULRunner</ulink>.</para>
+                               <glossseealso otherterm="xul"/>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>Y</title>
+               <glossentry id="YAZ">
+                       <glossterm>YAZ</glossterm>
+                       <indexterm>
+                               <primary>yaz</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A programmers’ toolkit supporting the development of Z39.50/SRW/SRU
+                               clients and servers.</para>
+                       </glossdef>
+               </glossentry>
+               <glossentry id="yaz-client">
+                       <indexterm>
+                               <primary>yaz</primary>
+                       </indexterm>
+                       <glossterm>yaz-client</glossterm>
+                       <glossdef>
+                               <para>Z39.50/SRU client for connecting to YAZ servers. 
+                               More information is available at 
+                               <ulink url="http://www.indexdata.com/yaz">http://www.indexdata.com/yaz</ulink></para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+       <glossdiv>
+               <title>Z</title>
+               <glossentry id="Z39.50">
+                       <glossterm>Z39.50</glossterm>
+                       <indexterm>
+                               <primary>Z39.50</primary>
+                       </indexterm>
+                       <glossdef>
+                               <para>A client–server protocol for searching and retrieving information from
+                               remote computer databases.</para>
+                       </glossdef>
+               </glossentry>
+       </glossdiv>
+</glossary>
diff --git a/2.0/appendices/installchecklist.xml b/2.0/appendices/installchecklist.xml
new file mode 100644 (file)
index 0000000..d9b1c63
--- /dev/null
@@ -0,0 +1,86 @@
+<?xml version='1.0' encoding='UTF-8'?>\r
+<appendix xmlns="http://docbook.org/ns/docbook" xmlns:xi="http://www.w3.org/2001/XInclude"\r
+xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="install_checklist">\r
+       <info>\r
+               <title>Evergreen Installation Checklist</title>\r
+               <abstract>\r
+                       <para>This appendix is a checklist of things to do to istall and configure Evergreen. It will refer to the necessary chapter with the specific instructions for each item.</para>\r
+               </abstract>\r
+       </info>\r
+       <orderedlist numeration="loweralpha">\r
+               <listitem>\r
+                       <para><link linkend="serversideinstallation-opensrf">Install OpenSRF</link></para><indexterm><primary>OpenSRF</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="serversideinstallation-ubuntudebian">Install Evergreen server software</link></para>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="staffclientinstallation">Install Evergreen staff client</link></para><indexterm><primary>staff client</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="backingup">Establish a back up strategy for Evergreen data and files</link></para>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="configuringPostgreSQL">Configure PostgreSQL for better performance</link></para><indexterm><primary>PostgreSQL</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="logfiles">Configure Evergreen error logging</link></para><indexterm><primary>logs</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="orgtypes">Set up organizational unit types</link></para><indexterm><primary>organizational unit types</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="orgunits">Set up organizational units</link></para><indexterm><primary>organizational units</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="languagesandlocalization">Customize localization and languages</link> (optional)</para><indexterm><primary>localization and languages</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="circmodifiers">Add circ modifiers</link></para><indexterm><primary>circulation modifiers</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="copystatus">Configure copy statuses</link></para><indexterm><primary>copy status</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="catalogingtemplates">Add cataloguing templates</link></para><indexterm><primary>cataloguing </primary><secondary>templates</secondary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="permissions">Add user groups and assign permissions</link></para><indexterm><primary>permissions</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="lsa">Adjust various Local Administration Settings</link></para>\r
+               </listitem>\r
+               <listitem>\r
+                       <para>Adjust circulation policies and <link linkend="lsa-group-penalty">penalty threshholds</link> for groups</para><indexterm><primary>penalty threshholds</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="admin-staff_accounts">Add staff users</link></para>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="Customizing_OPAC">Customize OPAC</link> as needed</para><indexterm><primary>OPAC</primary><secondary>customizing</secondary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="migratingdata">Import data</link></para><indexterm><primary>migrating</primary><secondary>importing data</secondary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="report_starting_reporter_service">Start the reporter service and set up reports</link> \r
+                       <indexterm><primary>reports</primary><secondary>starting</secondary></indexterm></para>\r
+                       \r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="notifications">Set up email notifications for holds and overdue items</link></para><indexterm><primary>notifications</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="actiontriggers">Set up action triggers</link></para><indexterm><primary>action triggers</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="z3950">Set up Z39.50 server</link> (optional)</para><indexterm><primary>Z39.50</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="relevancyrankings">Adjust search relevancy settings</link> if required (optional)</para><indexterm><primary>search relevancy</primary></indexterm>\r
+               </listitem>\r
+               <listitem>\r
+                       <para><link linkend="sipserver">Install SIP server</link> (optional) - for communications with automated devices such as self check stations, autmated sorters and other devices using SIP</para><indexterm><primary>SIP</primary></indexterm>\r
+               </listitem>\r
+       </orderedlist>\r
+</appendix>\r
diff --git a/2.0/appendices/more_info.xml b/2.0/appendices/more_info.xml
new file mode 100644 (file)
index 0000000..d8c3622
--- /dev/null
@@ -0,0 +1,33 @@
+<?xml version='1.0' encoding='UTF-8'?>\r
+<appendix xmlns="http://docbook.org/ns/docbook" xmlns:xi="http://www.w3.org/2001/XInclude"\r
+xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="more_info">\r
+       <info>\r
+               <title>Getting More Information</title>\r
+       </info> \r
+       <para>This documentation is just one way to learn about Evergreen and find solutions to Evergreen challenges. Below is a list of many other resources to help you find answers to almost any question \r
+       you might have.</para>\r
+               <para><link xl:href="http://www.open-ils.org/">Evergreen Wiki</link> - Loads of information and the main portal to the Evergreen community.</para><indexterm><primary>wiki</primary></indexterm>\r
+               <para><link xl:href="http://www.open-ils.org/listserv.php">Evergreen mailing lists</link> - These are excellent for initiating questions. There are several lists including:\r
+                       <itemizedlist>\r
+                               <listitem><link xl:href="http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general">General list</link> - General inquiries regarding Evergreen. If unsure about \r
+                               which list to use, this is a good stating point.</listitem><indexterm><primary>mailing lists</primary></indexterm>\r
+                               <listitem><link xl:href="http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev">Developer list</link> - Technical questions should be asked here including \r
+                               questions regarding installation. As well, patches can be submitted using this list and developer communication also takes place here. </listitem>\r
+                               <listitem><link xl:href="http://libmail.georgialibraries.org/mailman/listinfo/open-ils-documentation">DIG list</link> - This list is used for questions and \r
+                               feedback regarding this documentation, the Documentation Interest Group and other documentation related ideas and issues.</listitem><indexterm><primary>Documentation Interest Group (DIG)</primary></indexterm>\r
+                       </itemizedlist>\r
+               </para>\r
+               <para><link xl:href="http://evergreen-ils.org/blog/">Evergreen Blog</link> - Great for getting general news and updates about Evergreen. It is also an interesting historical read \r
+               with entries dating back to the early beginnings of Evergreen.</para>\r
+               <para><link xl:href="http://evergreen-ils.org/irc.php">Evergreen IRC channel</link> - Allows live chat. Many developers hang out here and will try to field technical questions. This \r
+               is often the quickest way to get a solution to a specific problem. Just remember that while the channel is open 24/7, there are times when no one is available in the channel. The most \r
+               active times for the IRC channel seem to be weekday afternoons (Eastern Standard Time). There is also an archive of logs from the chat sessions available on the \r
+               <link xl:href="http://evergreen-ils.org/irc.php">IRC</link> page.</para><indexterm><primary>IRC chat</primary></indexterm>\r
+               <para><link xl:href="http://planet.evergreen-ils.org/">Evergreen related community blogs</link> - Evergreen related blog entries from the community.</para>\r
+               <para><link xl:href="http://rscel.evergreen-ils.org/">Resource Sharing Cooperative of Evergreen Libraries (RSCEL)</link> - Provides some technical documents and a means for the \r
+               Evergreen community to collaborate with other libraries.</para><indexterm><primary>Resource Sharing Cooperative of Evergreen Libraries (RSCEL)</primary></indexterm>\r
+               <para><link xl:href="http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen_libraries">List of current Evergreen libraries</link> - Locate other libraries who are  \r
+               using Evergreen.</para>         \r
+</appendix>\r
+\r
+\r
diff --git a/2.0/appendices/schema.xml b/2.0/appendices/schema.xml
new file mode 100644 (file)
index 0000000..7916c66
--- /dev/null
@@ -0,0 +1,41207 @@
+<?xml version="1.0" encoding="UTF-8" ?>\r
+<appendix id="databaseschema">\r
+       <title>Database Schema</title>\r
+       <para>This is the schema for the Evergreen database.</para>\r
+       \r
+       <section id="acq.schema">\r
+               <title>Schema acq</title>\r
+               \r
+               <simplesect id="acq.table.currency-type" xreflabel="acq.currency_type">         \r
+                       <title>currency_type</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>label</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>          \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                                       <itemizedlist>\r
+                                               <title>Tables referencing acq.exchange_rate via Foreign Key Constraints</title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.exchange-rate"/></para>\r
+                                                       </listitem><listitem>\r
+                                                               <para><xref linkend="acq.table.fund"/></para>\r
+                                                       </listitem><listitem>\r
+                                                               <para><xref linkend="acq.table.fund-debit"/></para>\r
+                                                       </listitem>\r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.funding-source"/></para>\r
+                                                       </listitem>\r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.provider"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                       </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.distribution-formula" xreflabel="acq.distribution_formula">           \r
+                       <title>distribution_formula</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>owner</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>skip_count</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.distribution_formula_entry via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.distribution-formula-entry"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.distribution-formula-entry" xreflabel="acq.distribution_formula_entry">               \r
+                       <title>distribution_formula_entry</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>formula</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.distribution-formula"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>position</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>item_count</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>owning_lib</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>location</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="asset.table.copy-location"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                                       <variablelist>\r
+                                               <title>Constraints on distribution_formula_entry</title>\r
+                                               \r
+                                               <varlistentry>\r
+                                                       <term>acqdfe_must_ be_somewhere</term>\r
+                                                       <listitem><para>CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</para></listitem>\r
+                                               </varlistentry>\r
+                                               \r
+                                       </variablelist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.exchange-rate" xreflabel="acq.exchange_rate">         \r
+                       <title>exchange_rate</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>from_currency</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.currency-type"/>\r
+                                                                               \r
+                                                                       \r
+                                                                               \r
+                                                                       \r
+                                                                       </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>to_currency</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.currency-type"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ratio</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fiscal-calendar" xreflabel="acq.fiscal_calendar">             \r
+                       <title>fiscal_calendar</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.fiscal_year via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fiscal-year"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fiscal-year" xreflabel="acq.fiscal_year">             \r
+                       <title>fiscal_year</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>calendar</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1 ;UNIQUE#2; NOT NULL;\r
+                                                               <xref linkend="acq.table.fiscal-calendar"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>year</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>year_begin</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>UNIQUE#2; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>year_end</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fund" xreflabel="acq.fund">           \r
+                       <title>fund</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>org</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#2; UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>year</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#2; UNIQUE#1; NOT NULL; DEFAULT date_part( &apos;year&apos;::text, now() );</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>currency_type</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/> </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#2;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fund-allocation"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fund-debit"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fund-allocation" xreflabel="acq.fund_allocation">             \r
+                       <title>fund_allocation</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>funding_source</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.funding-source"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>percent</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>allocator</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>note</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>create_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now(); </entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                                       <variablelist>\r
+                                               <title>Constraints on fund_allocation</title>\r
+                                               \r
+                                               <varlistentry>\r
+                                                       <term>allocation_amount _or_percent</term>\r
+                                                       <listitem><para>CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))</para></listitem>\r
+                                               </varlistentry>\r
+                                               \r
+                               \r
+                               \r
+                                               <varlistentry>\r
+                                                       <term>fund_allocation_ percent_check</term>\r
+                                                       <listitem><para>CHECK (((percent IS NULL) OR ((percent &gt;= 0.0) AND (percent &lt;= 100.0))))</para></listitem>\r
+                                               </varlistentry>\r
+                                               \r
+                                       </variablelist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-allocation-total" xreflabel="acq.fund_allocation_total">          \r
+                       <title>fund_allocation_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>\r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric(100,2)</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-combined-balance" xreflabel="acq.fund_combined_balance">          \r
+                       <title>fund_combined_balance</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fund-debit" xreflabel="acq.fund_debit">               \r
+                       <title>fund_debit</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>origin_amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>origin_currency_type</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/> </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>encumbrance</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT true;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>debit_type</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>xfer_destination</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.fund"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>create_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.lineitem_detail via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-debit-total" xreflabel="acq.fund_debit_total">            \r
+                       <title>fund_debit_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>encumbrance</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-encumbrance-total" xreflabel="acq.fund_encumbrance_total">                \r
+                       <title>fund_encumbrance_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-spent-balance" xreflabel="acq.fund_spent_balance">                \r
+                       <title>fund_spent_balance</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.fund-spent-total" xreflabel="acq.fund_spent_total">            \r
+                       <title>fund_spent_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fund-tag" xreflabel="acq.fund_tag">           \r
+                       <title>fund_tag</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>owner</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.fund_tag_map via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.fund-tag-map" xreflabel="acq.fund_tag_map">           \r
+                       <title>fund_tag_map</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="acq.table.fund"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>tag</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; <xref linkend="acq.table.fund-tag"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.funding-source" xreflabel="acq.funding_source">               \r
+                       <title>funding_source</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>owner</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>UNIQUE#1; NOT NULL; <xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>currency_type</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.currency-type"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>UNIQUE;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.fund-allocation"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.funding-source-credit"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.funding-source-allocation-total" xreflabel="acq.funding_source_allocation_total">              \r
+                       <title>funding_source_allocation_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>funding_source</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric(100,2)</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.funding-source-balance" xreflabel="acq.funding_source_balance">                \r
+                       <title>funding_source_balance</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>funding_source</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>\r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric(100,2)</entry>\r
+                                                               <entry>\r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       \r
+                                                                       </entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.funding-source-credit" xreflabel="acq.funding_source_credit">         \r
+                       <title>funding_source_credit</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>funding_source</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.funding-source"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>note</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.view.funding-source-credit-total" xreflabel="acq.funding_source_credit_total">              \r
+                       <title>funding_source_credit_total</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>funding_source</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>amount</entry>\r
+                                                               <entry>numeric</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem" xreflabel="acq.lineitem">           \r
+                       <title>lineitem</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigserial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>creator</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>editor</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>selector</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL;<xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>provider</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.provider"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>purchase_order</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.purchase-order"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>picklist</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.picklist"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>expected_recv_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>create_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>edit_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now(); </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>marc</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>eg_bib_id</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="biblio.table.record-entry"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>source_label</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>item_count</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>state</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;DEFAULT &apos;new&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                                       <variablelist>\r
+                                               <title>Constraints on lineitem</title>\r
+                                               \r
+                                               <varlistentry>\r
+                                                       <term>picklist_or_po</term>\r
+                                                       <listitem><para>CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))</para></listitem>\r
+                                               </varlistentry>\r
+                                               \r
+                                       </variablelist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+                                       <itemizedlist>\r
+                                               <title>\r
+                                                       Tables referencing acq.lineitem_attr via Foreign Key Constraints\r
+                                               </title>\r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.lineitem-attr"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                               \r
+                               \r
+                                                       <listitem>\r
+                                                               <para><xref linkend="acq.table.lineitem-note"/></para>\r
+                                                       </listitem>\r
+                                                       \r
+                                       </itemizedlist>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-attr" xreflabel="acq.lineitem_attr">         \r
+                       <title>lineitem_attr</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigserial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>definition</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>lineitem</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>NOT NULL;<xref linkend="acq.table.lineitem"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>attr_type</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>attr_name</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>attr_value</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-attr-definition" xreflabel="acq.lineitem_attr_definition">           \r
+                       <title>lineitem_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigserial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-detail" xreflabel="acq.lineitem_detail">             \r
+                       <title>lineitem_detail</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigserial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>lineitem</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.lineitem"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.fund"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>fund_debit</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="acq.table.fund-debit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>eg_copy_id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry><xref linkend="asset.table.copy"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>barcode</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>cn_label</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>note</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>collection_code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>circ_modifier</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry><xref linkend="config.table.circ-modifier"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>owning_lib</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="actor.table.org-unit"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>location</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry><xref linkend="asset.table.copy-location"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>recv_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-generated-attr-definition" xreflabel="acq.lineitem_generated_attr_definition">               \r
+                       <title>lineitem_generated_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>xpath</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+               </para>\r
+               </simplesect>\r
+               <simplesect id="acq.table.lineitem-local-attr-definition" xreflabel="acq.lineitem_local_attr_definition">               \r
+                       <title>lineitem_local_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL;DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-marc-attr-definition" xreflabel="acq.lineitem_marc_attr_definition">         \r
+                       <title>lineitem_marc_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>xpath</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-note" xreflabel="acq.lineitem_note">         \r
+                       <title>lineitem_note</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>serial</entry>\r
+                                                               <entry>PRIMARY KEY</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>lineitem</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.lineitem"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>creator</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>editor</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>create_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>edit_time</entry>\r
+                                                               <entry>timestamp with time zone</entry>\r
+                                                               <entry>NOT NULL; DEFAULT now();</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>value</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-provider-attr-definition" xreflabel="acq.lineitem_provider_attr_definition">         \r
+                       <title>lineitem_provider_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>xpath</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>provider</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="acq.table.provider"/> </entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.lineitem-usr-attr-definition" xreflabel="acq.lineitem_usr_attr_definition">           \r
+                       <title>lineitem_usr_attr_definition</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>id</entry>\r
+                                                               <entry>bigint</entry>\r
+                                                               <entry>PRIMARY KEY DEFAULT nextval( &apos;lineitem_attr_definition_id_seq&apos;::regclass );\r
+                                                                       \r
+                                                                       \r
+                                                                               \r
+                                                                       \r
+                                                                       </entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>code</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>description</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>remove</entry>\r
+                                                               <entry>text</entry>\r
+                                                               <entry>NOT NULL; DEFAULT &apos;&apos;::text;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>ident</entry>\r
+                                                               <entry>boolean</entry>\r
+                                                               <entry>NOT NULL; DEFAULT false;</entry>\r
+                                                       </row>\r
+                                               \r
+                                                       <row>\r
+                                                               <entry>usr</entry>\r
+                                                               <entry>integer</entry>\r
+                                                               <entry>NOT NULL; <xref linkend="actor.table.usr"/></entry>\r
+                                                       </row>\r
+                                               \r
+                                               </tbody>\r
+                                       </tgroup>\r
+                               </informaltable>\r
+                               <para>\r
+                               \r
+                               \r
+                               \r
+                               \r
+               </para>\r
+               </simplesect>\r
+               \r
+               <simplesect id="acq.table.picklist" xreflabel="acq.picklist">           \r
+                       <title>picklist</title>\r
+                       <informaltable>\r
+                               <tgroup cols="3">\r
+                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>\r
+                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>\r
+                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>\r
+                                       <thead>\r
+                                               <row>\r
+                                                       <entry>Field</entry>\r
+                                                       <entry>Data Type</entry>\r
+                                                       <entry>Constraints and References</entry>\r
+                                               </row>\r
+                                               </thead>\r
+                                               <tbody>\r
+   &