More overflow error fixing. overflow errors occur during FO/PDF processing.
authorRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Wed, 17 Nov 2010 20:27:09 +0000 (15:27 -0500)
committerRobert Soulliere <rsoulliere@libdog.mohawkcollege.ca>
Wed, 17 Nov 2010 20:27:09 +0000 (15:27 -0500)
14 files changed:
1.6/admin/admin-lsa.xml
1.6/admin/serveradministration.xml
1.6/admin/troubleshooting.xml
1.6/appendices/installchecklist.xml
1.6/appendices/schema.xml
1.6/development/directoriesandFiles.xml
1.6/development/introduction_to_sql.xml
1.6/development/supercat.xml
1.6/reports/report-generate-report.xml
1.6/reports/report-intro.xml [new file with mode: 0644]
1.6/reports/report-view-output.xml
1.6/root.xml
1.6/stafftasks/circulation.xml
1.6/test.xml [new file with mode: 0644]

index 1e86c25..c9a3c1a 100644 (file)
             </mediaobject>\r
          </para>\r
       </informalfigure>\r
-      <informalfigure>\r
          <para>This menu is new in Evergreen 1.6 and provides shortcuts to settings also available\r
-            from the <guilabel>Local Administration</guilabel> page shown below:</para>\r
-         <para>\r
-            <mediaobject>\r
-               <alt>screenshot of staff client</alt>\r
-               <imageobject>\r
-                  <imagedata scalefit="0" fileref="../media/lsa-2.jpg"/>\r
-               </imageobject>\r
-            </mediaobject>\r
-         </para>\r
-      </informalfigure>\r
+            from the <guilabel>Local Administration</guilabel> page.</para>\r
       <para>Either access point can be used, but examples in this manual use the more comprehensive\r
             <guilabel>Local Administration</guilabel> rollover menu.</para>\r
       <para>Items on this menu are visible to anyone logged into the staff client but usually\r
index 9813712..5535dc5 100644 (file)
@@ -426,6 +426,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                </simplesect>\r
                <simplesect>\r
                        <title>Permissions</title>\r
+                       \r
                        <table xml:id="permissiondescriptions">\r
                                <title>Permissions Table</title>\r
                                <tgroup cols="2">\r
@@ -1098,7 +1099,8 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                                                </row>\r
                                        </tbody>\r
                                </tgroup>\r
-                       </table>        \r
+                       </table>\r
+       \r
                </simplesect>\r
        </section>\r
        <section xml:id="admin-staff_accounts">\r
@@ -1179,7 +1181,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                         <entry>Circ + Copy Edit</entry>\r
                         <entry>Circ + Full Cat</entry>\r
                         <entry>Catalogers</entry>\r
-                        <entry>Local System Administrator (LSA)</entry>\r
+                        <entry>Local System Admin.</entry>\r
                     </row>\r
                 </thead>\r
 \r
@@ -1844,8 +1846,8 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="serveradministrati
                        field_class, name, xpath, and format.</para>\r
                        <para>The following is one representative line from the <link linkend="config.table.metabib-field">config.metabib_field</link> table:</para>\r
 <screen>\r
-author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:\r
-roleTerm[text()='creator']] | mods32 | 1 ) \r
+author | conference | //mods32:mods/mods32:name[@type='conference']/mods32:\r
+namePart[../mods32:role/mods32:roleTerm[text()='creator']] | mods32 | 1 ) \r
 </screen>\r
                        <para>The default value for index-field weights in config.metabib_field is 1. Adjust the\r
                        weighting of indexed fields to boost or lower the relevance score for matches on that\r
@@ -2269,7 +2271,9 @@ WHERE id = 17;
                 <!-- do we attempt email notification? -->\r
                 <email_notify>true</email_notify>\r
                 <!-- notice template file -->\r
-                <email_template>/openils/var/data/templates/overdue_7day.example</email_template>\r
+                <email_template>\r
+                       /openils/var/data/templates/overdue_7day.example\r
+               </email_template>\r
             </notice>\r
         </overdue>\r
 <!-- Courtesy notices -->\r
@@ -2284,7 +2288,9 @@ WHERE id = 17;
                 <notify_interval>1 day</notify_interval>\r
                 <file_append>false</file_append>\r
                 <email_notify>true</email_notify>\r
-                <email_template>/openils/var/data/templates/predue_1day.example</email_template>\r
+                <email_template>\r
+                       /openils/var/data/templates/predue_1day.example\r
+               </email_template>\r
             </notice>\r
         </predue>\r
 ...\r
index 73ad289..8ab2fe1 100644 (file)
@@ -245,7 +245,8 @@ Tie::IxHash version 1.21
 Parse::RecDescent version 1.95.1\r
 SRU version 0.99\r
 JSON::XS version 2.27\r
