Add acquisitions diagra, from Tim.
[working/Evergreen.git] / appendices / schema.xml
1 <?xml version="1.0" encoding="UTF-8" ?>
2 <chapter id="databaseschema">
3         <title>Database Schema</title>
4         <para>This is the schema for the Evergreen database.</para>     
5         
6         
7         
8         <section id="acq.schema">
9                 <title>Schema acq</title>
10                 <para></para>   
11         
12       <simplesect id="acq.table.acq-lineitem-history"
13                xreflabel="acq.acq_lineitem_history">
14         <title id="acq.table.acq-lineitem-history-title">
15          Table:
16          
17          acq_lineitem_history
18         </title>
19  
20                 <formalpara>
21                         <title>Columns:</title>
22                         <simplelist type="horiz" columns="1">
23                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
24                         <member>
25                         <database class="field">audit_id</database> : <database class="datatype">bigint</database> 
26 --
27                          <literal>PRIMARY KEY</literal>,
28                         </member>
29                         <member>
30                         <database class="field">audit_time</database> : <database class="datatype">timestamp with time zone</database> 
31 --
32                         <literal>NOT NULL</literal>, 
33                         </member>
34                         <member>
35                         <database class="field">audit_action</database> : <database class="datatype">text</database> 
36 --
37                         <literal>NOT NULL</literal>, 
38                         </member>
39                         <member>
40                         <database class="field">id</database> : <database class="datatype">bigint</database> 
41 --
42                         <literal>NOT NULL</literal>, 
43                         </member>
44                         <member>
45                         <database class="field">creator</database> : <database class="datatype">integer</database> 
46 --
47                         <literal>NOT NULL</literal>, 
48                         </member>
49                         <member>
50                         <database class="field">editor</database> : <database class="datatype">integer</database> 
51 --
52                         <literal>NOT NULL</literal>, 
53                         </member>
54                         <member>
55                         <database class="field">selector</database> : <database class="datatype">integer</database> 
56 --
57                         <literal>NOT NULL</literal>, 
58                         </member>
59                         <member>
60                         <database class="field">provider</database> : <database class="datatype">integer</database> 
61 --
62                         </member>
63                         <member>
64                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
65 --
66                         </member>
67                         <member>
68                         <database class="field">picklist</database> : <database class="datatype">integer</database> 
69 --
70                         </member>
71                         <member>
72                         <database class="field">expected_recv_time</database> : <database class="datatype">timestamp with time zone</database> 
73 --
74                         </member>
75                         <member>
76                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
77 --
78                         <literal>NOT NULL</literal>, 
79                         </member>
80                         <member>
81                         <database class="field">edit_time</database> : <database class="datatype">timestamp with time zone</database> 
82 --
83                         <literal>NOT NULL</literal>, 
84                         </member>
85                         <member>
86                         <database class="field">marc</database> : <database class="datatype">text</database> 
87 --
88                         <literal>NOT NULL</literal>, 
89                         </member>
90                         <member>
91                         <database class="field">eg_bib_id</database> : <database class="datatype">bigint</database> 
92 --
93                         </member>
94                         <member>
95                         <database class="field">source_label</database> : <database class="datatype">text</database> 
96 --
97                         </member>
98                         <member>
99                         <database class="field">state</database> : <database class="datatype">text</database> 
100 --
101                         <literal>NOT NULL</literal>, 
102                         </member>
103                         <member>
104                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
105 --
106                         </member>
107                         <member>
108                         <database class="field">estimated_unit_price</database> : <database class="datatype">numeric</database> 
109 --
110                         </member>
111                         <member>
112                         <database class="field">claim_policy</database> : <database class="datatype">integer</database> 
113 --
114                         </member>
115                 </simplelist>
116                 </formalpara>
117         <formalpara>
118                 <title>Indexes:</title>
119                 <simplelist type="horiz" columns="1">
120         <member><database class="index">acq_lineitem_hist_id_idx</database> : id</member>
121         </simplelist>
122         </formalpara>   
123     </simplesect>
124       <simplesect id="acq.view.acq-lineitem-lifecycle"
125                xreflabel="acq.acq_lineitem_lifecycle">
126         <title id="acq.view.acq-lineitem-lifecycle-title">
127          View:
128          
129          acq_lineitem_lifecycle
130         </title>
131  
132                 <formalpara>
133                         <title>Columns:</title>
134                         <simplelist type="horiz" columns="1">
135                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
136                         <member>
137                         <database class="field">?column?</database> : <database class="datatype">bigint</database> 
138 --
139                         </member>
140                         <member>
141                         <database class="field">audit_time</database> : <database class="datatype">timestamp with time zone</database> 
142 --
143                         </member>
144                         <member>
145                         <database class="field">audit_action</database> : <database class="datatype">text</database> 
146 --
147                         </member>
148                         <member>
149                         <database class="field">id</database> : <database class="datatype">bigint</database> 
150 --
151                         </member>
152                         <member>
153                         <database class="field">creator</database> : <database class="datatype">integer</database> 
154 --
155                         </member>
156                         <member>
157                         <database class="field">editor</database> : <database class="datatype">integer</database> 
158 --
159                         </member>
160                         <member>
161                         <database class="field">selector</database> : <database class="datatype">integer</database> 
162 --
163                         </member>
164                         <member>
165                         <database class="field">provider</database> : <database class="datatype">integer</database> 
166 --
167                         </member>
168                         <member>
169                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
170 --
171                         </member>
172                         <member>
173                         <database class="field">picklist</database> : <database class="datatype">integer</database> 
174 --
175                         </member>
176                         <member>
177                         <database class="field">expected_recv_time</database> : <database class="datatype">timestamp with time zone</database> 
178 --
179                         </member>
180                         <member>
181                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
182 --
183                         </member>
184                         <member>
185                         <database class="field">edit_time</database> : <database class="datatype">timestamp with time zone</database> 
186 --
187                         </member>
188                         <member>
189                         <database class="field">marc</database> : <database class="datatype">text</database> 
190 --
191                         </member>
192                         <member>
193                         <database class="field">eg_bib_id</database> : <database class="datatype">bigint</database> 
194 --
195                         </member>
196                         <member>
197                         <database class="field">source_label</database> : <database class="datatype">text</database> 
198 --
199                         </member>
200                         <member>
201                         <database class="field">state</database> : <database class="datatype">text</database> 
202 --
203                         </member>
204                         <member>
205                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
206 --
207                         </member>
208                         <member>
209                         <database class="field">estimated_unit_price</database> : <database class="datatype">numeric</database> 
210 --
211                         </member>
212                         <member>
213                         <database class="field">claim_policy</database> : <database class="datatype">integer</database> 
214 --
215                         </member>
216                 </simplelist>
217                 </formalpara>
218     </simplesect>
219       <simplesect id="acq.table.acq-purchase-order-history"
220                xreflabel="acq.acq_purchase_order_history">
221         <title id="acq.table.acq-purchase-order-history-title">
222          Table:
223          
224          acq_purchase_order_history
225         </title>
226  
227                 <formalpara>
228                         <title>Columns:</title>
229                         <simplelist type="horiz" columns="1">
230                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
231                         <member>
232                         <database class="field">audit_id</database> : <database class="datatype">bigint</database> 
233 --
234                          <literal>PRIMARY KEY</literal>,
235                         </member>
236                         <member>
237                         <database class="field">audit_time</database> : <database class="datatype">timestamp with time zone</database> 
238 --
239                         <literal>NOT NULL</literal>, 
240                         </member>
241                         <member>
242                         <database class="field">audit_action</database> : <database class="datatype">text</database> 
243 --
244                         <literal>NOT NULL</literal>, 
245                         </member>
246                         <member>
247                         <database class="field">id</database> : <database class="datatype">integer</database> 
248 --
249                         <literal>NOT NULL</literal>, 
250                         </member>
251                         <member>
252                         <database class="field">owner</database> : <database class="datatype">integer</database> 
253 --
254                         <literal>NOT NULL</literal>, 
255                         </member>
256                         <member>
257                         <database class="field">creator</database> : <database class="datatype">integer</database> 
258 --
259                         <literal>NOT NULL</literal>, 
260                         </member>
261                         <member>
262                         <database class="field">editor</database> : <database class="datatype">integer</database> 
263 --
264                         <literal>NOT NULL</literal>, 
265                         </member>
266                         <member>
267                         <database class="field">ordering_agency</database> : <database class="datatype">integer</database> 
268 --
269                         <literal>NOT NULL</literal>, 
270                         </member>
271                         <member>
272                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
273 --
274                         <literal>NOT NULL</literal>, 
275                         </member>
276                         <member>
277                         <database class="field">edit_time</database> : <database class="datatype">timestamp with time zone</database> 
278 --
279                         <literal>NOT NULL</literal>, 
280                         </member>
281                         <member>
282                         <database class="field">provider</database> : <database class="datatype">integer</database> 
283 --
284                         <literal>NOT NULL</literal>, 
285                         </member>
286                         <member>
287                         <database class="field">state</database> : <database class="datatype">text</database> 
288 --
289                         <literal>NOT NULL</literal>, 
290                         </member>
291                         <member>
292                         <database class="field">order_date</database> : <database class="datatype">timestamp with time zone</database> 
293 --
294                         </member>
295                         <member>
296                         <database class="field">name</database> : <database class="datatype">text</database> 
297 --
298                         <literal>NOT NULL</literal>, 
299                         </member>
300                         <member>
301                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
302 --
303                         </member>
304                         <member>
305                         <database class="field">prepayment_required</database> : <database class="datatype">boolean</database> 
306 --
307                         <literal>NOT NULL</literal>, 
308                         </member>
309                 </simplelist>
310                 </formalpara>
311         <formalpara>
312                 <title>Indexes:</title>
313                 <simplelist type="horiz" columns="1">
314         <member><database class="index">acq_po_hist_id_idx</database> : id</member>
315         </simplelist>
316         </formalpara>   
317     </simplesect>
318       <simplesect id="acq.view.acq-purchase-order-lifecycle"
319                xreflabel="acq.acq_purchase_order_lifecycle">
320         <title id="acq.view.acq-purchase-order-lifecycle-title">
321          View:
322          
323          acq_purchase_order_lifecycle
324         </title>
325  
326                 <formalpara>
327                         <title>Columns:</title>
328                         <simplelist type="horiz" columns="1">
329                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
330                         <member>
331                         <database class="field">?column?</database> : <database class="datatype">bigint</database> 
332 --
333                         </member>
334                         <member>
335                         <database class="field">audit_time</database> : <database class="datatype">timestamp with time zone</database> 
336 --
337                         </member>
338                         <member>
339                         <database class="field">audit_action</database> : <database class="datatype">text</database> 
340 --
341                         </member>
342                         <member>
343                         <database class="field">id</database> : <database class="datatype">integer</database> 
344 --
345                         </member>
346                         <member>
347                         <database class="field">owner</database> : <database class="datatype">integer</database> 
348 --
349                         </member>
350                         <member>
351                         <database class="field">creator</database> : <database class="datatype">integer</database> 
352 --
353                         </member>
354                         <member>
355                         <database class="field">editor</database> : <database class="datatype">integer</database> 
356 --
357                         </member>
358                         <member>
359                         <database class="field">ordering_agency</database> : <database class="datatype">integer</database> 
360 --
361                         </member>
362                         <member>
363                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
364 --
365                         </member>
366                         <member>
367                         <database class="field">edit_time</database> : <database class="datatype">timestamp with time zone</database> 
368 --
369                         </member>
370                         <member>
371                         <database class="field">provider</database> : <database class="datatype">integer</database> 
372 --
373                         </member>
374                         <member>
375                         <database class="field">state</database> : <database class="datatype">text</database> 
376 --
377                         </member>
378                         <member>
379                         <database class="field">order_date</database> : <database class="datatype">timestamp with time zone</database> 
380 --
381                         </member>
382                         <member>
383                         <database class="field">name</database> : <database class="datatype">text</database> 
384 --
385                         </member>
386                         <member>
387                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
388 --
389                         </member>
390                         <member>
391                         <database class="field">prepayment_required</database> : <database class="datatype">boolean</database> 
392 --
393                         </member>
394                 </simplelist>
395                 </formalpara>
396     </simplesect>
397       <simplesect id="acq.view.all-fund-allocation-total"
398                xreflabel="acq.all_fund_allocation_total">
399         <title id="acq.view.all-fund-allocation-total-title">
400          View:
401          
402          all_fund_allocation_total
403         </title>
404  
405                 <formalpara>
406                         <title>Columns:</title>
407                         <simplelist type="horiz" columns="1">
408                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
409                         <member>
410                         <database class="field">fund</database> : <database class="datatype">integer</database> 
411 --
412                         </member>
413                         <member>
414                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
415 --
416                         </member>
417                 </simplelist>
418                 </formalpara>
419     </simplesect>
420       <simplesect id="acq.view.all-fund-combined-balance"
421                xreflabel="acq.all_fund_combined_balance">
422         <title id="acq.view.all-fund-combined-balance-title">
423          View:
424          
425          all_fund_combined_balance
426         </title>
427  
428                 <formalpara>
429                         <title>Columns:</title>
430                         <simplelist type="horiz" columns="1">
431                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
432                         <member>
433                         <database class="field">fund</database> : <database class="datatype">integer</database> 
434 --
435                         </member>
436                         <member>
437                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
438 --
439                         </member>
440                 </simplelist>
441                 </formalpara>
442     </simplesect>
443       <simplesect id="acq.view.all-fund-encumbrance-total"
444                xreflabel="acq.all_fund_encumbrance_total">
445         <title id="acq.view.all-fund-encumbrance-total-title">
446          View:
447          
448          all_fund_encumbrance_total
449         </title>
450  
451                 <formalpara>
452                         <title>Columns:</title>
453                         <simplelist type="horiz" columns="1">
454                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
455                         <member>
456                         <database class="field">fund</database> : <database class="datatype">integer</database> 
457 --
458                         </member>
459                         <member>
460                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
461 --
462                         </member>
463                 </simplelist>
464                 </formalpara>
465     </simplesect>
466       <simplesect id="acq.view.all-fund-spent-balance"
467                xreflabel="acq.all_fund_spent_balance">
468         <title id="acq.view.all-fund-spent-balance-title">
469          View:
470          
471          all_fund_spent_balance
472         </title>
473  
474                 <formalpara>
475                         <title>Columns:</title>
476                         <simplelist type="horiz" columns="1">
477                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
478                         <member>
479                         <database class="field">fund</database> : <database class="datatype">integer</database> 
480 --
481                         </member>
482                         <member>
483                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
484 --
485                         </member>
486                 </simplelist>
487                 </formalpara>
488     </simplesect>
489       <simplesect id="acq.view.all-fund-spent-total"
490                xreflabel="acq.all_fund_spent_total">
491         <title id="acq.view.all-fund-spent-total-title">
492          View:
493          
494          all_fund_spent_total
495         </title>
496  
497                 <formalpara>
498                         <title>Columns:</title>
499                         <simplelist type="horiz" columns="1">
500                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
501                         <member>
502                         <database class="field">fund</database> : <database class="datatype">integer</database> 
503 --
504                         </member>
505                         <member>
506                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
507 --
508                         </member>
509                 </simplelist>
510                 </formalpara>
511     </simplesect>
512       <simplesect id="acq.table.cancel-reason"
513                xreflabel="acq.cancel_reason">
514         <title id="acq.table.cancel-reason-title">
515          Table:
516          
517          cancel_reason
518         </title>
519  
520                 <formalpara>
521                         <title>Columns:</title>
522                         <simplelist type="horiz" columns="1">
523                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
524                         <member>
525                         <database class="field">id</database> : <database class="datatype">serial</database> 
526 --
527                          <literal>PRIMARY KEY</literal>,
528                         </member>
529                         <member>
530                         <database class="field">org_unit</database> : <database class="datatype">integer</database> 
531 --
532                          <literal>UNIQUE#1</literal>,
533                         <literal>NOT NULL</literal>, 
534                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
535                         </member>
536                         <member>
537                         <database class="field">label</database> : <database class="datatype">text</database> 
538 --
539                          <literal>UNIQUE#1</literal>,
540                         <literal>NOT NULL</literal>, 
541                         </member>
542                         <member>
543                         <database class="field">description</database> : <database class="datatype">text</database> 
544 --
545                         <literal>NOT NULL</literal>, 
546                         </member>
547                         <member>
548                         <database class="field">keep_debits</database> : <database class="datatype">boolean</database> 
549 --
550                         <literal>NOT NULL</literal>, 
551                         <literal>DEFAULT false</literal>, 
552                         </member>
553                 </simplelist>
554                 </formalpara>
555         <formalpara>         
556                 <title>Tables referencing acq.lineitem via Foreign Key Constraints:</title>
557                 <simplelist type="horiz" columns="2">
558                 <member><xref linkend="acq.table.lineitem"/></member> 
559                 <member><xref linkend="acq.table.lineitem-detail"/></member> 
560                 <member><xref linkend="acq.table.purchase-order"/></member> 
561                 <member><xref linkend="acq.table.user-request"/></member> 
562                 </simplelist>
563         </formalpara>
564     </simplesect>
565       <simplesect id="acq.table.claim"
566                xreflabel="acq.claim">
567         <title id="acq.table.claim-title">
568          Table:
569          
570          claim
571         </title>
572  
573                 <formalpara>
574                         <title>Columns:</title>
575                         <simplelist type="horiz" columns="1">
576                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
577                         <member>
578                         <database class="field">id</database> : <database class="datatype">serial</database> 
579 --
580                          <literal>PRIMARY KEY</literal>,
581                         </member>
582                         <member>
583                         <database class="field">type</database> : <database class="datatype">integer</database> 
584 --
585                         <literal>NOT NULL</literal>, 
586                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim-type"/>. 
587                         </member>
588                         <member>
589                         <database class="field">lineitem_detail</database> : <database class="datatype">bigint</database> 
590 --
591                         <literal>NOT NULL</literal>, 
592                         <literal>REFERENCES</literal> <xref linkend="acq.table.lineitem-detail"/>. 
593                         </member>
594                 </simplelist>
595                 </formalpara>
596         <formalpara>
597                 <title>Indexes:</title>
598                 <simplelist type="horiz" columns="1">
599         <member><database class="index">claim_lid_idx</database> : lineitem_detail</member>
600         </simplelist>
601         </formalpara>   
602         <formalpara>         
603                 <title>Tables referencing acq.claim_event via Foreign Key Constraints:</title>
604                 <simplelist type="horiz" columns="2">
605                 <member><xref linkend="acq.table.claim-event"/></member> 
606                 </simplelist>
607         </formalpara>
608     </simplesect>
609       <simplesect id="acq.table.claim-event"
610                xreflabel="acq.claim_event">
611         <title id="acq.table.claim-event-title">
612          Table:
613          
614          claim_event
615         </title>
616  
617                 <formalpara>
618                         <title>Columns:</title>
619                         <simplelist type="horiz" columns="1">
620                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
621                         <member>
622                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
623 --
624                          <literal>PRIMARY KEY</literal>,
625                         </member>
626                         <member>
627                         <database class="field">type</database> : <database class="datatype">integer</database> 
628 --
629                         <literal>NOT NULL</literal>, 
630                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim-event-type"/>. 
631                         </member>
632                         <member>
633                         <database class="field">claim</database> : <database class="datatype">serial</database> 
634 --
635                         <literal>NOT NULL</literal>, 
636                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim"/>. 
637                         </member>
638                         <member>
639                         <database class="field">event_date</database> : <database class="datatype">timestamp with time zone</database> 
640 --
641                         <literal>NOT NULL</literal>, 
642                         <literal>DEFAULT now()</literal>, 
643                         </member>
644                         <member>
645                         <database class="field">creator</database> : <database class="datatype">integer</database> 
646 --
647                         <literal>NOT NULL</literal>, 
648                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
649                         </member>
650                         <member>
651                         <database class="field">note</database> : <database class="datatype">text</database> 
652 --
653                         </member>
654                 </simplelist>
655                 </formalpara>
656         <formalpara>
657                 <title>Indexes:</title>
658                 <simplelist type="horiz" columns="1">
659         <member><database class="index">claim_event_claim_date_idx</database> : claim, event_date</member>
660         </simplelist>
661         </formalpara>   
662     </simplesect>
663       <simplesect id="acq.table.claim-event-type"
664                xreflabel="acq.claim_event_type">
665         <title id="acq.table.claim-event-type-title">
666          Table:
667          
668          claim_event_type
669         </title>
670  
671                 <formalpara>
672                         <title>Columns:</title>
673                         <simplelist type="horiz" columns="1">
674                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
675                         <member>
676                         <database class="field">id</database> : <database class="datatype">serial</database> 
677 --
678                          <literal>PRIMARY KEY</literal>,
679                         </member>
680                         <member>
681                         <database class="field">org_unit</database> : <database class="datatype">integer</database> 
682 --
683                          <literal>UNIQUE#1</literal>,
684                         <literal>NOT NULL</literal>, 
685                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
686                         </member>
687                         <member>
688                         <database class="field">code</database> : <database class="datatype">text</database> 
689 --
690                          <literal>UNIQUE#1</literal>,
691                         <literal>NOT NULL</literal>, 
692                         </member>
693                         <member>
694                         <database class="field">description</database> : <database class="datatype">text</database> 
695 --
696                         <literal>NOT NULL</literal>, 
697                         </member>
698                         <member>
699                         <database class="field">library_initiated</database> : <database class="datatype">boolean</database> 
700 --
701                         <literal>NOT NULL</literal>, 
702                         <literal>DEFAULT false</literal>, 
703                         </member>
704                 </simplelist>
705                 </formalpara>
706         <formalpara>         
707                 <title>Tables referencing acq.claim_event via Foreign Key Constraints:</title>
708                 <simplelist type="horiz" columns="2">
709                 <member><xref linkend="acq.table.claim-event"/></member> 
710                 <member><xref linkend="acq.table.claim-policy-action"/></member> 
711                 <member><xref linkend="acq.table.serial-claim-event"/></member> 
712                 </simplelist>
713         </formalpara>
714     </simplesect>
715       <simplesect id="acq.table.claim-policy"
716                xreflabel="acq.claim_policy">
717         <title id="acq.table.claim-policy-title">
718          Table:
719          
720          claim_policy
721         </title>
722  
723                 <formalpara>
724                         <title>Columns:</title>
725                         <simplelist type="horiz" columns="1">
726                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
727                         <member>
728                         <database class="field">id</database> : <database class="datatype">serial</database> 
729 --
730                          <literal>PRIMARY KEY</literal>,
731                         </member>
732                         <member>
733                         <database class="field">org_unit</database> : <database class="datatype">integer</database> 
734 --
735                          <literal>UNIQUE#1</literal>,
736                         <literal>NOT NULL</literal>, 
737                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
738                         </member>
739                         <member>
740                         <database class="field">name</database> : <database class="datatype">text</database> 
741 --
742                          <literal>UNIQUE#1</literal>,
743                         <literal>NOT NULL</literal>, 
744                         </member>
745                         <member>
746                         <database class="field">description</database> : <database class="datatype">text</database> 
747 --
748                         <literal>NOT NULL</literal>, 
749                         </member>
750                 </simplelist>
751                 </formalpara>
752         <formalpara>         
753                 <title>Tables referencing acq.claim_policy_action via Foreign Key Constraints:</title>
754                 <simplelist type="horiz" columns="2">
755                 <member><xref linkend="acq.table.claim-policy-action"/></member> 
756                 <member><xref linkend="acq.table.lineitem"/></member> 
757                 <member><xref linkend="acq.table.provider"/></member> 
758                 </simplelist>
759         </formalpara>
760     </simplesect>
761       <simplesect id="acq.table.claim-policy-action"
762                xreflabel="acq.claim_policy_action">
763         <title id="acq.table.claim-policy-action-title">
764          Table:
765          
766          claim_policy_action
767         </title>
768  
769                 <formalpara>
770                         <title>Columns:</title>
771                         <simplelist type="horiz" columns="1">
772                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
773                         <member>
774                         <database class="field">id</database> : <database class="datatype">serial</database> 
775 --
776                          <literal>PRIMARY KEY</literal>,
777                         </member>
778                         <member>
779                         <database class="field">claim_policy</database> : <database class="datatype">integer</database> 
780 --
781                          <literal>UNIQUE#1</literal>,
782                         <literal>NOT NULL</literal>, 
783                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim-policy"/>. 
784                         </member>
785                         <member>
786                         <database class="field">action_interval</database> : <database class="datatype">interval</database> 
787 --
788                          <literal>UNIQUE#1</literal>,
789                         <literal>NOT NULL</literal>, 
790                         </member>
791                         <member>
792                         <database class="field">action</database> : <database class="datatype">integer</database> 
793 --
794                         <literal>NOT NULL</literal>, 
795                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim-event-type"/>. 
796                         </member>
797                 </simplelist>
798                 </formalpara>
799     </simplesect>
800       <simplesect id="acq.table.claim-type"
801                xreflabel="acq.claim_type">
802         <title id="acq.table.claim-type-title">
803          Table:
804          
805          claim_type
806         </title>
807  
808                 <formalpara>
809                         <title>Columns:</title>
810                         <simplelist type="horiz" columns="1">
811                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
812                         <member>
813                         <database class="field">id</database> : <database class="datatype">serial</database> 
814 --
815                          <literal>PRIMARY KEY</literal>,
816                         </member>
817                         <member>
818                         <database class="field">org_unit</database> : <database class="datatype">integer</database> 
819 --
820                          <literal>UNIQUE#1</literal>,
821                         <literal>NOT NULL</literal>, 
822                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
823                         </member>
824                         <member>
825                         <database class="field">code</database> : <database class="datatype">text</database> 
826 --
827                          <literal>UNIQUE#1</literal>,
828                         <literal>NOT NULL</literal>, 
829                         </member>
830                         <member>
831                         <database class="field">description</database> : <database class="datatype">text</database> 
832 --
833                         <literal>NOT NULL</literal>, 
834                         </member>
835                 </simplelist>
836                 </formalpara>
837         <formalpara>         
838                 <title>Tables referencing acq.claim via Foreign Key Constraints:</title>
839                 <simplelist type="horiz" columns="2">
840                 <member><xref linkend="acq.table.claim"/></member> 
841                 <member><xref linkend="acq.table.serial-claim"/></member> 
842                 </simplelist>
843         </formalpara>
844     </simplesect>
845       <simplesect id="acq.table.currency-type"
846                xreflabel="acq.currency_type">
847         <title id="acq.table.currency-type-title">
848          Table:
849          
850          currency_type
851         </title>
852  
853                 <formalpara>
854                         <title>Columns:</title>
855                         <simplelist type="horiz" columns="1">
856                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
857                         <member>
858                         <database class="field">code</database> : <database class="datatype">text</database> 
859 --
860                          <literal>PRIMARY KEY</literal>,
861                         </member>
862                         <member>
863                         <database class="field">label</database> : <database class="datatype">text</database> 
864 --
865                         </member>
866                 </simplelist>
867                 </formalpara>
868         <formalpara>         
869                 <title>Tables referencing acq.exchange_rate via Foreign Key Constraints:</title>
870                 <simplelist type="horiz" columns="2">
871                 <member><xref linkend="acq.table.exchange-rate"/></member> 
872                 <member><xref linkend="acq.table.fund"/></member> 
873                 <member><xref linkend="acq.table.fund-debit"/></member> 
874                 <member><xref linkend="acq.table.funding-source"/></member> 
875                 <member><xref linkend="acq.table.provider"/></member> 
876                 </simplelist>
877         </formalpara>
878     </simplesect>
879       <simplesect id="acq.table.debit-attribution"
880                xreflabel="acq.debit_attribution">
881         <title id="acq.table.debit-attribution-title">
882          Table:
883          
884          debit_attribution
885         </title>
886  
887                 <formalpara>
888                         <title>Columns:</title>
889                         <simplelist type="horiz" columns="1">
890                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
891                         <member>
892                         <database class="field">id</database> : <database class="datatype">integer</database> 
893 --
894                          <literal>PRIMARY KEY</literal>,
895                         </member>
896                         <member>
897                         <database class="field">fund_debit</database> : <database class="datatype">integer</database> 
898 --
899                         <literal>NOT NULL</literal>, 
900                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund-debit"/>. 
901                         </member>
902                         <member>
903                         <database class="field">debit_amount</database> : <database class="datatype">numeric</database> 
904 --
905                         <literal>NOT NULL</literal>, 
906                         </member>
907                         <member>
908                         <database class="field">funding_source_credit</database> : <database class="datatype">integer</database> 
909 --
910                         <literal>REFERENCES</literal> <xref linkend="acq.table.funding-source-credit"/>. 
911                         </member>
912                         <member>
913                         <database class="field">credit_amount</database> : <database class="datatype">numeric</database> 
914 --
915                         </member>
916                 </simplelist>
917                 </formalpara>
918         <formalpara>
919                 <title>Indexes:</title>
920                 <simplelist type="horiz" columns="1">
921         <member><database class="index">acq_attribution_credit_idx</database> : funding_source_credit</member>
922         <member><database class="index">acq_attribution_debit_idx</database> : fund_debit</member>
923         </simplelist>
924         </formalpara>   
925     </simplesect>
926       <simplesect id="acq.table.distribution-formula"
927                xreflabel="acq.distribution_formula">
928         <title id="acq.table.distribution-formula-title">
929          Table:
930          
931          distribution_formula
932         </title>
933  
934                 <formalpara>
935                         <title>Columns:</title>
936                         <simplelist type="horiz" columns="1">
937                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
938                         <member>
939                         <database class="field">id</database> : <database class="datatype">serial</database> 
940 --
941                          <literal>PRIMARY KEY</literal>,
942                         </member>
943                         <member>
944                         <database class="field">owner</database> : <database class="datatype">integer</database> 
945 --
946                          <literal>UNIQUE#1</literal>,
947                         <literal>NOT NULL</literal>, 
948                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
949                         </member>
950                         <member>
951                         <database class="field">name</database> : <database class="datatype">text</database> 
952 --
953                          <literal>UNIQUE#1</literal>,
954                         <literal>NOT NULL</literal>, 
955                         </member>
956                         <member>
957                         <database class="field">skip_count</database> : <database class="datatype">integer</database> 
958 --
959                         <literal>NOT NULL</literal>, 
960                         </member>
961                 </simplelist>
962                 </formalpara>
963         <formalpara>         
964                 <title>Tables referencing acq.distribution_formula_application via Foreign Key Constraints:</title>
965                 <simplelist type="horiz" columns="2">
966                 <member><xref linkend="acq.table.distribution-formula-application"/></member> 
967                 <member><xref linkend="acq.table.distribution-formula-entry"/></member> 
968                 </simplelist>
969         </formalpara>
970     </simplesect>
971       <simplesect id="acq.table.distribution-formula-application"
972                xreflabel="acq.distribution_formula_application">
973         <title id="acq.table.distribution-formula-application-title">
974          Table:
975          
976          distribution_formula_application
977         </title>
978  
979                 <formalpara>
980                         <title>Columns:</title>
981                         <simplelist type="horiz" columns="1">
982                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
983                         <member>
984                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
985 --
986                          <literal>PRIMARY KEY</literal>,
987                         </member>
988                         <member>
989                         <database class="field">creator</database> : <database class="datatype">integer</database> 
990 --
991                         <literal>NOT NULL</literal>, 
992                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
993                         </member>
994                         <member>
995                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
996 --
997                         <literal>NOT NULL</literal>, 
998                         <literal>DEFAULT now()</literal>, 
999                         </member>
1000                         <member>
1001                         <database class="field">formula</database> : <database class="datatype">integer</database> 
1002 --
1003                         <literal>NOT NULL</literal>, 
1004                         <literal>REFERENCES</literal> <xref linkend="acq.table.distribution-formula"/>. 
1005                         </member>
1006                         <member>
1007                         <database class="field">lineitem</database> : <database class="datatype">integer</database> 
1008 --
1009                         <literal>NOT NULL</literal>, 
1010                         <literal>REFERENCES</literal> <xref linkend="acq.table.lineitem"/>. 
1011                         </member>
1012                 </simplelist>
1013                 </formalpara>
1014         <formalpara>
1015                 <title>Indexes:</title>
1016                 <simplelist type="horiz" columns="1">
1017         <member><database class="index">acqdfa_creator_idx</database> : creator</member>
1018         <member><database class="index">acqdfa_df_idx</database> : formula</member>
1019         <member><database class="index">acqdfa_li_idx</database> : lineitem</member>
1020         </simplelist>
1021         </formalpara>   
1022     </simplesect>
1023       <simplesect id="acq.table.distribution-formula-entry"
1024                xreflabel="acq.distribution_formula_entry">
1025         <title id="acq.table.distribution-formula-entry-title">
1026          Table:
1027          
1028          distribution_formula_entry
1029         </title>
1030  
1031                 <formalpara>
1032                         <title>Columns:</title>
1033                         <simplelist type="horiz" columns="1">
1034                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1035                         <member>
1036                         <database class="field">id</database> : <database class="datatype">serial</database> 
1037 --
1038                          <literal>PRIMARY KEY</literal>,
1039                         </member>
1040                         <member>
1041                         <database class="field">formula</database> : <database class="datatype">integer</database> 
1042 --
1043                          <literal>UNIQUE#1</literal>,
1044                         <literal>NOT NULL</literal>, 
1045                         <literal>REFERENCES</literal> <xref linkend="acq.table.distribution-formula"/>. 
1046                         </member>
1047                         <member>
1048                         <database class="field">position</database> : <database class="datatype">integer</database> 
1049 --
1050                          <literal>UNIQUE#1</literal>,
1051                         <literal>NOT NULL</literal>, 
1052                         </member>
1053                         <member>
1054                         <database class="field">item_count</database> : <database class="datatype">integer</database> 
1055 --
1056                         <literal>NOT NULL</literal>, 
1057                         </member>
1058                         <member>
1059                         <database class="field">owning_lib</database> : <database class="datatype">integer</database> 
1060 --
1061                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
1062                         </member>
1063                         <member>
1064                         <database class="field">location</database> : <database class="datatype">integer</database> 
1065 --
1066                         <literal>REFERENCES</literal> <xref linkend="asset.table.copy-location"/>. 
1067                         </member>
1068                 </simplelist>
1069                 </formalpara>
1070         <formalpara>
1071         <title>Constraints:</title>
1072         <simplelist type="horiz" columns="1">
1073           <member><database class="constraint">acqdfe_must_be_somewhere</database> : CHECK (((owning_lib IS NOT NULL) OR (location IS NOT NULL)))</member>
1074         </simplelist>
1075         </formalpara>
1076     </simplesect>
1077       <simplesect id="acq.table.edi-account"
1078                xreflabel="acq.edi_account">
1079         <title id="acq.table.edi-account-title">
1080          Table:
1081          
1082          edi_account
1083         </title>
1084  
1085                 <formalpara>
1086                         <title>Columns:</title>
1087                         <simplelist type="horiz" columns="1">
1088                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1089                         <member>
1090                         <database class="field">id</database> : <database class="datatype">integer</database> 
1091 --
1092                          <literal>PRIMARY KEY</literal>,
1093                         <literal>DEFAULT nextval(&apos;config.remote_account_id_seq&apos;::regclass)</literal>, 
1094                         </member>
1095                         <member>
1096                         <database class="field">label</database> : <database class="datatype">text</database> 
1097 --
1098                         <literal>NOT NULL</literal>, 
1099                         </member>
1100                         <member>
1101                         <database class="field">host</database> : <database class="datatype">text</database> 
1102 --
1103                         <literal>NOT NULL</literal>, 
1104                         </member>
1105                         <member>
1106                         <database class="field">username</database> : <database class="datatype">text</database> 
1107 --
1108                         </member>
1109                         <member>
1110                         <database class="field">password</database> : <database class="datatype">text</database> 
1111 --
1112                         </member>
1113                         <member>
1114                         <database class="field">account</database> : <database class="datatype">text</database> 
1115 --
1116                         </member>
1117                         <member>
1118                         <database class="field">path</database> : <database class="datatype">text</database> 
1119 --
1120                         </member>
1121                         <member>
1122                         <database class="field">owner</database> : <database class="datatype">integer</database> 
1123 --
1124                         <literal>NOT NULL</literal>, 
1125                         </member>
1126                         <member>
1127                         <database class="field">last_activity</database> : <database class="datatype">timestamp with time zone</database> 
1128 --
1129                         </member>
1130                         <member>
1131                         <database class="field">provider</database> : <database class="datatype">integer</database> 
1132 --
1133                         <literal>NOT NULL</literal>, 
1134                         <literal>REFERENCES</literal> <xref linkend="acq.table.provider"/>. 
1135                         </member>
1136                         <member>
1137                         <database class="field">in_dir</database> : <database class="datatype">text</database> 
1138 --
1139                         </member>
1140                         <member>
1141                         <database class="field">vendcode</database> : <database class="datatype">text</database> 
1142 --
1143                         </member>
1144                         <member>
1145                         <database class="field">vendacct</database> : <database class="datatype">text</database> 
1146 --
1147                         </member>
1148                 </simplelist>
1149                 </formalpara>
1150         <formalpara>         
1151                 <title>Tables referencing acq.edi_message via Foreign Key Constraints:</title>
1152                 <simplelist type="horiz" columns="2">
1153                 <member><xref linkend="acq.table.edi-message"/></member> 
1154                 <member><xref linkend="acq.table.provider"/></member> 
1155                 </simplelist>
1156         </formalpara>
1157     </simplesect>
1158       <simplesect id="acq.table.edi-message"
1159                xreflabel="acq.edi_message">
1160         <title id="acq.table.edi-message-title">
1161          Table:
1162          
1163          edi_message
1164         </title>
1165  
1166                 <formalpara>
1167                         <title>Columns:</title>
1168                         <simplelist type="horiz" columns="1">
1169                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1170                         <member>
1171                         <database class="field">id</database> : <database class="datatype">serial</database> 
1172 --
1173                          <literal>PRIMARY KEY</literal>,
1174                         </member>
1175                         <member>
1176                         <database class="field">account</database> : <database class="datatype">integer</database> 
1177 --
1178                         <literal>REFERENCES</literal> <xref linkend="acq.table.edi-account"/>. 
1179                         </member>
1180                         <member>
1181                         <database class="field">remote_file</database> : <database class="datatype">text</database> 
1182 --
1183                         </member>
1184                         <member>
1185                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
1186 --
1187                         <literal>NOT NULL</literal>, 
1188                         <literal>DEFAULT now()</literal>, 
1189                         </member>
1190                         <member>
1191                         <database class="field">translate_time</database> : <database class="datatype">timestamp with time zone</database> 
1192 --
1193                         </member>
1194                         <member>
1195                         <database class="field">process_time</database> : <database class="datatype">timestamp with time zone</database> 
1196 --
1197                         </member>
1198                         <member>
1199                         <database class="field">error_time</database> : <database class="datatype">timestamp with time zone</database> 
1200 --
1201                         </member>
1202                         <member>
1203                         <database class="field">status</database> : <database class="datatype">text</database> 
1204 --
1205                         <literal>NOT NULL</literal>, 
1206                         <literal>DEFAULT &apos;new&apos;::text</literal>, 
1207                         </member>
1208                         <member>
1209                         <database class="field">edi</database> : <database class="datatype">text</database> 
1210 --
1211                         </member>
1212                         <member>
1213                         <database class="field">jedi</database> : <database class="datatype">text</database> 
1214 --
1215                         </member>
1216                         <member>
1217                         <database class="field">error</database> : <database class="datatype">text</database> 
1218 --
1219                         </member>
1220                         <member>
1221                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
1222 --
1223                         <literal>REFERENCES</literal> <xref linkend="acq.table.purchase-order"/>. 
1224                         </member>
1225                         <member>
1226                         <database class="field">message_type</database> : <database class="datatype">text</database> 
1227 --
1228                         <literal>NOT NULL</literal>, 
1229                         </member>
1230                 </simplelist>
1231                 </formalpara>
1232         <formalpara>
1233         <title>Constraints:</title>
1234         <simplelist type="horiz" columns="1">
1235           <member><database class="constraint">status_value</database> : CHECK ((status = ANY (ARRAY[&apos;new&apos;::text, &apos;translated&apos;::text, &apos;trans_error&apos;::text, &apos;processed&apos;::text, &apos;proc_error&apos;::text, &apos;delete_error&apos;::text, &apos;retry&apos;::text, &apos;complete&apos;::text])))</member>
1236           <member><database class="constraint">valid_message_type</database> : CHECK ((message_type = ANY (ARRAY[&apos;ORDERS&apos;::text, &apos;ORDRSP&apos;::text, &apos;INVOIC&apos;::text, &apos;OSTENQ&apos;::text, &apos;OSTRPT&apos;::text])))</member>
1237         </simplelist>
1238         </formalpara>
1239     </simplesect>
1240       <simplesect id="acq.table.exchange-rate"
1241                xreflabel="acq.exchange_rate">
1242         <title id="acq.table.exchange-rate-title">
1243          Table:
1244          
1245          exchange_rate
1246         </title>
1247  
1248                 <formalpara>
1249                         <title>Columns:</title>
1250                         <simplelist type="horiz" columns="1">
1251                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1252                         <member>
1253                         <database class="field">id</database> : <database class="datatype">serial</database> 
1254 --
1255                          <literal>PRIMARY KEY</literal>,
1256                         </member>
1257                         <member>
1258                         <database class="field">from_currency</database> : <database class="datatype">text</database> 
1259 --
1260                          <literal>UNIQUE#1</literal>,
1261                         <literal>NOT NULL</literal>, 
1262                         <literal>REFERENCES</literal> <xref linkend="acq.table.currency-type"/>. 
1263                         </member>
1264                         <member>
1265                         <database class="field">to_currency</database> : <database class="datatype">text</database> 
1266 --
1267                          <literal>UNIQUE#1</literal>,
1268                         <literal>NOT NULL</literal>, 
1269                         <literal>REFERENCES</literal> <xref linkend="acq.table.currency-type"/>. 
1270                         </member>
1271                         <member>
1272                         <database class="field">ratio</database> : <database class="datatype">numeric</database> 
1273 --
1274                         <literal>NOT NULL</literal>, 
1275                         </member>
1276                 </simplelist>
1277                 </formalpara>
1278     </simplesect>
1279       <simplesect id="acq.table.fiscal-calendar"
1280                xreflabel="acq.fiscal_calendar">
1281         <title id="acq.table.fiscal-calendar-title">
1282          Table:
1283          
1284          fiscal_calendar
1285         </title>
1286  
1287                 <formalpara>
1288                         <title>Columns:</title>
1289                         <simplelist type="horiz" columns="1">
1290                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1291                         <member>
1292                         <database class="field">id</database> : <database class="datatype">serial</database> 
1293 --
1294                          <literal>PRIMARY KEY</literal>,
1295                         </member>
1296                         <member>
1297                         <database class="field">name</database> : <database class="datatype">text</database> 
1298 --
1299                         <literal>NOT NULL</literal>, 
1300                         </member>
1301                 </simplelist>
1302                 </formalpara>
1303         <formalpara>         
1304                 <title>Tables referencing acq.fiscal_year via Foreign Key Constraints:</title>
1305                 <simplelist type="horiz" columns="2">
1306                 <member><xref linkend="acq.table.fiscal-year"/></member> 
1307                 <member><xref linkend="actor.table.org-unit"/></member> 
1308                 </simplelist>
1309         </formalpara>
1310     </simplesect>
1311       <simplesect id="acq.table.fiscal-year"
1312                xreflabel="acq.fiscal_year">
1313         <title id="acq.table.fiscal-year-title">
1314          Table:
1315          
1316          fiscal_year
1317         </title>
1318  
1319                 <formalpara>
1320                         <title>Columns:</title>
1321                         <simplelist type="horiz" columns="1">
1322                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1323                         <member>
1324                         <database class="field">id</database> : <database class="datatype">serial</database> 
1325 --
1326                          <literal>PRIMARY KEY</literal>,
1327                         </member>
1328                         <member>
1329                         <database class="field">calendar</database> : <database class="datatype">integer</database> 
1330 --
1331                          <literal>UNIQUE#1</literal>,
1332                          <literal>UNIQUE#2</literal>,
1333                         <literal>NOT NULL</literal>, 
1334                         <literal>REFERENCES</literal> <xref linkend="acq.table.fiscal-calendar"/>. 
1335                         </member>
1336                         <member>
1337                         <database class="field">year</database> : <database class="datatype">integer</database> 
1338 --
1339                          <literal>UNIQUE#1</literal>,
1340                         <literal>NOT NULL</literal>, 
1341                         </member>
1342                         <member>
1343                         <database class="field">year_begin</database> : <database class="datatype">timestamp with time zone</database> 
1344 --
1345                          <literal>UNIQUE#2</literal>,
1346                         <literal>NOT NULL</literal>, 
1347                         </member>
1348                         <member>
1349                         <database class="field">year_end</database> : <database class="datatype">timestamp with time zone</database> 
1350 --
1351                         <literal>NOT NULL</literal>, 
1352                         </member>
1353                 </simplelist>
1354                 </formalpara>
1355     </simplesect>
1356       <simplesect id="acq.table.fund"
1357                xreflabel="acq.fund">
1358         <title id="acq.table.fund-title">
1359          Table:
1360          
1361          fund
1362         </title>
1363  
1364                 <formalpara>
1365                         <title>Columns:</title>
1366                         <simplelist type="horiz" columns="1">
1367                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1368                         <member>
1369                         <database class="field">id</database> : <database class="datatype">serial</database> 
1370 --
1371                          <literal>PRIMARY KEY</literal>,
1372                         </member>
1373                         <member>
1374                         <database class="field">org</database> : <database class="datatype">integer</database> 
1375 --
1376                          <literal>UNIQUE#2</literal>,
1377                          <literal>UNIQUE#1</literal>,
1378                         <literal>NOT NULL</literal>, 
1379                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
1380                         </member>
1381                         <member>
1382                         <database class="field">name</database> : <database class="datatype">text</database> 
1383 --
1384                          <literal>UNIQUE#1</literal>,
1385                         <literal>NOT NULL</literal>, 
1386                         </member>
1387                         <member>
1388                         <database class="field">year</database> : <database class="datatype">integer</database> 
1389 --
1390                          <literal>UNIQUE#2</literal>,
1391                          <literal>UNIQUE#1</literal>,
1392                         <literal>NOT NULL</literal>, 
1393                         <literal>DEFAULT date_part(&apos;year&apos;::text, now())</literal>, 
1394                         </member>
1395                         <member>
1396                         <database class="field">currency_type</database> : <database class="datatype">text</database> 
1397 --
1398                         <literal>NOT NULL</literal>, 
1399                         <literal>REFERENCES</literal> <xref linkend="acq.table.currency-type"/>. 
1400                         </member>
1401                         <member>
1402                         <database class="field">code</database> : <database class="datatype">text</database> 
1403 --
1404                          <literal>UNIQUE#2</literal>,
1405                         </member>
1406                         <member>
1407                         <database class="field">rollover</database> : <database class="datatype">boolean</database> 
1408 --
1409                         <literal>NOT NULL</literal>, 
1410                         <literal>DEFAULT false</literal>, 
1411                         </member>
1412                         <member>
1413                         <database class="field">propagate</database> : <database class="datatype">boolean</database> 
1414 --
1415                         <literal>NOT NULL</literal>, 
1416                         <literal>DEFAULT true</literal>, 
1417                         </member>
1418                         <member>
1419                         <database class="field">active</database> : <database class="datatype">boolean</database> 
1420 --
1421                         <literal>NOT NULL</literal>, 
1422                         <literal>DEFAULT true</literal>, 
1423                         </member>
1424                         <member>
1425                         <database class="field">balance_warning_percent</database> : <database class="datatype">integer</database> 
1426 --
1427                         </member>
1428                         <member>
1429                         <database class="field">balance_stop_percent</database> : <database class="datatype">integer</database> 
1430 --
1431                         </member>
1432                 </simplelist>
1433                 </formalpara>
1434         <formalpara>
1435         <title>Constraints:</title>
1436         <simplelist type="horiz" columns="1">
1437           <member><database class="constraint">acq_fund_rollover_implies_propagate</database> : CHECK ((propagate OR (NOT rollover)))</member>
1438         </simplelist>
1439         </formalpara>
1440         <formalpara>         
1441                 <title>Tables referencing acq.fund_allocation via Foreign Key Constraints:</title>
1442                 <simplelist type="horiz" columns="2">
1443                 <member><xref linkend="acq.table.fund-allocation"/></member> 
1444                 <member><xref linkend="acq.table.fund-debit"/></member> 
1445                 <member><xref linkend="acq.table.fund-tag-map"/></member> 
1446                 <member><xref linkend="acq.table.fund-transfer"/></member> 
1447                 <member><xref linkend="acq.table.invoice-item"/></member> 
1448                 <member><xref linkend="acq.table.lineitem-detail"/></member> 
1449                 <member><xref linkend="acq.table.po-item"/></member> 
1450                 </simplelist>
1451         </formalpara>
1452     </simplesect>
1453       <simplesect id="acq.table.fund-allocation"
1454                xreflabel="acq.fund_allocation">
1455         <title id="acq.table.fund-allocation-title">
1456          Table:
1457          
1458          fund_allocation
1459         </title>
1460  
1461                 <formalpara>
1462                         <title>Columns:</title>
1463                         <simplelist type="horiz" columns="1">
1464                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1465                         <member>
1466                         <database class="field">id</database> : <database class="datatype">serial</database> 
1467 --
1468                          <literal>PRIMARY KEY</literal>,
1469                         </member>
1470                         <member>
1471                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
1472 --
1473                         <literal>NOT NULL</literal>, 
1474                         <literal>REFERENCES</literal> <xref linkend="acq.table.funding-source"/>. 
1475                         </member>
1476                         <member>
1477                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1478 --
1479                         <literal>NOT NULL</literal>, 
1480                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1481                         </member>
1482                         <member>
1483                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1484 --
1485                         <literal>NOT NULL</literal>, 
1486                         </member>
1487                         <member>
1488                         <database class="field">allocator</database> : <database class="datatype">integer</database> 
1489 --
1490                         <literal>NOT NULL</literal>, 
1491                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
1492                         </member>
1493                         <member>
1494                         <database class="field">note</database> : <database class="datatype">text</database> 
1495 --
1496                         </member>
1497                         <member>
1498                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
1499 --
1500                         <literal>NOT NULL</literal>, 
1501                         <literal>DEFAULT now()</literal>, 
1502                         </member>
1503                 </simplelist>
1504                 </formalpara>
1505         <formalpara>
1506                 <title>Indexes:</title>
1507                 <simplelist type="horiz" columns="1">
1508         <member><database class="index">fund_alloc_allocator_idx</database> : allocator</member>
1509         </simplelist>
1510         </formalpara>   
1511     </simplesect>
1512       <simplesect id="acq.table.fund-allocation-percent"
1513                xreflabel="acq.fund_allocation_percent">
1514         <title id="acq.table.fund-allocation-percent-title">
1515          Table:
1516          
1517          fund_allocation_percent
1518         </title>
1519  
1520                 <formalpara>
1521                         <title>Columns:</title>
1522                         <simplelist type="horiz" columns="1">
1523                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1524                         <member>
1525                         <database class="field">id</database> : <database class="datatype">serial</database> 
1526 --
1527                          <literal>PRIMARY KEY</literal>,
1528                         </member>
1529                         <member>
1530                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
1531 --
1532                          <literal>UNIQUE#1</literal>,
1533                         <literal>NOT NULL</literal>, 
1534                         <literal>REFERENCES</literal> <xref linkend="acq.table.funding-source"/>. 
1535                         </member>
1536                         <member>
1537                         <database class="field">org</database> : <database class="datatype">integer</database> 
1538 --
1539                          <literal>UNIQUE#1</literal>,
1540                         <literal>NOT NULL</literal>, 
1541                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
1542                         </member>
1543                         <member>
1544                         <database class="field">fund_code</database> : <database class="datatype">text</database> 
1545 --
1546                          <literal>UNIQUE#1</literal>,
1547                         </member>
1548                         <member>
1549                         <database class="field">percent</database> : <database class="datatype">numeric</database> 
1550 --
1551                         <literal>NOT NULL</literal>, 
1552                         </member>
1553                         <member>
1554                         <database class="field">allocator</database> : <database class="datatype">integer</database> 
1555 --
1556                         <literal>NOT NULL</literal>, 
1557                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
1558                         </member>
1559                         <member>
1560                         <database class="field">note</database> : <database class="datatype">text</database> 
1561 --
1562                         </member>
1563                         <member>
1564                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
1565 --
1566                         <literal>NOT NULL</literal>, 
1567                         <literal>DEFAULT now()</literal>, 
1568                         </member>
1569                 </simplelist>
1570                 </formalpara>
1571         <formalpara>
1572         <title>Constraints:</title>
1573         <simplelist type="horiz" columns="1">
1574           <member><database class="constraint">percentage_range</database> : CHECK (((percent &gt;= (0)::numeric) AND (percent &lt;= (100)::numeric)))</member>
1575         </simplelist>
1576         </formalpara>
1577     </simplesect>
1578       <simplesect id="acq.view.fund-allocation-total"
1579                xreflabel="acq.fund_allocation_total">
1580         <title id="acq.view.fund-allocation-total-title">
1581          View:
1582          
1583          fund_allocation_total
1584         </title>
1585  
1586                 <formalpara>
1587                         <title>Columns:</title>
1588                         <simplelist type="horiz" columns="1">
1589                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1590                         <member>
1591                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1592 --
1593                         </member>
1594                         <member>
1595                         <database class="field">amount</database> : <database class="datatype">numeric(100,2)</database> 
1596 --
1597                         </member>
1598                 </simplelist>
1599                 </formalpara>
1600     </simplesect>
1601       <simplesect id="acq.view.fund-combined-balance"
1602                xreflabel="acq.fund_combined_balance">
1603         <title id="acq.view.fund-combined-balance-title">
1604          View:
1605          
1606          fund_combined_balance
1607         </title>
1608  
1609                 <formalpara>
1610                         <title>Columns:</title>
1611                         <simplelist type="horiz" columns="1">
1612                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1613                         <member>
1614                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1615 --
1616                         </member>
1617                         <member>
1618                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1619 --
1620                         </member>
1621                 </simplelist>
1622                 </formalpara>
1623     </simplesect>
1624       <simplesect id="acq.table.fund-debit"
1625                xreflabel="acq.fund_debit">
1626         <title id="acq.table.fund-debit-title">
1627          Table:
1628          
1629          fund_debit
1630         </title>
1631  
1632                 <formalpara>
1633                         <title>Columns:</title>
1634                         <simplelist type="horiz" columns="1">
1635                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1636                         <member>
1637                         <database class="field">id</database> : <database class="datatype">serial</database> 
1638 --
1639                          <literal>PRIMARY KEY</literal>,
1640                         </member>
1641                         <member>
1642                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1643 --
1644                         <literal>NOT NULL</literal>, 
1645                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1646                         </member>
1647                         <member>
1648                         <database class="field">origin_amount</database> : <database class="datatype">numeric</database> 
1649 --
1650                         <literal>NOT NULL</literal>, 
1651                         </member>
1652                         <member>
1653                         <database class="field">origin_currency_type</database> : <database class="datatype">text</database> 
1654 --
1655                         <literal>NOT NULL</literal>, 
1656                         <literal>REFERENCES</literal> <xref linkend="acq.table.currency-type"/>. 
1657                         </member>
1658                         <member>
1659                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1660 --
1661                         <literal>NOT NULL</literal>, 
1662                         </member>
1663                         <member>
1664                         <database class="field">encumbrance</database> : <database class="datatype">boolean</database> 
1665 --
1666                         <literal>NOT NULL</literal>, 
1667                         <literal>DEFAULT true</literal>, 
1668                         </member>
1669                         <member>
1670                         <database class="field">debit_type</database> : <database class="datatype">text</database> 
1671 --
1672                         <literal>NOT NULL</literal>, 
1673                         </member>
1674                         <member>
1675                         <database class="field">xfer_destination</database> : <database class="datatype">integer</database> 
1676 --
1677                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1678                         </member>
1679                         <member>
1680                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
1681 --
1682                         <literal>NOT NULL</literal>, 
1683                         <literal>DEFAULT now()</literal>, 
1684                         </member>
1685                 </simplelist>
1686                 </formalpara>
1687         <formalpara>         
1688                 <title>Tables referencing acq.debit_attribution via Foreign Key Constraints:</title>
1689                 <simplelist type="horiz" columns="2">
1690                 <member><xref linkend="acq.table.debit-attribution"/></member> 
1691                 <member><xref linkend="acq.table.invoice-item"/></member> 
1692                 <member><xref linkend="acq.table.lineitem-detail"/></member> 
1693                 <member><xref linkend="acq.table.po-item"/></member> 
1694                 </simplelist>
1695         </formalpara>
1696     </simplesect>
1697       <simplesect id="acq.view.fund-debit-total"
1698                xreflabel="acq.fund_debit_total">
1699         <title id="acq.view.fund-debit-total-title">
1700          View:
1701          
1702          fund_debit_total
1703         </title>
1704  
1705                 <formalpara>
1706                         <title>Columns:</title>
1707                         <simplelist type="horiz" columns="1">
1708                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1709                         <member>
1710                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1711 --
1712                         </member>
1713                         <member>
1714                         <database class="field">encumbrance</database> : <database class="datatype">boolean</database> 
1715 --
1716                         </member>
1717                         <member>
1718                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1719 --
1720                         </member>
1721                 </simplelist>
1722                 </formalpara>
1723     </simplesect>
1724       <simplesect id="acq.view.fund-encumbrance-total"
1725                xreflabel="acq.fund_encumbrance_total">
1726         <title id="acq.view.fund-encumbrance-total-title">
1727          View:
1728          
1729          fund_encumbrance_total
1730         </title>
1731  
1732                 <formalpara>
1733                         <title>Columns:</title>
1734                         <simplelist type="horiz" columns="1">
1735                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1736                         <member>
1737                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1738 --
1739                         </member>
1740                         <member>
1741                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1742 --
1743                         </member>
1744                 </simplelist>
1745                 </formalpara>
1746     </simplesect>
1747       <simplesect id="acq.view.fund-spent-balance"
1748                xreflabel="acq.fund_spent_balance">
1749         <title id="acq.view.fund-spent-balance-title">
1750          View:
1751          
1752          fund_spent_balance
1753         </title>
1754  
1755                 <formalpara>
1756                         <title>Columns:</title>
1757                         <simplelist type="horiz" columns="1">
1758                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1759                         <member>
1760                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1761 --
1762                         </member>
1763                         <member>
1764                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1765 --
1766                         </member>
1767                 </simplelist>
1768                 </formalpara>
1769     </simplesect>
1770       <simplesect id="acq.view.fund-spent-total"
1771                xreflabel="acq.fund_spent_total">
1772         <title id="acq.view.fund-spent-total-title">
1773          View:
1774          
1775          fund_spent_total
1776         </title>
1777  
1778                 <formalpara>
1779                         <title>Columns:</title>
1780                         <simplelist type="horiz" columns="1">
1781                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1782                         <member>
1783                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1784 --
1785                         </member>
1786                         <member>
1787                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
1788 --
1789                         </member>
1790                 </simplelist>
1791                 </formalpara>
1792     </simplesect>
1793       <simplesect id="acq.table.fund-tag"
1794                xreflabel="acq.fund_tag">
1795         <title id="acq.table.fund-tag-title">
1796          Table:
1797          
1798          fund_tag
1799         </title>
1800  
1801                 <formalpara>
1802                         <title>Columns:</title>
1803                         <simplelist type="horiz" columns="1">
1804                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1805                         <member>
1806                         <database class="field">id</database> : <database class="datatype">serial</database> 
1807 --
1808                          <literal>PRIMARY KEY</literal>,
1809                         </member>
1810                         <member>
1811                         <database class="field">owner</database> : <database class="datatype">integer</database> 
1812 --
1813                          <literal>UNIQUE#1</literal>,
1814                         <literal>NOT NULL</literal>, 
1815                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
1816                         </member>
1817                         <member>
1818                         <database class="field">name</database> : <database class="datatype">text</database> 
1819 --
1820                          <literal>UNIQUE#1</literal>,
1821                         <literal>NOT NULL</literal>, 
1822                         </member>
1823                 </simplelist>
1824                 </formalpara>
1825         <formalpara>         
1826                 <title>Tables referencing acq.fund_tag_map via Foreign Key Constraints:</title>
1827                 <simplelist type="horiz" columns="2">
1828                 <member><xref linkend="acq.table.fund-tag-map"/></member> 
1829                 </simplelist>
1830         </formalpara>
1831     </simplesect>
1832       <simplesect id="acq.table.fund-tag-map"
1833                xreflabel="acq.fund_tag_map">
1834         <title id="acq.table.fund-tag-map-title">
1835          Table:
1836          
1837          fund_tag_map
1838         </title>
1839  
1840                 <formalpara>
1841                         <title>Columns:</title>
1842                         <simplelist type="horiz" columns="1">
1843                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1844                         <member>
1845                         <database class="field">id</database> : <database class="datatype">serial</database> 
1846 --
1847                          <literal>PRIMARY KEY</literal>,
1848                         </member>
1849                         <member>
1850                         <database class="field">fund</database> : <database class="datatype">integer</database> 
1851 --
1852                          <literal>UNIQUE#1</literal>,
1853                         <literal>NOT NULL</literal>, 
1854                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1855                         </member>
1856                         <member>
1857                         <database class="field">tag</database> : <database class="datatype">integer</database> 
1858 --
1859                          <literal>UNIQUE#1</literal>,
1860                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund-tag"/>. 
1861                         </member>
1862                 </simplelist>
1863                 </formalpara>
1864     </simplesect>
1865       <simplesect id="acq.table.fund-transfer"
1866                xreflabel="acq.fund_transfer">
1867         <title id="acq.table.fund-transfer-title">
1868          Table:
1869          
1870          fund_transfer
1871         </title>
1872  
1873         <para>
1874           
1875 Fund Transfer
1876 Each row represents the transfer of money from a source fund
1877 to a destination fund.  There should be corresponding entries
1878 in acq.fund_allocation.  The purpose of acq.fund_transfer is
1879 to record how much money moved from which fund to which other
1880 fund.
1881 The presence of two amount fields, rather than one, reflects
1882 the possibility that the two funds are denominated in different
1883 currencies.  If they use the same currency type, the two
1884 amounts should be the same.
1885         </para>
1886                 <formalpara>
1887                         <title>Columns:</title>
1888                         <simplelist type="horiz" columns="1">
1889                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1890                         <member>
1891                         <database class="field">id</database> : <database class="datatype">serial</database> 
1892 --
1893                          <literal>PRIMARY KEY</literal>,
1894                         </member>
1895                         <member>
1896                         <database class="field">src_fund</database> : <database class="datatype">integer</database> 
1897 --
1898                         <literal>NOT NULL</literal>, 
1899                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1900                         </member>
1901                         <member>
1902                         <database class="field">src_amount</database> : <database class="datatype">numeric</database> 
1903 --
1904                         <literal>NOT NULL</literal>, 
1905                         </member>
1906                         <member>
1907                         <database class="field">dest_fund</database> : <database class="datatype">integer</database> 
1908 --
1909                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
1910                         </member>
1911                         <member>
1912                         <database class="field">dest_amount</database> : <database class="datatype">numeric</database> 
1913 --
1914                         </member>
1915                         <member>
1916                         <database class="field">transfer_time</database> : <database class="datatype">timestamp with time zone</database> 
1917 --
1918                         <literal>NOT NULL</literal>, 
1919                         <literal>DEFAULT now()</literal>, 
1920                         </member>
1921                         <member>
1922                         <database class="field">transfer_user</database> : <database class="datatype">integer</database> 
1923 --
1924                         <literal>NOT NULL</literal>, 
1925                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
1926                         </member>
1927                         <member>
1928                         <database class="field">note</database> : <database class="datatype">text</database> 
1929 --
1930                         </member>
1931                         <member>
1932                         <database class="field">funding_source_credit</database> : <database class="datatype">integer</database> 
1933 --
1934                         <literal>NOT NULL</literal>, 
1935                         <literal>REFERENCES</literal> <xref linkend="acq.table.funding-source-credit"/>. 
1936                         </member>
1937                 </simplelist>
1938                 </formalpara>
1939         <formalpara>
1940                 <title>Indexes:</title>
1941                 <simplelist type="horiz" columns="1">
1942         <member><database class="index">acqftr_usr_idx</database> : transfer_user</member>
1943         </simplelist>
1944         </formalpara>   
1945     </simplesect>
1946       <simplesect id="acq.table.funding-source"
1947                xreflabel="acq.funding_source">
1948         <title id="acq.table.funding-source-title">
1949          Table:
1950          
1951          funding_source
1952         </title>
1953  
1954                 <formalpara>
1955                         <title>Columns:</title>
1956                         <simplelist type="horiz" columns="1">
1957                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
1958                         <member>
1959                         <database class="field">id</database> : <database class="datatype">serial</database> 
1960 --
1961                          <literal>PRIMARY KEY</literal>,
1962                         </member>
1963                         <member>
1964                         <database class="field">name</database> : <database class="datatype">text</database> 
1965 --
1966                          <literal>UNIQUE#1</literal>,
1967                         <literal>NOT NULL</literal>, 
1968                         </member>
1969                         <member>
1970                         <database class="field">owner</database> : <database class="datatype">integer</database> 
1971 --
1972                          <literal>UNIQUE#1</literal>,
1973                         <literal>NOT NULL</literal>, 
1974                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
1975                         </member>
1976                         <member>
1977                         <database class="field">currency_type</database> : <database class="datatype">text</database> 
1978 --
1979                         <literal>NOT NULL</literal>, 
1980                         <literal>REFERENCES</literal> <xref linkend="acq.table.currency-type"/>. 
1981                         </member>
1982                         <member>
1983                         <database class="field">code</database> : <database class="datatype">text</database> 
1984 --
1985                          <literal>UNIQUE</literal>,
1986                         </member>
1987                 </simplelist>
1988                 </formalpara>
1989         <formalpara>         
1990                 <title>Tables referencing acq.fund_allocation via Foreign Key Constraints:</title>
1991                 <simplelist type="horiz" columns="2">
1992                 <member><xref linkend="acq.table.fund-allocation"/></member> 
1993                 <member><xref linkend="acq.table.fund-allocation-percent"/></member> 
1994                 <member><xref linkend="acq.table.funding-source-credit"/></member> 
1995                 </simplelist>
1996         </formalpara>
1997     </simplesect>
1998       <simplesect id="acq.view.funding-source-allocation-total"
1999                xreflabel="acq.funding_source_allocation_total">
2000         <title id="acq.view.funding-source-allocation-total-title">
2001          View:
2002          
2003          funding_source_allocation_total
2004         </title>
2005  
2006                 <formalpara>
2007                         <title>Columns:</title>
2008                         <simplelist type="horiz" columns="1">
2009                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2010                         <member>
2011                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
2012 --
2013                         </member>
2014                         <member>
2015                         <database class="field">amount</database> : <database class="datatype">numeric(100,2)</database> 
2016 --
2017                         </member>
2018                 </simplelist>
2019                 </formalpara>
2020     </simplesect>
2021       <simplesect id="acq.view.funding-source-balance"
2022                xreflabel="acq.funding_source_balance">
2023         <title id="acq.view.funding-source-balance-title">
2024          View:
2025          
2026          funding_source_balance
2027         </title>
2028  
2029                 <formalpara>
2030                         <title>Columns:</title>
2031                         <simplelist type="horiz" columns="1">
2032                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2033                         <member>
2034                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
2035 --
2036                         </member>
2037                         <member>
2038                         <database class="field">amount</database> : <database class="datatype">numeric(100,2)</database> 
2039 --
2040                         </member>
2041                 </simplelist>
2042                 </formalpara>
2043     </simplesect>
2044       <simplesect id="acq.table.funding-source-credit"
2045                xreflabel="acq.funding_source_credit">
2046         <title id="acq.table.funding-source-credit-title">
2047          Table:
2048          
2049          funding_source_credit
2050         </title>
2051  
2052                 <formalpara>
2053                         <title>Columns:</title>
2054                         <simplelist type="horiz" columns="1">
2055                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2056                         <member>
2057                         <database class="field">id</database> : <database class="datatype">serial</database> 
2058 --
2059                          <literal>PRIMARY KEY</literal>,
2060                         </member>
2061                         <member>
2062                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
2063 --
2064                         <literal>NOT NULL</literal>, 
2065                         <literal>REFERENCES</literal> <xref linkend="acq.table.funding-source"/>. 
2066                         </member>
2067                         <member>
2068                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
2069 --
2070                         <literal>NOT NULL</literal>, 
2071                         </member>
2072                         <member>
2073                         <database class="field">note</database> : <database class="datatype">text</database> 
2074 --
2075                         </member>
2076                         <member>
2077                         <database class="field">deadline_date</database> : <database class="datatype">timestamp with time zone</database> 
2078 --
2079                         </member>
2080                         <member>
2081                         <database class="field">effective_date</database> : <database class="datatype">timestamp with time zone</database> 
2082 --
2083                         <literal>NOT NULL</literal>, 
2084                         <literal>DEFAULT now()</literal>, 
2085                         </member>
2086                 </simplelist>
2087                 </formalpara>
2088         <formalpara>         
2089                 <title>Tables referencing acq.debit_attribution via Foreign Key Constraints:</title>
2090                 <simplelist type="horiz" columns="2">
2091                 <member><xref linkend="acq.table.debit-attribution"/></member> 
2092                 <member><xref linkend="acq.table.fund-transfer"/></member> 
2093                 </simplelist>
2094         </formalpara>
2095     </simplesect>
2096       <simplesect id="acq.view.funding-source-credit-total"
2097                xreflabel="acq.funding_source_credit_total">
2098         <title id="acq.view.funding-source-credit-total-title">
2099          View:
2100          
2101          funding_source_credit_total
2102         </title>
2103  
2104                 <formalpara>
2105                         <title>Columns:</title>
2106                         <simplelist type="horiz" columns="1">
2107                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2108                         <member>
2109                         <database class="field">funding_source</database> : <database class="datatype">integer</database> 
2110 --
2111                         </member>
2112                         <member>
2113                         <database class="field">amount</database> : <database class="datatype">numeric</database> 
2114 --
2115                         </member>
2116                 </simplelist>
2117                 </formalpara>
2118     </simplesect>
2119       <simplesect id="acq.table.invoice"
2120                xreflabel="acq.invoice">
2121         <title id="acq.table.invoice-title">
2122          Table:
2123          
2124          invoice
2125         </title>
2126  
2127                 <formalpara>
2128                         <title>Columns:</title>
2129                         <simplelist type="horiz" columns="1">
2130                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2131                         <member>
2132                         <database class="field">id</database> : <database class="datatype">serial</database> 
2133 --
2134                          <literal>PRIMARY KEY</literal>,
2135                         </member>
2136                         <member>
2137                         <database class="field">receiver</database> : <database class="datatype">integer</database> 
2138 --
2139                         <literal>NOT NULL</literal>, 
2140                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
2141                         </member>
2142                         <member>
2143                         <database class="field">provider</database> : <database class="datatype">integer</database> 
2144 --
2145                          <literal>UNIQUE#1</literal>,
2146                         <literal>NOT NULL</literal>, 
2147                         <literal>REFERENCES</literal> <xref linkend="acq.table.provider"/>. 
2148                         </member>
2149                         <member>
2150                         <database class="field">shipper</database> : <database class="datatype">integer</database> 
2151 --
2152                         <literal>NOT NULL</literal>, 
2153                         <literal>REFERENCES</literal> <xref linkend="acq.table.provider"/>. 
2154                         </member>
2155                         <member>
2156                         <database class="field">recv_date</database> : <database class="datatype">timestamp with time zone</database> 
2157 --
2158                         <literal>NOT NULL</literal>, 
2159                         <literal>DEFAULT now()</literal>, 
2160                         </member>
2161                         <member>
2162                         <database class="field">recv_method</database> : <database class="datatype">text</database> 
2163 --
2164                         <literal>NOT NULL</literal>, 
2165                         <literal>DEFAULT &apos;EDI&apos;::text</literal>, 
2166                         <literal>REFERENCES</literal> <xref linkend="acq.table.invoice-method"/>. 
2167                         </member>
2168                         <member>
2169                         <database class="field">inv_type</database> : <database class="datatype">text</database> 
2170 --
2171                         </member>
2172                         <member>
2173                         <database class="field">inv_ident</database> : <database class="datatype">text</database> 
2174 --
2175                          <literal>UNIQUE#1</literal>,
2176                         <literal>NOT NULL</literal>, 
2177                         </member>
2178                         <member>
2179                         <database class="field">payment_auth</database> : <database class="datatype">text</database> 
2180 --
2181                         </member>
2182                         <member>
2183                         <database class="field">payment_method</database> : <database class="datatype">text</database> 
2184 --
2185                         <literal>REFERENCES</literal> <xref linkend="acq.table.invoice-payment-method"/>. 
2186                         </member>
2187                         <member>
2188                         <database class="field">note</database> : <database class="datatype">text</database> 
2189 --
2190                         </member>
2191                         <member>
2192                         <database class="field">complete</database> : <database class="datatype">boolean</database> 
2193 --
2194                         <literal>NOT NULL</literal>, 
2195                         <literal>DEFAULT false</literal>, 
2196                         </member>
2197                 </simplelist>
2198                 </formalpara>
2199         <formalpara>         
2200                 <title>Tables referencing acq.invoice_entry via Foreign Key Constraints:</title>
2201                 <simplelist type="horiz" columns="2">
2202                 <member><xref linkend="acq.table.invoice-entry"/></member> 
2203                 <member><xref linkend="acq.table.invoice-item"/></member> 
2204                 </simplelist>
2205         </formalpara>
2206     </simplesect>
2207       <simplesect id="acq.table.invoice-entry"
2208                xreflabel="acq.invoice_entry">
2209         <title id="acq.table.invoice-entry-title">
2210          Table:
2211          
2212          invoice_entry
2213         </title>
2214  
2215                 <formalpara>
2216                         <title>Columns:</title>
2217                         <simplelist type="horiz" columns="1">
2218                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2219                         <member>
2220                         <database class="field">id</database> : <database class="datatype">serial</database> 
2221 --
2222                          <literal>PRIMARY KEY</literal>,
2223                         </member>
2224                         <member>
2225                         <database class="field">invoice</database> : <database class="datatype">integer</database> 
2226 --
2227                         <literal>NOT NULL</literal>, 
2228                         <literal>REFERENCES</literal> <xref linkend="acq.table.invoice"/>. 
2229                         </member>
2230                         <member>
2231                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
2232 --
2233                         <literal>REFERENCES</literal> <xref linkend="acq.table.purchase-order"/>. 
2234                         </member>
2235                         <member>
2236                         <database class="field">lineitem</database> : <database class="datatype">integer</database> 
2237 --
2238                         <literal>REFERENCES</literal> <xref linkend="acq.table.lineitem"/>. 
2239                         </member>
2240                         <member>
2241                         <database class="field">inv_item_count</database> : <database class="datatype">integer</database> 
2242 --
2243                         <literal>NOT NULL</literal>, 
2244                         </member>
2245                         <member>
2246                         <database class="field">phys_item_count</database> : <database class="datatype">integer</database> 
2247 --
2248                         </member>
2249                         <member>
2250                         <database class="field">note</database> : <database class="datatype">text</database> 
2251 --
2252                         </member>
2253                         <member>
2254                         <database class="field">billed_per_item</database> : <database class="datatype">boolean</database> 
2255 --
2256                         </member>
2257                         <member>
2258                         <database class="field">cost_billed</database> : <database class="datatype">numeric(8,2)</database> 
2259 --
2260                         </member>
2261                         <member>
2262                         <database class="field">actual_cost</database> : <database class="datatype">numeric(8,2)</database> 
2263 --
2264                         </member>
2265                         <member>
2266                         <database class="field">amount_paid</database> : <database class="datatype">numeric(8,2)</database> 
2267 --
2268                         </member>
2269                 </simplelist>
2270                 </formalpara>
2271     </simplesect>
2272       <simplesect id="acq.table.invoice-item"
2273                xreflabel="acq.invoice_item">
2274         <title id="acq.table.invoice-item-title">
2275          Table:
2276          
2277          invoice_item
2278         </title>
2279  
2280                 <formalpara>
2281                         <title>Columns:</title>
2282                         <simplelist type="horiz" columns="1">
2283                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2284                         <member>
2285                         <database class="field">id</database> : <database class="datatype">serial</database> 
2286 --
2287                          <literal>PRIMARY KEY</literal>,
2288                         </member>
2289                         <member>
2290                         <database class="field">invoice</database> : <database class="datatype">integer</database> 
2291 --
2292                         <literal>NOT NULL</literal>, 
2293                         <literal>REFERENCES</literal> <xref linkend="acq.table.invoice"/>. 
2294                         </member>
2295                         <member>
2296                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
2297 --
2298                         <literal>REFERENCES</literal> <xref linkend="acq.table.purchase-order"/>. 
2299                         </member>
2300                         <member>
2301                         <database class="field">fund_debit</database> : <database class="datatype">integer</database> 
2302 --
2303                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund-debit"/>. 
2304                         </member>
2305                         <member>
2306                         <database class="field">inv_item_type</database> : <database class="datatype">text</database> 
2307 --
2308                         <literal>NOT NULL</literal>, 
2309                         <literal>REFERENCES</literal> <xref linkend="acq.table.invoice-item-type"/>. 
2310                         </member>
2311                         <member>
2312                         <database class="field">title</database> : <database class="datatype">text</database> 
2313 --
2314                         </member>
2315                         <member>
2316                         <database class="field">author</database> : <database class="datatype">text</database> 
2317 --
2318                         </member>
2319                         <member>
2320                         <database class="field">note</database> : <database class="datatype">text</database> 
2321 --
2322                         </member>
2323                         <member>
2324                         <database class="field">cost_billed</database> : <database class="datatype">numeric(8,2)</database> 
2325 --
2326                         </member>
2327                         <member>
2328                         <database class="field">actual_cost</database> : <database class="datatype">numeric(8,2)</database> 
2329 --
2330                         </member>
2331                         <member>
2332                         <database class="field">fund</database> : <database class="datatype">integer</database> 
2333 --
2334                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
2335                         </member>
2336                         <member>
2337                         <database class="field">amount_paid</database> : <database class="datatype">numeric(8,2)</database> 
2338 --
2339                         </member>
2340                         <member>
2341                         <database class="field">po_item</database> : <database class="datatype">integer</database> 
2342 --
2343                         <literal>REFERENCES</literal> <xref linkend="acq.table.po-item"/>. 
2344                         </member>
2345                         <member>
2346                         <database class="field">target</database> : <database class="datatype">bigint</database> 
2347 --
2348                         </member>
2349                 </simplelist>
2350                 </formalpara>
2351     </simplesect>
2352       <simplesect id="acq.table.invoice-item-type"
2353                xreflabel="acq.invoice_item_type">
2354         <title id="acq.table.invoice-item-type-title">
2355          Table:
2356          
2357          invoice_item_type
2358         </title>
2359  
2360                 <formalpara>
2361                         <title>Columns:</title>
2362                         <simplelist type="horiz" columns="1">
2363                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2364                         <member>
2365                         <database class="field">code</database> : <database class="datatype">text</database> 
2366 --
2367                          <literal>PRIMARY KEY</literal>,
2368                         </member>
2369                         <member>
2370                         <database class="field">name</database> : <database class="datatype">text</database> 
2371 --
2372                         <literal>NOT NULL</literal>, 
2373                         </member>
2374                         <member>
2375                         <database class="field">prorate</database> : <database class="datatype">boolean</database> 
2376 --
2377                         <literal>NOT NULL</literal>, 
2378                         <literal>DEFAULT false</literal>, 
2379                         </member>
2380                 </simplelist>
2381                 </formalpara>
2382         <formalpara>         
2383                 <title>Tables referencing acq.invoice_item via Foreign Key Constraints:</title>
2384                 <simplelist type="horiz" columns="2">
2385                 <member><xref linkend="acq.table.invoice-item"/></member> 
2386                 <member><xref linkend="acq.table.po-item"/></member> 
2387                 </simplelist>
2388         </formalpara>
2389     </simplesect>
2390       <simplesect id="acq.table.invoice-method"
2391                xreflabel="acq.invoice_method">
2392         <title id="acq.table.invoice-method-title">
2393          Table:
2394          
2395          invoice_method
2396         </title>
2397  
2398                 <formalpara>
2399                         <title>Columns:</title>
2400                         <simplelist type="horiz" columns="1">
2401                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2402                         <member>
2403                         <database class="field">code</database> : <database class="datatype">text</database> 
2404 --
2405                          <literal>PRIMARY KEY</literal>,
2406                         </member>
2407                         <member>
2408                         <database class="field">name</database> : <database class="datatype">text</database> 
2409 --
2410                         <literal>NOT NULL</literal>, 
2411                         </member>
2412                 </simplelist>
2413                 </formalpara>
2414         <formalpara>         
2415                 <title>Tables referencing acq.invoice via Foreign Key Constraints:</title>
2416                 <simplelist type="horiz" columns="2">
2417                 <member><xref linkend="acq.table.invoice"/></member> 
2418                 </simplelist>
2419         </formalpara>
2420     </simplesect>
2421       <simplesect id="acq.table.invoice-payment-method"
2422                xreflabel="acq.invoice_payment_method">
2423         <title id="acq.table.invoice-payment-method-title">
2424          Table:
2425          
2426          invoice_payment_method
2427         </title>
2428  
2429                 <formalpara>
2430                         <title>Columns:</title>
2431                         <simplelist type="horiz" columns="1">
2432                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2433                         <member>
2434                         <database class="field">code</database> : <database class="datatype">text</database> 
2435 --
2436                          <literal>PRIMARY KEY</literal>,
2437                         </member>
2438                         <member>
2439                         <database class="field">name</database> : <database class="datatype">text</database> 
2440 --
2441                         <literal>NOT NULL</literal>, 
2442                         </member>
2443                 </simplelist>
2444                 </formalpara>
2445         <formalpara>         
2446                 <title>Tables referencing acq.invoice via Foreign Key Constraints:</title>
2447                 <simplelist type="horiz" columns="2">
2448                 <member><xref linkend="acq.table.invoice"/></member> 
2449                 </simplelist>
2450         </formalpara>
2451     </simplesect>
2452       <simplesect id="acq.table.lineitem"
2453                xreflabel="acq.lineitem">
2454         <title id="acq.table.lineitem-title">
2455          Table:
2456          
2457          lineitem
2458         </title>
2459  
2460                 <formalpara>
2461                         <title>Columns:</title>
2462                         <simplelist type="horiz" columns="1">
2463                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2464                         <member>
2465                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
2466 --
2467                          <literal>PRIMARY KEY</literal>,
2468                         </member>
2469                         <member>
2470                         <database class="field">creator</database> : <database class="datatype">integer</database> 
2471 --
2472                         <literal>NOT NULL</literal>, 
2473                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
2474                         </member>
2475                         <member>
2476                         <database class="field">editor</database> : <database class="datatype">integer</database> 
2477 --
2478                         <literal>NOT NULL</literal>, 
2479                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
2480                         </member>
2481                         <member>
2482                         <database class="field">selector</database> : <database class="datatype">integer</database> 
2483 --
2484                         <literal>NOT NULL</literal>, 
2485                         <literal>REFERENCES</literal> <xref linkend="actor.table.usr"/>. 
2486                         </member>
2487                         <member>
2488                         <database class="field">provider</database> : <database class="datatype">integer</database> 
2489 --
2490                         <literal>REFERENCES</literal> <xref linkend="acq.table.provider"/>. 
2491                         </member>
2492                         <member>
2493                         <database class="field">purchase_order</database> : <database class="datatype">integer</database> 
2494 --
2495                         <literal>REFERENCES</literal> <xref linkend="acq.table.purchase-order"/>. 
2496                         </member>
2497                         <member>
2498                         <database class="field">picklist</database> : <database class="datatype">integer</database> 
2499 --
2500                         <literal>REFERENCES</literal> <xref linkend="acq.table.picklist"/>. 
2501                         </member>
2502                         <member>
2503                         <database class="field">expected_recv_time</database> : <database class="datatype">timestamp with time zone</database> 
2504 --
2505                         </member>
2506                         <member>
2507                         <database class="field">create_time</database> : <database class="datatype">timestamp with time zone</database> 
2508 --
2509                         <literal>NOT NULL</literal>, 
2510                         <literal>DEFAULT now()</literal>, 
2511                         </member>
2512                         <member>
2513                         <database class="field">edit_time</database> : <database class="datatype">timestamp with time zone</database> 
2514 --
2515                         <literal>NOT NULL</literal>, 
2516                         <literal>DEFAULT now()</literal>, 
2517                         </member>
2518                         <member>
2519                         <database class="field">marc</database> : <database class="datatype">text</database> 
2520 --
2521                         <literal>NOT NULL</literal>, 
2522                         </member>
2523                         <member>
2524                         <database class="field">eg_bib_id</database> : <database class="datatype">bigint</database> 
2525 --
2526                         <literal>REFERENCES</literal> <xref linkend="biblio.table.record-entry"/>. 
2527                         </member>
2528                         <member>
2529                         <database class="field">source_label</database> : <database class="datatype">text</database> 
2530 --
2531                         </member>
2532                         <member>
2533                         <database class="field">state</database> : <database class="datatype">text</database> 
2534 --
2535                         <literal>NOT NULL</literal>, 
2536                         <literal>DEFAULT &apos;new&apos;::text</literal>, 
2537                         </member>
2538                         <member>
2539                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
2540 --
2541                         <literal>REFERENCES</literal> <xref linkend="acq.table.cancel-reason"/>. 
2542                         </member>
2543                         <member>
2544                         <database class="field">estimated_unit_price</database> : <database class="datatype">numeric</database> 
2545 --
2546                         </member>
2547                         <member>
2548                         <database class="field">claim_policy</database> : <database class="datatype">integer</database> 
2549 --
2550                         <literal>REFERENCES</literal> <xref linkend="acq.table.claim-policy"/>. 
2551                         </member>
2552                 </simplelist>
2553                 </formalpara>
2554         <formalpara>
2555         <title>Constraints:</title>
2556         <simplelist type="horiz" columns="1">
2557           <member><database class="constraint">picklist_or_po</database> : CHECK (((picklist IS NOT NULL) OR (purchase_order IS NOT NULL)))</member>
2558         </simplelist>
2559         </formalpara>
2560         <formalpara>
2561                 <title>Indexes:</title>
2562                 <simplelist type="horiz" columns="1">
2563         <member><database class="index">li_creator_idx</database> : creator</member>
2564         <member><database class="index">li_editor_idx</database> : editor</member>
2565         <member><database class="index">li_pl_idx</database> : picklist</member>
2566         <member><database class="index">li_po_idx</database> : purchase_order</member>
2567         <member><database class="index">li_selector_idx</database> : selector</member>
2568         </simplelist>
2569         </formalpara>   
2570         <formalpara>         
2571                 <title>Tables referencing acq.distribution_formula_application via Foreign Key Constraints:</title>
2572                 <simplelist type="horiz" columns="2">
2573                 <member><xref linkend="acq.table.distribution-formula-application"/></member> 
2574                 <member><xref linkend="acq.table.invoice-entry"/></member> 
2575                 <member><xref linkend="acq.table.lineitem-attr"/></member> 
2576                 <member><xref linkend="acq.table.lineitem-detail"/></member> 
2577                 <member><xref linkend="acq.table.lineitem-note"/></member> 
2578                 <member><xref linkend="acq.table.user-request"/></member> 
2579                 </simplelist>
2580         </formalpara>
2581     </simplesect>
2582       <simplesect id="acq.table.lineitem-alert-text"
2583                xreflabel="acq.lineitem_alert_text">
2584         <title id="acq.table.lineitem-alert-text-title">
2585          Table:
2586          
2587          lineitem_alert_text
2588         </title>
2589  
2590                 <formalpara>
2591                         <title>Columns:</title>
2592                         <simplelist type="horiz" columns="1">
2593                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2594                         <member>
2595                         <database class="field">id</database> : <database class="datatype">serial</database> 
2596 --
2597                          <literal>PRIMARY KEY</literal>,
2598                         </member>
2599                         <member>
2600                         <database class="field">code</database> : <database class="datatype">text</database> 
2601 --
2602                          <literal>UNIQUE#1</literal>,
2603                         <literal>NOT NULL</literal>, 
2604                         </member>
2605                         <member>
2606                         <database class="field">description</database> : <database class="datatype">text</database> 
2607 --
2608                         </member>
2609                         <member>
2610                         <database class="field">owning_lib</database> : <database class="datatype">integer</database> 
2611 --
2612                          <literal>UNIQUE#1</literal>,
2613                         <literal>NOT NULL</literal>, 
2614                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
2615                         </member>
2616                 </simplelist>
2617                 </formalpara>
2618         <formalpara>         
2619                 <title>Tables referencing acq.lineitem_note via Foreign Key Constraints:</title>
2620                 <simplelist type="horiz" columns="2">
2621                 <member><xref linkend="acq.table.lineitem-note"/></member> 
2622                 </simplelist>
2623         </formalpara>
2624     </simplesect>
2625       <simplesect id="acq.table.lineitem-attr"
2626                xreflabel="acq.lineitem_attr">
2627         <title id="acq.table.lineitem-attr-title">
2628          Table:
2629          
2630          lineitem_attr
2631         </title>
2632  
2633                 <formalpara>
2634                         <title>Columns:</title>
2635                         <simplelist type="horiz" columns="1">
2636                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2637                         <member>
2638                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
2639 --
2640                          <literal>PRIMARY KEY</literal>,
2641                         </member>
2642                         <member>
2643                         <database class="field">definition</database> : <database class="datatype">bigint</database> 
2644 --
2645                         <literal>NOT NULL</literal>, 
2646                         </member>
2647                         <member>
2648                         <database class="field">lineitem</database> : <database class="datatype">bigint</database> 
2649 --
2650                         <literal>NOT NULL</literal>, 
2651                         <literal>REFERENCES</literal> <xref linkend="acq.table.lineitem"/>. 
2652                         </member>
2653                         <member>
2654                         <database class="field">attr_type</database> : <database class="datatype">text</database> 
2655 --
2656                         <literal>NOT NULL</literal>, 
2657                         </member>
2658                         <member>
2659                         <database class="field">attr_name</database> : <database class="datatype">text</database> 
2660 --
2661                         <literal>NOT NULL</literal>, 
2662                         </member>
2663                         <member>
2664                         <database class="field">attr_value</database> : <database class="datatype">text</database> 
2665 --
2666                         <literal>NOT NULL</literal>, 
2667                         </member>
2668                 </simplelist>
2669                 </formalpara>
2670         <formalpara>
2671                 <title>Indexes:</title>
2672                 <simplelist type="horiz" columns="1">
2673         <member><database class="index">li_attr_definition_idx</database> : definition</member>
2674         <member><database class="index">li_attr_li_idx</database> : lineitem</member>
2675         <member><database class="index">li_attr_value_idx</database> : attr_value</member>
2676         </simplelist>
2677         </formalpara>   
2678     </simplesect>
2679       <simplesect id="acq.table.lineitem-attr-definition"
2680                xreflabel="acq.lineitem_attr_definition">
2681         <title id="acq.table.lineitem-attr-definition-title">
2682          Table:
2683          
2684          lineitem_attr_definition
2685         </title>
2686  
2687                 <formalpara>
2688                         <title>Columns:</title>
2689                         <simplelist type="horiz" columns="1">
2690                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2691                         <member>
2692                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
2693 --
2694                          <literal>PRIMARY KEY</literal>,
2695                         </member>
2696                         <member>
2697                         <database class="field">code</database> : <database class="datatype">text</database> 
2698 --
2699                         <literal>NOT NULL</literal>, 
2700                         </member>
2701                         <member>
2702                         <database class="field">description</database> : <database class="datatype">text</database> 
2703 --
2704                         <literal>NOT NULL</literal>, 
2705                         </member>
2706                         <member>
2707                         <database class="field">remove</database> : <database class="datatype">text</database> 
2708 --
2709                         <literal>NOT NULL</literal>, 
2710                         <literal>DEFAULT &apos;&apos;::text</literal>, 
2711                         </member>
2712                         <member>
2713                         <database class="field">ident</database> : <database class="datatype">boolean</database> 
2714 --
2715                         <literal>NOT NULL</literal>, 
2716                         <literal>DEFAULT false</literal>, 
2717                         </member>
2718                 </simplelist>
2719                 </formalpara>
2720     </simplesect>
2721       <simplesect id="acq.table.lineitem-detail"
2722                xreflabel="acq.lineitem_detail">
2723         <title id="acq.table.lineitem-detail-title">
2724          Table:
2725          
2726          lineitem_detail
2727         </title>
2728  
2729                 <formalpara>
2730                         <title>Columns:</title>
2731                         <simplelist type="horiz" columns="1">
2732                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2733                         <member>
2734                         <database class="field">id</database> : <database class="datatype">bigserial</database> 
2735 --
2736                          <literal>PRIMARY KEY</literal>,
2737                         </member>
2738                         <member>
2739                         <database class="field">lineitem</database> : <database class="datatype">integer</database> 
2740 --
2741                         <literal>NOT NULL</literal>, 
2742                         <literal>REFERENCES</literal> <xref linkend="acq.table.lineitem"/>. 
2743                         </member>
2744                         <member>
2745                         <database class="field">fund</database> : <database class="datatype">integer</database> 
2746 --
2747                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund"/>. 
2748                         </member>
2749                         <member>
2750                         <database class="field">fund_debit</database> : <database class="datatype">integer</database> 
2751 --
2752                         <literal>REFERENCES</literal> <xref linkend="acq.table.fund-debit"/>. 
2753                         </member>
2754                         <member>
2755                         <database class="field">eg_copy_id</database> : <database class="datatype">bigint</database> 
2756 --
2757                         </member>
2758                         <member>
2759                         <database class="field">barcode</database> : <database class="datatype">text</database> 
2760 --
2761                         </member>
2762                         <member>
2763                         <database class="field">cn_label</database> : <database class="datatype">text</database> 
2764 --
2765                         </member>
2766                         <member>
2767                         <database class="field">note</database> : <database class="datatype">text</database> 
2768 --
2769                         </member>
2770                         <member>
2771                         <database class="field">collection_code</database> : <database class="datatype">text</database> 
2772 --
2773                         </member>
2774                         <member>
2775                         <database class="field">circ_modifier</database> : <database class="datatype">text</database> 
2776 --
2777                         <literal>REFERENCES</literal> <xref linkend="config.table.circ-modifier"/>. 
2778                         </member>
2779                         <member>
2780                         <database class="field">owning_lib</database> : <database class="datatype">integer</database> 
2781 --
2782                         <literal>REFERENCES</literal> <xref linkend="actor.table.org-unit"/>. 
2783                         </member>
2784                         <member>
2785                         <database class="field">location</database> : <database class="datatype">integer</database> 
2786 --
2787                         <literal>REFERENCES</literal> <xref linkend="asset.table.copy-location"/>. 
2788                         </member>
2789                         <member>
2790                         <database class="field">recv_time</database> : <database class="datatype">timestamp with time zone</database> 
2791 --
2792                         </member>
2793                         <member>
2794                         <database class="field">cancel_reason</database> : <database class="datatype">integer</database> 
2795 --
2796                         <literal>REFERENCES</literal> <xref linkend="acq.table.cancel-reason"/>. 
2797                         </member>
2798                 </simplelist>
2799                 </formalpara>
2800         <formalpara>
2801                 <title>Indexes:</title>
2802                 <simplelist type="horiz" columns="1">
2803         <member><database class="index">li_detail_li_idx</database> : lineitem</member>
2804         </simplelist>
2805         </formalpara>   
2806         <formalpara>         
2807                 <title>Tables referencing acq.claim via Foreign Key Constraints:</title>
2808                 <simplelist type="horiz" columns="2">
2809                 <member><xref linkend="acq.table.claim"/></member> 
2810                 </simplelist>
2811         </formalpara>
2812     </simplesect>
2813       <simplesect id="acq.table.lineitem-generated-attr-definition"
2814                xreflabel="acq.lineitem_generated_attr_definition">
2815         <title id="acq.table.lineitem-generated-attr-definition-title">
2816          Table:
2817          
2818          lineitem_generated_attr_definition
2819         </title>
2820  
2821                 <formalpara>
2822                         <title>Columns:</title>
2823                         <simplelist type="horiz" columns="1">
2824                         <member><emphasis class="italic">field name : datatype -- parameters, contraints and notes</emphasis></member>
2825                         <member>
2826                         <database class="field">id</database> : <database class="datatype">bigint</database> 
2827 --
2828                          <literal>PRIMARY KEY</literal>,
2829                         <literal>DEFAULT nextval(&apos;acq.lineitem_attr_definition_id_seq&apos;::regclass)</literal>, 
2830                         </member>
2831                         <member>
2832                         <database class="field">code</database> : <database class="datatype">text</database> 
2833 --
2834                         <literal>NOT NULL</literal>, 
2835                         </member>
2836                         <member>
2837                         <database class="field">description</database> : <database class="datatype">text</database> 
2838 --
2839                         <literal>NOT NULL</literal>, 
2840                         </member>
2841                         <member>
2842                         <database class="field">remove</database> : <database class="datatype">text</database> 
2843 --
2844                         <literal>NOT