PMT_DSP_FILE_VW

(SQL View)
Index Back

Payment Message Info

Payment Message Info

SELECT PMTRUNINSTANCE , PMT_FILE_ID , FILE_STATUS , BANK_SETID , BANK_CD , FORMAT_ID , TOTAL_PMT_COUNT FROM PS_PMT_FILE_DEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMTRUNINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process ID
2 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File 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 TOTAL_PMT_COUNT Number(7,0) INTEGER NOT NULL Total Payment count