CreditNoteLineItems
Query the available Credit Note line items in Stripe.
Table Specific Information
Select
The add-in 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 add-in.
You can select from CreditNoteLineItems with the following queries:
SELECT * FROM CreditNoteLineItems WHERE CreditNoteId = 'cn_1N8iWQ2eZvKYlo2CnrPpfSnK'
SELECT * FROM CreditNoteLineItems WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
SELECT * FROM CreditNoteLineItems WHERE Amount > 5000
SELECT * FROM CreditNoteLineItems WHERE Livemode = true
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. |