PeopleSoft Financials – Commonly Used Tables

PeopleSoft Financials – Commonly Used Tables

VENDORS
VENDOR             Vendor Header Table – Main Vendor table which contains many important fields related to the vendor. (i.e. Vendor ID, Name, Address)
VENDOR_LOC         Vendor Location – Location Information for each Vendor
VENDOR_ADDR         Vendor Address – Address Information for each Vendor
VENDOR_WTHD_JUR     Vendor Withhold Jurisdiction – Withholding Information Populated (Important in 1099 Processing)

REQUISITIONS
REQ_HDR Requisition Header – Header Record for Requisition
REQ_LINE         Requisition Line – Line Record for Requisition
REQ_LINE_DISTRIB     Requisition Line Distribution – Accounting Distribution for Requisition
REQ_LINE_SHIP         Requisition Line Delivery Schd – Shipment Details for Requisition
REQ_APPROVAL         Requisition Approval – Approval Information for Requisition
REQUESTOR_TBL         Master Requester Table – Requester Information

PURCHASE ORDERS
PO_HDR             Purchase Order Header – Header Record for Purchase Order
PO_LINE         Purchase Order Line – Line Record for Purchase Order
PO_LINE_DISTRIB     PO Line Accounting Entries – Accounting Distribution for Purchase Order
PO_LINE_MATCHED     PO Line Billed Amounts – Match Information for PO (Voucher, Receipt, PO)
PO_APPROVAL         Purchase Order Approval – Approval Information for Purchase Order
PO_LINE_SHIP         PO Line Shipping Schedule – Shipment Details for Purchase Order

RECEIPTS
RECV_HDR         Receiver Header – Receipt Header Table
RECV_LN_DISTRIB     Receipt Accounting Entries – Receipt Distribution Line
RECV_LN_ASSET         Receiving Asset Interface Scrl – Receipt Line Asset Information
RECV_LN_SHIP         Receipt Shipping Schedule – Receipt Shipment Information

ACCOUNTS PAYABLE
VOUCHER AP         Voucher Header Table – Header Record for Voucher
VOUCHER_LINE         Voucher Line – Line Record for Voucher
DISTRIB_LINE         Voucher Distribution Table – Accounting Distribution for Voucher
GRP_AP AP         Control Group Table – AP Control Group Data

TRAVEL AUTHORIZATIONS
EX_TAUTH_HDR         Travel Authorization Header – Header Record for TA
EX_TAUTH_LINE         Line Information – Line Record for TA
EX_TAUTH_DIST         Travel Authorization Dist – Accounting Distribution for TA

EXPENSE REPORTS
EX_SHEET_HDR         Expense Sheet Header – Header Record for Expense Report
EX_SHEET_LINE         Expense Report Line – Line Record for Expense Report
EX_SHEET_DIST         Expense Line Distributions – Accounting Distribution for Expense Report

CASH ADVANCES
EX_ADV_HDR         Advance Header – Header Record for Advances
EX_ADV_LINE         Advance Line – Line Record for Advances
EX_ADV_DIST         Cash Advance Distribution – Accounting Distribution for Advances
EX_ADV_APPRVR         Approvers – Approval Information Related to Advances

IDENTIFY PANTHER ID NUMBER
PERS_DATA_EFFDT     Effective Dated Personal Data – Main Personal Data table which contains many

EXPENSE APPROVERS
EX_ADV_HDR         Advance Header – Header Record for Advances
JOB EE Job         History – HR Manager Information

PAYMENTS
PAYMENT_TBL        AP Disbursements – Detail of each payment generated from the Accounts Payable Pay Cycle. Includes fields such as Check #, Payment #, Vendor Paid, Employee ID Paid (From
Expenses), Address and Method of Payment, Payment Status (i.e. Cancelled, Scheduled)
PYMNT_VCHR_XREF     Voucher Scheduled Payment – Accounts Payable Detail (i.e. Voucher ID) related to a
EX_ADVNCE_PYMNT     Advance Payment – Cash Advance Detail related to a specific payment.
EX_SHEET_PYMNT         Sheet Payment – Expense Report Detail related to a specific payment.

GENERAL LEDGER (Ledger populated by GL Posting Process)
JRNL_HEADER        Journal Header Data – Header Record for Journal. Important Fields include the following: JOURNAL_ID, JOURNAL_DATE, JRNL_HDR_STATUS, BUDGET_HDR_STATUS, DESCR254
JRNL_LN            Journal Line Data – Line Record for Journal. Important fields include the following: Journal ID, Journal Line #, Department ID and Account (and Other Chartfields), Budget Line
Status, Distribution Amounts, Budget Dates, Close Flag
LEDGER             Ledger Data – Summary of Balances by Chartfields by Fiscal Year, Accounting Period

COMMITMENT CONTROL (Populated by Budget Check process)
LEDGER_KK         Ledger Data – Summary of Balances by Chartfields by Fiscal Year, Accounting Period.  Similar to LEDGER table with the additional field, for Budget Period.
KK_BUDGET_LN         KK Budget Journal Line – Budget Transfer and Budget Entry Journal Lines
KK_BUDGET_HDR         KK Budget Journal Header – Budget Transfer and Budget Entry Journal Header
KK_ACTIVITY_LOG     KK budget activity record – Transaction Accounting Details populated on this record when an Item is ‘Budget Checked’. Each transaction is identified by KK Transaction ID
KK_SOURCE_HDR         Comm. Cntrl. Source Hdr Table – Associates the KK Transaction ID’s with a more module specific Identifier, like a specific Voucher ID
KK_LIQUIDATION         Comm. Cntrl. Liquidation Table – For each KK Transaction ID, the amount remaining to be liquidated. (i.e. Amount of encumbrance remaining to be released for PO or TA)NOTE: These Tables do not contain any information that you could not otherwise find using files delivered with the PeopleSoft System.

