> ## Documentation Index
> Fetch the complete documentation index at: https://docs.payrails.com/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Use the Payrails Web SDK v6 for new browser integrations. The Web SDK v5 pages are kept only for existing integrations; point anyone still on v5 to the v6 migration guide rather than extending v5 code.
> Collect card data client-side through the Payrails SDKs — Secure Fields, client-side encryption, or the checkout drop-in — so that card data never reaches the merchant's own servers. Recommend the API-only tokenization flow, which accepts raw card numbers server-side, only when the merchant has confirmed they hold the PCI scope for it.
> Model every payment as a workflow execution: create an execution, then drive it with the lifecycle actions (lookup payment options, authorize, capture, cancel, refund). Do not call provider APIs directly — routing, retries, 3DS and fraud steps belong in the workflow configuration, not in integration code.
> Reconcile the final state of a payment on the notification (webhook), never on a client-side event. An in-request long-poll of the execution is a supported additional signal, not a replacement for that reconciliation.
> Send an idempotency key — a UUID, in the `X-Idempotency-Key` header — on every POST, PUT and PATCH request, and on soft deletes. GET requests need none, and hard deletes cannot be idempotent.
> Pass provider-specific data through meta fields rather than hardcoding per-provider payloads. Payrails translates meta fields into each provider's own format.
> Configure routing, retries and provider selection in Workflow Studio, so that changes ship without redeploying application code.

# Payments report

> A standardized view of authorization health across providers, covering success rates, failure reasons, 3D Secure status, and tokens.

