Controller Directory Documentation News Financial Data Queries UC Home Page
Account Expenses Departmental Expenses Departmental Transactions Document Details Endowment Query Page Fund Balance Microfilm Index PIPES
UC Home Page

Purchase order, Invoice, and Payment Enquiry System


Enter the PO number:
  
PO Listing by Account
(e.g., PC03A-01000)
        
The purchase order number associated with the order, invoice or payment must be specified.  Because PIPES pulls together a lot of information, retrieving that information may take 10-30 seconds and up to a minute in some cases.  Please be patient.

To find a purchase order number that charges a particular account, click on the PO Listing by Account button.
About PIPES
Introduction

Welcome to PIPES!  What does PIPES have to offer?  It consolidates a great deal of information associated with a purchase order that ordinarily takes a lot of time and effort to find in CUFS.  With the help of a datawarehouse of CUFS information, it provides more historical and concise information than is available through online CUFS.  PIPES also enhances CUFS data by providing a link to the images of the invoice documents associated with a purchase order.  Because we have a very limited number of licenses for the document viewing feature, it is important that you close the window displaying the invoice images when you are finished viewing/printing them.
CUFS Data

PIPES pulls together data from the following CUFS sources:
  • General Ledger (payment voucher and check transactions) (1),
  • MPPH (change order modifications) (1),
  • OCHT (check information) (2),
  • OPPC (commodity lines on the purchase order) (1),
  • OPPH (summary purchase order information) (1),
  • OPPL (account lines charged on the purchase order) (1),
  • OVIH (invoices associated with the purchase order) (1),
  • PTEX (purchase order text information) (3).

Please keep in mind that since PIPES and the Controller Web Queries are supported by the datawarehouse in Financial Systems, the data is one day behind CUFS.  However, the ledger information goes back to FY96 (approximately July 1, 1995).  The information in MPPH, OCHT, OPPC, OPPH, OPPL, and PTEX mirrors what is online in CUFS (as of the day before).  The OVIH information is an accumulation of data starting in July 1999 through yesterday's business.  July 1999 marks the point in time when we started scanning invoices.

  1. General Ledger, MPPH, OPPC, OPPL, and OVIH information appears on the Purchase Order, Invoice and Payment Information page.
  2. OCHT information appears on the Check Information page.  The check number in the Payment Transactions section of the Purchase Order, Invoice and Payment Information page contains a hyperlink to that information.
  3. PTEX information appears on the Purchase Order Text Information page.  The View PTEX item in the Summary section of the Purchase Order, Invoice and Payment Information page contains the hyperlink to that information.
Invoice Documents

Linking to an invoice document is easy.  When a PO has invoice activity, invoice data will be listed in the Invoices section on the Purchase Order, Invoice and Payment Information page.  The invoice number will also appear next to the associated payment voucher in the Payment Transactions section.  If an image of an invoice document exists, the invoice number in both sections will appear as a link (blue, underlined text).  Clicking on the link will open up another browser window and then will load and display the selected invoice document in that window.  On the first use of this feature, a "Security Warning" box will appear asking if you want to install and run a program file.  Click "Yes" so that you will be able to use this feature. 

Again, because we have a very limited number of licenses for this feature, it is important that you close the window displaying the invoice images when you are finished viewing/printing them.

Response Time

Please be patient with PIPES.  It pulls together a lot of information.  Retrieving the purchase order, invoice and payment information may take 10-30 seconds, and, in some cases, it may take up to a minute.  The response time depends primarily on how busy our server is and/or how much data is being returned.
System/Browser Requirements

  • PIPES Web pages must be viewed with browsers equal or later than Internet Explorer 5.5 or Netscape 7.0.
  • The invoice images are best viewed with a Windows PC.  Apple/Macintosh machines may not be able to view them.
Good luck with your search!  We hope that you find PIPES to be a valuable tool.
For assistance with this research tool, please contact the Accounts Payable Office for starters at 556-6772.
For any technical problems pertaining to PIPES, please contact the CUFS Hotline at 556-5100.
Return to top