InvoicePayments
Returns the available invoice payment objects in Stripe.
View-Specific Information
SELECT
The connector uses the Stripe API to filter the results by the following columns and operators:
| Column | Supported Operators |
| Id | = |
| InvoiceId | = |
| Status | = |
The rest of the filter is executed client-side within the connector.
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.
The allowed values are charge, payment_intent. | |
| PaymentIntentId | String | The 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 | The 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.
The allowed values are canceled, open, paid. | |
| Created | Datetime | The date and 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 | Indicates whether the object exists in live mode. The value is true in live mode and false 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. |