SCR_HDFT_ATT_VW (SQL View)	Index Back
Header Attachments View A view of the header attachment draft table and master attachments table.

SCR_HDFT_ATT_VW

(SQL View)

Header Attachments View

A view of the header attachment draft table and master attachments table.

SELECT A.SCR_ID ,A.SCM_ATTACH_ID ,A.ATT_VERSION ,B.ATTACH_DESCR FROM PS_SCR_HDR_ATT_DFT A ,PS_PV_ATTACHMENTS B WHERE 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 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCR_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Change Request ID
2	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.
3	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.
4	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.