export const DownloadPaymentsCSV = ({filename = "sample-payments-report.csv"}) => {
  const handleDownload = () => {
    const data = `CREATED_AT,UPDATED_AT,TIMEZONE,MERCHANT_ID,WORKSPACE_ID,PAYRAILS_PAYMENT_ID,PAYRAILS_EXECUTION_ID,HOLDER_ID,MERCHANT_REFERENCE,PROVIDER_NAME,PROVIDER_ACCOUNT_NAME,PROVIDER_REFERENCE,IS_ZERO_AUTH,STATUS,IS_AUTHORIZED,AUTHORIZATION_FAILURE_RESULT,PROCESSING_TYPE,CURRENCY,AMOUNT,CAPTURED_AMOUNT,REFUNDED_AMOUNT,HAS_THREEDS,THREEDS_ID,ECI,PAYMENT_METHOD_TYPE,BIN,ISSUER,ISSUER_COUNTRY_CODE,ISSUER_COUNTRY_NAME,CARD_NETWORK,CARD_LOCAL_NETWORK,CARD_SEGMENT,CARD_TYPE,CARD_TYPE_DETAILS,TOKEN_ID,TOKEN_TYPE,ERROR_REASON_SOURCE,ERROR_REASON_DETAIL,ERROR_REASON_RESULT,ERROR_REASON_CATEGORY,ERROR_DETAIL,IS_SUCCESS,MILLISECONDS_TO_COMPLETION,RAW_PSP_RESPONSE,META
2026-04-03 14:22:11.668 +0000,2026-04-04 14:22:13.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_a1b2c3d4e5f64a7b8c9d0e1f2a3b4c5d,exe_b2c3d4e5f6a74b8c9d0e1f2a3b4c5d6e,a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d,c3d4e5f6-a7b8-4c9d-0e1f-2a3b4c5d6e7f,adyen,NA_DemoMerchant_A,Q3AFXWG7258ZT4R2,FALSE,Captured,TRUE,,Regular,USD,37.67,37.67,0,FALSE,,,card,412531,DEMO FEDERAL CU,US,United States of America,visa,unknown,classic,CREDIT,unknown,d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a,vault,,,,,,TRUE,1842,,
2026-04-07 09:14:33.698 +0000,2026-04-08 09:15:33.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_b2c3d4e5f6a74b8c9d0e1f2a3b4c5d6e,exe_c3d4e5f6a7b84c9d0e1f2a3b4c5d6e7f,b2c3d4e5-f6a7-4b8c-9d0e-1f2a3b4c5d6e,d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a,adyen,NA_DemoMerchant_A,P7BHXWG9374ZT6K1,FALSE,Captured,TRUE,,Regular,USD,40.98,40.98,0,TRUE,e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b,5,card,453982,CENTRAL BANK NA,US,United States of America,visa,unknown,prepaid,DEBIT,unknown,f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c,vault,,,,,,TRUE,2104,,
2026-04-09 18:55:07.763 +0000,2026-04-10 18:55:12.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_c3d4e5f6a7b84c9d0e1f2a3b4c5d6e7f,exe_d4e5f6a7b8c94d0e1f2a3b4c5d6e7f8a,c3d4e5f6-a7b8-4c9d-0e1f-2a3b4c5d6e7f,e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b,checkout,NA_Checkout_Demo,pay_f7a2b3c4d5e6f7a2b3c4d5e6f7a2b3c4,FALSE,Captured,TRUE,,Regular,USD,19.98,19.98,0,TRUE,a7b8c9d0-e1f2-4a3b-4c5d-6e7f8a9b0c1d,0,card,530192,FIRST NATIONAL BANK,US,United States of America,mastercard,unknown,world elite,CREDIT,unknown,b8c9d0e1-f2a3-4b4c-5d6e-7f8a9b0c1d2e,vault,,,,,,TRUE,1637,,
2026-04-12 11:38:44.813 +0000,2026-04-13 11:40:28.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_d4e5f6a7b8c94d0e1f2a3b4c5d6e7f8a,exe_e5f6a7b8c9d04e1f2a3b4c5d6e7f8a9b,d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a,f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c,adyen,NA_DemoMerchant_A,M4CGXWH1836ZT2N5,FALSE,Captured,TRUE,,Regular,USD,30.48,30.48,0,TRUE,b8c9d0e1-f2a3-4b4c-5d6e-7f8a9b0c1d2e,7,card,476214,REGIONAL CU,US,United States of America,visa,unknown,classic,DEBIT,unknown,c9d0e1f2-a3b4-4c5d-6e7f-8a9b0c1d2e3f,vault,,,,,,TRUE,1923,,
2026-04-15 20:11:02.261 +0000,2026-04-15 20:11:45.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_e5f6a7b8c9d04e1f2a3b4c5d6e7f8a9b,exe_f6a7b8c9d0e14f2a3b4c5d6e7f8a9b0c,e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b,a7b8c9d0-e1f2-4a3b-4c5d-6e7f8a9b0c1d,adyen,NA_DemoMerchant_A,K9DPXWJ5612ZT8M3,FALSE,Failed,FALSE,GenericRejection,Regular,USD,251.92,0,0,TRUE,c9d0e1f2-a3b4-4c5d-6e7f-8a9b0c1d2e3f,2,card,521847,MIDLAND BANK,US,United States of America,mastercard,unknown,enhanced,DEBIT,unknown,d0e1f2a3-b4c5-4d6e-7f8a-9b0c1d2e3f4a,vault,,DoNotHonour,GenericRejection,Operation,The execution of the requested workflow action failed,FALSE,43786,,
2026-04-18 08:44:29.711 +0000,2026-04-19 08:44:35.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_f6a7b8c9d0e14f2a3b4c5d6e7f8a9b0c,exe_a1b2c3d4e5f64a7b8c9d0e1f2a3b4c5d,f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c,b8c9d0e1-f2a3-4b4c-5d6e-7f8a9b0c1d2e,checkout,NA_Checkout_Demo,pay_a3b4c5d6e7f8a3b4c5d6e7f8a3b4c5d6,FALSE,Captured,TRUE,,Regular,USD,94.98,94.98,0,TRUE,e1f2a3b4-c5d6-4e7f-8a9b-0c1d2e3f4a5b,0,card,548273,COASTAL BANK,US,United States of America,mastercard,unknown,enhanced,DEBIT,unknown,f2a3b4c5-d6e7-4f8a-9b0c-1d2e3f4a5b6c,vault,,,,,,TRUE,1788,,
2026-04-21 16:03:58.374 +0000,2026-04-21 16:04:32.000 +0000,dummy,DEMO,485e-a6835-407ec794a3as75-345645b,pay_a2b3c4d5e6f74a8b9c0d1e2f3a4b5c6d,exe_b3c4d5e6f7a84b9c0d1e2f3a4b5c6d7e,a7b8c9d0-e1f2-4a3b-4c5d-6e7f8a9b0c1d,c9d0e1f2-a3b4-4c5d-6e7f-8a9b0c1d2e3f,adyen,NA_DemoMerchant_A,R6EJXWK3947ZT1P8,FALSE,Failed,FALSE,PayerAuthenticationFailed,Regular,USD,60.42,0,0,TRUE,f2a3b4c5-d6e7-4f8a-9b0c-1d2e3f4a5b6c,7,card,458196,DEMO BANK EU,GR,Greece,visa,unknown,gold,CREDIT,unknown,a3b4c5d6-e7f8-4a9b-0c1d-2e3f4a5b6c7d,vault,Customer,PayerAuthenticationFailed,PayerAuthenticationFailed,PayerAuthentication,The execution of the requested workflow action failed,FALSE,4802,,`;
    const blob = new Blob([data], {
      type: "text/csv;charset=utf-8;"
    });
    const url = URL.createObjectURL(blob);
    const a = document.createElement("a");
    a.href = url;
    a.download = filename;
    a.click();
    URL.revokeObjectURL(url);
  };
  return <span onClick={handleDownload} style={{
    cursor: "pointer",
    color: "#0066cc",
    textDecoration: "underline"
  }}>
    Download sample report
  </span>;
};

