Peoplesoft Awe Tables

 



Peoplesoft awe tables onlinePeoplesoft tables listBelow are the list of tables used in PeopleSoft Financial modules
Awe1. 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

PeopleSoft AWE Open Data Conversion Errors for Requisition. For doing data conversion from PeopleSoft 8.9 Instance to PeopleSoft 9.1 Instance as part of upgrade, few points should be considered with respect to AWE data migration in 9.1 instances for Requisition. This table holds the Approval Process definition properties. Setting up Approval Process in PeopleSoft Approval Workflow Engine (AWE) Being part of an organization which houses its HRIS system in PeopleSoft, we as an employee do various Self Service transactions like submit a planned leave request for a week or so which then goes to manager for their approval and upon final approval the database changes.

Does PeopleSoft provide a way to track the workflows/emails sent? Is there a record or a log file which tracks the PeopleSoft delivered emails sent as a result of user transaction sin PeopleSoft? Is there a way to see which email was triggered to whom with what subject? Who was copied(Cc) and blindly copied(Bcc) in that workflow notification? Hello Kevin, That Peoplecode was of great help. I was wondering if you can also share the SQL for PSZZWFAUTHVW view and the details on how you setup the ZZREQAWE Approver User list. Complete List of PeopleSoft Tables I could not find this else where and hence, I decided to build one myself – a complete list of PeopleSoft tables. Often a times when working on something like a PeopleSoft issue or a PeopleSoft upgrade, you feel the need to have a handly list of PeopleSoft tables.


  • 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
Peoplesoft awe tables reviews
  • PS_JRNL_LN
  • PS_JRNL_HEADER
  • PS_LEDGER
4. Purchase Order

Peoplesoft Awe Approval Tables

  • PS_PO_HDR
  • PS_PO_LINE
  • PS_PO_LINE_DISTRIB
  • PS_PO_LINE_SHIP

Peoplesoft Workflow Tables

Purchase Order Staging Tables:
  • PS_PO_HDR_STG
  • PS_PO_ITM_STG
  • PS_PO_DISTRIB_STG
5. Receipts

Peoplesoft Awe Tables


Peoplesoft Awe Tables Tutorial

  • PS_RECV_HDR
  • PS_RECV_LN_SHIP
  • PS_RECV_LN_ACCTG
6. VendorsTables
  • 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 Awe Workflow Tables


  • PS_ITEM
  • PS_ITEM_ACTIVITY
  • PS_ITEM_DST
  • PS_CUST_DATA
  • PS_CUST_AGING
  • PS_CUSTOMER
8. Billing

Peoplesoft AWE Workflow configuration DMS scripts

Peoplesoft AWE Workflow configuration and setup tables. Ver 9.0
User the following scripts to move the AWE configuration / setup data from the one instance to another instance.
Note :- add where clause if you need to move only configuration specific to particular AWE transactions.
Export script
-- 'Register Transaction'
EXPORT PS_PTAFAW_TXN;
EXPORT PS_PTAFAW_TXN_LNG;
EXPORT PS_PTAFAW_TXN_LBL;
EXPORT PS_PTAFAW_TXN_LVL;
-- 'Approvals > Workflow Transaction '
EXPORT EO_TRANSACTIONS;
EXPORT EO_TRANS_LNG;
-- 'Configure Transactions'
EXPORT PS_PTAFAW_NOTIFY;
EXPORT PS_PTAFAW_NOT_USER;
EXPORT PS_PTAFAW_TXN_CFG;
-- 'Setup Process Definitions'
EXPORT PS_PTAFAW_PATH;
EXPORT PS_PTAFAW_PATH_LNG;
EXPORT PS_PTAFAW_PRCS;
EXPORT PS_PTAFAW_PRCS_LNG;
EXPORT PS_PTAFAW_STAGE;
EXPORT PS_PTAFAW_STG_LNG;
EXPORT PS_PTAFAW_STEP;
EXPORT PS_PTAFAW_STEP_LNG;
-- 'Criteria Definitions'
EXPORT PS_PTAFCRTA;
EXPORT PS_PTAFCRTA_REC;
EXPORT PS_PTAFCRTA_VAL;
-- 'Maintain User Lists'
EXPORT PS_PTAFUSER_LIST;
EXPORT PS_PTAFUSER_LNG;
-- 'Generic Templates'
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PS_WL_TEMPL_GEN_RS;

4comments:

  1. Hi, could you post the same for version 9.1?


  2. I have the same question here, can the same list be used 9.1 ?
    Thanks in advance



  4. Hi,
    I did for Financials 9.1 and PT 8.50, just replace PTAF in the table name with EOAW.
    Juras


Newer PostOlder PostHome