AP_PR_ATCH_VW

(SQL View)
 Index Back

Payment Request Attachemnt


SELECT A.REQUEST_ID , C.SCM_ATTACH_ID , C.ATT_VERSION , C.ATTACHSYSFILENAME , C.ATTACHUSERFILE , C.ATTACH_DESCR , AF.EOAWPRCS_ID , AF.EOAWTHREAD_ID , AF.EOAWPARENT_THREAD , A.BUSINESS_UNIT , A.VOUCHER_ID , A.FMS_OPRID , A.FMS_LASTUPDOPRID , A.FMS_DTTM_STAMP , A.FMS_LASTUPDDTTM , OP.OPRDEFNDESC FROM PS_PR_ATT A , PS_PV_ATTACHMENTS C , PS_PR_REQUEST_XREF AF , PSOPRDEFN OP WHERE A.SCM_ATTACH_ID = C.SCM_ATTACH_ID AND A.ATT_VERSION = C.ATT_VERSION AND A.REQUEST_ID = AF.REQUEST_ID AND OP.OPRID = A.FMS_OPRID AND A.SHOW_APPROVAL = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL 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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
8 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
9 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
12 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
13 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
14 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
15 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
16 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user