PMT_ACK (SQL Table)	Index Back
Payment EIP Message Header Payment EIP Message Header

PMT_ACK

(SQL Table)

Payment EIP Message Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_ACK_FILE_ID Character(12) VARCHAR2(12) NOT NULL Payment file id

2 PYMNT_REF_ID Character(20) VARCHAR2(20) NOT NULL Payment ID

3 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

4 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_ACK_FILE_ID	Character(12)	VARCHAR2(12) NOT NULL	Payment file id
2	PYMNT_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Payment ID
3	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
4	BANK_REF_ID	Character(16)	VARCHAR2(16) NOT NULL	A reference identifier associated with a given bank/counterparty transaction.
5	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.