PeopleSoft Financials 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:
PS_RT_RATE_TBL : Market Rate Data Tale. There is also the market rate default view RT_DFLT_VW.

Vendor Tables

PS_VENDOR: Stores vendor related information.

PS_VENDOR_ADDR: Vendor address related info.

PS_VENDOR_INVOICE: Stores vendor invoice related flags.

PS_VENDOR_PAY: Vendor payment defaults such as payment method, payment handling code, bank code and so forth.

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.

转载于:https://www.cnblogs.com/GoDevil/archive/2008/08/08/1263782.html