List of Tables in PeopleSoft Financials

Below are the list of tables used in PeopleSoft Financial modules

1. Accounts Payable

• PS_VOUCHER
• PS_VOUCHER_LINE
• PS_DISTRIB_LINE
• PS_PYMNT_VCHR_XREF
• PS_PAYMENT_TBL
• PS_VCHR_ACCTG_LINE
• PS_PYMNT_ADVICE
• PS_VCHR_PPAY_XREF

2. Asset Management

• PS_INTFC_FIN
• PS_INTFC_PHY_A
• PS_ASSET
• PS_BOOK
• PS_COST
• PS_DEPRECIATION
• PS_BOOK_HIST
• PS_DIST_LN
• PS_ASSET_ACQ_DETAIL
• PS_ASSET_LOCATION
• PS_OPEN_TRANS
• PS_DEPR_RPT
• PS_ASSET_NBV_TBL
• PS_RETIREMENT

3. General Ledger

• PS_JRNL_LN
• PS_JRNL_HEADER
• PS_LEDGER

4. Purchase Order

• PS_PO_HDR
• PS_PO_LINE
• PS_PO_LINE_DISTRIB
• PS_PO_LINE_SHIP

     Purchase Order Staging Tables:

• PS_PO_HDR_STG
• PS_PO_ITM_STG
• PS_PO_DISTRIB_STG

5. Receipts

• PS_RECV_HDR
• PS_RECV_LN_SHIP
• PS_RECV_LN_ACCTG

6. Vendors

• PS_VENDOR
• PS_VENDOR_ADDR
• PS_VENDOR_LOC
• PS_VENDOR_PAY
• PS_VENDOR_INVOICE
• PS_VENDOR_CNTCT
• PS_VNDR_BANK_ACCT
• PS_VNDR_IBANK_ACCT
• PS_VNDR_WTHD_JUR

7. Accounts Receivables

• PS_ITEM
• PS_ITEM_ACTIVITY
• PS_ITEM_DST
• PS_CUST_DATA
• PS_CUST_AGING
• PS_CUSTOMER

8. Billing

• PS_BI_HDR
• PS_BI_LN
• PS_BI_ACCT_ENTRY