Transaction Summary Report

The Transaction Summary report contains the summarized deposits and refunds submitted by the merchant for both settled and conveyed methods of payment, broken down by purchase currency. Worldpay produces this report daily.

Filename Syntax

The syntax of the report filename is:

Transactional_Summary_TxnReportByActivityDate${rptCategoryId}_${organizationId}_${targe tDay}

where

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.
organizationId is the ID of the parent merchant organization
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
Reporting Group	Alphanumeric	50	The Reporting Group to which the transaction belongs.
Reporting Group Type	Alphanumeric	50	The type of Reporting Group: Transactional, if this Reporting group is at a transaction level (the ones submitted with the transactions) or Rollup, if this contains child Reporting Group.
Merchant	Alphanumeric	50	The name of the parent organization (or division) that submitted the transaction.
Purchase Currency	Alphanumeric	5	The currency used for the purchase, designated by a three-character abbreviation of the country.
Funding Method	Alphanumeric	50	Defines the Funding Method for the transaction as either Settled or Conveyed.
Payment Type	Alphanumeric	50	The method of payment (Visa, MasterCard, etc.) for this transaction.
Txn Status	Alphanumeric	50	Indicates the status of the transaction, either Submitted, Approved, or Declined.
Txn Type	Alphanumeric	50	Indicates whether the transaction was a Deposit or a Refund.
Vantiv Initiated	Alphanumeric	5	Indicates whether or not this transaction originated from Worldpay. Yes = Worldpay Initiated No = Merchant Initiated
Count	Numeric	15	The total number of transactions included in this Reporting Group
Amount	Decimal (17,2)	21	The total dollar amount of all transactions in this Reporting Group.