SSIS Components for Stripe

Build 24.0.9062

CreditNoteLineItems

Query the available Credit Note line items in Stripe.

Table Specific Information

Select

The 本製品 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 本製品.

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

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

Name Type Description
AccountId String The Id of the connected account to get orders for.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062