Fraud Alert Report

The Fraud Alert report is a daily listing of issuer-confirmed, fraudulent transactions. This information allows you to issue refunds for fraudulent transaction in a timely manner to prevent chargebacks.

Filename Syntax

The syntax of the report filename is:

Transactional_Detail_FraudAlertReport_${organizationId}_${rptCategoryId}_${targetDay}_$ (merchantId)_$(mop)

where

  • organizationId is the of the parent merchant organization

  • 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.

  • targetDay is the date to which the data applies

  • merchantId is the ID of the merchant

  • mop is the designater for the method of payment (either VI, MC or ALL)

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

Merchant Name

Alphanumeric

50

The name of the parent organization (or division) that submitted the transaction.

Report Date

Date (YYYY-MM-DD)

10

The date when this Fraud Alert was posted by Worldpay.

Billing Descriptor

Alphanumeric

25

The custom billing descriptor text that will appear on the customer’s bill for the transaction associated with this Fraud alert.

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 ofor the BIN. Also, the BIN field is blank for PayPal and Direct Debit transaction.

Bank Name

Alphanumeric

60

The name of the bank associated with this BIN.

Customer ID

Alphanumeric

50

The unique identifier for the purchaser associated with the transaction.

Transaction Type

Alphanumeric

50

The type of transaction (for example, Deposit or Refund).

Deposit Payment ID

Numeric

19

The payment Id assigned to the deposit associated with this Fraud Alert.

Deposit Order Number

Alphanumeric

25

The merchant-designated identifier assigned to the deposit associated with this Fraud Alert.

Deposit Date

Date (YYYY-MM-DD)

10

The date of the deposit associated with this Fraud Alert.

Deposit Amount

Signed Decimal (17,2)

21

The amount of the deposit associated with this Fraud Alert.

Auto-refund (Y/N)

Alphabetic

1

Indicated whether the deposit associated with this Fraud Alert was auto-refunded by Worldpay.

  • Y - Auto-refunded

  • N - Not auto-refunded

CBK Issuing Bank Day

Date (YYYY-MM-DD)

10

The date the issuing bank submitted the chargeback associated with this Fraud Alert (one day prior to Worldpay receiving the chargeback).

CBK Current Cycle

Alphanumeric

25

The current phase of the life-cycle for the chargeback associated with this Fraud Alert. Possible values are:

  • RETRIEVAL_REQUEST

  • FIRST_CHARGEBACK

  • REPRESENTMENT

  • ARBITRATION_CHARGEBACK

  • CHARGEBACK_REVERSAL

  • PRE_ARB_CHARGEBACK

  • ISSUER_ARB_CHARGEBACK

CBK Amount

Signed Decimal (17,2)

21

The amount of the chargeback associated with this Fraud Alert.

Prior Refund Date

Date (YYYY-MM-DD)

10

The date of the refund associated with this Fraud Alert.

Prior Refund Amount

Signed Decimal (17,2)

21

The amount of the refund associated with this Fraud Alert.

Method of Payment

Alphanumeric

50

The method of payment (Visa, MasterCard, etc.) for the transaction associated with this Fraud Alert.

Fraud Type

Numeric

2

The card network code indication the type of fraud. Possible values are:

  • 0 - Lost

  • 1 - Stolen

  • 2 - Card not received

  • 3 - Fraudulent application

  • 4 - Issuer-reported counterfeit

  • 5 - Miscellaneous

  • 6 - Fraudulent use

  • 9 - Acquirer-reported counterfeit

Refund ID

Numeric (with preceding apostrophe)

20

The Worldpay Transaction Id associated with the refund transaction.