CreditNoteLineItems
Returns the line items associated with a credit note, including credited amounts, quantities, discount, and tax details.
View-Specific Information
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| CreditNoteId | = |
| AccountId | = |
You can select from CreditNoteLineItems with the following queries:
SELECT * FROM CreditNoteLineItems WHERE CreditNoteId = 'cn_1N8iWQ2eZvKYlo2CnrPpfSnK'
SELECT * FROM CreditNoteLineItems WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the credit note line item. | |
| CreditNoteId | String |
CreditNotes.Id | The Id of the credit note. |
| Amount | Integer | The integer amount in cents representing the gross amount being credited for this line item, excluding exclusive 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 | The Id of the invoice line item being credited. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Returns true if the object exists in live mode and false if the object exists in test mode. | |
| Quantity | Integer | The number of units of product being credited. | |
| 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 whose value is the Id of the credited line item on the invoice. | |
| UnitAmount | Integer | The cost of each unit of product being credited. | |
| UnitAmountDecimal | Decimal | The same value as unit_amount, but contains a decimal value with at most 12 decimal places. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to the line item object. | |
| PretaxCreditAmountsAggregate | String | Pre-tax credit amounts for this line item. | |
| TaxesAggregate | String | The aggregate amounts calculated per tax rate for this line item. |
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 line items for. |