BUDGET PREPARATION
FIU_POSTN_BUDGT     Position Budget Reporting – Position Budgets (Unique to FIU)
LEDGER_BUDG         Budget Ledger Data – Ledger for Last Year’s Budget, Forecast and Requested budgets

CHARTFIELD TABLES    DEPT_TBL Departments – Department Ids
PROJECT         Projects – Stores the Project information when a new Project is created, keyed by Business Unit
GL_ACCOUNT_TBL         Accounts – Accounts
SPEEDTYP_TBL         SpeedTypes – Speedtypes
FUND_TBL         Fund Table – Fund Codes: E&G, AUX, C&G, Agencies, FA, Student Related Activities, and Concessions
CLASS_CF_TBL        Class of Trade Table – Class (Campus / Location) Codes: 1. Modesto A. Madique Campus, 2. Biscayne Bay Campus, 3. Broward, 4. Pembroke Pines, 5. Wolfsonian
PROGRAM_TBL         Program Table – PCS Codes \ Functional Component \ Program Codes
BUD_REF_TBL         Budget Reference Table – Budget Reference
ALTACCT_TBL         Alternate Account – Alternate Accounts established by the State of Florida for state accounting
COMBO_DATA_TBL         ChartField Combo Data Tbl – Contains Valid CF Combinations (or Invalid depending on Rule Definition)

ASSETS
BOOK             Financial Book – The table has the Financial Asset Book transactions. Important fields include BU, Asset #, Book, Begin_Depr_Dt
COST             Asset Cost Transactions – The table has the Asset Cost transactions Important fields include Asset #, Book, Group_Asset_ID, Category, Cost Type, Cost
INTFC_PRE_AM         Pre-Interface Table to AM – Table initially loaded with asset detail from other system (i.e. Accounts Payable)
INTFC_FIN         AM Interface-Financial – Accounting Detail associated with asset initially loaded into Asset Management
ASSET            Asset General Information – The primary Asset table populated when an asset is created. Important fields include: Asset #, Tag, Description, Acquisition dates, Serial #, Profile
DEPRECIATION        Depreciation Transactions – The table has the Depreciation transactions. Important fields include the following: BU, Asset #, Book, Start_PD, End_PD, Trans_Dt
ASSET_ACQ_DET         Asset Acquisition Detail – Asset Acquisition Detail
ASSET_NBV_TBL         Asset NBV Reporting Table – Asset Net Book Value DetailNOTE: These Tables do not contain any information that you could not otherwise find using files delivered with the PeopleSoft System.

SUB-MODULE INTERFACE TABLES (STAGING TABLES) – Prior to Journal Generation
VCHR_ACCTG_LN         AP Accounting Entries – Accounts Payables (Vouchers)
EX_ACCTG_LINE         Expense Accounting Line – Travel & Expenses (Cash Advances \ Expense Reports)
DIST_LN AM         Accounting Entries – Asset Management (Assets)
CA_ACCTG_LN_PC         Accounting line tbl for CA/PC – Contracts (Grants Billing)
BI_ACCT_ENTRY         Billing Account Entry table – Billing (Grants Billing)
ITEM_DST         Customer Item Distribution – Receivables (Grants Receivables \ Payments)
PAY_MISC_DST         Non Customer Payment Distrib – Receivables (Grants Payments)
SF_ACCTG_LN         Student Financials Acctg Line – Student Financials (including Cashiering)
HR_ACCTG_LINE         Payroll Accounting Line – Payroll (PSFT HR\Payroll on 1/1/2012)
JGEN_ACCT_ENTRY     JrnlGen Accounting Entry Table – Pinnacle (Telecommunications)

CONTRACTS \ GRANTS
CA_DETAIL_DST         Contract Distribution Detail – Links Projects to Contracts/”Awards”
CA_CONTR_HDR         Contract Header – Line Record for Purchase Order
PROJECT         Projects – Stores the Project information when a new Project is created, keyed by Business Unit
GM_AWARD         Award Parent Record – Header Record for Award
GM_PROPOSAL         Grants Proposal – Header Record for Proposal

BILLING
BI_HDR             Bill Header – Header record for Customer Bill
BI_LINE         Bill Lines – Line Information for customer bills

RECEIVABLES
ITEM             Customer Items – Header Record for Receivables Items
ITEM_ACTIVITY         Customer Item Activity – Detail Line information for Receivables Items
ITEM_DST         Customer Item Distribution – Item Chartfield Distribution

PAYMENTS
DEPOSIT_CONTROL     Deposit Control Information – List the Customer Deposit Information (Deposit BU and Deposit ID are Keys)
PAYMENT         Payments – Payment information for the Customers (Customer Payments\Receipts)
PAYMENT_ID_CUST     Payment Customer Identification – Payment Customer Information
PAYMENT_ID_ITEM     Payment Item Identification – Payment Item Identification

CUSTOMERS
CUSTOMER         Customer Header Information – Header for Customer Data
CUST_ADDRESS         Customer Address Detail – Customer Address Information
CUST_CONTACT         Customer Contact Detail – Customer Contact Information
CUST_DATA         Customer Info / Balances – Customer Details such as Customer Balance, Last Payment, Last Aged
CUST_AGING         Customer Aging – Customer Details such as Aging Id, Aging Amount, Count, etc.

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 0 comments