Table: stripe_invoices
This table shows data for Stripe Invoices.
https://stripe.com/docs/api/invoices (opens in a new tab)
The primary key for this table is id. It supports incremental syncs based on the created column.
Columns
Name | Type |
---|---|
_cq_source_name | String |
_cq_sync_time | Timestamp |
_cq_id | UUID |
_cq_parent_id | UUID |
id (PK) | String |
created (Incremental Key) | Timestamp |
account_country | String |
account_name | String |
account_tax_ids | JSON |
amount_due | Int |
amount_paid | Int |
amount_remaining | Int |
amount_shipping | Int |
application | JSON |
application_fee_amount | Int |
attempt_count | Int |
attempted | Bool |
auto_advance | Bool |
automatic_tax | JSON |
billing_reason | String |
charge | JSON |
collection_method | String |
currency | String |
customer | JSON |
customer_address | JSON |
customer_email | String |
customer_name | String |
customer_phone | String |
customer_shipping | JSON |
customer_tax_exempt | String |
customer_tax_ids | JSON |
custom_fields | JSON |
default_payment_method | JSON |
default_source | JSON |
default_tax_rates | JSON |
deleted | Bool |
description | String |
discount | JSON |
discounts | JSON |
due_date | Int |
ending_balance | Int |
footer | String |
from_invoice | JSON |
hosted_invoice_url | String |
invoice_pdf | String |
last_finalization_error | JSON |
latest_revision | JSON |
lines | JSON |
livemode | Bool |
metadata | JSON |
next_payment_attempt | Int |
number | String |
object | String |
on_behalf_of | JSON |
paid | Bool |
paid_out_of_band | Bool |
payment_intent | JSON |
payment_settings | JSON |
period_end | Int |
period_start | Int |
post_payment_credit_notes_amount | Int |
pre_payment_credit_notes_amount | Int |
quote | JSON |
receipt_number | String |
rendering_options | JSON |
shipping_cost | JSON |
shipping_details | JSON |
starting_balance | Int |
statement_descriptor | String |
status | String |
status_transitions | JSON |
subscription | JSON |
subscription_proration_date | Int |
subtotal | Int |
subtotal_excluding_tax | Int |
tax | Int |
test_clock | JSON |
threshold_reason | JSON |
total | Int |
total_discount_amounts | JSON |
total_excluding_tax | Int |
total_tax_amounts | JSON |
transfer_data | JSON |
webhooks_delivered_at | Int |