PayoutsReconciliationSummaryForASinglePayoutReport
Payouts reconciliation summary for a single payout in Stripe.
Table Specific Information
It is used to query the Payouts reconciliation summary for a single payout in Stripe.
Note: It requires a live-mode API key which we can set using the LiveAPIKey connection property. The view is not visible without mentioning the LiveAPIKey.
Creating the Report
To create a report we need to pass some required parameters.
- ParametersPayout
To create a report we can also pass some 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
To query the report we can try the below queries.
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 | 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. |