EX_ED_HDR_ATT (SQL View)	Index Back
Expense Report Hdr Attachment View of Expense header attachment with system file name info.

EX_ED_HDR_ATT

(SQL View)

Expense Report Hdr Attachment

View of Expense header attachment with system file name info.

SELECT A.SHEET_ID , A.SCM_ATTACH_ID , A.ATT_VERSION , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE FROM PS_EX_ER_ATT_HDR 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 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
Prompt Table: EX_SHEET_HDR

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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID Prompt Table: EX_SHEET_HDR
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	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
5	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File