JDBC Driver for Stripe

Build 22.0.8462

InvoiceLineItems

Query the available invoices line items in Stripe.

Table Specific Information

Select

Server-Side Query Support

The driver will use 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 driver.

  • InvoiceId support the following operator: =.

The provider supports all columns to be used as criteria in the WHERE clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

-an InvoiceLineItems by specifying its InvoiceId:

SELECT * FROM InvoiceLineItems WHERE InvoiceId = 'in_123456'

Columns

Name Type References Description
Id [KEY] String Unique identifier for the object.
InvoiceId String The Id of the invoice.
Amount Integer The amount, in cents.
AmountExcludingTax Integer The integer amount in cents representing the amount for this line item, excluding all tax and discounts.
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.
Discountable Boolean If true, discounts will apply to this line item. Always false for prorations.
InvoiceItem String The ID of the invoice item associated with this line item if any.
LiveMode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
Metadata String The metadata object.
Object String String representing the object's type. Objects of the same type share the same value.
PeriodEnd Datetime The end of the period, which must be greater than or equal to the start.
PeriodStart Datetime The start of the period..
PriceId String Unique identifier for the price.
PriceObject String String representing the object's type. Objects of the same type share the same value.
PriceActive Boolean Whether the price can be used for new purchases.
PriceBillingScheme String Describes how to compute the price per period.
PriceCreated Datetime 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.
PriceCustomUnitAmount String When set, provides configuration for the amount to be adjusted by the customer during Checkout Sessions and Payment Links.
PriceLiveMode Boolean Has the value true if the object exists in live mode or the value 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 Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.
PriceNickname String A brief description of the price, hidden from customers.
PriceProduct String The ID of the product this price is associated with.
PriceRecurring String The recurring components of a price such as interval and usage_type.
PriceTaxBehavior String Specifies whether the price is considered inclusive of taxes or exclusive of taxes. One of inclusive, exclusive, or unspecified. Once specified as either inclusive or exclusive, it cannot be changed.
PriceTiersMode String Defines if the tiering price should be graduated or volume based. In volume-based tiering, the maximum quantity within a period determines the per unit price. In graduated tiering, pricing can change as the quantity grows.
PriceTransformQuantity String Apply a transformation to the reported usage or set quantity before computing the amount billed. Cannot be combined with tiers.
PriceType String One of one_time or recurring depending on whether the price is for a one-time purchase or a recurring (subscription) purchase.
PriceUnitAmount Integer The unit amount in cents to be charged, represented as a whole integer if possible. Only set if billing_scheme=per_unit.
PriceUnitAmountDecimal Float The unit amount in cents to be charged, represented as a decimal string with at most 12 decimal places. Only set if billing_scheme=per_unit.
Proration Boolean Whether this is a proration.
ProrationDetails String Additional details for proration line items
Quantity Integer The quantity of the subscription, if the line item is a subscription or a proration.
Subscription String The subscription that the invoice item pertains to, if any.
SubscriptionItems String The subscription item that generated this invoice item. Left empty if the line item is not an explicit result of a subscription.
Type String A string identifying the type of the source of this line item, either an invoiceitem or a subscription.
UnitAmountExcludingTax String The amount in cents representing the unit amount for this line item, excluding all tax and discounts.
DiscountAmountsAggregate String The amount of discount calculated per discount for this line item.
TaxAmountsAggregate String The amount of tax calculated per tax rate for this line item.
TaxRatesAggregate String The tax rates which apply to the line item.
DiscountsAggregate String The discounts which apply to the invoice item.

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 invoice line items for

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462