---
title: Merchant processor report
slug: concepts/cards/reporting-and-compliance/merchant-acquiring-reports/merchant-processor-report
description: Cross River merchant acquiring reporting requirements for authorized and settled transactions, including fraud monitoring, reconciliation, compliance, and PCI DSS data standards.
createdAt: 2026-09-27T10:14:52.612Z
---

## Merchant processor report (transaction details)&#x20;

This file gives a detailed record of card transaction activity processed through Cross River's merchant acquiring programs. **Partners must send two reports:**&#x20;

1. **Authorized Report:** captures transactions when they're approved, and &#x20;
2. **Settled Report:** reflects transactions once they've cleared and funded.&#x20;

**The report format is identical for each.&#x20;**&#x43;ross River uses these reports to spot unusual activity, review merchant behavior and reconcile transaction flows. Together, they help Cross River meet its compliance and reporting requirements.

## File delivery and format

Refer here for [file delivery](docId\:i4b_iqAVcQFp9m1611twC) and [file format](docId\:i4b_iqAVcQFp9m1611twC) details.

## Sample processor (transaction details) file

The following file contains sample data.  If you have any questions, please be in touch with your onboarding team.

::File{src="https://api.archbee.com/api/presign/4hvUOg5mU1sCngl0n0Has/1zp0RdyVjA7YzbM6ERTsF_merchant-processor-transaction-report-sample.csv" label="Merchant Processor Transaction Report Sample.csv"}

## Explanation of fields

