PeopleSoft Finance Tables

PeopleSoft Finance - CORE Tables for AP and GL General Ledger Tables   

PS_LEDGER	The general ledger data table
PS_JRNL_HEADER	Stores general ledger journal header data.
PS_JRNL_LN	Stores general ledger journal line data.
PS_COMBO_RULE_TBL	Stores ChartField combination rules.
PS_COMBO_GROUP_TBL	Stores ChartField combination groups.
PS_COMBO_DATA_TBL	ChartField Combo data table.
PS_BU_LED_COMB_TBL	Business Unit CharField Combos for Ledger.
PS_GL_ACCOUNT_TBL	GL Accounts table.

Accounts Payable/Voucher Tables      

PS_GRP_AP	Stores AP control groups.
PS_VOUCHER	AP voucher header table.
PS_VOUCHER_LINE	AP voucher line.
PS_DISTRIB_LINE	Voucher distribution table.
PS_PAYMENT_TBL	AP disbursements table.
PS_PYMNT_VCHR_XREF	Voucher Scheduled Payment.
PYMNT_XREF_VW
PS_RT_RATE_TBL	Market Rate Data Tale. There is also the market rate default view RT_DFLT_VW.
PS_VCHR_ACCTG_LINE	AP accounting entries.
RT_RATE_TBL	Market Rate Data Tale. There is also the market rate default view
RT_DFLT_VW

Voucher Build Staging Tables

PS_VCHR_HDR_STG
PS_VCHR_LINE_STG
PS_VCHR_DIST_STG
PS_VCHR_PYMT_STG

Vendor Tables       

VENDOR	Stores vendor related information.
VENDOR_ADDR	Vendor address related info.
VENDOR_LOC	Vendor locations.
VENDOR_PAY	Payment processing specifications such as payment method, payment handling code, bank code and so forth.
VNDR_ADDR_SCROL	Index to address table
VNDR_CNTCT_SCR	Index to contact table.
VNDR_LOC_SCROL	Index to location table.
VENDOR_ID_NBRS	Additional ID numbers (Dun & Bradstreet numbers).
VENDOR_ADDR_PHN	Vendor phone numbers.
VENDOR_CNTCT	Vendor contacts.
VENDOR_CONVER	Vendor converstaions.
VENDOR_INVOICE	Stores vendor invoice related flags.
VENDOR_TYPE	Vendor type codes.
VNDR_BANK_ACCT	Vendor electronic payment information.
VNDR_CNTCT_PHN	Vendor contact phone numbers.
VNDR_IND_CLASS	Vendor Standard Industrial Classification (SIC) codes.
VNDR_URL	Vendor website address.
VNDR_VAT_RGSTRN	Vendor VAT information.
VENDOR_WTHD	Withholding data
VENDOR_WTHD_JUR	Withholding type.

Requisition Tables

REQ_HDR	Requisition Header
REQ_LINE	Requisition Line
REQ_LINE_SHIP	Requisition Line Schedule
REQ_LN_DISTRIB	Requisition Distribution

Purchase Order Tables

PS_PO_HDR	PO header detail
PS_PO_LINE	Po line details
PS_PO_LINE_DISTRIB	PO line distribution details
PO_LINE_MATCHED PS_VENDOR	Vendor details.
PS_PERSONAL_DATA	Personal data details
PS_IF_WFLOW_PO	PO work flow details
PS_PO_LINE_SHIP	PO ship details.
PS_PO_RECV_LN_VW	When PO received then its details
PS_VCHR_LN_PO_VW	When we create voucher of PO PS_RECV_HDR---Receiver header table RECV_LN

Accounts Receivable Tables

PS_ITEMPS_ITEM_ACTIVITY
PS_ITEM_DSTPS_PENDING_ITEM
PS_PENDING_DST
PS_GROUP_CONTROL
PS_DEPOSIT_CONTROL
PS_PAYMENT
PS_PAYMENT_ID_CUST
PS_PAYMENT_ID_ITEM

SELECT * FROM PSSECOPTIONS -- PS Password security details
SELECT * FROM PSSTATUS           -- PS PeopleTools version details
SELECT * FROM PSRELEASE        -- PS PeopleSoft Application Details