Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  Query the warehouse
What you need
Access request forms
Password change
Query tool software
Training options
Tips
  
  Related information
About the warehouse
Data Administration
Security
Support services
Warehouse updates
  
  Data collections
advancement
assets
brim
brs
express mail
facilities
faculty
general ledger
infrastructure
learning management
position inventory
research
salary management
student
tuition distribution
cross-collection

General Ledger Collection Data Diagrams

The General Ledger Data Collection is described in the FINQUERY, FINQUERY Template Universe, FINSUMQ, and FINQO2N diagrams. Each diagram illustrates the architiecture of a specific Business Objects universe and identifies the join criteria between tables.

The FINQUERY diagram provides access to the General Ledger balances. In most instances, you will use this diagram when querying the General Ledger Data Collection.

The FINQUERY Template Universe diagram depicts the assorted template tables, which can be used to roll up balances or mimic General Ledger reports, joined to the FINQUERY universe.

The FINSUMQ diagram provides access to summary balances.

The FINQO2N diagram helps you to translate financial query records into terms that were used before July 1 1996, when the present General Ledger accounting structure was implemented. For example, translate object codes into subject codes.

In addition, users of the General Ledger data collection are automatically authorized to view the following:

The Express Mail diagram identifies the tables that make up the Express Mail universe and their join criteria. This diagram should be printed using landscape orientation.

The ISC Billing Detail diagram provides access to ISC Networking Billing detail data.

The ISC Telecommunications Detail diagram provides access to ISC Telecommunications invoice and charge data.

The ISC Mainframe Chargeback diagram provides access to Mainframe Chargeback invoice summary data..

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania