CreditNoteLineItems
Query the available Credit Note line items in Stripe.
Table Specific Information
Select
The connector uses the Stripe API to filter the results by the following column and operator:
- CreditNoteId supports the = operator.
- AccountId supports the = operator.
The rest of the filter is executed client-side within the connector.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
SELECT * FROM CreditNoteLineItems SELECT * FROM CreditNoteLineItems WHERE CreditNoteId = 'cn_1N8iWQ2eZvKYlo2CnrPpfSnK'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID of Credit Note LineItem. | |
| CreditNoteId | String |
CreditNotes.Id | Credit Note Id. |
| Amount | Integer | The integer amount in cents representing the gross amount being credited for this line item, excluding (exclusive) tax and discounts. | |
| AmountExcludingTax | Integer | The integer amount in cents representing the amount being credited for this line item, excluding all tax and discounts. | |
| Description | String | Description of the item being credited. | |
| DiscountAmounts | String | The amount of discount calculated per discount for this line item. | |
| InvoiceLineItem | String | ID of the invoice line item being credited. | |
| Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| Quantity | Integer | The number of units of product being credited. | |
| TaxAmounts | String | The amount of tax calculated per tax rate for this line item. | |
| TaxRates | String | The tax rates which apply to the line item. | |
| Type | String | The type of the credit note line item, one of invoice_line_item or custom_line_item. When the type is invoice_line_item there is an additional invoice_line_item property on the resource the value of which is the id of the credited line item on the invoice. | |
| UnitAmount | Integer | The cost of each unit of product being credited. | |
| UnitAmountDecimal | Decimal | Same as unit_amount, but contains a decimal value with at most 12 decimal places. | |
| UnitAmountExcludingTax | Decimal | The amount in cents representing the unit amount being credited for this line item, excluding all tax and discounts. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get orders for. |