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