PO_SE_CNT_ATT

(SQL View)
 Index Back

Search comments and attach

PO Contracts

SELECT COM.SETID , COM.CNTRCT_ID , COM.VERSION_NBR , COM.SCM_ATTACH_ID , COM.ATT_VERSION , COM.ATTACH_DESCR , B.COMMENTS_2000 , COM.FILENAME , COM.FILE_EXTENSION , COM.OPRID , ATT.SERVER_ID , ATT.SERVER_PATH , ATT.ATTACHSYSFILENAME , CASE ATT.PV_URL_ID WHEN ' ' THEN %Substring(ATT.ATT_SRV_NAME,1 ,30) ELSE ATT.PV_URL_ID END FROM PS_CNTRCT_COMMENTS COM LEFT OUTER JOIN ( SELECT A.SERVER_ID , A.SERVER_PATH , A.ATTACHSYSFILENAME , SRV.PV_URL_ID , SRV.ATT_SRV_NAME , A.SCM_ATTACH_ID , A.ATT_VERSION FROM PS_PV_ATTACHMENTS A , PS_PV_ATT_SERVERS SRV WHERE A.SERVER_ID = SRV.SERVER_ID) ATT ON COM.SCM_ATTACH_ID = ATT.SCM_ATTACH_ID AND COM.ATT_VERSION = ATT.ATT_VERSION AND COM.STATUS = 'A' LEFT OUTER JOIN PS_COMMENTS_TBL B ON COM.OPRID = B.OPRID AND COM.COMMENT_ID = B.COMMENT_ID AND COM.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND COM.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
5 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
6 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
7 SES_PROC_CMMT Long Character CLOB Common Procurement Comment Field
8 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
9 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID
12 SERVER_PATH Character(254) VARCHAR2(254) NOT NULL For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
13 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
14 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).