PO_DOCATT_DB_VW

(SQL View)

SELECT DISTINCT A.COMMENT_ID , A.COMMENT_TYPE , A.SCM_ATTACH_ID , A.ATT_VERSION , A.ATTACH_DESCR , A.FILENAME , A.FILE_EXTENSION , A.OPRID , B.SERVER_ID , B.SERVER_PATH , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE FROM PS_PO_COMMENTS A , PS_PV_ATTACHMENTS B WHERE B.SERVER_TYPE = 'D' AND COMMENT_TYPE IN ('HDR', 'LIN', 'SHP') AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered

2 COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
BF=Bid Factor
CBF=Analysis Collab Bid Factor
HDR=Header
LIN=Line
SHP=Ship To Location

3 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.

4 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.

5 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.

6 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

7 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID

10 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.

11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered
2	COMMENT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Comment Type BF=Bid Factor CBF=Analysis Collab Bid Factor HDR=Header LIN=Line SHP=Ship To Location
3	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.
4	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.
5	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.
6	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
7	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	SERVER_ID	Number(4,0)	SMALLINT NOT NULL	File Server ID
10	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.
11	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
12	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File