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
-
organizationIdis the ID of the parent merchant organization -
rptCategoryIdis 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. -
targetDayis 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 |
|
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 |
|
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. |