InvoicePayments

Get the available invoice payment objects in Stripe.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following columns and operators:

Id supports the following operator: =.
InvoiceId supports the following operator: =.
Status supports the following operator: =.

The rest of the filter is executed client-side within the 本製品.

You can select from InvoicePayments with the following queries:

    SELECT * FROM InvoicePayments WHERE Id = 'inpay_1RMiwb02nMQhszwxxSLgJ9XU'
    SELECT * FROM InvoicePayments WHERE InvoiceId = 'in_1RMivP02nMQhszwx2UyrvB3x'
    SELECT * FROM InvoicePayments WHERE Status = 'open'

Columns


Name	Type	References	Description
Id [KEY]	String		Unique identifier for the InvoicePayment object.
InvoiceId	String	Invoices.Id	The invoice that was paid.
AmountPaid	Integer		Amount that was actually paid for this invoice, in cents. This field is null until the payment is paid. This amount can be less than the amount_requested if the PaymentIntent’s amount_received is not sufficient to pay all of the invoices that it is attached to.
AmountRequested	Integer		Amount intended to be paid toward this invoice, in cents.
IsDefault	Boolean		Stripe automatically creates a default InvoicePayment when the invoice is finalized, and keeps it synchronized with the invoice’s amount_remaining. The PaymentIntent associated with the default payment can’t be edited or canceled directly.
PaymentType	String		Type of payment object associated with this invoice payment. 使用できる値は次のとおりです。charge, payment_intent
PaymentIntentId	String	PaymentIntent.Id	ID of the PaymentIntent associated with this payment when type is payment_intent. Note: This property is only populated for invoices finalized on or after March 15th, 2019.
PaymentChargeId	String	Charges.Id	ID of the successful charge for this payment when type is charge.
Status	String		The status of the payment, one of open, paid, or canceled. 使用できる値は次のとおりです。canceled, open, paid
Created	Datetime		Time at which the object was created. Measured in seconds since the Unix epoch.
Currency	String		Three-letter ISO currency code, in lowercase. Must be a supported currency.
Livemode	Boolean		Has the value true if the object exists in live mode or the value false if the object exists in test mode.
StatusTransitionsCanceledAt	Datetime		The time that the payment was canceled.
StatusTransitionsPaidAt	Datetime		The time that the payment succeeded.
Object	String		String representing the object's type. Objects of the same type share the same value.

SSIS Components for Stripe

InvoicePayments

Table Specific Information

Select

Columns