PMT_FILE_IDC=Complete
CE=Complete with Errors
E=Error
P=In Process
R=Received by Bank
S=Sent to Bank
X=Canceled
E=EBICS
F=File
M=Integration Broker
PMT_FILE_DEFNVW(SQL View) |
Index Back |
|---|---|
Payment File ViewPayment Message View |
| SELECT PMT_FILE_ID ,PMTRUNINSTANCE ,FILE_STATUS ,BANK_SETID ,BANK_CD ,FORMAT_ID ,OUTPUT_TYPE ,PMT_FILE_PATH ,FILENAME ,CREATE_DTTM ,CREATED_BY_USER ,PMT_CRYPTO_ID ,PUBNODE ,MSGNAME ,APMSGVER ,CHNLNAME ,PUBID ,EVENT_TRACKING_ID , PMT_FILE_ID FROM PS_PMT_FILE_DEFN |
| # | 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 | HEADER_ID | Character(8) | VARCHAR2(8) NOT NULL | Header_id |