Solved

PeopleSoft Tables and Terminology

Posted on 2011-09-13
2
877 Views
Last Modified: 2012-08-14
Hello, this is mostly just a general information request.  We are in the midst of a conversion from a  mainframe system to PeopleSoft and I'm the database developer on a downstream reporting mart that needs to interface with the PeopleSoft data.

I haven't worked with PeopleSoft in many years and I'm just trying to get a handle on the tables again and which ones are for what...

Basically I'm trying to wrap my head around the AR related tables, AP and Purchasing.  My first question is with payment tables.  It appears that there are 2 payment tables.  One is just called PAYMENT and the other is called PAYMENT_TBL.  From my research on the PeopleSoft ERDs it appears that PAYMENT is an AR table and PAYMENT_TBL is the AP table?  

For AR, the tables I'm looking at are mostly Billing tables (BI_HDR, BI_LINE), Item tables, Payment.  Any other key ones here?
For AP, Voucher tables, payment_tbl ... any others?
Purchasing, PO tables, Requisition tables, Recieving tables, Credit Card tables, Contract tables

Any other meaningful direction would also be welcome. :)
0
Comment
Question by:Roxanne25
2 Comments
 
LVL 1

Accepted Solution

by:
jsr_dba earned 500 total points
Comment Utility
Hi,

Yes , you are right.  PAYMENT is AR and PAYMENT_TBL is in AP module.

PAYMENT_TBL - Contains the AP disbursement information, including check, payment date and remit vendor.

Cut & paste this link for furher information on PS Key tables. this is for version 8.4.

http://webcache.googleusercontent.com/search?q=cache:HjZtRRP8C_MJ:https://myshare.in.gov/SBA/encompass/Shared%2520Documents/Upgrade%2520Test%2520Scripts/General%2520Ledger%2520(GL)/Query%2520Reporting/PT_501a%2520List%2520of%2520Helpful%2520Tables.xls+payment_tbl+peoplesoft&cd=2&hl=en&ct=clnk&gl=us

Hope this gives an idea.
0
 

Author Comment

by:Roxanne25
Comment Utility
Ooooooooo, thanks!  

That is really helpful.  Much appreciated.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now