Auto AU Repaired Auth Report

The Auto AU Repaired Auth report provides a summary of authorizations repaired by Worldpay. Worldpay produces this report daily.

Filename Syntax

The syntax of the report filename is:

Transactional_Detail_AuRepairedAuth_${organizationId}_${rptCategoryId}_${targetDay}_$(currencyCode)

where

  • organizationId is the ID of the parent merchant organization

  • rptCategoryId is the ID of the Reporting Group to which the report applies

  • targetDay is the activity date of the transactions in the report . The format is yyyyMMdd.

  • currencyCode is the 3-letter ISO 4217 currency code for the currency of the transactions included in the report

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

Payment ID

Numeric (with preceding apostrophe)

20

The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.

Repair Activity Date

Date (YYYY/MM/dd HH:mm:ss)

10

The date and time the repair activity was performed.

Merchant Order Number

Alphanumeric

256

The merchant-designated identifier for this transaction (i.e., value of the orderId element).

Amount

Signed Decimal (17,2)

21

The dollar amount of the repaired transaction (Prepended with $).

Response Reason Message

Alphanumeric

80

The transaction response returned by Worldpay for this transaction. If the transaction was declined, this message provides a reason.

BIN

Alphanumeric (enclosed by double quotes)

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

All Discover Cards return a value of discov for the BIN. Also, the BIN field is blank for PayPal and Direct Debit transaction.

Old Card Suffix

Numeric (enclosed by double quotes)

4

The account number suffix (last four digits) of the original credit card used in this transaction.

Old Expiry

Numeric (enclosed by double quotes)

4

The expiration date of the original credit card used in this transaction. The format is mmYY.