JRNL_UP_ATCH_VW

(SQL View)
 Index Back

Fluid Jrn Approval Attachment

Attachment view for Fluid Journal Unpost Approval

SELECT AF.BUSINESS_UNIT , AF.JOURNAL_ID , AF.JOURNAL_DATE , AF.BUSINESS_UNIT_LN , F.SCM_ATTACH_ID , F.ATT_VERSION , AF.EOAWPRCS_ID , AF.EOAWTHREAD_ID , AF.EOAWPARENT_THREAD , F.ATTACHSYSFILENAME , F.ATTACHUSERFILE , F.ATTACH_DESCR , J.FMS_OPRID , OP.OPRDEFNDESC , J.FMS_DTTM_STAMP , J.FMS_LASTUPDDTTM FROM PS_JRNL_UNPOST_ATT J , PS_PV_ATTACHMENTS F , PS_JRNL_UP_AF_XREF AF , PSOPRDEFN OP WHERE F.SCM_ATTACH_ID = J.SCM_ATTACH_ID AND F.ATT_VERSION = J.ATT_VERSION AND AF.BUSINESS_UNIT = J.BUSINESS_UNIT AND AF.BUSINESS_UNIT_LN = J.BUSINESS_UNIT_LN AND AF.JOURNAL_ID = J.JOURNAL_ID AND AF.JOURNAL_DATE = J.JOURNAL_DATE AND J.UNPOST_SEQ = 0 AND OP.OPRID = J.FMS_OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_GL_NONVW

2 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit

Prompt Table: SP_BU_GL_NONVW

5 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.
6 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.
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 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
11 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
12 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.
13 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
14 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
15 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
16 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.