Chargeback Financial Report

Chargeback Financial (Activity) report provides details of chargeback activities for either a designated activity (post day) or fund transfer (settlement) date. The report also includes Direct Debit return information, as well as PIN Debit Adjustment information. Worldpay produces this report daily.

Filename Syntax

The syntax of the report filename is either:

Financial_Detail_ChargebackFinancialByActivityDate${rptCategoryId}_${organizationId}_${targetDay}

Financial_Detail_ChargebackFinancialBySettlementDate${rptCategoryId}_${organizationId}_${targetDay}

where

rptCategoryId is the ID of the Reporting Group to which the report applies. If the report is not filtered by Reporting Group, this value is replaced by a 0.
organizationId is the ID of the parent merchant organization
targetDay is 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
Case ID	Numeric (with preceding apostrophe)	20	This field contains the unique Worldpay assigned ID for a chargeback, the return ID for an Direct Debit return, or the Adjustment Id for a PIN Debit Adjustment.
Vantiv Payment ID	Numeric (with preceding apostrophe)	20	The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.
Merchant Order Number	Alphanumeric	256	The merchant-designated identifier for this transaction (i.e., value of the orderId element).
Account Suffix	Alphanumeric	4	The account number suffix that the customer used for this transaction. Regardless of account permissions, only the last four digits are visible for credit/debit cards, and the last three digits for eChecks, unless the Direct Debit account number is <4 digits. In this case this field contains XXXX.
Bin	Alphanumeric	6	The bank identification number, which is the first six digits of the credit card number used for the transaction. This uniquely identifies the institution that issued the credit card to the card holder. All Discover Cards return a value of discov for the BIN. Also, the BIN field is blank for PayPal and Direct Debit transaction.
Payment Type	Alphanumeric	50	The method of payment (Visa, MasterCard, Direct Debit, etc.) for this transaction. Returns PINless Debit Adjustment for a PINless Debit Adjustment.
Reason Code	Alphanumeric	25	Code indicating why this chargeback, Direct Debit return, or PIN Debit Adjustment was initiated.
Reason Description	Alphanumeric	100	Description corresponding to Reason Code.
Date Issued	Date (MM/dd/yyyy)	10	The day the issuing bank processed the chargeback, Direct Debit return, or PINless Debit Adjustment.
Date Received	Date (MM/dd/yyyy)	10	The day that Worldpay received the chargeback, Direct Debit return, or PINless Debit Adjustment from the network/bank.
Reply By Date	Date (MM/dd/yyyy)	10	The day by which merchants must respond to the case. Note: Since this field does not apply to Direct Debit returns or PINless Debit Adjustments, it is empty for these cases.
Chargeback Currency	Alphanumeric	50	The currency used for the chargeback.
Chargeback Amt	Signed Decimal (17,2)	21	The disputed dollar amount of the chargeback, Direct Debit return, or PINless Debit Adjustment.
Auth Date	Date (MM/dd/yyyy)	10	The date of the original Authorization. This field does not apply to Direct Debit or PINless Debit Adjustment.
Auth Currency	Alphanumeric	50	The currency used for the Authorization amount.
Auth Amt	Signed Decimal (17,2)	21	The total dollar amount of the original authorization. This field is empty for Direct Debit and PINless Debit Adjustment.
Transaction Date	Date (MM/dd/yyyy)	10	The date of the original transaction.
Transaction Purchase Currency	Alphanumeric	50	The currency used for the transaction purchase amount.
Transaction Purchase Amt	Signed Decimal (17,2)	21	The total dollar amount of the original purchase.
Transaction Settlement Currency	Alphanumeric	50	The currency used for the transaction settlement amount.
Transaction Settlement Amt	Signed Decimal (17,2)	21	The total dollar amount of the purchase in the settlement currency.
Activity Date	Date (MM/dd/yyyy)	10	The original date of the transaction
Settlement Date	Date (MM/dd/yyyy)	10	The date that Worldpay sent the settled funds to your merchant account.
Activity	Alphanumeric	50	The activity performed on the chargeback. Possible values are: Add Note Assign To Vantiv Assign To Merchant Assign To Merchant Automated Assign to User Attach Document Auto Represent File Pre-arbitration Merchant Accepts Liability Merchant Accepts Liability - PayPal Merchant Represent Merchant Requests Arbitration Merchant Respond Merchant Respond - Sent Credit Move To Vantiv Error Queue Network Accepted Network Decision Receive Network Transaction Request Declined Send Representment Send Retrieval Request Response Successful PayPal Case ACH Direct Debit Returns Rejected Payments
Cycle	Alphanumeric	25	The current cycle of the chargeback. Possible values are: ARBITRATION_CHARGEBACK ARBITRATION_LOST ARBITRATION_SPLIT ARBITRATION_WON CHARGEBACK_REVERSAL FIRST_CHARGEBACK ISSUER_ACCEPT_PREARB ISSUER_ARB_CHARGEBACK ISSUER_DECLINE_PREARB PRE_ARB_CHARGEBACK REPRESENTMENT RETRIEVAL_REQUEST RAPID_DISPUTE_RESOLUTION For Direct Debit returns, this column will be empty.
Campaign	Alphanumeric	25	The merchant-specified identifier used to track transactions associated with specific marketing campaigns.
Merchant Name	Alphanumeric	50	The name of the parent organization (or division) that submitted the transaction.
Affiliate	Alphanumeric	25	The merchant-specified identifier used to track transactions associated with your affiliate organizations.
Merchant Grouping ID	Alphanumeric	25	The merchant-specified identifier for grouping transactions by an additional transaction level ID outside of Affiliate or Campaign.
Reporting Group	Alphanumeric	50	The Reporting Group to which the transaction belongs.
Txn Type	Alphanumeric	50	The type of transaction (for example, Deposit or Refund).
Batch ID	Numeric (with preceding apostrophe)	20	The unique number automatically assigned by the system for the batch associated with the transaction.
Session ID	Numeric (with preceding apostrophe)	20	The unique number automatically assigned by the system for the session associated with the transaction.
ARN	Alphanumeric (with preceding apostrophe)	23	The Acquirer Reference Number (ARN) that uniquely identifies this transaction with the networks.
Customer ID	Alphanumeric	50	The unique identifier for the purchaser associated with the transaction.
Merchant Transaction ID	Alphanumeric	25	The identifier specified by the merchant for this transaction. This value corresponds to the `id` attribute (`id`="value") of the transaction.
Billing Descriptor	Alphanumeric	25	The text shown on the customer bill. This is either the default (hard-coded billing descriptor), or the value designated in the transaction (soft billing descriptor.
Assigned To	Alphanumeric	105	The name of the user to which the chargeback is assigned.
Assigned To User Type	Alphanumeric	15	Defines the type of user as one of the following: VANTIV MERCHANT PRESENTER MULTI_ORG
Issuing Bank Country Code	Alpha	3	The 3-character alpha country code indicating the location of the issuing bank.
Merchant ID	Alphanumeric	50	The value of the merchantId element/attribute submitted in the cnpAPI transaction.
Issuing Bank	Alphanumeric	100	The name of the issuing bank. If the value is null and the Payment Type is either Visa or MasterCard, then the issuing bank in unknown. If the Payment Type is American Express, the issuing bank in American Express. If the Payment Type is Discover, the issuing bank in Discover.
Presenter	Alphanumeric	15	The short name of the presenter.
Txn Secondary Amt	Signed Decimal (17,2)	19	The portion of the purchase amount that is directed to a third party.
Txn Secondary Settlement Amt	Signed Decimal (17,2)	19	The portion of the settlement amount that is directed to a third party.
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.
PINless Adjustment Number	Alphanumeric	19	The identifier of the PINless Adjustment case. If the chargeback is not related to a PINless debit card, this column is empty.
PINless Debit Network	Alphanumeric	20	The Debit Network associated with the Adjustment. If the chargeback is not related to a PINless debit card, this column is empty
Worldpay Transfer Id	Numeric	36	The unique transfer identifier for the transaction.