Declined Transaction Report
The Declined Transaction report contains details about deferred, declined and (Online) duplicate transactions. Worldpay produces this report daily.
The Declined Transaction report is also available in Worldpay eComm iQ. Unlike the SSR version, which runs daily, the iQ report supplies near real-time information.
Filename Syntax
The syntax of the report filename is:
Declined_Transactional_Report_${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 |
|---|---|---|---|
| Vantiv Payment ID | Numeric (with preceding apostrophe) | 19 | The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction. |
| Batch ID | Numeric (with preceding apostrophe) | 19 | The unique number automatically assigned by Worldpay for the batch associated with the transaction. |
| Session ID | Numeric (with preceding apostrophe) | 19 | The unique number automatically assigned by the system for the session associated with the transaction. |
| Txn Type | Alphanumeric | 50 | The type of transaction. |
| Merchant ID | Numeric (with preceding apostrophe) | 19 | The value of the merchantId element/attribute submitted in the transaction. |
|
Response Reason Code |
Alphanumeric |
5 |
The 3-digit response reason Code associated with the transaction. |
| Response Reason Message | Alphanumeric | 80 | The transaction response returned by Worldpay for this transaction. If the transaction was declined, this message provides a reason. |
| Organization ID | Numeric (with preceding apostrophe) | 19 | The Worldpay assigned identifier of the parent organization (or division) that submitted the transaction. |
| Category ID | Numeric (with preceding apostrophe) | 19 | The Worldpay assigned identifier of the Reporting Group associated with the transaction. |
|
Reject Type |
Alphanumeric |
20 |
The reason the transaction was rejected (Deferred or Processing). |
|
Dupe Txn ID |
Numeric (with preceding apostrophe) |
19 |
The transaction ID associated with the previously submitted/duplicate transaction. |
|
Amount |
Decimal |
19 |
The amount of the transaction. |
|
Purchase Currency |
Alphanumeric |
3 |
The currency used for the purchase, designated by a three-character abbreviation of the country. |
|
POST_DAY |
Date (MM/dd/yyyy) |
10 |
The post date of the transaction. |
|
Reported Timestamp |
Timestamp(MM/dd/yyyy HH:mm:ss) |
26 |
The date and time the transaction was processed by Worldpay. |
|
Payment Type |
Alphanumeric |
5 |
The method of payment for this transaction. For example, MC = MasterCard, VI = Visa, etc. |
|
Reporting Group |
Alphanumeric |
25 |
The Reporting Group to which the transaction belongs. |
|
Merchant Order Number |
Alphanumeric |
100 |
The merchant-designated identifier for this transaction (i.e., value of the orderId element). |
|
Merchant Txn ID |
Alphanumeric |
50 |
The identifier specified by the merchant for this transaction. This value corresponds to the id attribute (id="value") of the transaction. |
|
Parent Id |
Numeric (with preceding apostrophe) |
20 |
The payment Id for the parent transaction. For example, if the transaction was a Capture, this is the payment Id for the associated Authorization transaction. |
|
Merchant Category Code |
Alphanumeric |
4 |
The Merchant Category Code associated with the merchant submitting the transaction, or associated with the transaction, if you use dynamic MCCs. |