PINless Debit Savings Report
The PINless Debit Savings report applies to merchants using the Worldpay eComm Prime PINless Debit service and provides detailed information about PINless Debit savings. The report shows the estimated savings on a per transaction basis for the given activity day by comparing the actual fees against the estimated fees were the transactions to use the signature network. Worldpay produces this report daily.
Filename Syntax
The syntax of the report filename is:
PINless_Debit_Savings_DetailReport_${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 |
|---|---|---|---|
|
Reporting Group |
Alphanumeric |
50 |
The Reporting Group to which the transaction belongs. |
|
Merchant |
Alphanumeric |
50 |
The name of the parent organization (or division) that submitted the transaction. |
|
Merchant ID |
Alphanumeric |
50 |
The value of the merchantId element/attribute submitted in the cnpAPI transaction. |
|
Activity Date |
Date (MM/dd/yyyy) |
10 |
The original date of the submitted transaction. |
|
Vantiv Payment ID |
Numeric (with preceding apostrophe) |
20 |
The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction. |
|
Transaction Amount |
Decimal (9,2) |
11 |
The dollar amount of this transaction. |
|
Payment Type |
Alphanumeric |
50 |
The method of payment. For example, Visa, MasterCard, Discover, etc. |
|
PINless Debit Network |
Alphanumeric |
10 |
The name of the debit Network used for the transaction. For example, STAR, ACCEL, PULSE, Jeanie, etc. |
|
Interchange Rate |
Alphanumeric |
50 |
The interchange code acronym and description for the PINless Debit Network. |
|
PINless Debit Interchange Fee |
Decimal (13,3) |
17 |
The Interchange fee charged by the PINless Debit Network for processing the transaction. |
|
PINless Debit Assessment Fee |
Decimal (13,3) |
17 |
The Assessment fee charged by the PINless Debit Network for processing the transaction. |
|
PINless Debit Network Fee |
Decimal (13,3) |
17 |
The Network fee charged by the PINless Debit Network for processing the transaction. |
|
PINless Debit Total Fee |
Decimal (13,3) |
17 |
The sum of the Interchange, Assessment, and Network fees. |
|
Estimated Signature Interchange Fee |
Decimal (13,3) |
17 |
The estimated Interchange fee charged by the signature network for processing the transaction. |
|
Estimated Signature Assessment Fee |
Decimal (13,3) |
17 |
The estimated Assessment fee charged by the signature network for processing the transaction. |
|
Estimated Signature Total Fee |
Decimal (13,3) |
17 |
The sum of the estimated (Signature) Interchange and Assessment fees. |
|
Savings |
Signed Decimal (13,3) |
18 |
The difference between the estimated (Signature) fees and the PINless Debit fees. This represents the estimated savings for the transaction realized by using the Prime - PINless Debit service. |
|
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. |