AuthMax Transaction Report

The AuthMax Transaction report applies to merchants using the Worldpay eComm AuthMax service and provides detailed information about transactions processed using AuthMax. The report shows transactional level information about transactions using the AuthMax service, as well as control transaction if applicable. Using this information, you can gage the performance of the AuthMax service. Worldpay produces this report daily.

Filename Syntax

The syntax of the report filename is:

AuthMax_Transaction_Report_${organizationId}_${rptCategoryId}_${targetDay}

where

  • organizationId is the ID 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

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

Transaction Processing Timestamp

Timestamp

(MM/dd/yyyy HH:mm:ss)

22

The date and time (GMT) the transaction was processed by Worldpay

Reporting Group

Alphanumeric

50

The Reporting Group to which the transaction belongs.

Merchant

Alphanumeric

50

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

Activity Date

Date (MM/dd/yyyy)

10

The original date of the submitted transaction.

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

Transaction Category

Alphanumeric

8

Indicates whether the transaction used AuthMax or is from the control sample.

Order Source

Alphanumeric

50

Indicates the Order Source for the transaction. For example, Recurring Transaction, Telephone, Mail Order, etc.

Purchase Currency

Alphanumeric

5

The currency used for the purchase, designated by a three-character abbreviation of the country.

Purchase Amt

Decimal (10,2)

13

The amount of this transaction.

Some currencies appear only as whole numbers.

Payment Type

Alphanumeric

50

The method of payment. For example, Visa, MasterCard, Discover, etc.

Response Reason Message

Alphanumerickjknb

80

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

Customer ID

Alphanumeric

50

The unique identifier for the purchaser associated with the transaction.

Merchant Transaction ID

Alphanumeric

36

The identifier specified by the merchant for this transaction. This value corresponds to the id attribute (id="value") of the transaction.

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.