PMT_FILE_XRF_VW (SQL View)	Index Back
Payment Message Info Payment Message Info

PMT_FILE_XRF_VW

(SQL View)

Payment Message Info

SELECT A.PMT_ID , A.PMT_FILE_ID , B.PMTRUNINSTANCE , B.FILE_STATUS , B.BANK_SETID , B.BANK_CD , B.FORMAT_ID , B.OUTPUT_TYPE , B.PMT_FILE_PATH , B.FILENAME , B.CREATE_DTTM , B.CREATED_BY_USER , B.PMT_CRYPTO_ID , B.PUBNODE , B.MSGNAME , B.APMSGVER , B.CHNLNAME , B.PUBID , B.EVENT_TRACKING_ID , B.TOTAL_PMT_COUNT FROM PS_PMT_FILE_XREF A , PS_PMT_FILE_DEFN B WHERE A.PMT_FILE_ID = B.PMT_FILE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id

2 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File ID

3 PMTRUNINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process ID

4 FILE_STATUS Character(2) VARCHAR2(2) NOT NULL File Status
C=Complete
CE=Complete with Errors
E=Error
P=In Process
R=Received by Bank
S=Sent to Bank
X=Canceled

5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

7 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

8 OUTPUT_TYPE Character(1) VARCHAR2(1) NOT NULL Output type
E=EBICS
F=File
M=Integration Broker

9 PMT_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Payment file path

10 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name

11 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

12 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By

13 PMT_CRYPTO_ID Character(30) VARCHAR2(30) NOT NULL Payment encrypted ID

14 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

15 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

16 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version

17 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

18 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

19 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

20 TOTAL_PMT_COUNT Number(7,0) INTEGER NOT NULL Total Payment count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id
2	PMT_FILE_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment File ID
3	PMTRUNINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process ID
4	FILE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	File Status C=Complete CE=Complete with Errors E=Error P=In Process R=Received by Bank S=Sent to Bank X=Canceled
5	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
6	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
7	FORMAT_ID	Character(10)	VARCHAR2(10) NOT NULL	Format ID
8	OUTPUT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Output type E=EBICS F=File M=Integration Broker
9	PMT_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Payment file path
10	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
11	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
12	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
13	PMT_CRYPTO_ID	Character(30)	VARCHAR2(30) NOT NULL	Payment encrypted ID
14	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
15	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
16	APMSGVER	Character(30)	VARCHAR2(30) NOT NULL	Message Version
17	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).
18	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier
19	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
20	TOTAL_PMT_COUNT	Number(7,0)	INTEGER NOT NULL	Total Payment count