Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. What Oracle Tables does the Acquisitions Module Use?

    What Oracle Tables does the Acquisitions Module Use?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • What Oracle tables are used to produce circulation statistics?
      • What Oracle Tables does the Circulation Module Use?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. Acquisitions (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved