Some PeopleSoft FSCM base tables


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.
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.

Vendor Tables
VENDOR: Stores vendor related information.
VENDOR_ADDR: Vendor address related info.
VENDOR_LOC: Vendor locations.
VENDOR_PAY: Payment processing sepecifications such as payment method, payment handling code, bank code and so forth.
VENDOR_ADDR_SCROL: Index to address table.
VENDOR_CNTCT_SCR: Index to contact table.
VENDOR_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: Witholding data.
VENDOR_WTHD_JUR: Witholding type.

The following is vendor tables parent-child relationships from PeopleSoft 9.0 PeopleBooks.

Business Unit Tables

PS_BUS_UNIT_TBL_FS: PeopleSoft financials business units.
PS_BUS_UNIT_TBL_AM: Asset Management business unit table.
PS_BUS_UNIT_TBL_AP: Accounts Payable business unit table.
PS_BUS_UNIT_TBL_AR: Accounts Receivable business unit table.
PS_BUS_UNIT_TBL_GL: General Ledger business unit table.
PS_BUS_UNIT_TBL_BI: Bill business unit table.

Purchasing Tables

Requisition Tables

REQ_HDR: Requisition Header
REQ_LINE: Requisition Line
REQ_LINE_SHIP : Requisition Line Schedule

REQ_LN_DISTRIB: Requistion Distribution

REQ_COMMENTS: Requisition Comments

PV_REQ_HDR_DTL: eProcurement Requisition Header Table