KK_AF_ATCH_VW (SQL View)	Index Back
Fluid CBJ Approval Attachment Attachment view for Fluid Control Budget Journal Approval

KK_AF_ATCH_VW

(SQL View)

Fluid CBJ Approval Attachment

Attachment view for Fluid Control Budget Journal Approval

SELECT J.BUSINESS_UNIT , J.JOURNAL_ID , J.JOURNAL_DATE , F.SCM_ATTACH_ID , F.ATT_VERSION , F.ATTACHSYSFILENAME , F.ATTACHUSERFILE , F.ATTACH_DESCR , J.FMS_OPRID , OP.OPRDEFNDESC , J.FMS_DTTM_STAMP , J.FMS_LASTUPDDTTM FROM PS_KK_HEADER_ATT J , PS_PV_ATTACHMENTS F , PSOPRDEFN OP WHERE F.SCM_ATTACH_ID = J.SCM_ATTACH_ID AND F.ATT_VERSION = J.ATT_VERSION AND OP.OPRID = J.FMS_OPRID AND J.UNPOST_SEQ = 0 AND J.SHOW_APPROVAL = 'Y'

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

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

6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

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

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

9 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

10 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

11 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

12 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

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