PeopleSoft Finance Tables Overview

PeopleSoft Financials relies on a robust and complex relational database structure, with numerous tables storing financial data. Understanding the purpose of key tables is crucial for reporting, integrations, and customizations. These tables hold information relating to General Ledger, Accounts Payable, Accounts Receivable, Asset Management, and Purchasing.

General Ledger Tables

The General Ledger (GL) module centers around these core tables:

• LEDGER: The primary table storing GL balances. It contains summarized financial data by business unit, ledger, account, operating unit, and various other dimensions. This table is the foundation for financial reporting.
• JOURNAL_HEADER: Stores header-level information for journal entries, including journal ID, date, source, and description.
• JOURNAL_LINE: Contains the detailed line items of journal entries, including account, debit/credit amounts, and descriptions. It’s linked to JOURNAL_HEADER through the Journal ID.
• ACCOUNT_TBL: Defines the chart of accounts, including account descriptions, valid combinations, and budgetary control settings.
• BUSINESS_UNIT_TBL: Stores information about business units, including their names, addresses, and default ledger group.

Accounts Payable Tables

Accounts Payable (AP) manages vendor invoices and payments. Key tables include:

• VOUCHER: The central table for voucher data, storing information like vendor ID, invoice date, gross amount, and payment terms.
• VOUCHER_LINE: Stores the individual lines of a voucher, specifying the expense account, amount, and distribution information.
• VENDOR: Contains vendor information, including name, address, contact details, and payment terms.
• PAYMENT_TBL: Holds information about payments made to vendors, including payment date, amount, and payment method.

Accounts Receivable Tables

Accounts Receivable (AR) manages customer invoices and payments. Important tables are:

• CUSTOMER: Stores customer information, including name, address, contact details, and credit limits.
• ITEM: Holds information about customer invoices (items), including invoice date, amount, and due date.
• ITEM_LINE: Contains the individual lines of an invoice, specifying the revenue account, amount, and description.
• PAYMENT: Stores information about customer payments, including payment date, amount, and method of payment.

Asset Management Tables

Asset Management (AM) tracks the lifecycle of assets. Key tables include:

• ASSET: Stores information about individual assets, including acquisition date, cost, and depreciation method.
• ASSET_BOOK: Tracks the depreciation of assets for different books (e.g., book and tax).
• DEPR_RPT: Contains depreciation expense information for reporting purposes.

Purchasing Tables

Purchasing manages the procurement process. Relevant tables include:

• PO_HDR: Stores header-level information for purchase orders, including vendor ID, purchase order date, and delivery address.
• PO_LINE: Contains the individual lines of a purchase order, specifying the item, quantity, and price.
• REQUISITION_HDR: Stores header-level information for requisitions.
• REQUISITION_LINE: Contains the individual lines of a requisition.

These are just a few of the many tables within PeopleSoft Financials. Understanding the relationships between these tables is crucial for effectively using the system and extracting meaningful financial information. Developers and analysts often use SQL queries to join these tables and create custom reports or integrations.