PaymentIntent
A PaymentIntent guides you through the process of collecting a payment from your customer.
Table Specific Information
Select
The 本製品 uses 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 本製品.
- Id support the following operator: =.
- Amount support the following operator: =.
- Customer support the following operator: =.
- Currency support the following operator: =.
- Metadata support the following operator: =.
- Status support the following operators: =, !=.
- Created support the following operators: =, !=, >, >=, <, <=.
You can select from the PaymentIntent table with the following queries:
SELECT * FROM PaymentLinks WHERE Id = 'pi_3MOZgsSC4snQ4WkO1git8c00' SELECT * FROM PaymentLinks WHERE Customer = 'cus_N8rO0qc7j1SJJ9' SELECT * from PaymentLinks where MetadataAggregate ='{\"key\":\"value\"}'
Insert
Amount and Currency are required to create a PaymentIntent:
INSERT INTO PaymentIntent(Amount,Currency,MetadataAggregate) values (123,'usd','[{\"nsame\":\"asdsa\"}]')
Update
To update a PaymentIntent, specify Id column:
Update PaymentIntent set description ='andasdn' where id = 'pi_3OQAkKCZ8rn6qR6h1liiAZfx'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Unique identifier for the object. | |
Amount | Integer | False |
Amount intended to be collected by this PaymentIntent. | |
AmountDetailsTip | String | True |
Amount Details Tip | |
AmountCapturable | Integer | True |
Amount that can be captured from this PaymentIntent. | |
AmountReceived | Integer | True |
Amount that was collected by this PaymentIntent. | |
ApplicationFeeAmount | Integer | False |
The amount of the application fee (if any) that will be requested to be applied to the payment and transferred to the application owners Stripe account. | |
AutomaticPaymentMethodsEnabled | Boolean | False |
Automatically calculates compatible payment methods | |
AutomaticPaymentMethodsAllowRedirects | String | False |
Controls whether this PaymentIntent will accept redirect-based payment methods. | |
CanceledAt | Datetime | True |
Populated when status is canceled, this is the time at which the PaymentIntent was canceled. | |
CancellationReason | String | True |
Reason for cancellation of this PaymentIntent, either user-provided (duplicate, fraudulent, requested_by_customer, or abandoned) or generated by Stripe internally (failed_invoice, void_invoice, or automatic). | |
CaptureMethod | String | False |
Controls when the funds will be captured from the customers account. | |
ClientSecret | String | True |
The client secret of this PaymentIntent. Used for client-side retrieval using a publishable key. | |
ConfirmationMethod | String | False |
Possible enum values-automatic, manual | |
Created | Datetime | True |
Time at which the object was created. Measured in seconds since the Unix epoch. | |
Currency | String | False |
Three-letter ISO currency code, in lowercase. | |
Application | String | True |
ID of the Connect application that created the PaymentIntent. | |
Customer | String | False |
ID of the Customer this PaymentIntent belongs to, if one exists. | |
LatestCharge | String | True |
The latest charge created by this payment intent. | |
PaymentMethod | String | False |
ID of the payment method used in this PaymentIntent. | |
TransferDataDestination | String | False |
The account (if any) the payment will be attributed to for tax reporting, and where funds from the payment will be transferred to upon payment success. | |
OnBehalfOf | String | False |
The account (if any) for which the funds of the PaymentIntent are intended. | |
Invoice | String | True |
ID of the invoice that created this PaymentIntent, if it exists. | |
Review | String | True |
ID of the review associated with this PaymentIntent, if any. | |
Description | String | False |
An arbitrary string attached to the object. Often useful for displaying to users. | |
LastPaymentErrorCharge | String | True |
For card errors, the ID of the failed charge. | |
LastPaymentErrorCode | String | True |
For some errors that could be handled programmatically, a short string indicating the error code reported. | |
LastPaymentErrorDeclineCode | String | True |
For some errors that could be handled programmatically, a short string indicating the error code reported. | |
LastPaymentErrorDocURL | String | True |
A URL to more information about the error code reported. | |
LastPaymentErrorMessage | String | True |
A human-readable message providing more details about the error. For card errors, these messages can be shown to your users. | |
LastPaymentErrorParam | String | True |
If the error is parameter-specific, the parameter related to the error. For example, you can use this to display a message near the correct form field. | |
LastPaymentErrorPaymentMethod | String | True |
The PaymentMethod object for errors returned on a request involving a PaymentMethod. | |
LastPaymentErrorPaymentMethodType | String | True |
If the error is specific to the type of payment method, the payment method type that had a problem. This field is only populated for invoice-related errors. | |
LastPaymentErrorType | String | True |
The type of error returned. One of api_error, card_error, idempotency_error, or invalid_request_error | |
LiveMode | Boolean | True |
Has the value true if the object exists in live mode or the value true if the object exists in test mode. | |
NextAction | String | True |
If present, this property tells you what actions you need to take in order for your customer to fulfill a payment using the provided source. | |
Object | String | True |
String representing the objects type. Objects of the same type share the same value. | |
PaymentMethodOptions | String | False |
Payment-method-specific configuration for this PaymentIntent. | |
PaymentMethodTypes | String | False |
The list of payment method types (e.g. card) that this PaymentIntent is allowed to use. | |
PaymentMethodConfigurationDetailsId | String | False |
ID of the payment method configuration used. | |
PaymentMethodConfigurationDetailsParent | String | False |
ID of the parent payment method configuration used. | |
ProcessingCard | String | True |
If the PaymentIntents payment_method_types includes card, this hash contains the details on the processing state of the payment. | |
ProcessingType | String | True |
Type of the payment method for which payment is in processing state, one of card. | |
ReceiptEmail | String | False |
Set of key-value pairs that you can attach to an object. | |
MetadataAggregate | String | False |
Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. | |
SetupFutureUsage | String | False |
Indicates that you intend to make future payments with this PaymentIntents payment method. | |
ShippingAddressCity | String | False |
City, district, suburb, town, or village.. | |
ShippingAddressCountry | String | False |
Two-letter country code | |
ShippingAddressline1 | String | False |
Address line 1 | |
ShippingAddressline2 | String | False |
Address line 2 | |
ShippingAddressPostalCode | String | False |
ZIP or postal code. | |
ShippingAddressState | String | False |
State, county, province, or region. | |
ShippingCarrier | String | False |
The delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc. | |
ShippingName | String | False |
Recipient name. | |
ShippingPhone | String | False |
Recipient phone (including extension). | |
ShippingTrackingNumber | String | False |
The tracking number for a physical product, obtained from the delivery service. | |
StatementDescriptor | String | False |
For non-card charges, you can use this value as the complete description that appears on your customers statements. | |
StatementDescriptorSuffix | String | False |
Provides information about a card payment that customers see on their statements. | |
Status | String | True |
Status of this PaymentIntent, one of requires_payment_method, requires_confirmation, requires_action, processing, requires_capture, canceled, or succeeded. Read more about each PaymentIntent status. | |
TransferDataAmount | Integer | False |
Amount intended to be collected by this PaymentIntent. | |
TransferGroup | String | False |
A string that identifies the resulting payment as part of a group. See the PaymentIntents use case for connected accounts for details. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Confirm | Boolean |
Set to true to attempt to confirm this PaymentIntent immediately. This column is supported in INSERT. |
OffSession | Boolean |
Set to true to indicate that the customer isn�t in your checkout flow during this payment attempt and can�t authenticate. This parameter can only be used with confirm=true. This column is supported in INSERT. |
ErrorOnRequiresAction | Boolean |
Set to true to fail the payment attempt if the PaymentIntent transitions into requires_action. Use this parameter for simpler integrations that don�t handle customer actions, such as saving cards without authentication. This parameter can only be used with confirm=true. This column is supported in INSERT. |
Mandate | String |
ID of the mandate that�s used for this payment. This parameter can only be used with confirm=true. This column is supported in INSERT. |
MandateDataCustomerAcceptanceType | String |
The type of customer acceptance information included with the Mandate. One of online or offline. This parameter can only be used with confirm=true. This column is supported in INSERT. 使用できる値は次のとおりです。online, offline |
MandateDataCustomerAcceptanceAcceptedAt | Datetime |
The time at which the customer accepted the Mandate. This parameter can only be used with confirm=true. This column is supported in INSERT. |
MandateDataCustomerAcceptanceOffline | String |
If this is a Mandate accepted offline, this hash contains details about the offline acceptance. This parameter can only be used with confirm=true. This column is supported in INSERT. |
MandateDataCustomerAcceptanceOnlineIPAddress | String |
The IP address from which the Mandate was accepted by the customer. This parameter can only be used with confirm=true. This column is supported in INSERT. |
MandateDataCustomerAcceptanceOnlineUserAgent | String |
The user agent of the browser from which the Mandate was accepted by the customer. This parameter can only be used with confirm=true. This column is supported in INSERT. |
RadarOptionsSession | String |
A Radar Session is a snapshot of the browser metadata and device details that help Radar make more accurate predictions on your payments. This column is supported in INSERT. |
ReturnURL | String |
The URL to redirect your customer back to after they authenticate or cancel their payment on the payment method�s app or site. This parameter can only be used with confirm=true. This column is supported in INSERT. |