PeopleSoft Decisions Support System 

Located on the APPO PeopleSoft Web Applications page in Self-Service, is a list of all the PeopleSoft tables available and documentation on the most used fields from those tables.

Click the table headers for descriptions of commonly used and most useful fields from these tables.

This information can also be accessed via Self Serve under the Administration Tab>Data Access>AP-PO PeopleSoft.

PeopleSoft Tables Available
TableTable detail
Vendor TablesVENDOR
VENDOR_LOC
VENDOR_TYPE
VENDOR_PAY
VENDOR_ADDR
VENDOR_WTHD
Voucher TablesVOUCHER
VOUCHER_LINE
DISTRIB_LINE
PYMNT_VCHR_XREF
GRP_AP
UI_VCHR_TBL
UI_VCHR_ACCTG
Payment TablesPAYMENT_TBL
PYMNT_ADVICE
UI_PAYMENT_TBL
UI_STALE_TBL
PO TablesDEPT_TBL
REQUESTOR_TBL
LOCATION_TBL
ORIGIN_PROCURE
PO_HDR
PO_LINE
PO_LINE_DISTRIB
UI_REQ_INFO_TBL
UI_PO_INV_TBL
UI_PO_ID_TBL
UI_REQID_RPTTBL
PO_LINE_SHIP
Vendor History TablesVNDR_HST
VNDR_LOC_HST
VNDR_TYPE_HST
VNDR_PAY_HST
VNDR_ADDR_HST
Voucher History TablesVCHR_HST
VCHR_LN_HST
VCHR_DSTLN_HST
PYMNT_VCHR_HST
UI_VCHR_ACCTLN_HST
Payment History TablesPYMNT_TBL_HST
PYMNT_ADV_HST