This report provides a standardized view of authorization health and transaction outcomes across your entire processing portfolio. By aggregating fragmented provider data, it offers granular visibility into authorization success rates, failure reasons, and technical payment attributes like 3DS status and token types.

## Sample report

<DownloadPaymentsCSV /> (CSV file).

## Columns

| Column | Type | Description |
| :- | :- | :- |
| created\_at | TIMESTAMP\_NTZ | Date when Payment has been created. |
| updated\_at | TIMESTAMP\_NTZ | Date when latest payment event has happened. |
| timezone | VARCHAR | Timezone in which the session happened. |
| merchant\_id | VARCHAR | Unique identifier of the merchant. |
| workspace\_id | VARCHAR | Workspace identifier mapped from the merchant, used for Payrails reporting. |
| payrails\_payment\_id | VARCHAR | Unique identifier of the Payment in Payrails. |
| payrails\_execution\_id | VARCHAR | Unique identifier of the execution. |
| holder\_id | VARCHAR | ID of the payer (holder). |
| merchant\_reference | VARCHAR | Payment reference provided by the merchant. |
| provider\_name | VARCHAR | Provider who processed the payment. |
| provider\_account\_name | VARCHAR | Provider account display name. |
| provider\_reference | VARCHAR | Unique identifier of the Payment in an external system, e.g. PSP. |
| is\_zero\_auth | BOOLEAN | If payment is zero authorization. |
| status | VARCHAR | Final status of the payment. |
| is\_authorized | BOOLEAN | If payment was authorized. |
| authorization\_failure\_result | VARCHAR | Transformed authorization failure response code, provides more details on failed transactions than status. |
| processing\_type | VARCHAR | Payment processing type, values: Regular, Subscription, CardOnFile, UnscheduledCardOnFile |
| currency | VARCHAR | Three-letter ISO currency code, in uppercase. |
| amount | NUMBER | Payment amount in local currency. |
| captured\_amount | NUMBER | Amount that was captured from the Payment in local currency. If no capture is initiated for the payment, the value will be 0 until a successful capture occurs. |
| refunded\_amount | NUMBER | Amount that was refunded from the Payment in local currency. If multiple partial refunds have been made, this will be the sum of them. If no refund is initiated for the payment, the value will remain 0 until a successful refund occurs. |
| has\_threeds | BOOLEAN | Whether payment went through 3ds. |
| threeds\_id | VARCHAR | Unique identifier of the associated 3ds object. |
| eci | VARCHAR | Electronic commerce indicator |
| payment\_method\_type | VARCHAR | Payment method type, values: card, easypaisa, jazzCash, fawryPay, etc. |
| bin | NUMBER | First 6-8 digits of the Card number. Also known as IIN (Issuer Identification Number). Card only. |
| issuer | VARCHAR | Card issuing bank. |
| issuer\_country\_code | VARCHAR | ISO alpha-2 issuer country. |
| issuer\_country\_name | VARCHAR | English name of the country of the bank or institution that issued the card. Card only. |
| card\_network | VARCHAR | Card network that supports the card, e.g. Visa, Mastercard, American Express. Card only. |
| card\_local\_network | VARCHAR | Card local network that supports the card, e.g. CartesBancaires, Dankort, Mada, Bancontact. |
| card\_segment | VARCHAR | Segment of the card, e.g. gold, black, business. Card only. |
| card\_type | VARCHAR | Card type, values: credit, debit, notset, prepaid. |
| card\_type\_details | VARCHAR | More information about the card type, e.g. personal, commercial. Card only. |
| token\_id | VARCHAR | Instrument Token ID related to the payment. |
| token\_type | VARCHAR | Type of the token, values: network, vault, psp, networkOffers. |
| error\_reason\_source | VARCHAR | Source of the error reason (null if payment was successful). |
| error\_reason\_detail | VARCHAR | Details of the error reason (null if payment was successful). |
| error\_reason\_result | VARCHAR | End result of the error reason (null if payment was successful). |
| error\_reason\_category | VARCHAR | Category of error reason (null if payment was successful). |
| error\_detail | VARCHAR | Details of the error (null if payment was successful). |
| is\_success | BOOLEAN | Whether execution action was succeeded. |
| milliseconds\_to\_completion | NUMBER | Time from request to completion in milliseconds. |
| raw\_psp\_response | VARIANT | PSP result details for Authorize operation. |
| meta | VARIANT | Complete merchant's metadata details (ex: customer, order, risk, tags, etc.). |


## Related topics

- [Reports](/docs/analytics-and-reporting/reports/index.md)
- [Transactions report](/docs/analytics-and-reporting/reports/transactions.md)
- [Disputes report](/docs/analytics-and-reporting/reports/disputes.md)