1 of 2

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

email

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

pdf

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

2 of 2

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

email

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

email

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