PeopleSoft commonly used tables - List of Tables in PeopleSoft Financials Tables

-

List of Tables in PeopleSoft Financials

Below are the list of tables used in PeopleSoft Financial modules

1. Accounts Payable

PS_VOUCHER

PS_VOUCHER_LINE

PS_DISTRIB_LINE

PS_PYMNT_VCHR_XREF

PS_PAYMENT_TBL

PS_VCHR_ACCTG_LINE

PS_PYMNT_ADVICE

PS_VCHR_PPAY_XREF

2. Asset Management

PS_INTFC_FIN

PS_INTFC_PHY_A

PS_ASSET

PS_BOOK

PS_COST

PS_DEPRECIATION

PS_BOOK_HIST

PS_DIST_LN

PS_ASSET_ACQ_DETAIL

PS_ASSET_LOCATION

PS_OPEN_TRANS

PS_DEPR_RPT

PS_ASSET_NBV_TBL

PS_RETIREMENT

3. General Ledger

PS_JRNL_LN

PS_JRNL_HEADER

PS_LEDGER

4. Purchase Order

PS_PO_HDR

PS_PO_LINE

PS_PO_LINE_DISTRIB

PS_PO_LINE_SHIP

5.Purchase Order Staging Tables:

PS_PO_HDR_STG

PS_PO_ITM_STG

PS_PO_DISTRIB_STG

6. Receipts

PS_RECV_HDR

PS_RECV_LN_SHIP

PS_RECV_LN_ACCTG

7. Vendors

PS_VENDOR

PS_VENDOR_ADDR

PS_VENDOR_LOC

PS_VENDOR_PAY

PS_VENDOR_INVOICE

PS_VENDOR_CNTCT

PS_VNDR_BANK_ACCT

PS_VNDR_IBANK_ACCT

PS_VNDR_WTHD_JUR

8. Accounts Receivables

PS_ITEM

PS_ITEM_ACTIVITY

PS_ITEM_DST

PS_CUST_DATA

PS_CUST_AGING

PS_CUSTOMER

9. Billing

PS_BI_HDR

PS_BI_LN

PS_BI_ACCT_ENTRY


Thank You for visiting my blog.

Keep Learning, Keep Sharing.

Popular posts from this blog

PeopleSoft Meta Tables

-
Application Engine Meta Data PSAEAPPLDEFN AE header record; 1 row per app engine PSAEAPPLSTATE AE state records (shows which one is the default) PSAEAPPLTEMPTBL AE temp tables assigned PSAESECTDEFN AE sections: public or private PSAESECTDTLDEFN AE section: descriptions, market, DB Type, EFFDT, EFF_STATUS, and auto commit PSAESTEPDEFN AE steps within section: description, market, DB Type, EFFDT, EFF_STATUS PSAESTMTDEFN AE actions within AE step: Step type (SQL, Do Select, etc.) with SQLID. PSAESTEPMSGDEFN AE message (parameters in each step) AEREQUESTPARM AE request parameters table behind the AE run control page. Find All Records Referenced in App Engine 1. Find the Temp Records (TAO) that are used: SELECT RECNAME FROM PSAEAPPLTEMPTBL WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME' 2. If there are records, find the number of instances: SELECT TEMPTBLINSTANCES FROM PSAEAPPLDEFN WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME...
Read more

PeopleSoft - PeopleTools Configurations Records or Meta Tables

-
PeopleSoft - PeopleTools Configurations Records or Meta Tables PeopleSoft records/metadata tables, often referred to as "meta tables," store information about various PeopleSoft objects and configurations.  1. Object Definition Tables: PSRECDEFN : Contains definitions of records (tables) used in the application, including details like record type and description. PSDBFIELD : Stores field definitions, detailing the attributes of each field such as data type and length. PSPNLGROUP : Holds information about components, which are collections of pages that function together. PSPNLDEFN : Contains definitions of pages (interfaces) within the application. PSMENUDEFN : Stores menu definitions, organizing how components are presented to users. 2. Security Tables: PSOPRDEFN : Maintains user profile information, including user IDs and associated roles. PSROLEDEFN : Defines roles that group together permissions for easier security management. PSCLASSDEFN : Holds permission li...
Read more

Peoplesoft Application Package, Application Class and Application Method Implementation

-
Application Classes in PeopleSoft Defining and Importing packages or classes in PeopleCode <Pacakge name>:<Subpacakge name>:<…>:<Class name or wild card> Class Extensions represents the “is-a” relationship.   When a class extends another class, it’s called a subclass of that class. No Multiple inheritances or Concept of interface in Application classes. Instance variables in the class are accessible in all the objects of that class. Application programs generally pass parameters by value, which is not the same as for existing functions. Parameter passing with object data types is by reference. When the objects are passed to method and it reassign the object with new object it will not reflected in the calling method. Application Programs use the out specifier to pass a parameter by reference. Method increment (&Value as number out); rem passed by reference.   Create is the key word used to create the class object.  ...
Read more