BUSINESS_UNITTREAS_HEADER_IDSCM_ATTACH_IDATT_VERSIONTR_CONF_ATT_VW(SQL View) |
Index Back |
|---|---|
Deal Attachment ViewTreasury Deal Confirmation Attachment view for Fluid Approvals - Page Composer |
| SELECT TRX.BUSINESS_UNIT , TRX.TREAS_HEADER_ID , B.SCM_ATTACH_ID , B.ATT_VERSION , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE , B.ATTACH_DESCR , TRX.FMS_OPRID , O.OPRDEFNDESC , TRX.FMS_DTTM_STAMP , TRX.FMS_LASTUPDDTTM , AF.EOAWTHREAD_ID , AF.EOAWPRCS_ID , AF.EOAWPARENT_THREAD , BU.DESCR FROM PS_TRX_HDR_TR_ATT TRX , PS_PV_ATTACHMENTS B , PSOPRDEFN O , PS_TRX_AFCONF_XREF AF , PS_BUS_UNIT_TBL_FS BU WHERE TRX.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND TRX.ATT_VERSION = B.ATT_VERSION AND TRX.FMS_OPRID = O.OPRID AND TRX.BUSINESS_UNIT = AF.BUSINESS_UNIT AND TRX.TREAS_HEADER_ID = AF.TREAS_HEADER_ID AND TRX.BUSINESS_UNIT = BU.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 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 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 6 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 7 | 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. |
| 8 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 9 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 10 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 11 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 12 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 13 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 14 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |