JDBC Driver for Stripe

Build 24.0.9062

PayoutsReconciliationSummaryForASinglePayoutReport

Payouts reconciliation summary for a single payout in Stripe.

Table Specific Information

Used to query the payouts reconciliation summary for a single payout in Stripe.

Note: This report requires a live-mode API key, which can be set using the LiveAPIKey connection property. This view is not accessible without specifying the LiveAPIKey.

Creating the Report

To create a report, the following parameters are required:

  • ParametersPayout

You can also include the following optional parameters:

  • ParametersColumns

//  This first creates the new Report and displays it. Report Creation takes time once it is created will display the report.
SELECT * FROM PayoutsReconciliationSummaryForASinglePayoutReport WHERE ParametersPayout = '12345678'

Select

You can run the following queries to retrieve report data:

SELECT * FROM PayoutsReconciliationSummaryForASinglePayoutReport WHERE Id IN (SELECT Id FROM Reports WHERE report_type = 'payout_reconciliation.by_id.summary.1')
SELECT * FROM PayoutsReconciliationSummaryForASinglePayoutReport WHERE Id IN ('frr_1I54dkATXQzBWNrlnaavpHGe', 'frr_1I3I59ATXQzBWNrl9VcczrDY')// This will show multiple reports
SELECT * FROM PayoutsReconciliationSummaryForASinglePayoutReport WHERE Id = 'frr_1I480mATXQzBWNrlYQRaLQ9x' // This will show a respective report

Columns

Name Type References Description
Reporting_Category String Reporting Category is a new categorization of balance transactions, meant to improve on the current type field.
Currency String Three-letter ISO code for the currency in which gross, fee and net are defined.
Count Int The number of transactions associated with the reporting_category.
Gross Decimal Sum of the gross amounts of the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Fee Decimal Sum of the fees paid for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Net Decimal Sum of the net amounts for the transactions associated with the reporting_category. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Id [KEY] String

Reports.Id

Unique identifier for the reports run object.
ParametersColumns String The set of output columns requested for inclusion in the report run.
ParametersPayout String

Payouts.Id

Payout ID by which to filter the report run.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062