Transaction List
5. Transaction List
Date Range: Yesterday → Tomorrow (effective entry date)
Description
A full transaction-level detail report for all sub-merchant activity within the date window. Covers the complete lifecycle of each transaction from submission through settlement, including any returns or notifications of change received. The 3-day window ensures all items across the standard settlement cycle are captured.
Dates are filtered by Effective Entry Date — the date the transaction was scheduled to settle at the consumer's bank.
Columns
Column | Type | Description |
|---|---|---|
| text | Unique identifier for the transaction. |
| text(25) | Reference number submitted with the transaction by the merchant or consumer. |
| text(25) | Authorization approval code. Blank if no authorization was performed. |
| date | Date the transaction was submitted and accepted. Format: |
| text(40) | Consumer full name on the transaction. |
| text(25) | Consumer phone number. May be blank. |
| text(25) | Consumer identifier (e.g., SSN token). May be blank. |
| currency | Transaction dollar amount. Always positive. Format: decimal (e.g., |
| integer |
|
| integer | Reference number of the original transaction if resubmitted. Blank otherwise. |
| date | Date the transaction funds were settled. Blank if not yet settled. Format: |
| text(25) | 9-digit routing number of the consumer's bank. |
| text(25) | Check number if the transaction originated from a paper check. Blank otherwise. |
| currency | Amount disbursed to the merchant after fees. May differ from |
| text(25) | Transaction status code. See |
| text(900) | Notes attached to the transaction. May include risk scoring data. |
| text(25) | Consumer billing address line 1. May be blank. |
| text(25) | Consumer billing address line 2. May be blank. |
| text(25) | Consumer city. May be blank. |
| text(25) | Consumer state (2-letter abbreviation). May be blank. |
| text(25) | Consumer ZIP code. May be blank. |
| text(40) | Consumer email address. May be blank. |
| date | Consumer date of birth. Format: |
| text(25) | State that issued the consumer's driver's license (2-letter code). May be blank. |
| text(25) | Indicates whether a NOC was issued. May be blank. |
| text(40) | Corrected data from the NOC notice (first 40 characters). Blank if no NOC. |
| date | Date a NOC was received for this transaction. Format: |
| integer |
|
| date | Date this transaction record was last updated. Format: |
| text(25) | Masked bank account number (e.g., |
| date | Date the transaction was sent to the banking network. Format: |
| integer | Count of refunds issued against this transaction. May be blank. |
| integer | ID of the original transaction if this record is a refund. May be blank. |
| text(25) | Standard Entry Class code (e.g., |
| text(25) | Company or product descriptor on the transaction. |
| text(25) | Batch upload identifier if submitted via batch file. May be blank. |
| integer | 10-digit merchant number of the sub-merchant that originated the transaction. |
| text(80) | Customer reference ID from the merchant's platform. May be blank. |
| text(25) | Transaction status label (e.g., |
| text(25) | Whether the transaction was included in a settlement file. Values: |
| text(25) | Whether a return was received. Values: |
| text(25) | Transaction type code (e.g., |
| text(25) | Last 8 digits of the 15-digit ACH trace number (sequence number portion). May be blank if not yet originated. |
| text(25) | First 7 digits of the 15-digit ACH trace number (routing transit prefix). May be blank if not yet originated. |
| text(25) | Entry class code of the associated ACH warehouse entry (e.g., |
| integer | External ID linking this transaction to its ACH origination record. May be blank. |
| text(25) | Source system of the |
| text(25) | Entry description field on the transaction (up to 10 characters). |
| date | Date the return was received. Format: |
| text(25) | Return code (e.g., |
| text(140) | Description of the return code. Blank if no return. |
| text(25) | WorldPay merchant chain code. Blank if not configured. |
| text(25) | WorldPay Company Group ID. Blank if not configured. |
| text(25) | WorldPay Merchant ID. Blank if not configured. |
| text(25) | WorldPay REP code. Blank if not configured. |
| text(25) | WorldPay Store/Terminal/Workstation code. Blank if not configured. |
| text(60) | Sub-merchant DBA name. |