Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ODBC Driver for Stripe Views


Name	Description
ApplicationFeeRefunds	Returns the refunds applied to application fees previously collected, including the refund amount, currency, and associated balance transaction.
ApplicationFees	Returns the application fees that Connect platforms collect from connected accounts, including the fee amount, currency, and associated charge.
Authorizations	Returns a list of Issuing Authorization objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.
AvailableBalance	Returns the available balance in Stripe, including the amount, currency, and a breakdown by source type.
BalanceChangeFromActivitySummaryReport	Returns the balance change from activity summary report in Stripe, including the gross, fee, and net amounts grouped by reporting category.
BalanceSummaryReport	Returns the balance summary report in Stripe, including the net amount and currency for each balance category.
BalanceTransactions	Returns the balance transactions that contribute to your Stripe balance, including the amount, fees, net amount, and source of each transaction.
Cardholders	Returns a list of Issuing Cardholder objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.
CashBalance	Returns the cash balance for a customer, including the available balances by currency and reconciliation settings.
CashBalanceTransactions	Returns the transactions that change a customer's cash balance in Stripe, including funding, applied payments, refunds, and transfers.
CheckoutSessionLineItems	Returns the line items associated with a Checkout Session, including pricing, quantity, discount, and tax details.
ClimateProducts	Returns Climate products available for carbon removal, including pricing, delivery year, and supplier details.
ClimateSuppliers	Returns carbon removal suppliers that fulfill Climate orders, including supplier name, locations, and removal pathway details.
CountrySpecs	Returns the country specifications that determine how accounts can be configured, including supported currencies, payment methods, and verification requirements.
CreditNoteLineItems	Returns the line items associated with a credit note, including credited amounts, quantities, discount, and tax details.
CreditNoteLineItemsDiscounts	Returns the discounts applied to credit note line items, including coupon, promotion code, and discount amount details.
CreditNotePreviewLineItems	Returns a preview of the line items that would appear on a credit note before it is created, including amounts, discounts, and tax details.
CryptoOnrampQuotes	DEPRECATED. Returns Crypto Onramp Quote objects, including source amounts, currencies, and destination network quotes.
CustomerBalanceTransactions	Returns the transactions that updated a customer's balance, including transaction amounts, types, and related invoice and credit note details.
CustomerSubscriptions	Returns the subscriptions associated with a customer, including plan, billing, and tax details.
EarlyFraudWarning	Returns early fraud warnings reported by card issuers, including the associated charge, payment intent, and fraud type details.
EndingBalanceReconciliationSummaryReport	Returns the ending balance reconciliation summary report, including transaction counts and gross, fee, and net amounts grouped by reporting category.
Events	Returns events generated by account activity, including the event type, associated object, and request details.
FileLinks	Returns publicly accessible links to files, including their expiration, target file, and download URL details.
Files	Returns files hosted on Stripe's servers, including their purpose, type, size, and download URL details.
InvoiceDiscounts	Returns the discounts applied to invoices, including coupon, promotion code, and discount period details.
InvoiceItemDiscounts	Returns the discounts applied to invoice items, including coupon, promotion code, and discount period details.
InvoiceLineItemDiscounts	Returns the discounts applied to invoice line items, including coupon, promotion code, and discount period details.
InvoiceLineItems	Returns the line items of invoices, including their amount, billing period, pricing, and applied discount details.
InvoicePayments	Returns invoice payments, including the associated invoice, paid and requested amounts, payment object, and status details.
InvoiceRenderingTemplates	Returns invoice rendering templates, including their nickname, status, and version details.
IssuingCards	Returns issued cards, including cardholder, spending control, shipping, and wallet details.
IssuingDisputes	Returns issuing disputes, including the disputed amount, evidence, status, and associated transaction details.
ItemizedBalanceChangeFromActivityReport	Returns the itemized balance change from activity report, including transaction amounts, fees, customer, charge, and payout details.
ItemizedEndingBalanceReconciliationReport	Returns the itemized ending balance reconciliation report, including transaction amounts, fees, customer, charge, and payout details.
ItemizedPayoutReconciliationReport	Returns the itemized payout reconciliation report, including transaction amounts, fees, customer, charge, and payout details.
ItemizedPayoutsReport	Returns the itemized payouts report, including transaction amounts, payout status, and balance transaction details.
ItemizedReconciliationForASinglePayoutReport	Returns the itemized reconciliation report for a single payout, including transaction, charge, and customer details.
Mandates	Retrieves a Mandate object.
PaymentLinkLineItems	Returns the line items associated with a payment link, including quantity, amounts, and price details.
PaymentMethodDomains	Lists the details of existing payment method domains.
PayoutsReconciliationSummaryForASinglePayoutReport	Returns the payouts reconciliation summary for a single payout, including transaction counts and gross, fee, and net totals by reporting category.
PayoutsReconciliationSummaryReport	Returns the payouts reconciliation summary report, including transaction counts and gross, fee, and net totals by reporting category.
PayoutsSummaryReport	Returns the payouts summary report, including transaction counts and gross, fee, and net totals by reporting category.
PendingBalance	Returns the pending balance, including amounts by currency and a breakdown by source type.
Reports	Represents report run objects, each of which is an instance of a report type generated with specific run parameters, including run status, result file details, and reporting parameters. Uses the V1 endpoint.
ReportTypes	Returns the available report types, including data availability ranges, default columns, and version details.
Reviews	Returns radar reviews, including the charge or payment intent under review, the reason it was opened or closed, and the originating IP address and session details.
SetupAttempts	Returns the setup attempts associated with a given setup intent, including payment method details, confirmation results, and any setup errors encountered.
SetupIntents	Returns setup intents, including payment method configuration, the latest setup attempt, and any setup errors encountered.
SubscriptionSchedules	Returns subscription schedules, including phase configurations, default settings, and lifecycle status details.
TaxCodes	Returns the tax codes that classify goods and services for tax purposes, including the code name and description.
ThinEvents	Returns thin events from the last thirty days, including the event type, related object reference, and the request that triggered the event. Query by the event Id or by the Id of the object on which the events occurred.
Transactions	Returns issuing transactions, including the transaction amount, associated card and cardholder, merchant data, and purchase details. The transactions are sorted in descending order by creation date, with the most recently created transaction appearing first.