PeopleSoft Financials – Commonly Used Tables | PeopleSoft Tutorial

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
 

>