| Field                             | Data Type                            | Description                                                                                                                                                                                         | Required/Conditional                                                                           |
| --------------------------------- | ------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------- |
| PROCESSOR\_REFERENCE\_ID          | VARCHAR                              | Unique ID the processor assigns to the transaction. Main key for matching transactions to other reports.                                                                                            | Required                                                                                       |
| TRANSACTION\_TYPE                 | VARCHAR                              | Type of transaction. Allowed values: Disbursement, Funding, Purchase, Reversal, Chargeback.                                                                                                         | Required                                                                                       |
| NUMERIC                           | CHAR(6)                              | 6-digit ID of the acquiring processing entity, e.g., Visa BIN (Acquirer BIN) or Mastercard ICA. Stored as text so leading zeros are kept.                                                           | Required                                                                                       |
| CARD\_ACCEPTOR\_ID                | VARCHAR                              | Card Acceptor ID (CAID). Identifies the underlying merchant of the ISO or Payment Facilitator (PayFac). Should match CAID (PF) in the merchant onboarding file.                                     | Conditional - populated for merchants under an ISO or Payment Facilitator                      |
| MERCHANT\_CATEGORY\_CODE          | CHAR(4)                              | Merchant Category Code (MCC). 4-digit code showing the merchant's industry or the nature of the payment. Stored as text so leading zeros are kept.                                                  | Required                                                                                       |
| MERCHANT\_NAME                    | NVARCHAR                             | Merchant's legal business name. Should match Merchant Legal Business Name in the merchant onboarding file.                                                                                          | Required                                                                                       |
| PAYER\_FIRST\_NAME                | NVARCHAR                             | First name of the payer (the party sending the funds).                                                                                                                                              | Conditional - populated when the payer is an individual                                        |
| PAYER\_LAST\_NAME                 | NVARCHAR                             | Last name of the payer (the party sending the funds).                                                                                                                                               | Conditional - populated when the payer is an individual                                        |
| PAYER\_BUSINESS\_NAME             | NVARCHAR                             | Business name of the payer (the party sending the funds).                                                                                                                                           | Conditional - populated when the payer is a business                                           |
| PAYER\_ADDRESS\_LINE              | NVARCHAR                             | Street address of the payer (street number and street name).                                                                                                                                        | Conditional - populated where available; required for Funding and Disbursement transactions    |
| PAYER\_ADDRESS\_CITY              | NVARCHAR                             | City or municipality of the payer's address.                                                                                                                                                        | Conditional - populated where available; required for Funding and Disbursement transactions    |
| PAYER\_ADDRESS\_STATE             | VARCHAR                              | State or province of the payer's address. 2-letter code (e.g., NJ).                                                                                                                                 | Conditional - populated where available; required for Funding and Disbursement transactions    |
| PAYER\_ADDRESS\_POSTAL            | VARCHAR                              | Postal or ZIP code of the payer's address.                                                                                                                                                          | Conditional - populated where available; required for Funding and Disbursement transactions    |
| PAYER\_ADDRESS\_COUNTRY           | VARCHAR                              | Country of the payer's address. ISO 3166-1 alpha-2 code (e.g., US).                                                                                                                                 | Conditional - populated where available; required for Funding and Disbursement transactions    |
| BENEFICIARY\_FIRST\_ NAME         | NVARCHAR(                            | First name of the beneficiary (the party receiving the funds).                                                                                                                                      | Conditional - populated when the beneficiary is an individual                                  |
| BENEFICIARY\_LAST\_ NAME          | NVARCHAR                             | Last name of the beneficiary (the party receiving the funds).                                                                                                                                       | Conditional - populated when the beneficiary is an individual                                  |
| BENEFICIARY\_BUSINESS\_NAME       | NVARCHAR                             | Business name of the beneficiary (the party receiving the funds).                                                                                                                                   | Conditional - populated when the beneficiary is a business                                     |
| BENEFICIARY\_ADDRESS\_LINE        | NVARCHAR                             | Street address of the beneficiary (street number and street name).                                                                                                                                  | Conditional - populated where available; required for Funding and Disbursement transactions    |
| BENEFICIARY\_ADDRESS\_CITY        | NVARCHAR                             | City or municipality of the beneficiary's address.                                                                                                                                                  | Conditional - populated where available; required for Funding and Disbursement transactions    |
| BENEFICIARY\_ADDRESS\_STATE       | VARCHAR                              | State or province of the beneficiary's address. 2-letter code (e.g., NJ).                                                                                                                           | Conditional - populated where available; required for Funding and Disbursement transactions    |
| BENEFICIARY\_ADDRESS\_POSTAL      | VARCHAR                              | Postal or ZIP code of the beneficiary's address.                                                                                                                                                    | Conditional - populated where available; required for Funding and Disbursement transactions    |
| BENEFICIARY\_ADDRESS\_COUNTRY     | VARCHAR                              | Country of the beneficiary's address. ISO 3166-1 alpha-2 code (e.g., US).                                                                                                                           | Conditional - populated where available; required for Funding and Disbursement transactions    |
| CARD\_NUMBER\_FIRST\_SIX          | CHAR(6)                              | First 6 digits of the card number (BIN/IIN). Identifies the issuing bank and card program. Stored as text so leading zeros are kept.                                                                | Required                                                                                       |
| CARD\_NUMBER\_LAST\_FOUR          | CHAR(4)                              | Last 4 digits of the card number. Used with the first six to identify the card without storing the full card number. Stored as text so leading zeros are kept.                                      | Required                                                                                       |
| CARD\_EXPIRATION\_DATE            | CHAR(4)                              | Card expiration date in MMYY format (e.g., 0928). Stored as text so leading zeros are kept. Sensitive card data: must be protected under PCI DSS.                                                   | Conditional - populated where provided by the processor                                        |
| ACQUIRER\_REFERENCE\_NUMBER       | VARCHAR                              | Acquirer Reference Number (ARN). Reference number the acquirer processor assigns to the transaction when it is cleared. Used to trace transactions and handle disputes. All digits, stored as text. | Conditional - populated once the transaction has been cleared                                  |
| BUSINESS\_APPLICATION\_IDENTIFIER | VARCHAR                              | Code showing the type of transaction: Business Application Identifier (BAI) for Visa (2 characters, e.g., AA, PP) or Transaction Type Identifier (TTI) for Mastercard (3 characters, e.g., C07).    | Conditional - populated for Funding and Disbursement (AFT/OCT and money transfer) transactions |
| NETWORK\_DESTINATION              | VARCHAR                              | Card network the transaction was routed to for authorization (e.g., Visa, Mastercard, STAR, NYCE, Pulse).                                                                                           | Required                                                                                       |
| NETWORK\_SETTLED                  | VARCHAR                              | Card network the transaction was settled through (e.g., Visa, Mastercard, STAR, NYCE, Pulse).                                                                                                       | Conditional - populated once the transaction has settled                                       |
| NETWORK\_RESPONSE\_CODE           | VARCHAR                              | Authorization response code returned by the network or issuer (ISO 8583 field 39), e.g., 00 = Approved.                                                                                             | Required                                                                                       |
| CARD\_BRAND                       | VARCHAR                              | Brand of the card used (e.g., Visa, Mastercard, Discover, Amex).                                                                                                                                    | Required                                                                                       |
| CARD\_PRODUCT\_TYPE               | VARCHAR                              | Type of card product. Allowed values: Debit, Prepaid, Credit.                                                                                                                                       | Required                                                                                       |
| ISSUING\_COUNTRY                  | VARCHAR                              | Country of the card issuer. ISO 3166-1 alpha-2 code (e.g., US).                                                                                                                                     | Required                                                                                       |
| TXN\_TIME\_CREATED\_EST           | DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time the transaction was created or initiated, in US Eastern Time.                                                                                                                         | Required                                                                                       |
| TXN\_TIME\_PROCESSED\_EST         | DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time the transaction was processed, in US Eastern Time.                                                                                                                                    | Conditional - blank if the transaction has not yet been processed                              |
| RETRIEVAL\_REFERENCE\_ID          | VARCHAR                              | Retrieval Reference Number (RRN). 12-digit reference assigned at authorization (ISO 8583 field 37). Used to link the authorization to clearing and settlement records. Stored as text.              | Required                                                                                       |
| TRANSACTION\_AMOUNT               | DECIMAL(19,4)                        | Amount of the transaction in the currency shown in TRANSACTION\_CURRENCY.                                                                                                                           | Required                                                                                       |
| TRANSACTION\_CURRENCY             | VARCHAR                              | ISO 4217 currency code of the transaction amount (e.g., USD, EUR).                                                                                                                                  | Required                                                                                       |
| SETTLEMENT\_AMOUNT                | DECIMAL(19,4)                        | Amount settled for the transaction in the currency shown in SETTLEMENT\_CURRENCY.                                                                                                                   | Conditional - populated once the transaction has settled                                       |
| SETTLEMENT\_CURRENCY              | VARCHAR                              | ISO 4217 currency code of the settlement amount (e.g., USD).                                                                                                                                        | Conditional - populated once the transaction has settled                                       |
| STATEMENT\_DESCRIPTOR             | VARCHAR                              | Merchant name or description shown on the cardholder's card statement for this transaction.                                                                                                         | Required                                                                                       |
| SETTLEMENT\_DATE                  | DATE (YYYY-MM-DD)                    | Date the transaction was settled by the card network.                                                                                                                                               | Conditional - populated once the transaction has settled                                       |
| INTERCHANGE\_CATEGORY\_DESCRIPTOR | VARCHAR                              | Name of the interchange rate category (fee program) the network applied to the transaction.                                                                                                         | Conditional - populated once the transaction has settled                                       |
| INTERCHANGE\_AMOUNT               | DECIMAL(19,4)                        | Interchange fee amount charged for the transaction, in the settlement currency.                                                                                                                     | Conditional - populated once the transaction has settled                                       |
| PROCESSING\_CODE                  | CHAR(6)                              | 6-digit ISO 8583 processing code (field 3). Shows the transaction type and the account types involved (e.g., 000000 = purchase). Stored as text so leading zeros are kept.                          | Required                                                                                       |