-\r
+</screen>\r
+<screen>\r
 Checking Jabber connection for user opensrf, domain private.localhost\r
 * Jabber successfully connected\r
 \r
index f4af922..d9b1c63 100644 (file)
@@ -7,7 +7,7 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="install_checklist"
                        <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>\r
+       <orderedlist numeration="loweralpha">\r
                <listitem>\r
                        <para><link linkend="serversideinstallation-opensrf">Install OpenSRF</link></para><indexterm><primary>OpenSRF</primary></indexterm>\r
                </listitem>\r
@@ -63,7 +63,9 @@ xmlns:xl="http://www.w3.org/1999/xlink" version="5.0" xml:id="install_checklist"
                        <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-introduction">Start the reporter service and set up reports</link></para><indexterm><primary>reports</primary><secondary>starting</secondary></indexterm>\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
index 0bad6aa..7916c66 100644 (file)
-<?xml version="1.0" encoding="UTF-8" ?>
-<appendix id="databaseschema">
-       <title>Database Schema</title>
-       <para>This is the schema for the Evergreen database.</para>
-       
-       <section id="acq.schema">
-               <title>Schema acq</title>
-               
-               <simplesect id="acq.table.currency-type" xreflabel="acq.currency_type">         
-                       <title>currency_type</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>code</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>label</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.exchange_rate via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.exchange-rate"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-debit"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.funding-source"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.provider"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.distribution-formula" xreflabel="acq.distribution_formula">           
-                       <title>distribution_formula</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>owner</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.org-unit"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>name</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>skip_count</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.distribution_formula_entry via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.distribution-formula-entry"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.distribution-formula-entry" xreflabel="acq.distribution_formula_entry">               
-                       <title>distribution_formula_entry</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>formula</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.distribution-formula"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>position</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>item_count</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>owning_lib</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.org-unit"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>location</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="asset.table.copy-location"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                                       <variablelist>
-                                               <title>Constraints on distribution_formula_entry</title>
-                                               
-                                               <varlistentry>
-                                                       <term>acqdfe_must_be_somewhere</term>
-                                                       <listitem><para>CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</para></listitem>
-                                               </varlistentry>
-                                               
-                                       </variablelist>
-                               
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.exchange-rate" xreflabel="acq.exchange_rate">         
-                       <title>exchange_rate</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>from_currency</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.currency-type"/>
-                                                                               
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>to_currency</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.currency-type"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>ratio</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fiscal-calendar" xreflabel="acq.fiscal_calendar">             
-                       <title>fiscal_calendar</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>name</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.fiscal_year via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fiscal-year"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fiscal-year" xreflabel="acq.fiscal_year">             
-                       <title>fiscal_year</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>calendar</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#2
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fiscal-calendar"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>year</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>year_begin</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#2
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>year_end</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fund" xreflabel="acq.fund">           
-                       <title>fund</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>org</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#2
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.org-unit"/>
-                                                                               
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>name</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>year</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#2
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT date_part(&apos;year&apos;::text, now());
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>currency_type</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.currency-type"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>code</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#2
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-allocation"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-debit"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fund-allocation" xreflabel="acq.fund_allocation">             
-                       <title>fund_allocation</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>funding_source</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.funding-source"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fund"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>percent</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>allocator</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.usr"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>note</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>create_time</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT now();
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                                       <variablelist>
-                                               <title>Constraints on fund_allocation</title>
-                                               
-                                               <varlistentry>
-                                                       <term>allocation_amount_or_percent</term>
-                                                       <listitem><para>CHECK ((((percent IS NULL) AND (amount IS NOT NULL)) OR ((percent IS NOT NULL) AND (amount IS NULL))))</para></listitem>
-                                               </varlistentry>
-                                               
-                               
-                               
-                                               <varlistentry>
-                                                       <term>fund_allocation_percent_check</term>
-                                                       <listitem><para>CHECK (((percent IS NULL) OR ((percent &gt;= 0.0) AND (percent &lt;= 100.0))))</para></listitem>
-                                               </varlistentry>
-                                               
-                                       </variablelist>
-                               
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-allocation-total" xreflabel="acq.fund_allocation_total">          
-                       <title>fund_allocation_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric(100,2)</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-combined-balance" xreflabel="acq.fund_combined_balance">          
-                       <title>fund_combined_balance</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fund-debit" xreflabel="acq.fund_debit">               
-                       <title>fund_debit</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fund"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>origin_amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>origin_currency_type</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.currency-type"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>encumbrance</entry>
-                                                               <entry>boolean</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT true;
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>debit_type</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>xfer_destination</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fund"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>create_time</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT now();
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.lineitem_detail via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-debit-total" xreflabel="acq.fund_debit_total">            
-                       <title>fund_debit_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>encumbrance</entry>
-                                                               <entry>boolean</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-encumbrance-total" xreflabel="acq.fund_encumbrance_total">                
-                       <title>fund_encumbrance_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-spent-balance" xreflabel="acq.fund_spent_balance">                
-                       <title>fund_spent_balance</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.fund-spent-total" xreflabel="acq.fund_spent_total">            
-                       <title>fund_spent_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fund-tag" xreflabel="acq.fund_tag">           
-                       <title>fund_tag</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>owner</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.org-unit"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>name</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.fund_tag_map via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-tag-map"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.fund-tag-map" xreflabel="acq.fund_tag_map">           
-                       <title>fund_tag_map</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>fund</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fund"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>tag</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.fund-tag"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.funding-source" xreflabel="acq.funding_source">               
-                       <title>funding_source</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>name</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>owner</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE#1
-                                                                               ;
-                                                                               
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.org-unit"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>currency_type</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.currency-type"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>code</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                               UNIQUE;
-                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.fund_allocation via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.fund-allocation"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.funding-source-credit"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.funding-source-allocation-total" xreflabel="acq.funding_source_allocation_total">              
-                       <title>funding_source_allocation_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>funding_source</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric(100,2)</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.funding-source-balance" xreflabel="acq.funding_source_balance">                
-                       <title>funding_source_balance</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>funding_source</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric(100,2)</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.funding-source-credit" xreflabel="acq.funding_source_credit">         
-                       <title>funding_source_credit</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>serial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>funding_source</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.funding-source"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>note</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.view.funding-source-credit-total" xreflabel="acq.funding_source_credit_total">              
-                       <title>funding_source_credit_total</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>funding_source</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>amount</entry>
-                                                               <entry>numeric</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.lineitem" xreflabel="acq.lineitem">           
-                       <title>lineitem</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>bigserial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>creator</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.usr"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>editor</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.usr"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>selector</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="actor.table.usr"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>provider</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.provider"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>purchase_order</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.purchase-order"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>picklist</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="acq.table.picklist"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>expected_recv_time</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>create_time</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT now();
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>edit_time</entry>
-                                                               <entry>timestamp with time zone</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT now();
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>marc</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>eg_bib_id</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                               <xref linkend="biblio.table.record-entry"/>
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>source_label</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>item_count</entry>
-                                                               <entry>integer</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>state</entry>
-                                                               <entry>text</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                               DEFAULT &apos;new&apos;::text;
-                                                                       
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                               </tbody>
-                                       </tgroup>
-                               </informaltable>
-                               <para>
-                               
-                               
-                                       <variablelist>
-                                               <title>Constraints on lineitem</title>
-                                               
-                                               <varlistentry>
-                                                       <term>picklist_or_po</term>
-                                                       <listitem><para>CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))</para></listitem>
-                                               </varlistentry>
-                                               
-                                       </variablelist>
-                               
-                               
-                               
-                               
-                                       <itemizedlist>
-                                               <title>
-                                                       Tables referencing acq.lineitem_attr via Foreign Key Constraints
-                                               </title>
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.lineitem-attr"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.lineitem-detail"/></para>
-                                                       </listitem>
-                                                       
-                               
-                               
-                                                       <listitem>
-                                                               <para><xref linkend="acq.table.lineitem-note"/></para>
-                                                       </listitem>
-                                                       
-                                       </itemizedlist>
-                               
-                               
-                               
-                               
-               </para>
-               </simplesect>
-               
-               <simplesect id="acq.table.lineitem-attr" xreflabel="acq.lineitem_attr">         
-                       <title>lineitem_attr</title>
-                       <informaltable>
-                               <tgroup cols="3">
-                                       <colspec colnum="1" colname="col1" colwidth="1.0*"/>
-                                       <colspec colnum="2" colname="col2" colwidth="1.0*"/>
-                                       <colspec colnum="3" colname="col3" colwidth="2.0*"/>
-                                       <thead>
-                                               <row>
-                                                       <entry>Field</entry>
-                                                       <entry>Data Type</entry>
-                                                       <entry>Constraints and References</entry>
-                                               </row>
-                                               </thead>
-                                               <tbody>
-                                               
-                                                       <row>
-                                                               <entry>id</entry>
-                                                               <entry>bigserial</entry>
-                                                               <entry><para>
-                                                                       
-                                                                               
-                                                                                       PRIMARY KEY
-                                                                                                               
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                       
-                                                                               
-                                                                       
-                                                                       </para></entry>
-                                                       </row>
-                                               
-                                                       <row>
-                                                               <entry>definition</entry>
-                                                               <entry>bigint</entry>
-                                                               <entry><para>
-                                                                       
-                                                                       
-                                                                               NOT NULL;
-                                                                       
-                                                                       
-                                                                       
-                                       &nb