EX_TA_ATCH_L_VW (SQL View)	Index Back
Travel Auth line Attachment Travel Auth Line Attachment for Fluid Approvals

EX_TA_ATCH_L_VW

(SQL View)

Travel Auth line Attachment

Travel Auth Line Attachment for Fluid Approvals

SELECT A.TRAVEL_AUTH_ID , A.LINE_NBR , A.SCM_ATTACH_ID , A.ATT_VERSION , P.ATTACHUSERFILE , P.ATTACHSYSFILENAME , L.TRANS_DT , B.DESCR , L.TXN_AMOUNT , L.TXN_CURRENCY_CD , P.ATTACH_DESCR , OP.OPRDEFNDESC , A.FMS_LASTUPDDTTM FROM PS_EX_TAUTH_HLN_VW L , PS_EX_TA_ATTACH A FULL OUTER JOIN PS_PV_ATTACHMENTS P ON A.SCM_ATTACH_ID = P.SCM_ATTACH_ID AND A.ATT_VERSION = P.ATT_VERSION , PS_EX_TYPES_TBL B , PSOPRDEFN OP WHERE L.SETID = B.SETID AND B.EXPENSE_TYPE = L.EXPENSE_TYPE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EX_TYPES_TBL X WHERE X.SETID = L.SETID AND X.EXPENSE_TYPE = L.EXPENSE_TYPE AND X.EFF_STATUS = 'A' AND X.EFFDT <= %CurrentDateIn) AND L.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID AND L.LINE_NBR = A.LINE_NBR AND OP.OPRID = A.FMS_LASTUPDOPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.

2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

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 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

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

7 TRANS_DT Date(10) DATE Transaction Date

8 EXPENSE_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Expense Type

9 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

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

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

13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
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	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
6	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
7	TRANS_DT	Date(10)	DATE	Transaction Date
8	EXPENSE_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Expense Type
9	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
10	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
11	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.
12	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by
13	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.