Merchant processor report
Merchant processor report (transaction details)
This file gives a detailed record of card transaction activity processed through Cross River's merchant acquiring programs. Partners must send two reports:
- Authorized Report: captures transactions when they're approved, and
- Settled Report: reflects transactions once they've cleared and funded.
The report format is identical for each. Cross 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 and file format 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.
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 |