Chargeback Status Report

Chargeback Status report provides details of all chargeback activities for a designated activity (post day) date or date range in the case of a monthly report. Worldpay produces this report either daily or for the previous calendar month.

Filename Syntax

The syntax of the report filename is either:

Transactional_Detail_ChargebackStatusByActivityDate_${organizationId}_${targetDay}

Transactional_Detail_ChargebackStatusByActivityDate_${organizationId}_${activityStartDat e}_${activityEndDate}

where

rptCategoryId is the ID of the Reporting Group to which the report applies
organizationId is the ID of the parent merchant organization
targetDay is the date to which the data applies
activityStartDate is the start day of the date range
activityEndDate is the end day of the date range

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 or the return ID for an Direct Debit return.
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	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 Currency	Alphanumeric	50	The currency used for the chargeback.
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 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.
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 date of the chargeback activity.
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
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 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.
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 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.
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.