JDBC Driver for Stripe

Build 22.0.8462

ItemizedEndingBalanceReconciliationReport

Query the Itemized ending balance change from activity report in Stripe.

Table Specific Information

It is used to query the Itemized ending balance change from activity report in Stripe.

Note: It requires a live-mode API key which we can set using the LiveAPIKey connection property. The view will not be visible without mentioning the LiveAPIKey.

Creating the Report

To create a report we need to pass some required parameters.

  • ParametersIntervalEnd

To create a report we can also pass some optional parameters.

  • ParametersColumns
  • ParametersCurrency
  • ParametersTimezone
  • ParametersReportingCategory

// This will first create the new Report and display that report. Report Creation takes time once it is created will display the report.
SELECT * FROM ItemizedEndingBalanceReconciliationReport WHERE ParametersIntervalEnd = '2020-12-28' 

Select

To query the report we can try the below queries.

SELECT * FROM ItemizedEndingBalanceReconciliationReport WHERE Id IN (SELECT Id FROM Reports WHERE report_type = 'ending_balance_reconciliation.itemized.4')
SELECT * FROM ItemizedEndingBalanceReconciliationReport WHERE Id IN ('frr_1I54dkATXQzBWNrlnaavpHGe', 'frr_1I3I59ATXQzBWNrl9VcczrDY')// This will show multiple reports
SELECT * FROM ItemizedEndingBalanceReconciliationReport WHERE Id = 'frr_1I480mATXQzBWNrlYQRaLQ9x' // This will show a respective report

Columns

Name Type References Description
Balance_Transaction_Id String Unique identifier for the balance transaction.
Created_UTC Datetime Time at which the balance transaction was created. Dates in UTC.
Created Datetime Time at which the balance transaction was created. Dates in the requested timezone, or UTC if not provided.
Available_On_UTC Datetime The date the balance transactions net funds will become available in the Stripe balance. Dates in UTC.
Available_On Datetime The date the balance transactions net funds will become available in the Stripe balance. Dates in the requested timezone, or UTC if not provided.
Currency String Three-letter ISO code for the currency in which gross, fee and net are defined.
Gross Decimal Gross amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Fee Decimal Fees paid for this transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Net Decimal Net amount of the transaction. Expressed in major units of the currency (e.g. dollars for USD, yen for JPY).
Reporting_Category String Reporting Category is a new categorization of balance transactions, meant to improve on the current type field.
Source_Id String The Stripe object to which this transaction is related.
Description String An arbitrary string attached to the balance transaction. Often useful for displaying to users.
Customer_Facing_Amount Decimal For transactions associated with charges or refunds, the amount of the original charge or refund.
Customer_Facing_Currency String For transactions associated with charges or refunds, the three-letter ISO code for the currency for customer_facing_amount.
Automatic_Payout_Id String ID of the automatically created payout associated with this balance transaction (only set if your account is on an automatic payout schedule).
Automatic_Payout_Effective_At_UTC Datetime The date we expect this automatic payout to arrive in your bank account, in UTC. This is also when the paid-out funds are deducted from your Stripe balance.
Automatic_Payout_Effective_At Datetime The date we expect this automatic payout to arrive in your bank account, in the requested timezone, or UTC if not provided. This is also when the paid-out funds are deducted from your Stripe balance.
Customer_Id String The unique ID of the related customer, if any.
Customer_Email String Email address of the customer, if any, associated with this balance transaction.
Customer_Name String Name of the customer, if any, associated with this balance transaction.
Customer_Description String Description provided when creating the customer, often used to store the customer name.
Shipping_Address_Line1 String First line of the shipping address associated with this charge, if any
Shipping_Address_Line2 String Second line of the shipping address associated with this charge, if any
Shipping_Address_City String City of the shipping address associated with this charge, if any
Shipping_Address_State String State of the shipping address associated with this charge, if any
Shipping_Address_Postal_Code String Postal code of the shipping address associated with this charge, if any
Shipping_Address_Country String Country of the shipping address associated with this charge, if any
Charge_Id String Unique identifier for the original charge associated with this balance transaction. Available for charges, refunds and disputes.
Payment_Intent_Id String The unique ID of the related Payment Intent, if any.
Charge_Created_UTC Datetime Creation time of the original charge associated with this balance transaction. Available for charges, refunds and disputes. For charges that were separately authorized and captured, this is the authorization time. Dates in UTC.
Charge_Created Datetime Creation time of the original charge associated with this balance transaction. Available for charges, refunds and disputes. For charges that were separately authorized and captured, this is the authorization time. Dates in the requested timezone, or UTC if not provided.
Invoice_Id String Unique ID for the invoice associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing invoice.
Subscription_Id String Unique ID for the subscription associated with this balance transaction. Available for charges, refunds, and disputes made in connection with a Stripe Billing subscription.
Payment_Method_Type String The type of payment method used in the related payment.
Card_Brand String Card brand, if applicable.
Card_Funding String Card funding type, if applicable.
Card_Country String Two-letter ISO code representing the country of the card.
Statement_Descriptor String The dynamic statement descriptor or suffix specified when the related charge was created.
Dispute_Reason String Reason given by cardholder for dispute.
Connected_Account_Id String For Stripe Connect activity related to a connected account, the unique ID for the account.
Connected_Account_Name String For Stripe Connect activity related to a connected account, the name of the account.
Connected_Account_Country String For Stripe Connect activity related to a connected account, the two-letter ISO code representing the country of the account.
Regulatory_Tag String ??An identifier reflecting the classification of this transaction according to local regulations, if applicable. Accounts with automatic payouts enabled receive a separate payout for each regulatory tag. ??This column is only populated for Brazilian accounts.
Payment_Metadata String Metadata associated with the related PaymentIntent, if any. If no PaymentIntent metadata exists, metadata from any related charge object will be returned. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys.
Refund_Metadata String Metadata associated with the related refund object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys.
Transfer_Metadata String Metadata associated with the related transfer object, if any. API requests including this column must specify a metadata key in brackets. This column can be specified multiple times to retrieve data from additional metadata keys.
Id String

Reports.Id

Unique identifier for the reports run object.
ParametersIntervalEnd Datetime Ending timestamp of data to be included in the report run (exclusive).
ParametersColumns String The set of output columns requested for inclusion in the report run.
ParametersCurrency String Currency of objects to be included in the report run.
ParametersReportingCategory String Category of balance transactions to be included in the report run.
ParametersTimezone String Defaults to Etc/UTC. The output timezone for all timestamps in the report.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462