PMT_ACKNOWLEDGE

(SQL Table)
Index Back

Payment Acknowledgement Record

Payment Acknowledgement Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
2 PMT_MSG_ID Character(15) VARCHAR2(15) NOT NULL Identification for the instance of a PAYMENT_REQUEST message (SEPA/Financial Gateway)
3 PMT_SEQ_NUM Number(7,0) INTEGER NOT NULL Sequence number which must be unique for the PMT_MSG_ID (SEPA/Financial Gateway)
4 PMT_STATUS Character(1) VARCHAR2(1) NOT NULL Status field for a generated payment transaction
F=Finalized
M=Manually Paid
N=No Active Allocations
P=Prepared
T=Payment Transferred
V=Hold
W=Void
5 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.
6 FED_WIRE_ID Character(22) VARCHAR2(22) NOT NULL This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer.
7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
9 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)