id🔑
account_id ➤ ACCOUNT
balance_transaction_id ➤ BALANCE_TRANSACTION
charge_id ➤ CHARGE
originating_transaction_id ➤ CHARGE
amount
amount_refunded
application
created
currency
livemode
refundeds
APPLICATION_FEE ⇱
id🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
card_id ➤ CARD
bank_account_id ➤ BANK_ACCOUNT
connected_account_id ➤ ACCOUNT
customer_id ➤ CUSTOMER
destination_id ➤ ACCOUNT
invoice_id ➤ INVOICE
on_behalf_of_id ➤ ACCOUNT
payment_intent_id ➤ PAYMENT_INTENT
payment_method_id ➤ PAYMENT_METHOD
source_id ➤ SOURCE
source_transfer_id ➤ TRANSFER
transfer_id ➤ TRANSFER
transfer_data_destination_id ➤ ACCOUNT
application
amount
amount_refunded
application_fee_amount
billing_detail_address_city
billing_detail_address_country
billing_detail_address_line_1
billing_detail_address_line_2
billing_detail_address_postal_code
billing_detail_address_state
billing_detail_email
billing_detail_name
billing_detail_phone
calculated_statement_descriptor
captured
created
currency
description
failure_code
failure_message
fraud_details_stripe_report
fraud_details_user_report
livemode
metadata
paid
receipt_email
receipt_number
receipt_url
refunded
source_id ➤ (see note below)
source_object
statement_descriptor
status
transfer_data_destination
transfer_group
outcome_*
shipping_*
shipping_address_*
CHARGE ⇱
id🔑
default_card_id ➤ CARD
bank_account_id ➤ BANK_ACCOUNT
source_id ➤ SOURCE
account_balance
balance
created
currency
delinquent
description
invoice_prefix
invoice_settings_footer
invoice_settings_footer_default_payment_method
is_deleted
livemode
metadata
name
phone
tax_exempt
tax_info_tax_id
tax_info_type
tax_info_verification_status
tax_info_verification_verified_name
address_*
shipping_*
shipping_address_*
CUSTOMER ⇱
id 🔑
amount_off
created
currency
duration
duration_in_months
is_deleted
livemode
max_redemptions
metadata
name
percent_off
redeem_by
times_redeemed
valid
COUPON ⇱
id 🔑�charge_id ➤ CHARGE
connected_account_id ➤ ACCOUNT
amount
balance_transaction
created
currency
evidence_access_activity_log
evidence_billing_address
evidence_cancellation_policy
evidence_cancellation_policy_disclosure
evidence_cancellation_rebuttal
evidence_customer_communication
evidence_customer_email_address
evidence_customer_name
evidence_customer_purchase_ip
evidence_customer_signature
evidence_duplicate_charge_documentation
evidence_duplicate_charge_explanation
evidence_duplicate_charge_id
evidence_product_description
evidence_receipt
evidence_refund_policy
evidence_refund_policy_disclosure
evidence_refund_refusal_explanation
evidence_service_date
evidence_service_documentation
evidence_shipping_address
evidence_shipping_carrier
evidence_shipping_date
evidence_shipping_documentation
evidence_shipping_tracking_number
evidence_uncategorized_file
evidence_uncategorized_text
evidence_details_due_by
evidence_details_has_evidence
evidence_details_past_due
evidence_details_submission_count
is_charge_refundable
livemode
metadata
reason
status
DISPUTE ⇱
id 🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
connected_account_id ➤ ACCOUNT
charge_id ➤ CHARGE
failure_balance_transaction_id ➤ BALANCE_TRANSACTION
payment_intent_id ➤ PAYMENT_INTENT
amount
created
currency
description
failure_reason
metadata
reason
receipt_number
status
REFUND ⇱
id 🔑
charge_id ➤ CHARGE
payment_intent_id ➤ PAYMENT_INTENT
billing_zip
closed_reason
created
ip_address
livemode
open
opened_reason
reason
session_browser
session_device
session_platform
session_version
ip_address_location_*
REVIEW ⇱
id 🔑
_fivetran_start 🔑
customer_id ➤ CUSTOMER
default_source_id ➤ SOURCE
default_payment_method_id ➤ PAYMENT_METHOD
latest_invoice_id ➤ INVOICE
pending_setup_intent_id ➤ SETUP_INTENT
application_fee_percent
billing
billing_cycle_anchor
billing_threshold_usage_gte
billing_threshold_reset_billing_cycle_anchor
cancel_at
cancel_at_period_end
canceled_at
cancellation_details_comment
cancellation_details_feedback
cancellation_details_reason
created
collection_method
current_period_end
current_period_start
customer
days_until_due
ended_at
livemode
metadata
quantity
start
start_date
status
tax_percent
trial_end
trial_start
pause_collection_*
SUBSCRIPTION_HISTORY ⇱
id 🔑
product_id ➤ PRODUCT
active
created
currency
image
inventory_quantity
inventory_type
inventory_value
is_deleted
livemode
metadata
price
updated�package_dimensions_*
SKU ⇱
id 🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
destination_id ➤ ACCOUNT
source_transaction ➤ CHARGE
source_transaction_id ➤ CHARGE
amount
amount_reversed
created
currency
description
destination_payment
destination_payment_id
livemode
metadata
reversed
source_type
transfer_group
TRANSFER ⇱
source_id is a foreign key reference to BANK_ACCOUNT, CARD, and SOURCE. Which table it refers to is captured in source_object
id 🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
source_id ➤ SOURCE
amount
created
currency
description
expected_availability_data
failure_code
failure_message
livemode
metadata
statement_descriptor
status
transfer_group
TOPUP ⇱
id 🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
failure_balance_transaction_id ➤ BALANCE_TRANSACTION
connected_account_id ➤ ACCOUNT
destination_bank_account_id ➤ BANK_ACCOUNT
destination_card_id ➤ CARD
amount
arrival_date
automatic
created
currency
description
failure_code
failure_message
livemode
metadata
method
reconciliation_status
source_type
statement_descriptor
status
type
PAYOUT ⇱
id 🔑
plan_id ➤ PLAN
subscription_id 🔑 ➤ SUBSCRIPTION_HISTORY�billing_threshold_usage_gte
billing_threshold_reset_billing_cycle_anchor�created
current_period_end
current_period_start
metadata
quantity
SUBSCRIPTION_ITEM ⇱
id 🔑
refund_id ➤ REFUND
order_id
amount
created
currency
livemode
ORDER_RETURN ⇱
id 🔑
balance_transaction_id ➤ BALANCE_TRANSACTION
source_refund_id ➤ REFUND
transfer_id ➤ TRANSFER
amount
created
currency
destination_payment_refund
metadata
TRANSFER_REVERSAL ⇱
id 🔑
authorization_id ➤ AUTHORIZATION
balance_transaction_id ➤ BALANCE_TRANSACTION
card_id ➤ ISSUING_CARD
dispute_id ➤ DISPUTE
amount_details_atm_fee
amount
cardholder
created
currency
livemode
metadata
type
TRANSACTION ⇱
id 🔑
product_id ➤ PRODUCT
active
aggregate_usage
amount
billing_schema
created
currency
interval
interval_count
is_deleted
livemode
metadata
nickname
tiers_mode
transform_usage_divide_by
transform_usage_round
trial_period_days
usage_type
PLAN ⇱
id 🔑
active
attributes
caption
created
deactivate_on
description
images
is_deleted
livemode
name
shippable
statement_descriptor
type
unit_label
updated
url
package_dimension_*
PRODUCT ⇱
id🔑�connected_account_id ➤ ACCOUNT
payout_id ➤ PAYOUT
amount
available_on
created
currency
description
exchange_rate
fee
net
reporting_category
source
status
type-
BALANCE_TRANSACTION ⇱
index 🔑
balance_transaction_id 🔑➤ BALANCE_TRANSACTION
connected_account_id ➤ ACCOUNT
amount
application
currency
description
type
FEE ⇱
id 🔑➤ SKU
name
value
ATTRIBUTE ⇱
id 🔑 ➤ PLAN
index 🔑
flat_amount
flat_amount_decimal
unit_amount
unit_amount_decimal
up_to
TIER ⇱
id 🔑
coupon_id ➤ COUPON
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
invoice_item_id ➤ INVOICE_ITEM
subscription_id ➤ SUBSCRIPTION_HISTORY
checkout_session
end
start
INVOICE_DISCOUNT ⇱
id 🔑
coupon_id ➤ COUPON
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
invoice_item_id ➤ INVOICE_ITEM
subscription_id ➤ SUBSCRIPTION_HISTORY
checkout_session
end
start
SUBSCRIPTION_DISCOUNT ⇱
dispute_id🔑 ➤ DISPUTE
balance_transaction_id🔑 ➤ BALANCE_TRANSACTION
DISPUTE_BALANCE_TRANSACTION
id🔑
application_fee_id ➤ APPLICATION_FEE
balance_transaction ➤ BALANCE_TRANSACTION
amount
currency
created
APPLICATION_FEE_REFUND ⇱
id 🔑
customer_id ➤ CUSTOMER�connected_account_id ➤ ACCOUNT�last_payment_error_charge_id ➤ CHARGE
last_payment_error_source_id ➤ SOURCE
on_behalf_of ➤ ACCOUNT�source_id ➤ SOURCE
transfer_data_destination ➤ ACCOUNT
amount
amount_capturable
amount_received
application
application_fee_amount
canceled_at
cancellation_reason
capture_method
confirmation_method
created
currency
description
livemode
metadata
payment_method_types
receipt_email
statement_descriptor
status
transfer_group
last_payment_error_*
PAYMENT_INTENT ⇱
id 🔑
customer_id ➤ CUSTOMER�invoice_id ➤ INVOICE
amount
created
currency
credit_note
description
ending_balance
livemode
type
CUSTOMER_BALANCE_TRANSACTION ⇱
id🔑
customer_id ➤ CUSTOMER
subscription_id ➤ SUBSCRIPTION_HISTORY
canceled_at
completed_at
created
current_phase_end_date
current_phase_start_date
end_behavior
livemode�metadata
released_at
released_subscription
status
SUBSCRIPTION_SCHEDULE ⇱
subscription_schedule_id🔑➤ SUBSCRIPTION_SCHEDULE
end_date 🔑
start_date 🔑
application_fee_percent
billing_thresholds_amount_gte
billing_thresholds_reset_billing_cycle_anchor
collection_method
coupon_id
default_payment_method
invoice_settings_days_until_due
tax_percent
trial_end
PHASE ⇱
subscription_schedule_id🔑➤ SUBSCRIPTION_SCHEDULE
end_date 🔑
start_date 🔑
plan_id
quantity
PHASE_PLAN ⇱
item_index 🔑
discount_id ➤ DISCOUNT
order_return_id 🔑 ➤ ORDER_RETURN
sku_id ➤ SKU
amount
currency
description
object
parent
quantity
type
ORDER_RETURN_ITEM ⇱
id 🔑
subscription_item_id 🔑 ➤ SUBSCRIPTION_ITEM
invoice_id ➤ INVOICE�livemode
period_start
period_end�timestamp
total_usage
USAGE_RECORD ⇱
id 🔑
coupon_id ➤ COUPON
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
invoice_item_id ➤ INVOICE_ITEM
subscription_id ➤ SUBSCRIPTION_HISTORY
checkout_session
end
start
CUSTOMER_DISCOUNT ⇱
id 🔑
invoice_item_id ➤ INVOICE_ITEM
product_id ➤ PRODUCT
active
billing_scheme
created
currency
is_deleted
livemode
lookup_key
metadata
nickname
tiers_mode
type
unit_amount
unit_amount_decimal
recurring_*
transform_quantity_*
PRICE ⇱
id 🔑
coupon_id ➤ COUPON
customer_id ➤ CUSTOMER
active
code
created
expires_at
first_time_transaction
livemode
max_redemptions
metadata
minimum_amount
minimum_amount_currency
times_redemeeded
PROMOTION_CODE ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
charge_id ➤ CHARGE
payment_intent_id ➤ PAYMENT_INTENT
billing_zip
closed_reason
created
ip_address
livemode
open
opened_reason
reason
session_browser
session_device
session_platform
session_version
ip_address_location_*
REVIEW ⇱
unique_id 🔑
invoice_id 🔑 ➤ INVOICE
Invoice_item_id ➤ INVOICE_ITEM
plan_id ➤ PLAN
price_id ➤ PRICE
subscription_id ➤ SUBSCRIPTION_HISTORY
subscription_item_id ➤ SUBSCRIPTION_ITEM
amount
amount_excluding_tax
currency
description
discountable
id
live_mode
metadata
period_start
period_end
proration
quantity
type
unit_amount_excluding_tax
INVOICE_LINE_ITEM ⇱
id 🔑
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
plan_id ➤ PLAN
price_id ➤ PRICE
subscription_id ➤ SUBSCRIPTION_HISTORY
subscription_item_id ➤ SUBSCRIPTION_ITEM
amount
currency
date
description
discountable�is_deleted
livemode
metadata
period_start
period_end
proration
quantity
test_clock
unit_amount
unit_amount_decimal
INVOICE_ITEM ⇱
EARLY_FRAUD_WARNING ⇱
id 🔑
charge_id ➤ CHARGE
actionable
created
fraud_type
livemode
invoice_id 🔑 ➤ INVOICE
tax_rate_id 🔑 ➤ TAX_RATE
INVOICE_TAX_RATE ⇱
invoice_item_id 🔑 ➤ INVOICE_ITEM
tax_rate_id 🔑 ➤ TAX_RATE
INVOICE_ITEM_TAX_RATE ⇱
subscription_id 🔑 ➤ SUBSCRIPTION_HISTORY
tax_rate_id 🔑 ➤ TAX_RATE
SUBSCRIPTION_TAX_RATE ⇱
id 🔑
active
created
description
display_name
inclusive
juristrictive
livemode
metadata_*
percentage
TAX_RATE ⇱
unique_id 🔑
invoice_id 🔑 ➤ INVOICE
tax_rate_id 🔑 ➤ TAX_RATE
INVOICE_LINE_ITEM_TAX_RATE ⇱
ibalance_transaction_id
created_at
available_on
currency
amount
fee
net
type
reporting_category
source
description
customer_facing_amount
customer_facing_currency
effective_at
connected_account_id
customer_id
receipt_email
customer_description
payment_method_type
payment_method_brand
payment_method_funding
charge_id
payment_intent_id
charge_created_at
card_brand
card_funding
card_country
payout_id
payout_expected_arrival_date
payout_status
payout_type
payout_description
refund_reason
source_relation
STRIPE__BALANCE_TRANSACTIONS ⇱
customer_id
customer_description
customer_created_at
customer_currency
[Other columns from the `stg_stripe__customer` table]
total_sales
total_refunds
total_gross_transaction_amount
total_fees
total_net_transaction_amount
total_sales_count
total_refund_count
sales_this_month
refunds_this_month
gross_transaction_amount_this_month
fees_this_month
net_transaction_amount_this_month
sales_count_this_month
refund_count_this_month
first_sale_date
most_recent_sale_date
total_failed_charge_count
total_failed_charge_amount
failed_charge_count_this_month
failed_charge_amount_this_month
source_relation
STRIPE__CUSTOMER_OVERVIEW ⇱
account_id
account_daily_id
date_day
date_week
date_month
date_year
date_index
source_relation
total_daily_sales_amount
total_daily_refunds_amount
total_daily_adjustments_amount
total_daily_other_transactions_amount
total_daily_gross_transaction_amount
total_daily_net_transactions_amount
total_daily_payout_fee_amount
total_daily_gross_payout_amount
daily_net_activity_amount
daily_end_balance_amount
total_daily_sales_count
total_daily_payouts_count
total_daily_adjustments_count
total_daily_failed_charge_count
total_daily_failed_charge_amount
rolling_total_daily_sales_amount
rolling_total_daily_refunds_amount
rolling_total_daily_adjustments_amount
rolling_total_daily_other_transactions_amount
rolling_total_daily_gross_transaction_amount
rolling_total_daily_net_transactions_amount
rolling_total_daily_payout_fee_amount
rolling_total_daily_gross_payout_amount
rolling_daily_net_activity_amount
rolling_daily_end_balance_amount
rolling_total_daily_sales_count
rolling_total_daily_payouts_count
rolling_total_daily_adjustments_count
rolling_total_daily_failed_charge_count
rolling_total_daily_failed_charge_amount
STRIPE__DAILY_OVERVIEW ⇱
invoice_id
invoice_number
invoice_created_at
period_start
period_end
status
due_date
currency
amount_due
amount_paid
subtotal
tax
total
amount_remaining
attempt_count
invoice_memo
number_of_line_items
total_quantity
balance_transaction_id
charge_amount
charge_status
connected_account_id
charge_created_at
charge_is_refunded
customer_id
customer_description
customer_account_balance
customer_currency
customer_is_delinquent
customer_email
subscription_id
subscription_billing
subscription_start_date
subscription_ended_at
source_relation
STRIPE__INVOICE_DETAILS ⇱
invoice_line_item_id
invoice_id
invoice_item_id
invoice_line_item_amount
currency
invoice_line_item_memo
is_discountable
plan_id
price_id
proration
quantity
subscription_id
subscription_item_id
type
unique_invoice_line_item_id
period_start
period_end
invoice_created_at
invoice_status
invoice_due_date
invoice_amount_due
invoice_amount_paid
invoice_subtotal
invoice_tax
invoice_total
connected_account_id
customer_id
subscription_billing
subscription_start_date
subscription_ended_at
price_plan_is_active
price_plan_amount
price_plan_interval
price_plan_interval_count
price_plan_nickname
price_plan_product_id
source_relation
STRIPE__INVOICE_LINE_ITEM_DETAILS ⇱
subscription_id
customer_id
customer_description
customer_email
status
start_date_at
ended_at
billing
billing_cycle_anchor
canceled_at
created_at
current_period_start
current_period_end
days_until_due
is_cancel_at_period_end
cancel_at
number_invoices_generated
total_amount_billed
total_amount_paid
total_amount_remaining
most_recent_invoice_created_at
average_invoice_amount
average_line_item_amount
avg_num_line_items
source_relation
STRIPE_SUBSCRIPTION_DETAILS ⇱
balance_transaction_id
created_at
available_on
currency
amount
fee
net
type
reporting_category
source
description
customer_facing_amount
customer_facing_currency
effective_at
connected_account_id
customer_id
receipt_email
customer_description
payment_method_type
payment_method_brand
payment_method_funding
charge_id
payment_intent_id
charge_created_at
card_brand
card_funding
card_country
payout_id
payout_expected_arrival_date
payout_status
payout_type
payout_description
refund_reason
source_relation
STRIPE__BALANCE_TRANSACTIONS
customer_id
customer_description
customer_created_at
customer_currency
total_sales
total_refunds
total_gross_transaction_amount
total_fees
total_net_transaction_amount
total_sales_count
total_refund_count
sales_this_month
refunds_this_month
gross_transaction_amount_this_month
fees_this_month
net_transaction_amount_this_month
sales_count_this_month
refund_count_this_month
first_sale_date
most_recent_sale_date
total_failed_charge_count
total_failed_charge_amount
failed_charge_count_this_month
failed_charge_amount_this_month
source_relation
STRIPE__CUSTOMER_OVERVIEW
account_id
account_daily_id
date_day
date_week
date_month
date_year
date_index
source_relation
total_daily_sales_amount
total_daily_refunds_amount
total_daily_adjustments_amount
total_daily_other_transactions_amount
total_daily_gross_transaction_amount
total_daily_net_transactions_amount
total_daily_payout_fee_amount
total_daily_gross_payout_amount
daily_net_activity_amount
daily_end_balance_amount
total_daily_sales_count
total_daily_payouts_count
total_daily_adjustments_count
total_daily_failed_charge_count
total_daily_failed_charge_amount
rolling_total_daily_sales_amount
rolling_total_daily_refunds_amount
rolling_total_daily_adjustments_amount
rolling_total_daily_other_transactions_amount
rolling_total_daily_gross_transaction_amount
rolling_total_daily_net_transactions_amount
rolling_total_daily_payout_fee_amount
rolling_total_daily_gross_payout_amount
rolling_daily_net_activity_amount
rolling_daily_end_balance_amount
rolling_total_daily_sales_count
rolling_total_daily_payouts_count
rolling_total_daily_adjustments_count
rolling_total_daily_failed_charge_count
rolling_total_daily_failed_charge_amount
STRIPE__DAILY_OVERVIEW
invoice_id
invoice_number
invoice_created_at
period_start
period_end
status
due_date
currency
amount_due
amount_paid
subtotal
tax
total
amount_remaining
attempt_count
invoice_memo
number_of_line_items
total_quantity
balance_transaction_id
charge_amount
charge_status
connected_account_id
charge_created_at
charge_is_refunded
customer_id
customer_description
customer_account_balance
customer_currency
customer_is_delinquent
customer_email
subscription_id
subscription_billing
subscription_start_date
subscription_ended_at
source_relation
STRIPE__INVOICE_DETAILS
invoice_line_item_id
invoice_id
invoice_item_id
invoice_line_item_amount
currency
invoice_line_item_memo
is_discountable
plan_id
price_id
proration
quantity
subscription_id
subscription_item_id
type
unique_invoice_line_item_id
period_start
period_end
invoice_created_at
invoice_status
invoice_due_date
invoice_amount_due
invoice_amount_paid
invoice_subtotal
invoice_tax
invoice_total
connected_account_id
customer_id
subscription_billing
subscription_start_date
subscription_ended_at
price_plan_is_active
price_plan_amount
price_plan_interval
price_plan_interval_count
price_plan_nickname
price_plan_product_id
source_relation
STRIPE__INVOICE_LINE_ITEM_DETAILS
subscription_id
customer_id
customer_description
customer_email
status
start_date_at
ended_at
billing
billing_cycle_anchor
canceled_at
created_at
current_period_start
current_period_end
days_until_due
is_cancel_at_period_end
cancel_at
number_invoices_generated
total_amount_billed
total_amount_paid
total_amount_remaining
most_recent_invoice_created_at
average_invoice_amount
average_line_item_amount
avg_num_line_items
source_relation
STRIPE_SUBSCRIPTION_DETAILS
Fivetran Data Models ��
Fivetran offers pre-built data models that are constructed in dbt and can be used to get immediate business value out of your data. For more information on how to generate the tables listed below, refer to Fivetran’s Stripe Data Model Documentation.
invoice_id 🔑 ➤ INVOICE
name 🔑
value
INVOICE_CUSTOM_FIELD ⇱
index 🔑
type 🔑
type_id 🔑
tax_rate_id ➤ TAX_RATE
amount
inclusive
taxability_reason
taxable_amount
TAX_AMOUNT ⇱
Note: a TAX_AMOUNT `type` can include values such as
“QUOTE_LINE_ITEM”
“QUOTE_TOTAL_DETAILS_BREAKDOWN”,
“CREDIT_NOTE”,
“CREDIT_NOTE_LINE_ITEM”
“CREDIT_NOTE_SHIPPING_COST”
“UPCOMING_INVOICE”,
“UPCOMING_INVOICE_LINE_ITEM”,
“UPCOMING_INVOICE_SHIPPING_COST”
“INVOICE”,
“INVOICE_LINE_ITEM”,
“INVOICE_SHIPPING_COST”
id 🔑
invoice_id ➤ INVOICE
customer_balance_transaction_id ➤ CUSTOMER_BALANCE_TRANSACTION
customer_id ➤ CUSTOMER
refund_id ➤ REFUND
amount
amount_shipping
created
currency
effective_at
livemode
memo
metadata
number
out_of_band_amount
reason
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
status
subtotal
subtotal_excluding_tax
total
total_excluding_tax
type
voided_at
CREDIT_NOTE ⇱
id 🔑
credit_note_id ➤ CREDIT_NOTE
amount
amount_excluding_tax
description
invoice_line_item
livemode
quantity
type
unit_amount
unit_amount_decimal
unit_amount_excluding_tax
CREDIT_NOTE_LINE_ITEM ⇱
credit_note_line_item_id 🔑 ➤ CREDIT_NOTE_LINE_ITEM
credit_note_id 🔑➤ CREDIT_NOTE
tax_rate_id 🔑 ➤ TAX_RATE
CREDIT_NOTE_LINE_ITEM_TAX_RATE ⇱
subscription_id🔑➤ SUBSCRIPTION_HISTORY
customer_id ➤ CUSTOMER
charge_id ➤ CHARGE
default_source_id ➤ SOURCE
default_payment_method_id ➤ PAYMENT_METHOD
payment_intent_id ➤ PAYMENT_INTENT
account_country
account_name
amount_due
amount_paid
amount_remaining
amount_shipping
application
application_fee_amount
attempt_count
attempted
auto_advance
automatic_tax_enabled
automatic_tax_liability_account
automatic_tax_liability_type
automatic_tax_status
billing_reason
collection_method
created
currency
description
due_date
effective_at
ending_balance
footer
from_invoice_action�from_invoice_invoice
hosted_invoice_url
invoice_pdf
is_deleted
issuer_account
issuer_type
last_finalization_error_code
last_finalization_error_doc_url
last_finalization_error_message
last_finalization_error_param
last_finalization_error_payment_method_type
last_finalization_error_type
latest_revision
livemode
metadata
next_payment_attempt
number
on_behalf_of
paid
paid_out_of_band
payment_settings_default_mandate
payment_settings_payment_method_options_*
payment_setting_payment_method_types
period_end
period_start
post_payment_credit_notes_amount
pre_payment_credit_notes_amount
receipt_number
rendering_amount_tax_display
rendering_pdf_page_size
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
shipping_details_address_*
shipping_details_name
shipping_details_phone
starting_balance
statement_descriptor
status
status_transitions_*
subscription_proration_date
subtotal
subtotal_excluding_tax
tax
tax_percent
test_clock
threshold_reason_amount_gte
total
total_excluding_tax
transfer_data_amount
transfer_data_destination
webhooks_delivered_at
UPCOMING_INVOICE ⇱
id 🔑
subscription_id 🔑➤ SUBSCRIPTION_HISTORY
customer_id ➤ CUSTOMER
plan_id ➤ PLAN
price_id ➤ PRICE
subscription_item_id ➤ SUBSCRIPTION_ITEM
amount
currency
description
discountable
id
live_mode
metadata
period_start
period_end
proration
quantity
type
UPCOMING_INVOICE_LINE_ITEM ⇱
id 🔑
subscription_id 🔑 ➤ SUBSCRIPTION_HISTORY
UPCOMING_INVOICE_ACCOUNT_TAX_ID ⇱
subscription_id 🔑 ➤ SUBSCRIPTION_HISTORY
name 🔑
value
UPCOMING_INVOICE_CUSTOM_FIELD ⇱
subscription_id🔑➤ SUBSCRIPTION_HISTORY
tax_rate_id 🔑 ➤ TAX_RATE
upcoming_invoice_line_item_id 🔑 ➤ UPCOMING_INVOICE_LINE_ITEM
UPCOMING_INVOICE_LINE_ITEM_TAX_RATE ⇱
subscription_id 🔑➤ SUBSCRIPTION_HISTORY
upcoming_invoice_line_item_id 🔑➤ UPCOMING_INVOICE_LINE_ITEM
invoice_id
invoice_line_item_id
UPCOMING_INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEM ⇱
subscription_id🔑➤ SUBSCRIPTION_HISTORY
tax_rate_id 🔑 ➤ TAX_RATE
UPCOMING_INVOICE_TAX_RATE ⇱
id🔑
charge_id ➤ CHARGE
customer_id ➤ CUSTOMER
default_source_id ➤ SOURCE
default_payment_method_id ➤ PAYMENT_METHOD
payment_intent_id ➤ PAYMENT_INTENT
subscription_id ➤ SUBSCRIPTION_HISTORY
account_country
account_name
amount_due
amount_paid
amount_remaining
amount_shipping
application
application_fee_amount
attempt_count
attempted
auto_advance
automatic_tax_enabled
automatic_tax_status
billing_reason
collection_method
created
currency
description
due_date
effective_at
ending_balance
footer
from_invoice_action�from_invoice_invoice
hosted_invoice_url
invoice_pdf
is_deleted
last_finalization_error_code
last_finalization_error_doc_url
last_finalization_error_message
last_finalization_error_param
last_finalization_error_payment_method_type
last_finalization_error_type
latest_revision
livemode
metadata
next_payment_attempt
number
on_behalf_of
paid
paid_out_of_band
payment_settings_default_mandate
payment_settings_payment_method_options_*
payment_setting_payment_method_types
period_end
period_start
post_payment_credit_notes_amount
pre_payment_credit_notes_amount
receipt_number
rendering_amount_tax_display
rendering_pdf_page_size
shipping_cost_amount_subtotal
shipping_cost_amount_tax
shipping_cost_amount_total
shipping_cost_shipping_rate
shipping_details_address_*
shipping_details_name
shipping_details_phone
starting_balance
statement_descriptor
status
status_transitions_*
subscription_proration_date
subtotal
subtotal_excluding_tax
tax
tax_percent
test_clock
threshold_reason_amount_gte
total
total_excluding_tax
webhooks_delivered_at
INVOICE ⇱
invoice_id 🔑 ➤ INVOICE
id 🔑
INVOICE_ACCOUNT_TAX_ID ⇱
credited_invoice_line_item_id 🔑
invoice_id 🔑➤ INVOICE
invoice_line_item_id 🔑➤ INVOICE_LINE_ITEM
credited_invoice_id
INVOICE_LINE_ITEM_PRORATION_DETAILS_CREDITED_ITEMS ⇱
id 🔑
customer_id ➤ CUSTOMER
owner_customer_id ➤ CUSTOMER
owner_account_id ➤ CUSTOMER
country
created
livemode
object
type
value
owner_type
verification_status
verification_verified_address
verification_verified_name
CUSTOMER_TAX ⇱
coupon_id 🔑➤ COUPON
product_id 🔑 ➤ PRODUCT
COUPON_PRODUCT ⇱
payout_id🔑 ➤ PAYOUT
balance_transaction_id🔑 ➤ BALANCE_TRANSACTION
PAYOUT_BALANCE_TRANSACTION
additional_explanation�attribution_end_date
attribution_start_date
balance_debited_at
balance_transaction_id
billing_amount
billing_currency
card_brand
card_country
card_funding
card_present
charge_id
customer_id
destination_id
dispute_id
event_type
fee_category
fee_currency
fee_id
fee_name
fixed_per_item_amount
fixed_per_item_count
fx_rate
incurred_at
max_amount
min_amount
plan_name
refund_id
request_id
subtotal_amount
tax_amount
tax_rate
total_amount
variable_rate
variable_volume_amount
CARD_PAYMENTS_FEES_TRANSACTION_LEVEL_1 ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id🔑
customer_id ➤ CUSTOMER
address_country
billing_detail_address_city
billing_detail_address_country
billing_detail_address_line_1
billing_detail_address_line_2
billing_detail_address_postal_code
billing_detail_address_state
created
is_deleted
livemode
metadata
type
PAYMENT_METHOD ⇱
payment_method_id 🔑 ➤ PAYMENT_METHOD
charge_id ➤ CHARGE
brand
description
fingerprint
funding
type
wallet_type
three_d_secure_usage_supported
PAYMENT_METHOD_CARD ⇱
payment_method_id 🔑➤ PAYMENT_METHOD
bank
bic
IDEAL ⇱
payment_method_id 🔑 ➤ PAYMENT_METHOD
bank_code
branch_code
country
fingerprint
last_4
SEPA_DEBIT ⇱
payment_method_id 🔑 ➤ PAYMENT_METHOD
bsb_number
fingerprint�last_4
AU_BECS_DEBIT ⇱
id🔑�customer_id ➤ CUSTOMER�payment_method_id ➤ PAYMENT_METHOD�on_behalf_of ➤ ACCOUNT
application
cancellation_reason
created
description
livemode
mandate
single_use_mandate
status
usage
SETUP_INTENT ⇱
id🔑�payment_method_id ➤ PAYMENT_METHOD
setup_intent_id ➤ SETUP_INTENT
on_behalf_of ➤ ACCOUNT
application
created
livemode
on_behalf_of
status
usage
setup_error_*
SETUP_ATTEMPT ⇱
payment_method_id 🔑➤ PAYMENT_METHOD
bank
FPX ⇱
payment_method_id 🔑➤ PAYMENT_METHOD
bank
FPX ⇱
id🔑
account_id ➤ ACCOUNT
connected_account_id ➤ ACCOUNT
customer_id ➤ CUSTOMER
address_city
address_country
available_payout_methods
brand
country
created
cvc_check
description
dynamic_last_4
exp_month
exp_year
fingerprint
funding
iin
issuer
last_4
name
network
recipient
status�three_d_secure_*
tokenization_method�wallet_type
address_*
CARD ⇱
id🔑�connected_account_id ➤ ACCOUNT
customer_id ➤ CUSTOMER
account
account_holder_name
account_holder_type
bank_name
country
currency
fingerprint
is_deleted
last_4
routing_number
status
BANK_ACCOUNT ⇱
id 🔑�connected_account_id ➤ ACCOUNT
customer_id ➤ CUSTOMER
amount
code_verification_attempts_remaining
code_verification_status
created
currency
flow
owner_address_city
owner_address_country
owner_address_line_1
owner_address_line_2
owner_address_postal_code
owner_address_state
owner_email
owner_name
owner_phone
owner_verified_address_city
owner_verified_address_country
owner_verified_address_line_1
owner_verified_address_line_2
owner_verified_address_postal_code
owner_verified_address_state
owner_verified_email
owner_verified_name
owner_pverified_hone
receiver_address
receiver_amount_charged
receiver_amount_return
receiver_amount_returned
receiver_refund_attribuets_method
receiver_refund_attributes_status
redirect_failure_reason
redirect_return_url
redirect_status
redirect_url
statement_descriptor
status
type
usage
SOURCE ⇱
id 🔑
created
filename
purpose
size
title
type
url
FILE ⇱
id 🔑
approved
amount
amount_details_atm_fee
authorization_method
cardholder
currency
held_amount
held_currency
is_held_amount_controllable
livemode
metadata
merchant_amount
merchant_currency
merchant_data
pending_authorized_amount
pending_held_amount
status
verification_data_address_line_1_check
verification_data_address_zip_check
verification_data_cvc_check
wallet_provider
AUTHORIZATION ⇱
id 🔑
amount
created
currency
evidence_fraudulent_dispute_explanation
evidence_fraudulent_uncategorized_file_id ➤ FILE
evidence_other_dispute_explanation
evidence_other_uncategorized_file_id ➤ FILE
livemode
reason
status
ISSUING_DISPUTE ⇱
id🔑
cardholder_id ➤ CARDHOLDER
cancellation_reason
brand
created
currency
exp_month
exp_year
last4
livemode
name
number
replaced_by
replacement_for
replacement_reason
shipping_address_city
shipping_address_country
shipping_address_line_1
shipping_address_line_2
shipping_address_postal_code
shipping_address_state
shipping_carrier
shipping_eta
shipping_name
shipping_service
shipping_status
shipping_tracking_number
shipping_tracking_url
shipping_type
status
type
ISSUING_CARD ⇱
id🔑
billing_name
billing_address_city
billing_address_country
billing_address_line_1
billing_address_line_2
billing_address_postal_code
billing_address_state
created
is_default
livemode
name
phone_number
spending_controls_allowed_categories
spending_controls_blocked_categories
spending_controls_spending_limits
spending_controls_spending_limits_currency
status
type
CARDHOLDER ⇱
id 🔑
created
expired
expires_at
file
livemode
metadata
url
FILE_LINKS ⇱
id 🔑
amount
amount_details
authorization ➤ AUTHORIZATION
balance_transaction ➤ BALANCE_TRANSACTION
card ➤ CARD
cardholder ➤ CARDHOLDER
reated
dispute ➤ DISPUTE
livemode
merchant_amount
merchant_currency
merchant_data
metadata
type
wallet
ISSUING_TRANSACTION
id 🔑�connected_account_id ➤ ACCOUNT
created
domain_name
livemode
APPLE_PAY_DOMAIN
id🔑
individual_id ➤ PERSON
business_profile_mcc
business_profile_name
business_profile_product_description
business_profile_support_email
business_profile_support_phone
business_profile_support_url
business_profile_url
business_type
capabilities_afterpay_clearpay_payments
capabilities_au_becs_debit_payments
capabilities_bacs_debit_payments
capabilities_bancontact_payments
capabilities_card_issuing
capabilities_card_payments
capabilities_cartes_bancaires_payments
capabilities_eps_payments
capabilities_fpx_payments
capabilities_giropay_payments
capabilities_grabpay_payments
capabilities_ideal_payments
capabilities_jcb_payments
capabilities_legacy_payments
capabilities_oxxo_payments
capabilities_p_24_payments
capabilities_platform_payments
capabilities_sepa_debit_payments
capabilities_sofort_payments
capabilities_tax_reporting_us_1099_k
capabilities_tax_reporting_us_1099_misc
capabilities_transfers
charges_enabled
company_directors_provided
company_executives_provided
company_name
company_name_kana
company_name_kanji
company_owners_provided
company_phone
company_structure
company_tax_id_provided
company_tax_id_registrar
company_vat_id_provided
company_verification_document_back
company_verification_document_details
company_verification_document_details_code
company_verification_document_front
country
created
default_currency
details_submitted
is_deleted
metadata
payouts_enabled
settings_branding_icon
settings_branding_logo
settings_branding_primary_color
settings_card_payments_decline_on_avs_failure
settings_card_payments_decline_on_cvc_failure
settings_card_payments_statement_descriptor_prefix
settings_dashboard_display_name
settings_dashboard_timezone
settings_payments_statement_descriptor
settings_payments_statement_descriptor_kana
settings_payments_statement_descriptor_kanji
settings_payouts_debit_negative_balances
settings_payouts_schedule_delay_days
settings_payouts_schedule_interval
settings_payouts_schedule_monthly_anchor
settings_payouts_schedule_weekly_anchor
settings_payouts_statement_descriptor
tos_acceptance_date
tos_acceptance_ip
tos_acceptance_user_agent
type
business_profile_support_address_*
company_address_*
requirements_*
ACCOUNT ⇱
id🔑
account_id ➤ ACCOUNT
address_city
address_country
address_line_1
address_line_2
address_postal_code
address_state
created
dob_day
dob_month
dob_year
first_name
gender
id_number_provided
last_name
maiden_name
phone
relationship_director
relationship_executive
relationship_owner
relationship_percent_ownership
relationship_representative
relationship_title
ssn_last_4_provided
verification_additional_document_back
verification_additional_document_details
verification_additional_document_code
verification_additional_document_front
verification_details
verification_details_code
verification_document_back
verification_document_details
verification_document_details_code
verification_document_front
verification_status�is_deleted
PERSON ⇱
id🔑
customer_id ➤ CUSTOMER
payment_intent_id ➤ PAYMENT_INTENT
setup_intent_id ➤ SETUP_INTENT
subscription_id ➤ SUBSCRIPTION_HISTORY
allow_promotion_codes
automatic_tax_enabled
automatic_tax_status
billing_address_collection
cancel_url
client_reference_id
consent_promotions
consent_collection_promotions
currency
expires_at
livemode
locale
metadata
mode
object
payment_link
payment_method_collection
payment_status
phone_number_collection_enabled
recovered_from
shipping_address_collection
shipping_options
status
submit_type
success_url
tax_id_collection_enabled
after_expiration_recovery_*
payment_method_options_afterpay_clearpay_*
payment_method_options_alipay_*
payment_method_options_au_becs_debit_*
payment_method_options_bacs_debit_*
payment_method_options_bancontact_*
payment_method_options_boleto_*
payment_method_options_card_*
payment_method_options_customer_balance_*
payment_method_options_eps_*
payment_method_options_fpx_*
payment_method_options_giropay_*
payment_method_options_ideal_*
payment_method_options_klarna_*
payment_method_options_konbini_*
payment_method_options_oxxo_*
payment_method_options_p24_*
payment_method_options_paynow_*
payment_method_options_sepa_debit_*
payment_method_options_sofort_setup_future_usage_*
payment_method_options_us_bank_account_*
shipping_*
shipping_rate_*
total_details_*
url
CHECKOUT_SESSION ⇱
checkout_session_id 🔑 ➤ CHECKOUT_SESSION
payment_method_type 🔑 ➤ PAYMENT_METHOD.type
CHECKOUT_SESSION_PAYMENT_METHOD ⇱
checkout_session_id 🔑 ➤ CHECKOUT_SESSION
shipping_rate_id 🔑 ➤ SHIPPING_RATE
shipping_amount
CHECKOUT_SESSION_SHIPPING_OPTION ⇱
checkout_session_id 🔑 ➤ CHECKOUT_SESSION
tax_rate_id 🔑 ➤ TAX_RATE
amount
CHECKOUT_SESSION_TAX_RATE ⇱
checkout_session_id 🔑 ➤ CHECKOUT_SESSION
allowed_country_code 🔑
CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES ⇱
id 🔑
checkout_session_id 🔑 ➤ CHECKOUT_SESSION�price_id ➤ PRICE
amount_subtotal
amount_total
currency
description
object
quantity
CHECKOUT_SESSION_LINE_ITEM ⇱
checkout_session_line_item_id 🔑 ➤ CHECKOUT_SESSION_LINE_ITEM
tax_rate_id 🔑 ➤ TAX_RATE
amount
CHECKOUT_SESSION_LINE_ITEM_TAX_RATE ⇱
id 🔑
active
created
display_name
livemode
tax_behavior
tax_code
type
delivery_estimate_*
fixed_amount_*
SHIPPING_RATE ⇱
discount_id 🔑
checkout_session_line_item_id 🔑 ➤ CHECKOUT_SESSION_LINE_ITEM
checkout_session ➤ CHECKOUT_SESSION
coupon_id ➤ COUPON
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
invoice_item_id ➤ INVOICE_ITEM
subscription_id ➤ SUBSCRIPTION_HISTORY
amount
end
promotion_code
start
CHECKOUT_SESSION_LINE_ITEM_DISCOUNT ⇱
id 🔑
type 🔑
type_id 🔑
checkout_session_line_item_id ➤ CHECKOUT_SESSION_LINE_ITEM
checkout_session ➤ CHECKOUT_SESSION
coupon_id ➤ COUPON
credit_note_line_item_id ➤ CREDIT_NOTE_LINE_ITEM
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
invoice_item_id ➤ INVOICE_ITEM
subscription_id ➤ SUBSCRIPTION_HISTORY
amount
end
promotion_code
start
DISCOUNT ⇱
Note: a DISCOUNT `type` can include values such as “CHECKOUT_SESSION_LINE_ITEM”, “CREDIT_NOTE_LINE_ITEM”, “CUSTOMER”,
“INVOICE_LINE_ITEM”, “PARENT_INVOICE_LINE_ITEM” or “SUBSCRIPTION”,
“QUOTE”,
“QUOTE_LINE_ITEM”,
“QUOTE_TOTAL_DETAILS_BREAKDOWN”
PARENT_INVOICE_LINE_ITEM: is the amount of discount calculated per invoice discount for this line item.
INVOICE_LINE_ITEM: The discounts applied to the invoice line item.
id🔑
customer_id ➤ CUSTOMER
invoice_id ➤ INVOICE
subscription_id ➤ SUBSCRIPTION_HISTORY
subscription_schedule_id ➤ SUBSCRIPTION_SCHEDULE
amount_subtotal
amount_total
application
application_fee_amount�application_fee_percent
automatic_tax_enabled
automatic_tax_liability_account
automatic_tax_liability_type
automatic_tax_status
collection_method
computed_recurring_amount_subtotal
computed_recurring_amount_total
computed_recurring_interval
computed_recurring_interval_count
computed_recurring_total_details_amount_discount
computed_recurring_total_details_amount_shipping
computed_recurring_total_details_amount_tax
computed.upfront_amount_subtotal
computed.upfront_amount_total�computed.upfront_total_details_amount_discount
computed.upfront_total_details_amount_shipping
computed.upfront_total_details_amount_tax
created
currency
description
expires_at
footer
from_quote_is_revision
from_quote_quote
header
invoice_settings_days_until_due
invoice_settings_issuer_account
invoice_settings_issuer_type
livemode
metadata
number
on_behalf_of
status
status_transitions_accepted_at
status_transitions_canceled_at
status_transitions_finalized_at
test_clock
total_details_amount_discount
total_details_amount_shipping
total_details_amount_tax
transfer_data_amount
transfer_data_amount_percent
transfer_data_destination
QUOTE ⇱
id🔑
quote_id ➤ QUOTE
amount_subtotal
amount_tax
amount_total
currency
description
quantity
QUOTE_LINE_ITEM ⇱
quote_id 🔑 ➤ QUOTE
tax_rate_id 🔑 ➤ TAX_RATE
QUOTE_TAX_RATE ⇱
id🔑
quote_id ➤ QUOTE
amount_subtotal
amount_tax
amount_total
currency
description
quantity
QUOTE_COMPUTED_UPFRONT_LINE_ITEM ⇱