PMT_FILEPMTSCVW

(SQL View)
 Index Back

Payment Message Info

Payment Message Info

SELECT 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 ,A.PMT_ID ,C.BUSINESS_UNIT ,C.BANK_ACCT_KEY ,C.PMT_SOURCE ,C.FROM_BNK_ID_NBR ,C.FROM_BNK_ACCT_NUM FROM PS_PMT_FILE_XREF A , PS_PMT_FILE_DEFN B , PS_PMT_DETAIL_TBL C WHERE A.PMT_FILE_ID = B.PMT_FILE_ID AND A.PMT_ID=C.PMT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File ID
2 PMTRUNINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process ID
3 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
4 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
6 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
7 OUTPUT_TYPE Character(1) VARCHAR2(1) NOT NULL Output type
E=EBICS
F=File
M=Integration Broker
8 PMT_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Payment file path
9 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
10 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
11 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
12 PMT_CRYPTO_ID Character(30) VARCHAR2(30) NOT NULL Payment encrypted ID
13 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
14 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
15 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
16 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
17 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
18 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.
19 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
20 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
21 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
22 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
23 FROM_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL From Bank ID Number
24 FROM_BNK_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL From Bank Account #