Echeck Return Report
Echeck Return report provides details of all eCheck return data for the designated target date. Worldpay produces this report either daily.
Filename Syntax
The syntax of the report filename is either:
ECheckReturnReport_${organizationId}_${targetDay}
where
-
organizationIdis the ID of the parent merchant organization -
targetDayis the date to which the data applies
Report Structure
The table below provides information about the fields included in the report. The report fields are in the order presented in the table.
A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as: 17 digits + decimal point + 2 digits + sign.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
|
Case ID |
Numeric (with preceding apostrophe) |
20 |
This field contains the unique Worldpay assigned ID for a chargeback or the return ID for an Direct Debit return. |
|
Worldpay Payment ID |
Numeric (with preceding apostrophe) |
20 |
The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction. |
|
Merchant Order Number |
Alphanumeric |
1024 |
The merchant-designated identifier for this transaction (i.e., value of |
|
Account Suffix |
Numeric |
4 |
The account number suffix that the customer used for this transaction. Regardless of account permissions, only the last four digits are visible for credit cards, and the last three digits for eChecks. |
|
Reason Code |
Alphanumeric |
10 |
Code indicating why this Direct Debit return was initiated. |
|
Reason Description |
Alphanumeric |
200 |
Description corresponding to Reason Code. |
|
Date Issued |
Date (MM/dd/yyyy) |
10 |
The day the issuing bank processed the chargeback or Direct Debit return. |
|
Date Received |
Date (MM/dd/yyyy) |
10 |
The day that Worldpay received the chargeback or Direct Debit return from the network. |
|
Chargeback Currency |
Alphanumeric |
5 |
The currency used for the chargeback. |
|
Chargeback Amt |
Signed Decimal (27,2) |
31 |
The disputed dollar amount of the chargeback or Direct Debit return. |
|
Transaction date |
Date (MM/dd/yyyy) |
10 |
The date of the original Authorization. |
|
Transaction Purchase Currency |
Alphanumeric |
50 |
The currency used for the Authorization amount. |
|
Transaction Purchase Amount |
Signed Decimal (17,2) |
21 |
The total dollar amount of the original authorization. This field is empty for Direct Debit. |
|
Transaction Settlement Currency |
Alphanumeric |
50 |
The currency used for the transaction settlement amount. |
|
Transaction Settlement Amount |
Signed Decimal (17,2) |
21 |
The total dollar amount of the purchase in the settlement currency. |
|
Activity Date |
Date (MM/dd/yyyy) |
10 |
The original date of the transaction |
|
Merchant Name |
Alphanumeric |
50 |
The name of the parent organization (or division) that submitted the transaction. |
|
Report Group |
Alphanumeric |
25 |
The merchant classification to which the transaction belongs. |
|
Reporting Group |
Alphanumeric |
50 |
The Reporting Group to which the transaction belongs. |
|
Txn Type |
Alphanumeric |
14 |
The type of transaction (ECheck Deposit) |
|
Batch ID |
Numeric (with preceding apostrophe) |
20 |
The unique number automatically assigned by the system for the batch associated with the transaction. |
|
Session ID |
Numeric (with preceding apostrophe) |
20 |
The unique number automatically assigned by the system for the session associated with the transaction. |
|
Merchant Transaction ID |
Alphanumeric |
50 |
The identifier specified by the merchant for this transaction. This value corresponds to the |
|
Billing Descriptor |
Alphanumeric |
25 |
The text shown on the customer bill. This is either the default (hard-coded billing descriptor), or the value designated in the transaction (soft billing descriptor). |
|
Merchant ID |
Numeric |
50 |
The value of the merchantId element/attribute submitted in the cnpAPI transaction. |
|
Presenter |
Alphanumeric |
15 |
The short name of the presenter. |