Batch Download

Date Range: Yesterday → Today (transaction date)

Description

A comma-delimited text file containing transaction-level detail for all sub-merchant activity within the date window. This is a headerless file — columns are identified by position. Includes all transactions processed within the date range (both originations and settled items).

Columns (by position)

Position

Type

Description

1

text(6)

Merchant number (6-digit, zero-padded).

2

text

Transaction status (e.g., ApprovedDeclinedReturned).

3

integer

Transaction ID.

4

(empty)

5

(empty)

6

text

Merchant reference number (TheirReferenceNumber).

7

text

Consumer name.

8

text

Batch upload ID. Blank if not submitted via batch.

9

text

Return date. Format: MM/DD/YYYY. Blank if no return.

10

text

Effective Entry Date. Format: MM/DD/YYYY. Blank if not yet originated.

11

(empty)

12

(empty)

13

text(1)

Transaction code character (D = debit, C = credit).

14

decimal

Transaction amount. Format: decimal (e.g., 150.50).

15

text

BOE (Back Office Exception) code extracted from transaction notes. Blank if none.

16

(empty)

17

text(9)

Bank routing number (9-digit, zero-padded).

18

(empty)

19

text

Check number. Blank if not a check transaction.

20

text

Return reason code (e.g., R01). Blank if no return.

21

text

Consumer individual ID and NOC data (format: ID (NOCData)). Blank if no individual ID.