About this guide

3.6

Added "PayFac" to the title of the PayFac version of the PayFac Visa Fixed Acquirer Network Fee Report.

Added the Worldpay Transaction Id column to Net Settled Sales by Transaction Report, Chargeback Financial Report, and the Activity and Settlement Reports.

3.5

Added the Dynamic Payout Wallet Projected Account Balance Report

Note: This report will replace the Dynamic Payout Current Account Balance Report

3.4

Removed old (DP) Account Balance Report

3.3

Added the Dynamic Payout Held Funding Instruction report.

3.2

Adding missing fields (Affiliate, Campaign, Merchant Grouping ID, Sales Tax, and FTP Filename) to Session Reports Fields table.

3.1

Changed RAPID DISPUTE RESOLUTION to RAPID_DISPUTE_RESOUTION for a field in the Chargeback Financial Report.

Changed the Amount field data type for the Decline Transaction report to Decimal.

3.0

• This guide was converted to an online-only format.

• Added the Billing Profile Id field to the Net Settled Sales Transaction by Transaction report.

2.19

• Removed deprecated DP Balance Summary report.

• New column added to the Fee report.

2.18

Added info about two new Dynamic Payout reports for Canada.

2.17

The max length of the Merchant Order Number field changed from 25 characters to 256 characters in all reports where used.

2.16

Added two new reports for PRIME users

2.15

Added Note to the Sub-merchant Funds Transfer NoC and Funding Reject Report by ACH Return Date reports.

Corrected field names in the Chargeback Financial report.

2.14

Added note to NSS by Transaction report.

2.13

Corrected name of new report added in Version 2.12.

2.12

Added new Dynamic Payout FBO Settlement Balance Summary report.

2.11

Changed contact information for the Chargeback group.

Added two new columns to the Chargeback Financial Report for PINless Debit Adjustments.

2.10

Changed several Session Type values from Litle Initiated to Worldpay Initiated. Also add the value Virtual Terminal Initiated to the list of possible values. This replaces Litle UI Initiated, which had not been listed, but was a possible value.

2.9

Added Merchant Category Column to several reports.

2.8

Corrected field name in the Balance Summary report.

Bank Settlement Day replaces Bank Settlement Data

2.7

Corrected time of report generation from 1:00PM - 9:00PM hourly to 10:00AM - 9:00PM hourly.

2.6

Added Tax Id column to the TIN Mismatch Report.

Corrected the filename syntax for the PayFac Visa Fixed Acquirer Network Fee Report to reflect the filename actually generated

2.5

Removed Implementation section from Contact Info.

Added information about the new Dynamic Payout Current Account Balance report.

2.4

Added PayFac note to three fields in Fee Report.

2.3

Added missing info to POA report field definitions.

Changed eCheck to Direct Debit in descriptions, where

applicable.

2.2

Corrected field names in Declined Transaction report to match header information from report.

2.1

Added Account Range ID column to Customer Insights.

Added the AuthMax Transaction Report

Added the eCheck PoA Request Notification report.

2.0

Rebrand document to Worldpay.

1.47

Corrected PayFac Report names.

Added FIFA to list of Transaction Types and corrected definition of Funds Transfer Id.

1.46

Changed Data Type of BIN field from numeric to alphanumeric and added a NOTE to the description.

1.45

Added PayFac Sub-Merchant Fee Rollup Report.

Added Note to the Issuer Insights report - Range Start and Range End fields no longer populated.

1.44

Modified the Description of the Last Update field.

Add new VCR related Chargeback Cycle information to the Chargeback Status and Chargeback Financial reports.

1.43

Expanded definition of Account Suffix field to account for change in behavior for account numbers less than 4 digits in the NSS by Txn, Session, and CBK Financial report

Added new Chapter 13 for PINless Debit Saving report.

All chapter numbers (formerly) 13 and above increment by 1.

1.42

Added eCheck Pre-Note NOC and Return Report as Chapter 18.

Added Visa FANF Fee report as Chapter 19.

All chapter numbers (formerly) 18 and above increment by 2.

1.41

Added new column to NSS by Transaction and Session reports. Also added list of possible values for TXN Type column (NSS by TXN and Session) and Session Types (Session).

1.40

Added info about PIN Adjustment to the Chargeback Financial Report

Removed last of Litle from column names and enum values.

1.39

Added two new PayFac reports: Visa FANF report and MC Location Fee report for Payment Facilitators.

1.38

Added new column to Issuer Insights report.

Corrected Chapter references in Document Structure

section.

1.37

Updated report generation frequency info.

Added new Chapter for new Issuer Insights report.

Changed references to LitleXML to cnpAPI, including in guide names.

