Declined Subscription Requests Report
The Declined Subscription Requests report contains details about declined requests for Recurring Subscription creations, updates, and cancellations. Worldpay produces this report daily.
Filename Syntax
The syntax of the report filename is:
Declined_Subscription_Request_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.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
|
Vantiv Request ID |
Numeric (with preceding apostrophe) |
19 |
The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction. |
|
Subscription Id |
Numeric (with preceding apostrophe) |
19 |
The unique identifier associated with the subscription. |
|
Vantiv Payment Id |
Numeric (with preceding apostrophe) |
19 |
The unique identifier automatically assigned by Worldpay to the original transaction associated with the subscription. |
|
Batch Id |
Numeric (with preceding apostrophe) |
19 |
The unique number automatically assigned by Worldpay for the batch associated with the transaction. |
|
Merchant Id |
Numeric (with preceding apostrophe) |
19 |
The value of the merchantId element/attribute submitted in the transaction. |
|
Txn Type |
Alphanumeric |
50 |
The type of transaction, either Create Subscription, Update Subscription, or Cancel Subscription. |
|
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. |
|
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. |
|
Plan Code |
Alphanumeric |
25 |
A merchant assigned, unique code for the Plan. You use this value to assign a plan to a Subscription. |
|
Start Date |
Date (YYYY-MM-DD) |
10 |
Defines the starting date of the recurring billing subscription. |
|
Amount |
Numeric (with preceding apostrophe) |
19 |
The amount of the transaction. |
|
Number of Payments |
Numeric |
2 |
The number of payments, between 1 and 99. If omitted, the plan is open-ended. |
|
Payment Type |
Alphanumeric |
2 |
The method of payment for this transaction. The possible values are:
|