CheckoutSessionLineItems
Returns the line items associated with a Checkout Session, including pricing, quantity, 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 |
| CheckoutSessionId | = |
You can select from CheckoutSessionLineItems with the following queries:
SELECT * FROM CheckoutSessionLineItems WHERE CheckoutSessionId = 'cs_test_c1niqxjO1iwaT5asACq3TXhErRm3T7iuPV6AEbcP5ReTfutnEloisMpGol'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the Checkout Session line item. | |
| CheckoutSessionId | String | The Id of the Checkout Session. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. | |
| AmountDiscount | Integer | Total discount amount applied. If no discounts were applied, defaults to 0. | |
| AmountTax | Integer | Total tax amount applied. If no tax was applied, defaults to 0. | |
| AmountSubtotal | Integer | Total before any discounts or taxes are applied. | |
| AmountTotal | Integer | Total after discounts and taxes. | |
| Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| Description | String | An arbitrary string attached to the object, often useful for displaying to users. Defaults to the product name. | |
| Discounts | String | DEPRECATED. The discounts applied to the line item. | |
| PriceId | String | The unique identifier for the price object. | |
| PriceObject | String | The string representing the object's type. Objects of the same type share the same value. | |
| PriceActive | Boolean | Indicates whether the price can be used for new purchases. | |
| PriceBillingScheme | String | Describes how to compute the price per period. | |
| PriceCreated | Datetime | The time at which the object was created. Measured in seconds since the Unix epoch. | |
| PriceCurrency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| PriceCustomUnitAmountMaximum | Integer | The maximum unit amount the customer can specify for this item. | |
| PriceCustomUnitAmountMinimum | Integer | The minimum unit amount the customer can specify for this item. | |
| PriceCustomUnitAmountPreset | Integer | The starting unit amount which can be updated by the customer. | |
| PriceLiveMode | 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. | |
| PriceLookupKey | String | A lookup key used to retrieve prices dynamically from a static string. This may be up to 200 characters. | |
| PriceMetadata | String | The set of key-value pairs that you can attach to the price object. | |
| PriceNickName | String | A brief description of the price, hidden from customers. | |
| PriceProduct | String | The Id of the product this price is associated with. | |
| PriceRecurringAggregateUsage | String | DEPRECATED. Specifies a usage aggregation strategy for prices where usage_type is metered. | |
| PriceRecurringInterval | String | The frequency at which a subscription is billed. | |
| PriceRecurringIntervalCount | Integer | The number of intervals between subscription billings. | |
| PriceRecurringUsageType | String | Configures how the quantity per period is determined. | |
| PriceTaxBehaviour | String | Specifies the tax behavior for the price. This is only required if a default tax behavior was not provided in the Stripe Tax settings. | |
| PriceTiers | String | Each element represents a pricing tier. | |
| PriceTiersMode | String | Defines whether the tiering price is graduated or volume-based. | |
| PriceTransformQuantityDivideBy | Integer | Divide usage by this number. | |
| PriceTransformQuantityRound | String | Specifies whether to round the result up or down after division. | |
| PriceType | String | Specifies whether the price is for a one-time purchase or a recurring (subscription) purchase, either one_time or recurring. | |
| PriceUnitAmount | Integer | The unit amount in cents to be charged, represented as a whole integer if possible. | |
| PriceUnitAmountDecimal | String | The unit amount in cents to be charged, represented as a decimal string with at most 12 decimal places. | |
| Quantity | Integer | The quantity of products being purchased. | |
| Taxes | String | The taxes applied to the line item. | |
| PriceRecurringMeter | String | The meter tracking the usage of a metered price. |