CreditNotePreviewLineItems
Returns the available Credit Note preview line items 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 |
| InvoiceId | = |
| AccountId | = |
You can select from CreditNotePreviewLineItems with the following queries:
SELECT * FROM CreditNotePreviewLineItems WHERE InvoiceId = 'in_1PDhVw2eZvKYlo2C6J4CKKUd'
SELECT * FROM CreditNotePreviewLineItems WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
SELECT * FROM CreditNotePreviewLineItems WHERE Amount > 10000
SELECT * FROM CreditNotePreviewLineItems WHERE Currency = 'usd'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the Credit Note Preview LineItem. | |
| InvoiceId | String |
Invoices.Id | The Id of the invoice. |
| Amount | Integer | The integer amount in cents representing the total amount of the credit note. | |
| CreditAmount | Integer | The integer amount in cents representing the amount to credit the customer's balance, which is automatically applied to their next invoice. | |
| AmountShipping | Integer | The shipping amount. | |
| Created | Datetime | The date of creation. | |
| Currency | String | The currency name. | |
| Customer | String | The Id of the customer. | |
| CustomerBalanceTransaction | String | The customer balance transaction. | |
| DiscountAmounts | String | The discount amounts. | |
| EffectiveAt | Datetime | The date when this credit note is in effect. Same as created unless overwritten. When defined, this value replaces the system-generated Date of issue printed on the credit note PDF. | |
| Lines | String | Line items that make up the credit note. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| Memo | String | The credit note's memo appears on the credit note PDF. | |
| Metadata | String | Set of key-value pairs that you can attach to an object. | |
| Number | String | The number. | |
| OutOfBandAmount | Integer | The integer amount in cents representing the amount that is credited outside of Stripe. | |
| String | The PDF URL. | ||
| Reason | String | The reason for issuing this credit note, one of duplicate, fraudulent, order_change, or product_unsatisfactory. | |
| Refund | String | The Id of an existing refund to link this credit note to. | |
| RefundAmount | Integer | The integer amount in cents representing the amount to refund. If set, a refund is created for the charge associated with the invoice. | |
| ShippingCost | String | When shipping_cost contains the shipping_rate from the invoice, the shipping_cost is included in the credit note. | |
| Status | String | The status. | |
| Subtotal | Integer | The subtotal. | |
| SubtotalExcludingTax | Integer | The subtotal excluding tax. | |
| TaxAmounts | String | The tax amounts. | |
| Total | Integer | The total. | |
| TotalExcludingTax | Integer | The total excluding tax. | |
| Type | String | The type. | |
| VoidedAt | Datetime | The date and time at which the credit note was voided. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get credit note preview line items for. |