Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    What Oracle Tables does the Acquisitions Module Use?

    1. Last updated
    2. Save as PDF
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 21

    Question

    What Oracle tables does the Acquisitions module use?

    Answer

    Z14 - Routing list member
    Z16 - Subscription
    Z18 - Routing list
    Z20 - Serial Claims
    Z68 - Order
    Z70 - Vendor
    Z71 - Order Log
    Z72 - Vendor address
    Z74 - EDI Load log
    Z75 - Invoice line item
    Z76 - Budgets
    Z77 - Invoices
    Z78 - Arrival information
    Z79 - Order Index
    Z82 - Currencies
    Z83 - Currency Information
    Z501 - Monographic Claims
    Z601 - Budget Transactions
    Z602 - Sublibrary/Order Unit for Budget and Vendor

    HOL 853/853X for MARC Prediction patterns and issues
    Z08 - Z09 - Non-MARC Prediction patterns (not generally in use)

    The Acquisitions module uses various tables (z00 doc record; z13 Brief doc record; z95/z97/z98 Word indexes; etc.), which are not specific to Acquisitions.

    Note: This should not be considered a definitive list; there may be others.

    Additional Information

    See also, the "ALEPH File Relationship Diagrams" on the Documentation Center.

    Category: Acquisitions (500)

    • Article last edited: 10/8/2013