Visa ECO Issuer Never Approve Fee Report
The Visa ECO Issuer Never Approve Fee Report is a PayFac report containing the details of Visa Visa ECO Issuer Never Approve and Visa Issuer Never Approve Cross Border fees. Worldpay produces the report on the 15th of each month. Each report contains data for the prior month. For example, a report produced on August 15th would contain data for July 1st through July 31st.
Filename Syntax
The syntax of the report filename is:
VisaEcoIssuerNeverApproveFeeReport_${organizationId}_${targetDay}
where
-
organizationIdis the Worldpay assigned identifier of the Payment Facilitator -
targetDay
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 |
|---|---|---|---|
|
MERCHANT_ID |
Numeric (with preceding apostrophe) |
19 |
The merchant Id in the Worldpay eComm system. |
|
MERCHANT_NAME |
Alphanumeric |
25 |
The merchant name in the Worldpay eComm system. |
|
ORGANIZATION_ID |
Numeric (with preceding apostrophe) |
19 |
The Organization ID in the Worldpay eComm system. |
|
ORGANIZATION_NAME |
Alphanumeric |
50 |
The Payment Facilitator/Organization name in the Worldpay eComm system. |
| CARD_ACCEPTOR_ID | Alphanumeric | 15 | The card acceptor identifier. |
| BILLING_MONTH | Numeric |
19
|
The month and year of the report. |
| BILLABLE_INDICATOR | Alphanumeric | 1 | Indicates whether the fee is billable. Value is always Y. |
| RETRIEVAL_REFERENCE_NUMBER | Alphanumeric | 20 | The retrieval reference number. |
| PAYMENT_ID | Numeric (with preceding apostrophe) | 19 | The transaction identifier assigned by Worldpay in the US eComm system (cnpTxnId) |
|
TRANSACTION_DATE |
Date (YYYY-MM-DD) |
10 |
The date the transaction occurred. |
|
BORDER_INDICATOR |
Alphanumeric |
1 |
Indicates whether the transaction was Domestic, D, or Cross Border, X. |
|
REPORT_IDENTIFIER |
Alphanumeric |
10 |
Fixed value of FEE403D. |
|
RESPONSE_REASON_CODE |
Alphanumeric |
5 |
The response code returned by Visa. |
|
TRANSACTION_TYPE_CODE |
Alphanumeric |
5 |
Specifies the type of transaction. One of the following values (in bold): 0 - Not Specified 1 - Telephone 2 - Recurring Transaction 3 - Installment Payment 4 - Unknown - Other 5 - SET- Ecommerce 6 - Non Authenticated SET- Ecommerce 7 - Non SET Channel Encrypted - Ecommerce 8 - Non Secure Ecommerce 9 - Non Auth Secure Ecommerce 10 - PPD (Prearranged payment and deposit entry (for eCheck)) 11 - CCD Corporate 12 - CTX (Corporate Trade eXchange) 16 - Mail-Order 17 - Retail 18 - Walk-in 19 - Employee 20 - Recurring Telephone Transaction 30 - Apple Pay 31 - Android Pay 52 - Default Recurring Transaction |
|
CURRENCY_CODE |
Alphanumeric |
5 |
The three digit code (defined by ISO 4217) representing a country's currency. For example, USD = 840, GBP = 826, EURO = 978, etc. |
|
TRANSACTION_AMOUNT |
Decimal (17,2) |
18 |
The amount of the transaction. |
|
ACTION_TYPE |
Alphanumeric |
5 |
One of the following values: A = Auth R = Refund P = Partial Reversal |
|
RESPONSE_DATE |
Timestamp (MM/dd/yyyy HH:mm:ss) |
26 |
The date the response reason code was set. |