Posted   by 

Peoplesoft Workflow Transaction Tables



  1. Peoplesoft Workflow Transaction Tables Template
  2. Peoplesoft Approval Workflow
  3. Peoplesoft Workflow Setup
  4. Peoplesoft Workflow Template
WorkflowPeoplesoftBelow are the list of tables used in PeopleSoft Financial modules

Peoplesoft Workflow Transaction Tables Template


  • TRANSACTIONID The system-assigned transaction ID for the work item. When an event triggers multiple routings, each work item has the same transaction ID, but a different instance ID. The system uses these fields to link the items in the worklist with their tracking information, which is stored in the PeopleSoft-defined table PSWORKLIST.
  • As you design the workflow application, identify the workflow rules and how they relate to the data objects and transactions in the PeopleSoft system. Build the underlying application. Create workflow maps. Use PeopleSoft Application Designer to create graphical maps that represent your business process.
  • How to disable a PeopleSoft Workflow? How to disable a particular PeopleSoft Workflow Activity/Event? This solution is applicable for PeopleTools version 8.4x including 8.44, 8.48, 8.49. I am not sure about other versions of PeopleSoft and I firmly believe the other versions of PeopleTools will also behave the same way.
  • Many daily tasks are part of a larger process thatinvolves several steps and people working together, such as the approvalof a promotion. To facilitate this type of multiuser process, PeopleSoftprovides approvals functionality, which enables you to automaticallytrigger workflow notifications to inform the next approver in theprocess of pending transactions.

NOTE: These Tables do not contain any information that you could not otherwise find using files delivered with the PeopleSoft System. Page 1 of 4 RECORD (TABLE) NAME RECORD (TABLE) DEFINATION & DESCRIPTION VENDORS VENDOR Vendor Header Table - Main Vendor table which contains many important fields related to the vendor. Vendor ID, Name, Address).

Peoplesoft Workflow Transaction Tables1. 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
Purchase Order Staging Tables:
  • PS_PO_HDR_STG
  • PS_PO_ITM_STG
  • PS_PO_DISTRIB_STG
Transaction5. Receipts
  • PS_RECV_HDR
  • PS_RECV_LN_SHIP
  • PS_RECV_LN_ACCTG

Peoplesoft Approval Workflow

6. 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
7. Accounts Receivables

Peoplesoft Workflow Setup

  • PS_ITEM
  • PS_ITEM_ACTIVITY
  • PS_ITEM_DST
  • PS_CUST_DATA
  • PS_CUST_AGING
  • PS_CUSTOMER

Peoplesoft Workflow Template

8. Billing