PMT_ACK_FILE_IDHEADER_IDA=Payments Accepted
E=File in Error
R=File Received by Bank
W=File Accepted With Error
PMT_FILE_ACK(SQL Table) |
Index Back |
|---|---|
Payment EIP Message HeaderPayment 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 | HEADER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Header_id |
| 3 | FILE_ACK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Ack status
A=Payments Accepted E=File in Error R=File Received by Bank W=File Accepted With Error |
| 4 | NUM_PMTS_ACCEPTED | Number(6,0) | INTEGER NOT NULL | Number of payments accepted in the bank acknowledgement file |
| 5 | NUM_PMTS_IN_ERROR | Number(6,0) | INTEGER NOT NULL | Number of payments in error in the bank acknowledgement file |
| 6 | ORIG_MSG_NAME | Character(14) | VARCHAR2(14) NOT NULL | Original Message Name |
| 7 | ORIG_NUM_TRAN | Number(6,0) | INTEGER NOT NULL | Number of payments accepted in the bank acknowledgement file |
| 8 | ORIG_CTRL_SUM | Number(9,0) | DECIMAL(9) NOT NULL | Original Control Sum |