Session Report

The Session report including all transactions for a particular activity day. Worldpay produces this report daily for use primarily for transaction reconciliation.

Filename Syntax

The syntax of the report filename is:

Transactional_Detail_SessionByActivityDate${presenterId}_${organizationId}_${targetDay}

where

presenterId is the ID of the presenter
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
Session ID	Numeric (with preceding apostrophe)	20	The unique number automatically assigned by Worldpay for the session associated with the transaction.
Batch ID	Numeric (with preceding apostrophe)	20	The unique number automatically assigned by the system for the batch associated with the transaction.
Batch Post Day	Date (MM/dd/yyyy)	10	The post date the batch was submitted.
Transaction Processing Timestamp GMT	Timestamp (MM/dd/yyyy HH:mm:ss)	22	The date and time the transaction was processed by Worldpay
Batch Completion Timestamp GMT	Timestamp (MM/dd/yyyy HH:mm:ss)	22	The date and time the batch was processed completely by Worldpay.
Reporting Group	Alphanumeric	50	The Reporting Group to which the transaction belongs.
Presenter	Alphanumeric	15	The short name that identifies the presenter.
Merchant	Alphanumeric	50	The name of the parent organization (or division) that submitted the transaction.
Merchant ID	Alphanumeric	50	The value of the merchantId element/attribute submitted in the cnpAPI transaction.
Vantiv Payment ID	Numeric (with preceding apostrophe)	20	The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.
Parent Vantiv Payment ID	Numeric (with preceding apostrophe)	20	The payment Id for the parent transaction. For example, if the transaction was a capture, this is the payment Id for the Authorization transaction.
Merchant Order #	Alphanumeric	256	The merchant-designated identifier for this transaction (i.e., value of the orderId element).
Customer ID	Alphanumeric	50	The unique identifier for the purchaser associated with the transaction.
Txn Type	Alphanumeric	50	The type of transaction; possible values are: Account Update Response Account Update Request Activate Card Activate Reversal Authorization Auth Reversal Balance Inquiry Deposit Deposit with External Auth Cond. Deposit Refund Direct Debit Deposit Direct Debit Refund Direct Debit Verification Direct Debit Prenotification Deposit Direct Debit Prenotification Refund Funding Instruction Void Physical Check Credit Physical Check Debit PayFac Debit PayFac Credit Reserve Credit Reserve Debit Submerchant Debit Submerchant Credit Vendor Credit Vendor Debit Void Unload Value Deactivate Card Refund Reversal Deposit Reversal Direct Debit Void
Purchase Currency	Alphanumeric	5	The currency used for the purchase, designated by a three-character abbreviation of the country.
Purchase Amt	Signed Decimal (17,2)	21	The total dollar amount of the purchase.
Payment Type	Alphanumeric	50	The method of payment (Visa, MasterCard, etc.) for this transaction.
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. NOTE: All Discover Cards return a value of discov for the BIN. Also, the BIN field is blank for PayPal and Direct Debit transaction.
Account Suffix	Alphanumeric	4	The account number suffix that the customer used for this transaction. Regardless of account permissions, only the last four digits are visible for credit cards, and the last three digits for eChecks, unless the Direct Debit account number is <4 digits. In this case this field contains XXXX.
Response Reason Code	Alphanumeric	3	The 3-digit transaction response code returned by Worldpay for this transaction. If the transaction was declined, this code provides a reason.
Response Reason Message	Alphanumeric	80	The transaction response returned by Worldpay for this transaction. If the transaction was declined, this message provides a reason.
AVS	Alphanumeric	2	The 2-digit Address Verification Service response code for the transaction.
Fraud Check Sum Response	Alphanumeric	10	Response received from security services, for example CVV2/CID/CVC2 for Visa, AMEX, and MC.
Payer ID	Alphanumeric	35	Unique identifier for a PayPal transaction
Merchant Transaction ID	Alphanumeric	25	The identifier specified by the merchant for this transaction. This value corresponds to the id attribute (id="value") of the transaction.
Affiliate	Alphanumeric	25	The merchant-specified identifier used to track transactions associated with your affiliate organizations.
Campaign	Alphanumeric	25	The merchant-specified identifier used to track transactions associated with specific marketing campaigns.
Merchant Grouping ID	Alphanumeric	25	The merchant-specified identifier for grouping transactions by an additional transaction level ID outside of Affiliate or Campaign.
Sales Tax	Decimal	19	The Sales Tax amount passed in from the merchant for the specific transaction.
FTP Filename	Alphanumeric	100	Name of the original file submitted by the presenter.
Session Type	Alphanumeric	50	Defines the type of file submitted. The possible values are: Normal Online POS RFR Account Updater Response Funding Instruction Virtual Terminal Initiated Worldpay Initiated Recycling Worldpay Initiated Recurring
Action Performed By	Alphanumeric	256	The name of the Virtual Terminal user performing the action.
Customer Reference	Alphanumeric	17	The reference string used by the cardholder to track the order.
Secondary Amt	Signed Decimal (17,2)	19	The portion of the purchase amount that is directed to a third party.
PINless Debit Network	Alphanumeric	10	The PINless Debit network on which the transaction was processed.
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.
Same Day ACH	Alphanumeric	3	Indicated whether the system executed the ACH-based Funding Instruction as a Same Day ACH.
Processing Endpoint	Alphanumeric	10	The final network on which a PINless Debit transaction was processed. This could be the PINless network name, the signature network name or UNKNOWN. (For example, Mastercard, Visa, NYCE, etc.)
Order Source	Alphanumeric	50	Indicates the Order Source for the transaction. For example, Recurring Transaction, Telephone, Mail Order, etc.