The EFT Return (EFTRET) table is a system-maintained table that stores the information of the returned EFT payments and EFT reversals by the bank. This table also stores the cancellation requests of returned EFT payments. The Process ACH Return batch job in the Returned ACH Transactions Chain creates the records into this table. The Initiate Disbursement Cancellation job in the Returned ACH Transactions Chain reads this table and initiates the disbursement cancellation for the Returned EFT payments. This table supports EFT transactions with the Disbursement Type of EFT and the Disbursement Format of CTX, CCD, PPD, or IAT. Records on this table can only be inserted by the Returned ACH Transaction batch process.
The EFTRET table has the following edits.
The Return Status of Reversal Failed by the Bank indicates that the request to reverse the EFT payment was rejected by the bank. This status is only applicable to returned reversals of EFT payments.
The Return Status of Bank Notified a Change indicates that the bank has processed the EFT payment and sent a notification of change (NOC) with the correct banking information. The EFT payment does not need to be cancelled because it was processed successfully by the bank. It is recommended to apply appropriate corrections prior to issuing the next EFT payment to respective vendor. This status is only applicable to returned regular EFT payments.
The Return Status of EFT Cancel Request Failed indicates that the EFT payment was rejected by the bank and the Returned ACH Transaction batch process could not initiate the cancellation of the EFT payment (possible reasons: EFT payment’s Status <> Disbursed or Warranted on the Check Reconciliation table, EFT payment is not on the Check Reconciliation table but on the Paid Check table, or EFT payment is neither on the Check Reconciliation table nor the Paid Check table). This status is only applicable to returned regular EFT payments.
The Return Status of EFT Cancel Initiated indicates that either the EFT payment was rejected by the bank or the credit transaction (Rejected EFT) was received first and the debit transaction (Returned EFT reversal) was received second for the same EFT Number, either via the same or a different ACH return file, and the Returned ACH Transaction batch process successfully initiated the cancellation of the EFT payment. This status is only applicable to returned regular EFT payments.
When appropriate, an authorized user could manually change the Return Status of applicable transactions from EFT Cancel Request Failed to EFT Cancel Initiated if the Addenda Type Code is set to 99 (EFT payment rejected by the bank). You can also enter an explanation on the Comment field. You will not be allowed to manually change the Return Status under other conditions.