📄️ List active TRX merchant accounts for the current client.
List active TRX merchant accounts for the current client.
📄️ Daily summary of credit card and ACH transactions.
Refund amounts are negative; Volume per rail is Sale - Refund.
📄️ Monthly summary of credit card and ACH transactions.
SettleDate is the raw 'MM/YYYY' TRX returns; SettleDateAnchor is the typed DateTime (1st of month).
📄️ Yearly summary of credit card and ACH transactions.
SettleDate is the raw 'YYYY' TRX returns; SettleDateAnchor is the typed DateTime (Jan 1).
📄️ Per-transaction credit card activity from TRX's DailyDetail report.
PaymentId / CustomerId / EBillingProfileId are populated when the transaction's Reference_Number resolves to a Rev.io payment.
📄️ Credit card transactions rolled up by settlement batch.
Date filter applies to BatchSettleTime so each row reflects the entire batch, not a half-window of it.
📄️ Distinct status values present on the current client's credit card transactions.
Distinct status values present on the current client's credit card transactions.
📄️ Per-transaction ACH activity from TRX's DailyDetail report.
PaymentId / CustomerId / EBillingProfileId are populated when the transaction's Reference_Number resolves to a Rev.io payment.
📄️ Distinct status values present on the current client's ACH transactions.
Distinct status values present on the current client's ACH transactions.
📄️ Credit card transactions flagged with an exception (chargeback, retrieval, RDR, etc.).
PaymentId / CustomerId / EBillingProfileId are populated when the transaction's Reference_Number resolves to a Rev.io payment.
📄️ ACH transactions flagged with an exception.
Combines TRX's ExceptionDetail and ExceptionDuplicates streams; the Source column distinguishes the two.
📄️ Credit card exception roll-up by exception type and reason code.
ReportedThrough is the end of the delivery window the row was reported in.