PMT_IDPMT_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_FILEXRFSCVW(SQL View) |
Index Back |
|---|---|
Payment Message InfoPayment 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.TOTAL_PMT_COUNT , 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 ,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_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 | TOTAL_PMT_COUNT | Number(7,0) | INTEGER NOT NULL | Total Payment count |
| 9 | OUTPUT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Output type
E=EBICS F=File M=Integration Broker |
| 10 | PMT_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | Payment file path |
| 11 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 12 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
| 13 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 14 | PMT_CRYPTO_ID | Character(30) | VARCHAR2(30) NOT NULL | Payment encrypted ID |
| 15 | PUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. |
| 16 | MSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
| 17 | APMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Message Version |
| 18 | CHNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Channel Name (see PSCHNLDEFN). |
| 19 | PUBID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Publication Identifier |
| 20 | 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. |
| 21 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 22 | 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 |
| 23 | PMT_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source System Name |
| 24 | FROM_BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | From Bank ID Number |
| 25 | FROM_BNK_ACCT_NUM | Character(35) | VARCHAR2(35) NOT NULL | From Bank Account # |