PMT_ACKFLREFSEC

(SQL View)
 Index Back

Ack File by pmt


SELECT DISTINCT A.HEADER_ID , 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.PMT_CRYPTO_ID , B.PUBNODE , B.MSGNAME , B.APMSGVER , B.CHNLNAME , B.PUBID , B.EVENT_TRACKING_ID , D.BUSINESS_UNIT , D.BANK_SETID , D.BANK_CD , D.BANK_ACCT_KEY , D.FROM_BNK_ID_NBR , D.FROM_BNK_ACCT_NUM , D.PMT_SOURCE , D.CREATED_BY_USER , B.BANK_ID_QUAL , B.BNK_ID_NBR , B.DFI_ID_NUM , B.DFI_ID_QUAL FROM PS_PMT_FILE_ACK A , PS_PMT_ACK_HEADER B , PS_PMT_FILE_XREF C , PS_PMT_DETAIL_TBL D WHERE A.PMT_ACK_FILE_ID = B.PMT_ACK_FILE_ID AND A.HEADER_ID = C.PMT_FILE_ID AND C.PMT_ID= D.PMT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File 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 PMT_CRYPTO_ID Character(30) VARCHAR2(30) NOT NULL Payment encrypted ID
12 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
13 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
14 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
15 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
16 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
17 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.
18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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_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
22 FROM_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL From Bank ID Number
23 FROM_BNK_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL From Bank Account #
24 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name
25 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
26 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
27 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
28 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
29 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