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.
| Table | Table detail |
|---|---|
| Vendor Tables | VENDOR VENDOR_LOC VENDOR_TYPE VENDOR_PAY VENDOR_ADDR VENDOR_WTHD |
| Voucher Tables | VOUCHER VOUCHER_LINE DISTRIB_LINE PYMNT_VCHR_XREF GRP_AP UI_VCHR_TBL UI_VCHR_ACCTG |
| Payment Tables | PAYMENT_TBL PYMNT_ADVICE UI_PAYMENT_TBL UI_STALE_TBL |
| PO Tables | DEPT_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 Tables | VNDR_HST VNDR_LOC_HST VNDR_TYPE_HST VNDR_PAY_HST VNDR_ADDR_HST |
| Voucher History Tables | VCHR_HST VCHR_LN_HST VCHR_DSTLN_HST PYMNT_VCHR_HST UI_VCHR_ACCTLN_HST |
| Payment History Tables | PYMNT_TBL_HST PYMNT_ADV_HST |