PeopleSoft FSCM important tables

 

PeopleSoft finance and supply chain management important tables list

 

SELECT * FROM PS_JRNL_LN_BUDG

SELECT * FROM PS_LEDGER_BUDG

SELECT * FROM PS_COMBO_DATA_TBL

SELECT * FROM PS_COMBO_DATA_BUDG

 

SELECT * FROM PS_REQ_HDR

SELECT * FROM PS_REQ_LINE

SELECT * FROM PS_REQ_LINE_SHIP

SELECT * FROM PS_REQ_LINE_DISTRIB

SELECT * FROM PS_REQ_LINE_ACCTG

 

SELECT * FROM PS_PO_HDR

SELECT * FROM PS_PO_LINE

SELECT * FROM PS_PO_LINE_SHIP

SELECT * FROM PS_PO_LINE_DISTRIB

SELECT * FROM PS_PO_LINE_ACCTG

 

SELECT * FROM PS_RECV_HDR

SELECT * FROM PS_RECV_LN

SELECT * FROM PS_RECV_LN_SHIP

SELECT * FROM PS_RECV_LN_DISTRIB

 

SELECT * FROM PS_VOUCHER

SELECT * FROM PS_VOUCHER_LINE

SELECT * FROM PS_DISTRIB_LINE

SELECT * FROM PS_VCHR_ACCTG_LINE

SELECT * FROM PS_PO_LINE_MATCHED

SELECT * FROM PS_PYMNT_ADVICE

SELECT * FROM PS_PYMNT_VCHR_XREF

SELECT * FROM PS_PAYMENT_TBL

 

 

SELECT * FROM PS_VENDOR

SELECT * FROM PS_VENDOR_LOC

SELECT * FROM PS_VENDOR_PAY

SELECT * FROM PS_VNDR_LOC_ADDR

SELECT * FROM PS_VENDOR_WTHD

SELECT * FROM PS_VENDOR_ADDR

 

--AR

SELECT * FROM PS_AR_PAYMENT_EC

SELECT * FROM PS_AR_IDCUST_EC

SELECT * FROM PS_AR_IDITEM_EC

 

SELECT * FROM PS_PAYMENT_ID_CUST

SELECT * FROM PS_PAYMENT_ID_ITEM

SELECT * FROM PS_DEPOSIT_CONTROL

SELECT * FROM PS_PAYMENT

 

 

Best Regards

Aravind Kumar R

System Analyst/Peoplesoft Practice
Birlasoft • 36, Vijayaraghava Road , T. Nagar, Chennai 600 017 (INDIA)
Cell: +91 9566750166

************************************************************************************************************************************************************************************
"This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the mail.admin@birlasoft.com immediately without opening the mail and attachment . Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email
************************************************************************************************************************************************************************************