CS_DOC_PO_SRVW4

(SQL View)
 Index Back

ALL - PO Contracts

Prompt for PO contract key fields on doc_find page (uses edittable) .. ALL documents (active and inactive/closed

SELECT A.SETID , A.CNTRCT_ID FROM PS_CS_DOC_PO_KEYS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID