InvoiceLineItemDiscounts

Get the available discounts from invoices line items in Stripe.

Table Specific Information

Select

Server-Side Query Support

The connector 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 connector.

InvoiceId supports the following operator: =.
AccountId supports the following operator: =.

You can select from InvoiceLineItemDiscounts with the following queries:

    SELECT * FROM InvoiceLineItemDiscounts WHERE Id = 'discount_1GhPzLJXTn'
    SELECT * FROM InvoiceLineItemDiscounts WHERE CustomerId = 'cus_ABC123'
    SELECT * FROM InvoiceLineItemDiscounts WHERE CouponPercentOff > 20.0
    SELECT * FROM InvoiceLineItemDiscounts WHERE CouponValid = true
    SELECT * FROM InvoiceLineItemDiscounts WHERE Start >= '2024-01-01'

Columns


Name	Type	References	Description
Id [KEY]	String		The Id of the discount object.
InvoiceId	String		The Id of the invoice.
CustomerId	String		The Id of the customer.
Start	Datetime		Date that the coupon was applied.
End	Datetime		If the coupon has a duration of repeating, the date that this discount will end. If the coupon has a duration of once or forever, this attribute will be null.
CouponId	String		The Id of the coupon.
CouponAmountOff	Integer		Amount (in the currency specified) that is taken off the subtotal of any invoices for this customer.
CouponCurrency	String		If amount_off has been set, the three-letter ISO code for the currency of the amount to take off.
CouponName	String		Name of the coupon displayed to customers on, for instance, invoices or receipts.
CouponCreatedAt	Datetime		The creation date.
CouponDuration	String		Describes how long a customer who applies this coupon will get the discount. One of forever, once, and repeating.
CouponDurationInMonths	Integer		If duration is repeating, the number of months the coupon applies. Null if coupon duration is forever or once.
CouponPercentOff	Decimal		Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with a percent_off of 50 will make a $100 invoice $50 instead.
CouponRedeemBy	Datetime		Date after which the coupon can no longer be redeemed.
CouponTimesRedeemed	Integer		Number of times this coupon has been applied to a customer.
CouponValid	Boolean		Taking account of the above properties, whether this coupon can still be applied to a customer.
CouponMaxRedemptions	Integer		Maximum number of times this coupon can be redeemed, in total, across all customers, before it is no longer valid.
PromotionCode	String		The promotion code applied to create this discount.
Subscription	String		The subscription that this coupon is applied to, if it is applied to a particular subscription.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。