2.0/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"