PeopleSoft Tables and Terminology
Posted on 2011-09-13
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. :)