Charges

Create, update, and query the available Charges in Stripe.

Table Specific Information

In this table only select, insert, and update operations are allowed.

Select

Server-Side Query Support

The driver will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the driver.

Id, Currency, CustomerId, Created, and Source support the following operators: <,>>=,<,<=,=.

The provider supports all columns to be used as criteria in the WHERE clause of SELECT statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

-a Charge by specifying its Id:

SELECT * FROM Charges WHERE Id = 'ch_12345678'

-Charges that belong to a Customer:

SELECT * FROM Charges WHERE CustomerId = 'cus_12345678'

-Charges created after a specific date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Charges WHERE Created > '2016-01-03'

Insert

Amount, Currency and Customer or Source columns are required to charge a credit card.

INSERT INTO Charges (Amount, Currency, CustomerId) VALUES (2000, 'usd', 'cus_12345678')

Update

To modify a Charge, provide an Id.

UPDATE Charges SET Description='updated charge' WHERE Id = 'ch_17rPMOATXQzBWNrliIRnfI5B'

Delete

Delete is not supported.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the charge.
Amount	Integer	False		The amount of the charge.
Currency	String	False		The currency of the charge.
CustomerId	String	False		The customer Id of the charge.
AmountRefunded	Integer	True		The amount in cents refunded.
ApplicationFee	String	False		The application fee (if any) for the charge.
ApplicationFeeAmount	Integer	False		The amount of the application fee (if any) for the charge.
BalanceTransaction	String	False		The Id of the balance transaction that describes the impact of this charge on your account balance .
BillingDetailsAggregate	String	True		Billing information associated with the payment method at the time of the transaction.
Captured	Boolean	False		Whether the charge was created without capturing.
CalculatedStatementDescriptor	String	True		The full statement descriptor that is passed to card networks, and that is displayed on your customers' credit card and bank statements. Allows you to see what the statement descriptor looks like after the static and dynamic portions are combined.
Created	Datetime	True		The datetime the charge was created.
Description	String	False		The description of the charge.
Destination	String	False		The account (if any) the charge was made on behalf of.
Disputed	Boolean	False		Whether the charge has been disputed.
DisputeId	String	True		The ID of the associated dispute.
FailureCode	String	False		The error code explaining the reason for the charge failure if available.
FailureMessage	String	False		The message to the user further explaining the reason for the charge failure if available.
FraudDetailsAggregate	String	False		Information on fraud assessments for the charge.
Invoice	String	False		The Id of the invoice this charge is for if one exists.
Livemode	Boolean	False		Whether the charge is in live mode.
MetadataAggregate	String	False		The charge metadata object.
Order	String	True		The Id of the order this charge is for if one exists.
OutcomeAggregate	String	True		Details about whether the payment was accepted, and why. See understanding declines for details.
Paid	Boolean	True		If the charge succeeded or was successfully authorized for later capture.
PaymentIntent	String	True		ID of the PaymentIntent associated with this charge, if one exists.
PaymentMethod	String	True		ID of the payment method used in this charge.
PaymentMethodDetailsAggregate	String	True		Details about the payment method at the time of the transaction.
ReceiptEmail	String	False		The email address that the receipt for this charge was sent to.
ReceiptNumber	String	False		The transaction number that appears on email receipts sent for this charge.
ReceiptURL	String	False		This is the URL to view the receipt for this charge. The receipt is kept up-to-date to the latest state of the charge, including any refunds. If the charge is for an Invoice, the receipt will be stylized as an Invoice receipt.
Refunded	Boolean	False		Whether or not the charge has been fully refunded.
RefundsAggregate	String	False		The list of refunds that have been applied to the charge.
Review	String	False		ID of the review associated with this charge if one exists.
ShippingAggregate	String	True		Shipping information for the charge.
SourceAggregate	String	False		The source of every charge is a credit or debit card.
SourceTransfer	String	False		The transfer Id that created this charge.
StatementDescriptor	String	False		The extra information about a charge.
Status	String	False		The status of the payment is either succeeded, pending, or failed.
Transfer	String	False		The Id of the transfer to the destination account.
TransferDataAggregate	String	True		An optional dictionary including the account to automatically transfer to as part of a destination charge.
TransferGroup	String	True		A string that identifies this transaction as part of a group.
StatementDescriptorSuffix	String	False		Provides information about the charge that customers see on their statements.
Object	String	False		String representing the object's type. Objects of the same type share the same value.
AmountCaptured	Integer	False		Amount in cents captured
Application	String	False		ID of the Connect application that created the charge.
FailureBalanceTransaction	String	False		ID of the balance transaction that describes the reversal of the balance on your account due to payment failure.
OnBehalfOf	String	False		The account (if any) the charge was made on behalf of without triggering an automatic transfer.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account to get charges for

JDBC Driver for Stripe