PMT_ACKPMTREFVW(SQL View) |
Index Back |
---|---|
Ack File by pmt |
SELECT DISTINCT %Substring(A.PYMNT_REF_ID, 1,15) , B.PMT_ACK_FILE_ID , B.ACK_FILE_STATUS , B.BANK_FILE_ID , B.BANK_SEND_DTTM , 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.BANK_SETID , B.BANK_CD , B.BANK_ID_QUAL , B.BNK_ID_NBR , B.DFI_ID_NUM , B.DFI_ID_QUAL FROM PS_PMT_ACK A , PS_PMT_ACK_HEADER B WHERE A.PMT_ACK_FILE_ID = B.PMT_ACK_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_ACK_FILE_ID | Character(12) | VARCHAR2(12) NOT NULL | Payment file id |
3 | ACK_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File status
C=Complete E=Error P=In Process |
4 | BANK_FILE_ID | Character(36) | VARCHAR2(36) NOT NULL | Bank file id |
5 | BANK_SEND_DTTM | DateTime(26) | TIMESTAMP | Send dttm |
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 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
20 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
21 | BANK_ID_QUAL | Character(3) | VARCHAR2(3) NOT NULL | "A bank/counterparty attribute that determines |
22 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
23 | DFI_ID_NUM | Character(12) | VARCHAR2(12) NOT NULL | A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun |
24 | DFI_ID_QUAL | Character(2) | VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number 02=Swift ID/BIC 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined |