[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

PeopleSoft Tables and Terminology

Posted on 2011-09-13
2
Medium Priority
?
936 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
jsr_dba earned 2000 total points
ID: 36545339
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
ID: 36545363
Ooooooooo, thanks!  

That is really helpful.  Much appreciated.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

650 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