1.36

Added Same Day Delivered column to Funding Instruction Confirmation Report.

1.35

Added two new chapters for Declined Plan Requests Report and Declined Subscription Requests Report (added as Chapters 13 and 14 and renumbered other chapters formerly 13 and above).

1.34

Made corrections to the Chargeback Winn/Loss report, so fields/order match the generated report.

1.33

Changed the description of the Balance Field.

Corrected file names of various PayFac reports.

1.32

Removed chapters related to several deprecated reports: Activity Discrepancy Report, Funding Instruction ACH Summary Report, and Funding Instruction Discrepancy Report.

Changed report names to match managed Scheduled Reports page in iQ.

1.31

Changed info about when the Dynamic Payout Account Balance report is available.

1.30

Changed Max Size of Funds Transfer Request Id field from 25 characters to 36 characters to support UUID length.

In NSS by Txn report, changed the Max Size of the Fraud Checksum Response Code field from 2 to 10. Also, provided a list of possible values.

1.29

Added new chapters for the Chargeback Win/Loss report and the Declined Transaction Report.

1.28

Added new column, Trace Number, to the PayFac Funding Instruction Confirmation report.

1.27

Corrected minor typos and missed name changes.

1.26

Fixed references to Dynamic and Managed Payout.

Added missing Mobile POS Response Codes

Added info about 14 new columns in the NSS by Transaction report.

1.25

Fixed Table Names in several chapters

Removed incorrect column from PayFac Balance Summary Report.

1.24

Rebranded several column names from Litle to Vantiv

Added five new PayFac Instruction-Based Funding reports.

1.23

Added possible values to Payment Type column.

Field length correction for Original Tran Code column. Also, updated the field length and definition for Updated Tran Code column.

1.22

Added new fields for Secondary Amounts to the following reports: Chargeback Financial, Chargeback Status, NSS by Transaction, and Session.

1.21

Added note to section on report retrieval about files with .prg extensions.

1.20

Added missing column to report to Failed Funds Transfer report. Also added new transaction values to Txn Type column.

1.19

Added new Activity (type), Rejected Payments, to the Chargeback Financial report.

1.18

Added two columns to TIN Validation report. Also changes the filename of the generated report.

Noted that Tin Validation report is available to Payment Facilitators using either Dynamic Payout method.

1.17

Rebranded Guide

Added info to Sections 1.2 and 1.3

1.16

Added info about the Customer Reference column added to the NSS by transaction and Session reports.

Corrected typos in several Table Names

Added eCheck Notice of Change Update report.

Added EMDR report.

Corrected Date format in several Fraud Alert Report fields and one field in AutoAU Repaired Auth Report.

Added cnpAPI Reporting Group field to NSS by Transaction and Customer Insights reports.

1.15

1.14

Added info about missing column in Settlement/Activity Report.

Changed Chapter/Report names for all PayFac reports.

Minor Corrections to Field Names in several reports. For example, “Sales tax” corrected to “Sales Tax”, or “Batch Completion” corrected to “Batch Completion Timestamp GMT”

Removed accountType from the filename syntax for the PayFac Account Balance report.

1.13

Added chapters for new PayFac Instruction-Based Sub-merchant funding reports.

1.12

Added new chapter for new PayFac Tax Id Validation report.

1.11

Added a new chapter for another Sub-merchant Funding report.

Also, corrected an error in the introduction to the other

Sub-merchant Funding Reports. The reports can only be run daily, not monthly.

1.10

Added three new chapters for new Sub-merchant Funding reports.

1.9

Added Presenter field and Merchant ID field to Activity and Settlement Report.

Added Virtual Account Number field to the Customer Insights report.

1.8

Corrected filename information for Fraud Alert report.

Added Merchant Id field to Fee Report

Added Presenter field to the Chargeback Financial and Chargeback Status reports.

1.7

Added ‘Refund Id’ column to Fraud Alert Report

Added ‘Merchant Name’ and ‘Presenter Name columns to Fee Report

1.6

Added section about the Manage Scheduled Reports interface.

Added Vantiv logo to title page.

1.5

Added chapter for the AU Repaired Auth Report.

1.4

Added Issuing Bank field to the Chargeback Financial and Chargeback Status reports.

1.3

Added Issuing Bank Country Code field to the Chargeback Financial and Chargeback Status reports.

Added Merchant Id field to NSS by Transaction, Chargeback Financial and Chargeback Status reports.

Changed definition of existing Merchant Id field in session report.

1.2

Added Chargeback Status report chapter

Added Billing Descriptor column to NSS by Txn and Chargeback Financial reports

1.1

Added Customer Insight Report chapter

Added Fee report chapter