InvoicePayments
Returns invoice payments, including the associated invoice, paid and requested amounts, payment object, and status details.
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 | The unique identifier for the invoice payment object. | |
| InvoiceId | String |
Invoices.Id | The Id of the invoice that was paid. |
| AmountPaid | Integer | The 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 payment intent's amount_received is not sufficient to pay all of the invoices that it is attached to. | |
| AmountRequested | Integer | The amount intended to be paid toward this invoice, in cents. | |
| IsDefault | Boolean | Indicates whether this is the default invoice payment. Stripe automatically creates a default invoice payment when the invoice is finalized and keeps it synchronized with the invoice's amount_remaining. The payment intent associated with the default payment cannot be edited or canceled directly. | |
| PaymentType | String | The type of payment object associated with this invoice payment.
The allowed values are charge, payment_intent. | |
| PaymentIntentId | String | The Id of the payment intent associated with this payment when the type is payment_intent. 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 the type is charge. |
| Status | String | The status of the payment, such as open, paid, or canceled.
The allowed values are canceled, open, paid. | |
| Created | Datetime | The time at which the object was created, measured in seconds since the Unix epoch. | |
| Currency | String | The three-letter ISO currency code, in lowercase. It must be a supported currency. | |
| Livemode | Boolean | Indicates whether the object exists in live mode, which is true in live mode and false in test mode. | |
| StatusTransitionsCanceledAt | Datetime | The time at which the payment was canceled. | |
| StatusTransitionsPaidAt | Datetime | The time at which the payment succeeded. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. |