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.

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.