Chargeback Win/Loss Report

Chargeback Win/Loss report provides information about chargeback cases won or lost on a given day. Worldpay produces this report daily.

Filename Syntax

The syntax of the report filename is:

ChargebackWinLoss${organizationId}_${targetDay}

where

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
Org ID	Numeric (with preceding apostrophe)	20	The Organization ID in the Worldpay eComm system.
Case ID	Numeric (with preceding apostrophe)	20	This field contains the unique Worldpay assigned ID for a chargeback or the return ID for an Direct Debit return.
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	Numeric	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 cards, and the last three digits for eChecks.
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, etc.) for this transaction.
Reason Code	Alphanumeric	25	Code indicating why this chargeback or Direct Debit return 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 or Direct Debit return.
Date Received	Date (MM/dd/yyyy)	10	The day that Worldpay received the chargeback or Direct Debit return from the network.
Reply by Date	Date (MM/dd/yyyy)	10	The day by which merchants must respond to the case. Since this field does not apply to Direct Debit returns, it will be empty.
Chargeback Amt	Signed Decimal (17,2)	21	The disputed dollar amount of the chargeback or Direct Debit return.
Auth Date	Date (MM/dd/yyyy)	10	The date of the original Authorization.
Auth Amount	Signed Decimal (17,2)	21	The total dollar amount of the original authorization. This field is empty for Direct Debit.
Transaction Date	Date (MM/dd/yyyy)	10	The date of the original transaction.
Purchase Currency	Alphanumeric	50	The currency used for the transaction purchase amount.
Purchase Amount	Signed Decimal (17,2)	21	The total dollar amount of the original purchase.
Secondary Amount	Signed Decimal (17,2)	19	The portion of the purchase amount that is directed to a third party.
Settlement Currency	Alphanumeric	50	The currency used for the transaction settlement amount.
Settlement Amount	Signed Decimal (17,2)	21	The total dollar amount of the purchase in the settlement currency.
Secondary Settlement Amount	Signed Decimal (17,2)	19	The portion of the settlement amount that is directed to a third party.
Activity Date	Date (MM/dd/yyyy)	10	The original date of the transaction.
Settlement Date	Date (MM/dd/yyyy)	10	The date Worldpay sent the settled funds to your organization’s bank.
Current Cycle	Alphanumeric	25	The current cycle of the chargeback. Possible values are: ARBITRATION_CHARGEBACK CHARGEBACK_REVERSAL FIRST_CHARGEBACK ISSUER_ARB_CHARGEBACK PRE_ARB_CHARGEBACK REPRESENTMENT RETRIEVAL_REQUEST This column empty for Direct Debit returns.
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 applies.
Transaction 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.
Issuing Bank Name	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 is Unknown. If the Payment Type is American Express, the issuing bank is American Express. If the Payment Type is Discover, the issuing bank is Discover.
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.
Issuing Bank Country Code	Alpha	3	The 3-character alpha country code indicating the location of the issuing bank.
Won/Loss	Alphanumeric	4	Indicator of whether or not the chargeback was won or lost.