Chargebee Product Catalog 2.0

Explore the interactive ERD

Table & Field Reference

gift_timeline

Column	Type	Keys
`_fivetran_id`	String	PK
`gift_id`	Unknown	FK
`occurred_at`	Unknown
`status`	Unknown

gift

Column	Type	Keys
`id`	Unknown	PK
`gift_receiver`	Unknown	FK
`gift_receiver_subscription_id`	Unknown	FK
`gifter_customer_id`	Unknown	FK
`gifter_invoice_id`	Unknown	FK
`auto_claim`	Unknown
`claim_expiry_date`	Unknown
`gift_receiver_email`	Unknown
`gift_receiver_first_name`	Unknown
`gift_receiver_last_name`	Unknown
`gifter_note`	Unknown
`gifter_signature`	Unknown
`no_expiry`	Unknown
`resource_version`	Unknown
`scheduled_at`	Unknown
`status`	Unknown
`updated_at`	Unknown

usage

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	FK
`item_price_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Unknown
`line_item_id`	Unknown
`note`	Unknown
`object`	Unknown
`quantity`	Unknown
`resource_version`	Unknown
`source`	Unknown
`updated_at`	Unknown
`usage_date`	Unknown

contract_term

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`action_at_term_end`	Unknown
`billing_cycle`	Unknown
`cancellation_cutoff_period`	Unknown
`contract_end`	Unknown
`contract_start`	Unknown
`created_at`	Unknown
`remaining_billing_cycles`	Unknown
`status`	Unknown
`total_contract_value`	Unknown
`total_contract_value_before_tax`	Unknown

subscription_renewal_estimate_invoice_line_item

Column	Type	Keys
`id`	Unknown	PK
`subscription_estimate_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount`	Unknown
`date_from`	Unknown
`date_to`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`is_taxed`	Unknown
`item_level_discount_amount`	Unknown
`object`	Unknown
`pricing_model`	Unknown
`quantity`	Unknown
`tax_amount`	Unknown
`unit_amount`	Unknown

subscription_renewal_estimate

Column	Type	Keys
`subscription_estimate_id`	Unknown	PKFK
`invoice_estimate_customer_id`	Unknown	FK
`created_at`	Unknown
`invoice_estimate_amount_due`	Unknown
`invoice_estimate_amount_paid`	Unknown
`invoice_estimate_credits_applied`	Unknown
`invoice_estimate_currency_code`	Unknown
`invoice_estimate_line_item_discounts`	Json
`invoice_estimate_line_item_taxes`	Json
`invoice_estimate_object`	Unknown
`invoice_estimate_price_type`	Unknown
`invoice_estimate_recurring`	Unknown
`invoice_estimate_round_off_amount`	Unknown
`invoice_estimate_sub_total`	Unknown
`invoice_estimate_taxes`	Json
`invoice_estimate_total`	Unknown
`object`	Unknown
`subscription_estimate_currency_code`	Unknown
`subscription_estimate_next_billing_at`	Unknown
`subscription_estimate_object`	Unknown
`subscription_estimate_pause_date`	Unknown
`subscription_estimate_resume_date`	Unknown
`subscription_estimate_status`	Unknown
`subscription_estimate_trial_end_action`	Unknown

payment_source_mandate

Column	Type	Keys
`id`	Unknown	PK
`payment_source_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Unknown

payment_source

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`amazon_payment_agreement_id`	Unknown
`amazon_payment_email`	Unknown
`bank_account_account_holder_type`	Unknown
`bank_account_account_type`	Unknown
`bank_account_bank_name`	Unknown
`bank_account_echeck_type`	Unknown
`bank_account_email`	Unknown
`bank_account_first_name`	Unknown
`bank_account_last_4`	Unknown
`bank_account_last_name`	Unknown
`bank_account_mandate_id`	Unknown
`bank_account_name_on_account`	Unknown
`business_entity_id`	Unknown
`card_billing_addr_1`	Unknown
`card_billing_addr_2`	Unknown
`card_billing_city`	Unknown
`card_billing_country`	Unknown
`card_billing_state`	Unknown
`card_billing_state_code`	Unknown
`card_billing_zip`	Unknown
`card_brand`	Unknown
`card_expiry_month`	Unknown
`card_expiry_year`	Unknown
`card_first_name`	Unknown
`card_funding_type`	Unknown
`card_iin`	Unknown
`card_last_4`	Unknown
`card_last_name`	Unknown
`card_masked_number`	Unknown
`card_object`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`gateway`	Unknown
`gateway_account_id`	Unknown
`ip_address`	Unknown
`issuing_country`	Unknown
`paypal_agreement_id`	Unknown
`paypal_email`	Unknown
`reference_id`	Unknown
`resource_version`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown
`upi_vpa`	Unknown

applicable_item

Column	Type	Keys
`applicable_item_id`	Unknown	PKFK
`item_id`	Unknown	PKFK

item_metadata

Column	Type	Keys
`name`	Unknown	PK
`item_id`	Unknown	PKFK
`value`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`item_family_id`	Unknown	FK
`archived_at`	Unknown
`channel`	Unknown
`description`	Unknown
`enabled_for_checkout`	Unknown
`enabled_in_portal`	Unknown
`external_name`	Unknown
`gift_claim_redirect_url`	Unknown
`included_in_mrr`	Unknown
`is_giftable`	Unknown
`is_shippable`	Unknown
`item_applicability`	Unknown
`metered`	Unknown
`name`	Unknown
`redirect_url`	Unknown
`resource_version`	Unknown
`status`	Unknown
`type`	Unknown
`unit`	Unknown
`updated_at`	Unknown
`usage_calculation`	Unknown
`custom_`

ramp_items_to_add

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`ramp_id`	Unknown	PKFK
`amount`	Unknown
`amount_in_decimal`	Unknown
`billing_cycle`	Unknown
`charge_on_event`	Unknown
`charge_on_option`	Unknown
`charge_once`	Unknown
`free_quantity`	Unknown
`free_quantity_in_decimal`	Unknown
`item_type`	Unknown
`metered_quantity`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`service_period_day`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown

ramp_items_to_update

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`ramp_id`	Unknown	PKFK
`amount`	Unknown
`amount_in_decimal`	Unknown
`billing_cycle`	Unknown
`charge_on_event`	Unknown
`charge_on_option`	Unknown
`charge_once`	Unknown
`free_quantity`	Unknown
`free_quantity_in_decimal`	Unknown
`item_type`	Unknown
`metered_quantity`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`service_period_day`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown

ramp_coupons_to_add

Column	Type	Keys
`coupon_id`	Unknown	PK
`ramp_id`	Unknown	PKFK
`apply_till`	Unknown

ramp_discounts_to_add

Column	Type	Keys
`index`	Unknown	PK
`ramp_id`	Unknown	PKFK
`amount`	Unknown
`apply_on`	Unknown
`created_at`	Unknown
`duration_type`	Unknown
`id`	Unknown
`included_in_mrr`	Unknown
`invoice_name`	Unknown
`item_price_id`	Unknown
`percentage`	Unknown
`period`	Unknown
`period_unit`	Unknown
`type`	Unknown

ramp_item_tier

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`ramp_id`	Unknown	PKFK
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`index`	Unknown
`package_size`	Unknown
`price`	Unknown
`price_in_decimal`	Unknown
`pricing_type`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown

ramp_contract_term

Column	Type	Keys
`index`	Unknown	PK
`ramp_id`	Unknown	PKFK
`action_at_term_end`	Unknown
`cancellation_cutoff_period`	Unknown
`renewal_billing_cycle`	Unknown

ramp_status_transition_reason

Column	Type	Keys
`index`	Unknown	PK
`ramp_id`	Unknown	PKFK
`code`	Unknown
`message`	Unknown

ramp

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`coupons_to_remove`	Json
`created_at`	Unknown
`deleted`	Unknown
`description`	Unknown
`discounts_to_remove`	Json
`effective_from`	Unknown
`items_to_remove`	Json
`resource_version`	Unknown
`status`	Unknown
`updated_at`	Unknown

differential_price_tier

Column	Type	Keys
`_fivetran_id`	String	PK
`differential_price_id`	Unknown	FK
`ending_unit`	Unknown
`price`	Unknown
`starting_unit`	Unknown

differential_price_parent_period

Column	Type	Keys
`_fivetran_id`	String	PK
`differential_price_id`	Unknown	FK
`period`	Json
`period_unit`	Unknown

differential_price

Column	Type	Keys
`id`	Unknown	PK
`item_price_id`	Unknown	FK
`parent_item_id`	Unknown	FK
`created_at`	Unknown
`currency_code`	Unknown
`modified_at`	Unknown
`price`	Unknown
`price_in_decimal`	Unknown
`resource_version`	Unknown
`status`	Unknown
`updated_at`	Unknown

resent_order

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	Unknown	FK
`amount`	Unknown
`reason`	Unknown

order_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`invoice_id`	Unknown	FK
`invoice_line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`amount`	Unknown
`amount_adjusted`	Unknown
`amount_paid`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`fulfillment_amount`	Unknown
`fulfillment_quantity`	Unknown
`is_shippable`	Unknown
`item_level_discount_amount`	Unknown
`refundable_credits`	Unknown
`refundable_credits_issued`	Unknown
`sku`	Unknown
`status`	Unknown
`tax_amount`	Unknown
`unit_price`	Unknown

order_line_item_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`is_non_compliance_tax`	Unknown
`is_partial_tax_applied`	Unknown
`local_currency_code`	Unknown
`tax_amount`	Unknown
`tax_amount_in_local_currency`	Unknown
`tax_juris_code`	Unknown
`tax_juris_name`	Unknown
`tax_juris_type`	Unknown
`tax_name`	Unknown
`tax_rate`	Unknown
`taxable_amount`	Unknown

order_line_item_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`line_item_id`	Unknown	FK
`order_id`	Unknown	FK
`discount_amount`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown

order_linked_credit_note

Column	Type	Keys
`id`	Unknown	PKFK
`order_id`	Unknown	FK

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`gift_id`	Unknown	FK
`invoice_id`	Unknown	FK
`original_order_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount_adjusted`	Unknown
`amount_paid`	Unknown
`batch_id`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_email`	Unknown
`billing_address_first_name`	Unknown
`billing_address_last_name`	Unknown
`billing_address_line_1`	Unknown
`billing_address_line_2`	Unknown
`billing_address_line_3`	Unknown
`billing_address_phone`	Unknown
`billing_address_state`	Unknown
`billing_address_state_code`	Unknown
`billing_address_validation_status`	Unknown
`billing_address_zip`	Unknown
`cancellation_reason`	Unknown
`cancelled_at`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`currency_code`	Unknown
`deleted`	Unknown
`delivered_at`	Unknown
`discount`	Unknown
`document_number`	Unknown
`fulfillment_status`	Unknown
`gift_note`	Unknown
`invoice_round_off_amount`	Unknown
`is_gifted`	Unknown
`is_resent`	Unknown
`note`	Unknown
`object`	Unknown
`order_date`	Unknown
`order_type`	Unknown
`paid_on`	Unknown
`payment_status`	Unknown
`price_type`	Unknown
`reference_id`	Unknown
`refundable_credits`	Unknown
`refundable_credits_issued`	Unknown
`resend_reason`	Unknown
`resent_status`	Unknown
`resource_version`	Unknown
`rounding_adjustement`	Unknown
`shipment_carrier`	Unknown
`shipped_at`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_email`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_line_1`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_line_3`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_state`	Unknown
`shipping_address_state_code`	Unknown
`shipping_address_validation_status`	Unknown
`shipping_address_zip`	Unknown
`shipping_cut_off_date`	Unknown
`shipping_date`	Unknown
`status`	Unknown
`status_update_at`	Unknown
`sub_total`	Unknown
`tax`	Unknown
`total`	Unknown
`tracking_id`	Unknown
`tracking_url`	Unknown
`updated_at`	Unknown

scheduled_subscription_change_item_price

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`scheduled_subscription_change_id`	Unknown	PKFK
`billing_cycles`	Unknown
`billing_period`	Unknown
`billing_period_unit`	Unknown

scheduled_subscription_change

Column	Type	Keys
`id`	Unknown	PKFK
`billing_period`	Unknown
`billing_period_unit`	Unknown
`remaining_billing_cycles`	Unknown

subscription_charged_item_price

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`deleted`	Unknown
`last_charged_at`	Unknown

subscription_item_price

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`item_type`	Unknown	FK
`amount`	Unknown
`amount_in_decimal`	Unknown
`billing_cycles`	Unknown
`billing_period`	Unknown
`billing_period_unit`	Unknown
`charge_on_event`	Unknown
`charge_on_option`	Unknown
`charge_once`	Unknown
`deleted`	Unknown
`free_quantity`	Unknown
`free_quantity_in_decimal`	Unknown
`object`	Unknown
`proration_type`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`service_period_days`	Unknown
`trial_end`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown
`usage_accumulation_reset_frequency`	Unknown

subscription_coupon

Column	Type	Keys
`coupon_id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`coupon_code`	Unknown	FK
`applied_count`	Unknown
`apply_till`	Unknown
`deleted`	Unknown

subscription_discount

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`amount`	Unknown
`applied_count`	Unknown
`apply_on`	Unknown
`apply_till`	Unknown
`coupon_id`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`deleted`	Unknown
`duration_type`	Unknown
`included_in_mrr`	Unknown
`index`	Unknown
`invoice_name`	Unknown
`item_price_id`	Unknown
`percentage`	Unknown
`period`	Unknown
`period_unit`	Unknown
`type`	Unknown

subscription_item_tier_price

Column	Type	Keys
`item_price_id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`deleted`	Unknown
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`index`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown

subscription_metadata

Column	Type	Keys
`name`	Unknown	PK
`subscription_id`	Unknown	PKFK
`value`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`business_entity_id`	Unknown	FK
`contract_term_business_entity_id`	Unknown	FK
`contract_term_subscription_id`	Unknown	FK
`customer_id`	Unknown	FK
`payment_source_id`	Unknown	FK
`activated_at`	Unknown
`active_id`	Unknown
`auto_close_invoice`	Unknown
`auto_collection`	Unknown
`base_currency_code`	Unknown
`billing_period`	Unknown
`billing_period_unit`	Unknown
`cancel_reason`	Unknown
`cancel_reason_code`	Unknown
`cancel_schedule_created_at`	Unknown
`cancel_scheduled_at`	Unknown
`cancelled_at`	Unknown
`changes_scheduled_at`	Unknown
`channel`	Unknown
`contract_term_billing_cycle_on_renewal`	Unknown
`create_pending_invoice`	Unknown
`created_at`	Unknown
`created_from_ip`	Unknown
`currency_code`	Unknown
`current_term_end`	Unknown
`current_term_start`	Unknown
`deleted`	Unknown
`due_invoices_count`	Unknown
`due_since`	Unknown
`exchange_rate`	Unknown
`free_period`	Unknown
`free_period_unit`	Unknown
`has_scheduled_advance_invoices`	Unknown
`has_scheduled_changes`	Unknown
`invoice_notes`	Unknown
`monthly_recurring_revenue`	Unknown
`net_term_days`	Unknown
`next_billing_at`	Unknown
`override_relationship`	Unknown
`pause_date`	Unknown
`plan_amount_in_decimal`	Unknown
`plan_free_quantity_in_decimal`	Unknown
`plan_quantity_in_decimal`	Unknown
`plan_unit_price_in_decimal`	Unknown
`po_number`	Unknown
`referral_info_account_id`	Unknown
`referral_info_campaign_id`	Unknown
`referral_info_coupon_code`	Unknown
`referral_info_destination_url`	Unknown
`referral_info_external_campaign_id`	Unknown
`referral_info_external_reference_id`	Unknown
`referral_info_friend_offer_type`	Unknown
`referral_info_notify_referral_system`	Unknown
`referral_info_post_purchase_widget_enabled`	Unknown
`referral_info_referral_code`	Unknown
`referral_info_referral_system`	Unknown
`referral_info_referrer_id`	Unknown
`referral_info_referrer_reward_type`	Unknown
`referral_info_reward_status`	Unknown
`remaining_billing_cycles`	Unknown
`resource_version`	Unknown
`resume_date`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_email`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_index`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_line_1`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_line_3`	Unknown
`shipping_address_object`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_state`	Unknown
`shipping_address_state_code`	Unknown
`shipping_address_validation_status`	Unknown
`shipping_address_zip`	Unknown
`start_date`	Unknown
`started_at`	Unknown
`status`	Unknown
`total_dues`	Unknown
`trial_end`	Unknown
`trial_end_action`	Unknown
`trial_start`	Unknown
`updated_at`	Unknown
`meta_data_`

event_webhook

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`webhook_status`	Unknown

event_metadata

Column	Type	Keys
`name`	Unknown	PK
`event_id`	Unknown	PKFK
`value`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`api_version`	Unknown
`event_type`	Unknown
`occurred_at`	Unknown
`origin_user`	Unknown
`source`	Unknown
`users`	Unknown
`webhook_status`	Unknown

coupon_code

Column	Type	Keys
`code`	Unknown	PK
`coupon_id`	Unknown	FK
`coupon_set_id`	Unknown	FK
`status`	Unknown

coupon_applicable_item_price

Column	Type	Keys
`coupon_id`	Unknown	PKFK
`coupon_item_constraint_type`	Unknown	PKFK
`coupon_item_constraints`	Unknown	PKFK
`item_price_id`	Unknown	PKFK

coupon_item_constraint

Column	Type	Keys
`constraints`	Unknown	PK
`coupon_id`	Unknown	PKFK
`item_type`	Unknown	PKFK

coupon_applicable_item_family

Column	Type	Keys
`coupon_id`	Unknown	PKFK
`coupon_item_constraint_criteria_index`	Unknown	PKFK
`item_family_id`	Unknown	PKFK
`coupon_item_constraint_criteria_item_type`	String

coupon_applicable_price_period

Column	Type	Keys
`item_price_period`	Unknown	PK
`coupon_id`	Unknown	PKFK
`coupon_item_constraint_criteria_index`	Unknown	PKFK

coupon_item_constraint_criteria

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`item_type`	String	FK
`currencies`	Json

coupon_metadata

Column	Type	Keys
`name`	Unknown	PK
`coupon_id`	Unknown	PKFK
`value`	Unknown

coupon

Column	Type	Keys
`id`	Unknown	PK
`apply_on`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`discount_amount`	Unknown
`discount_percentage`	Unknown
`discount_quantity`	Unknown
`discount_type`	Unknown
`duration_type`	Unknown
`invoice_name`	Unknown
`invoice_notes`	Unknown
`max_redemptions`	Unknown
`name`	Unknown
`period`	Unknown
`period_unit`	Unknown
`redemptions`	Unknown
`resource_version`	Unknown
`status`	Unknown
`updated_at`	Unknown
`valid_till`	Unknown
`custom_`

item_price_tier

Column	Type	Keys
`_fivetran_id`	String	PK
`item_price_id`	Unknown	FK
`ending_unit`	Unknown
`price`	Unknown
`starting_unit`	Unknown

item_price_metadata

Column	Type	Keys
`name`	Unknown	PK
`item_price_id`	Unknown	PKFK
`value`	Unknown

item_price

Column	Type	Keys
`id`	Unknown	PK
`item_family_id`	Unknown	FK
`item_id`	Unknown	FK
`accounting_detail_accounting_category_1`	Unknown
`accounting_detail_accounting_category_2`	Unknown
`accounting_detail_accounting_category_3`	Unknown
`accounting_detail_accounting_category_4`	Unknown
`accounting_detail_accounting_code`	Unknown
`accounting_detail_sku`	Unknown
`archived_at`	Unknown
`billing_cycles`	Unknown
`channel`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`external_name`	Unknown
`free_quantity`	Unknown
`free_quantity_in_decimal`	Unknown
`invoice_notes`	Unknown
`is_taxable`	Unknown
`name`	Unknown
`period`	Unknown
`period_unit`	Unknown
`price`	Unknown
`price_in_decimal`	Unknown
`pricing_model`	Unknown
`resource_version`	Unknown
`shipping_period`	Unknown
`shipping_period_unit`	Unknown
`show_description_in_invoices`	Unknown
`show_description_in_quotes`	Unknown
`status`	Unknown
`tax_detail_avalara_sale_type`	Unknown
`tax_detail_avalara_service_type`	Unknown
`tax_detail_avalara_tax_code`	Unknown
`tax_detail_avalara_transaction_type`	Unknown
`tax_detail_hsn_code`	Unknown
`tax_detail_tax_profile_id`	Unknown
`tax_detail_taxjar_product_code`	Unknown
`trial_end_action`	Unknown
`trial_period`	Unknown
`trial_period_unit`	Unknown
`updated_at`	Unknown
`custom_`

transaction_invoice

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK
`applied_amount`	Unknown
`applied_at`	Unknown

transaction_linked_payment

Column	Type	Keys
`linked_payment_id`	Unknown	PK
`transaction_id`	Unknown	PKFK
`linked_payments_id`	Unknown	FK

transaction_linked_credit_note

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK
`applied_amount`	Unknown
`applied_at`	Unknown

transaction_refund

Column	Type	Keys
`refunded_transaction_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK
`transaction_amount`	Unknown
`transaction_date`	Unknown
`transaction_status`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`payment_source_id`	Unknown	FK
`reference_authorization_id`	Unknown	FK
`reference_transaction_id`	Unknown	FK
`refunded_transaction_id`	Unknown	FK
`reversal_transaction_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount`	Unknown
`amount_capturable`	Unknown
`amount_unused`	Unknown
`authorization_reason`	Unknown
`currency_code`	Unknown
`date`	Unknown
`deleted`	Unknown
`error_code`	Unknown
`error_text`	Unknown
`exchange_rate`	Unknown
`fraud_flag`	Unknown
`fraud_reason`	Unknown
`gateway`	Unknown
`gateway_account_id`	Unknown
`id_at_gateway`	Unknown
`initiator_type`	Unknown
`issuer_identification_number`	Unknown
`last_4`	Unknown
`masked_card_number`	Unknown
`merchant_reference_id`	Unknown
`payment_method`	Unknown
`payment_method_details`	Unknown
`reference_number`	Unknown
`resource_version`	Unknown
`settled_at`	Unknown
`status`	Unknown
`three_d_secure`	Unknown
`type`	Unknown
`updated_at`	Unknown
`voided_at`	Unknown

credit_note_invoice_allocation

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK
`allocated_at`	Unknown

credit_note_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`credit_note_id`	Unknown	FK
`customer_id`	Unknown	FK
`reference_line_item_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount`	Unknown
`amount_in_decimal`	Unknown
`date_from`	Unknown
`date_to`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`entity_description`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`is_taxed`	Unknown
`item_level_discount_amount`	Unknown
`object`	Unknown
`pricing_model`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`tax_amount`	Unknown
`tax_exempt_reason`	Unknown
`tax_rate`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

credit_note_line_item_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_note_id`	Unknown	FK
`line_item_id`	Unknown	FK
`is_non_compliance_tax`	Unknown
`is_partial_tax_applied`	Unknown
`local_currency_code`	Unknown
`tax_amount`	Unknown
`tax_amount_in_local_currency`	Unknown
`tax_juris_code`	Unknown
`tax_juris_name`	Unknown
`tax_juris_type`	Unknown
`tax_name`	Unknown
`tax_rate`	Unknown
`taxable_amount`	Unknown

credit_note_line_item_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_note_id`	Unknown	FK
`line_item_id`	Unknown	FK
`discount_amount`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown

credit_note_line_item_tier

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_note_id`	Unknown	FK
`line_item_id`	Unknown	FK
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`quantity_used`	Unknown
`quantity_used_in_decimal`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

credit_note_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_note_id`	Unknown	FK
`amount`	Unknown
`description`	Unknown
`name`	Unknown

credit_note_linked_refund

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK
`applied_amount`	Unknown
`applied_at`	Unknown
`refund_reason_code`	Unknown

credit_note_linked_tax_withheld_refund

Column	Type	Keys
`id`	Unknown	PK
`credit_note_id`	Unknown	FK
`amount`	Unknown
`date`	Unknown
`description`	Unknown
`reference_number`	Unknown

credit_note_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`coupon_set_code`	Unknown	FK
`credit_note_id`	Unknown	FK
`line_item_id`	Unknown	FK
`amount`	Unknown
`description`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown

credit_note

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`reference_invoice_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount_allocated`	Unknown
`amount_available`	Unknown
`amount_refunded`	Unknown
`base_currency_code`	Unknown
`channel`	Unknown
`create_reason_code`	Unknown
`currency_code`	Unknown
`date`	Unknown
`deleted`	Unknown
`exchange_rate`	Unknown
`fractional_correction`	Unknown
`local_currency_code`	Unknown
`object`	Unknown
`price_type`	Unknown
`reason_code`	Unknown
`refunded_at`	Unknown
`resource_version`	Unknown
`round_off_amount`	Unknown
`status`	Unknown
`sub_total`	Unknown
`sub_total_in_local_currency`	Unknown
`total`	Unknown
`total_in_local_currency`	Unknown
`type`	Unknown
`updated_at`	Unknown
`vat_number`	Unknown
`vat_number_prefix`	Unknown
`voided_at`	Unknown

coupon_set

Column	Type	Keys
`id`	Unknown	PK
`coupon_id`	Unknown	FK
`archived_count`	Unknown
`name`	Unknown
`redeemed_count`	Unknown
`total_count`	Unknown

entitlement

Column	Type	Keys
`id`	Unknown	PK
`entity_id`	Unknown	FK
`created_at`	Unknown
`entity_type`	Unknown
`feature_id`	Unknown
`feature_name`	Unknown
`name`	Unknown
`object`	Unknown
`value`	Unknown

payment_schedule_entry

Column	Type	Keys
`id`	Unknown	PK
`payment_schedule_id`	Unknown	PKFK
`amount`	Unknown
`date`	Unknown
`object`	Unknown
`status`	Unknown

payment_schedule

Column	Type	Keys
`id`	Unknown	PK
`entity_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`entity_type`	Unknown
`object`	Unknown
`resource_version`	Unknown
`scheme_id`	Unknown
`updated_at`	Unknown

attached_item

Column	Type	Keys
`id`	Unknown	PK
`item_id`	Unknown	FK
`parent_item_id`	Unknown	FK
`billing_cycles`	Unknown
`channel`	Unknown
`charge_on_event`	Unknown
`charge_once`	Unknown
`created_at`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`resource_version`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown

hosted_page_transaction

Column	Type	Keys
`hosted_page_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK

hosted_page

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`created_at`	Unknown
`embed`	Unknown
`expires_at`	Unknown
`object`	Unknown
`resource_version`	Unknown
`state`	Unknown
`type`	Unknown
`updated_at`	Instant
`url`	Unknown

item_family

Column	Type	Keys
`id`	Unknown	PK
`channel`	Unknown
`description`	Unknown
`name`	Unknown
`resource_version`	Unknown
`status`	Unknown
`updated_at`	Unknown

subscription_entitlement

Column	Type	Keys
`_fivetran_id`	String	PK
`feature_id`	Unknown	FK
`subscription_id`	Unknown	FK
`feature_description`	Unknown
`feature_type`	Unknown
`is_enabled`	Unknown
`is_overridden`	Unknown

comment

Column	Type	Keys
`id`	Unknown	PK
`added_by`	Unknown
`created_at`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`notes`	Unknown
`type`	Unknown

invoice_issued_credit_note

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK

invoice_adjustment_credit_note

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK

invoice_dunning_attempt

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	PKFK
`transaction_id`	Unknown	FK
`attempt`	Unknown
`created_at`	Unknown
`dunning_type`	Unknown
`transaction_amount`	Unknown
`transaction_status`	Unknown

invoice_applied_credit

Column	Type	Keys
`credit_note_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK
`applied_amount`	Unknown
`applied_at`	Unknown

invoice_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount`	Unknown
`amount_in_decimal`	Unknown
`date_from`	Unknown
`date_to`	Unknown
`deleted`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`entity_description`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`is_taxed`	Unknown
`item_level_discount_amount`	Unknown
`object`	Unknown
`pricing_model`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`tax_amount`	Unknown
`tax_exempt_reason`	Unknown
`tax_rate`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

invoice_line_item_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`line_item_id`	Unknown	FK
`is_non_compliance_tax`	Unknown
`is_partial_tax_applied`	Unknown
`local_currency_code`	Unknown
`tax_amount`	Unknown
`tax_amount_in_local_currency`	Unknown
`tax_juris_code`	Unknown
`tax_juris_name`	Unknown
`tax_juris_type`	Unknown
`tax_name`	Unknown
`tax_rate`	Unknown
`taxable_amount`	Unknown

invoice_line_item_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`line_item_id`	Unknown	FK
`discount_amount`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown

invoice_line_item_tier

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`line_item_id`	Unknown	FK
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`quantity_used`	Unknown
`quantity_used_in_decimal`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

invoice_tax

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`amount`	Unknown
`description`	Unknown
`name`	Unknown

invoice_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`line_item_id`	Unknown	FK
`amount`	Unknown
`coupon_set_code`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown

invoice_note

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`entity_id`	Unknown
`entity_type`	Unknown
`note`	Unknown

invoice_linked_tax_withheld_refund

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`amount`	Unknown
`date`	Unknown
`description`	Unknown
`reference_number`	Unknown

invoice_linked_order

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`order_id`	Unknown	PKFK

invoice_linked_payment

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK
`applied_amount`	Unknown
`applied_at`	Unknown
`transaction_amount`	Unknown
`transaction_date`	Unknown
`transaction_status`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount_adjusted`	Unknown
`amount_due`	Unknown
`amount_paid`	Unknown
`amount_to_collect`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_email`	Unknown
`billing_address_first_name`	Unknown
`billing_address_last_name`	Unknown
`billing_address_line_1`	Unknown
`billing_address_line_2`	Unknown
`billing_address_line_3`	Unknown
`billing_address_object`	Unknown
`billing_address_phone`	Unknown
`billing_address_state`	Unknown
`billing_address_state_code`	Unknown
`billing_address_validation_status`	Unknown
`billing_address_zip`	Unknown
`channel`	Unknown
`credits_applied`	Unknown
`currency_code`	Unknown
`date`	Unknown
`deleted`	Unknown
`due_date`	Unknown
`dunning_status`	Unknown
`einvoice_id`	Unknown
`einvoice_message`	Unknown
`einvoice_status`	Unknown
`exchange_rate`	Unknown
`expected_payment_date`	Unknown
`first_invoice`	Unknown
`generated_at`	Unknown
`has_advance_charges`	Unknown
`is_gifted`	Unknown
`local_currency_code`	Unknown
`net_term_days`	Unknown
`new_sales_amount`	Unknown
`next_retry_at`	Unknown
`paid_at`	Unknown
`payment_owner`	Unknown
`po_number`	Unknown
`price_type`	Unknown
`recurring`	Unknown
`resource_version`	Unknown
`round_off_amount`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_email`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_line_1`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_line_3`	Unknown
`shipping_address_object`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_state`	Unknown
`shipping_address_state_code`	Unknown
`shipping_address_validation_status`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`sub_total`	Unknown
`sub_total_in_local_currency`	Unknown
`tax`	Unknown
`term_finalized`	Unknown
`total`	Unknown
`total_in_local_currency`	Unknown
`updated_at`	Unknown
`vat_number`	Unknown
`vat_number_prefix`	Unknown
`void_reason_code`	Unknown
`voided_at`	Unknown
`write_off_amount`	Unknown

customer_referral_url

Column	Type	Keys
`_fivetran_id`	String	PK
`customer_id`	Unknown	FK
`external_customer_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`referral_account_id`	Unknown
`referral_campaign_id`	Unknown
`referral_external_campaign_id`	Unknown
`referral_sharing_url`	Unknown
`referral_system`	Unknown
`updated_at`	Unknown

customer_contact

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	PKFK
`deleted`	Unknown
`email`	Unknown
`enabled`	Unknown
`first_name`	Unknown
`label`	Unknown
`last_name`	Unknown
`phone`	Unknown
`send_account_email`	Unknown
`send_billing_email`	Unknown

customer_balance

Column	Type	Keys
`_fivetran_id`	String	PK
`customer_id`	Unknown	FK
`currency_code`	Unknown
`deleted`	Unknown
`excess_payments`	Unknown
`promotional_credits`	Unknown
`refundable_credits`	Unknown
`unbilled_charges`	Unknown

customer_entity_identifier

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	PKFK
`deleted`	Unknown
`scheme`	Unknown
`standard`	Unknown
`value`	Unknown

customer_metadata

Column	Type	Keys
`name`	Unknown	PK
`customer_id`	Unknown	PKFK
`value`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`backup_payment_source_id`	Unknown	FK
`primary_payment_source_id`	Unknown	FK
`relationship_invoice_owner_id`	Unknown	FK
`relationship_parent_id`	Unknown	FK
`relationship_payment_owner_id`	Unknown	FK
`allow_direct_debit`	Unknown
`auto_close_invoices`	Unknown
`auto_collection`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_email`	Unknown
`billing_address_first_name`	Unknown
`billing_address_last_name`	Unknown
`billing_address_line_1`	Unknown
`billing_address_line_2`	Unknown
`billing_address_line_3`	Unknown
`billing_address_object`	Unknown
`billing_address_phone`	Unknown
`billing_address_state`	Unknown
`billing_address_state_code`	Unknown
`billing_address_validation_status`	Unknown
`billing_address_zip`	Unknown
`billing_date`	Unknown
`billing_date_mode`	Unknown
`billing_day_of_week`	Unknown
`billing_day_of_week_mode`	Unknown
`business_customer_without_vat_number`	Unknown
`business_entity_id`	Unknown
`channel`	Unknown
`child_account_access_portal_download_invoices`	Unknown
`child_account_access_portal_edit_subscriptions`	Unknown
`child_account_access_send_invoice_emails`	Unknown
`child_account_access_send_payment_emails`	Unknown
`child_account_access_send_subscription_emails`	Unknown
`client_profile_id`	Unknown
`company`	Unknown
`consolidated_invoicing`	Unknown
`created_at`	Unknown
`created_from_ip`	Unknown
`customer_type`	Unknown
`deleted`	Unknown
`email`	Unknown
`entity_code`	Unknown
`excess_payments`	Unknown
`exempt_number`	Unknown
`exemption_details`	Json
`first_name`	Unknown
`fraud_flag`	Unknown
`invoice_notes`	Unknown
`is_location_valid`	Unknown
`last_name`	Unknown
`locale`	Unknown
`net_term_days`	Unknown
`offline_payment_method`	Unknown
`parent_account_access_portal_download_child_invoices`	Unknown
`parent_account_access_portal_edit_child_subscriptions`	Unknown
`parent_account_access_send_invoice_emails`	Unknown
`parent_account_access_send_payment_emails`	Unknown
`parent_account_access_send_subscription_emails`	Unknown
`payment_method_gateway`	Unknown
`payment_method_gateway_account_id`	Unknown
`payment_method_object`	Unknown
`payment_method_reference_id`	Unknown
`payment_method_status`	Unknown
`payment_method_type`	Unknown
`phone`	Unknown
`pii_cleared`	Unknown
`preferred_currency_code`	Unknown
`promotional_credits`	Unknown
`refundable_credits`	Unknown
`registered_for_gst`	Unknown
`resource_version`	Unknown
`taxability`	Unknown
`unbilled_charges`	Unknown
`updated_at`	Unknown
`use_default_hierarchy_settings`	Unknown
`vat_number`	Unknown
`vat_number_prefix`	Unknown
`vat_number_status`	Unknown
`vat_number_validated_time`	Unknown
`meta_data_`

quote_line_item

Column	Type	Keys
`id`	Unknown	PK
`quote_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`reference_line_item_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount`	Unknown
`amount_in_decimal`	Unknown
`date_from`	Unknown
`date_to`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`entity_description`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`is_taxed`	Unknown
`item_level_discount_amount`	Unknown
`object`	Unknown
`pricing_model`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`tax_amount`	Unknown
`tax_exempt_reason`	Unknown
`tax_rate`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

quote_discount

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`line_item_id`	Unknown	FK
`amount`	Unknown
`coupon_set_code`	Unknown
`description`	Unknown
`discount_percentage`	Unknown
`discount_type`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`object`	Unknown

quote_note

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`note`	Unknown

quote_line_item_tax

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`line_item_id`	Unknown	FK
`date_from`	Unknown
`date_to`	Unknown
`is_non_compliance_tax`	Unknown
`is_partial_tax_applied`	Unknown
`local_currency_code`	Unknown
`object`	Unknown
`prorated_taxable_amount`	Unknown
`tax_amount`	Unknown
`tax_amount_in_local_currency`	Unknown
`tax_juris_code`	Unknown
`tax_juris_name`	Unknown
`tax_juris_type`	Unknown
`tax_name`	Unknown
`tax_rate`	Unknown
`taxable_amount`	Unknown

quote_line_item_discount

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`coupon_id`	Unknown	FK
`line_item_id`	Unknown	FK
`discount_amount`	Unknown
`discount_type`	Unknown
`object`	Unknown

quote_line_item_tier

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`line_item_id`	Unknown	FK
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`object`	Unknown
`quantity_used`	Unknown
`quantity_used_in_decimal`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown
`unit_amount`	Unknown
`unit_amount_in_decimal`	Unknown

quote_tax

Column	Type	Keys
`index`	Unknown	PK
`quote_id`	Unknown	PKFK
`amount`	Unknown
`description`	Unknown
`name`	Unknown
`object`	Unknown

quote

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount_due`	Unknown
`amount_paid`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_email`	Unknown
`billing_address_first_name`	Unknown
`billing_address_last_name`	Unknown
`billing_address_line_1`	Unknown
`billing_address_line_2`	Unknown
`billing_address_line_3`	Unknown
`billing_address_object`	Unknown
`billing_address_phone`	Unknown
`billing_address_state`	Unknown
`billing_address_state_code`	Unknown
`billing_address_validation_status`	Unknown
`billing_address_zip`	Unknown
`business_entity_id`	Unknown
`charge_on_acceptance`	Unknown
`contract_term_end`	Unknown
`contract_term_start`	Unknown
`contract_term_termination_fee`	Unknown
`credits_applied`	Unknown
`currency_code`	Unknown
`date`	Unknown
`deleted`	Unknown
`discounts`	Unknown
`name`	Unknown
`object`	Unknown
`operation_type`	Unknown
`po_number`	Unknown
`price_type`	Unknown
`resource_version`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_email`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_index`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_line_1`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_line_3`	Unknown
`shipping_address_object`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_state`	Unknown
`shipping_address_state_code`	Unknown
`shipping_address_validation_status`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`sub_total`	Unknown
`tax_category`	Unknown
`taxes`	Unknown
`total`	Unknown
`total_payable`	Unknown
`updated_at`	Unknown
`valid_till`	Unknown
`vat_number`	Unknown
`vat_number_prefix`	Unknown
`version`	Unknown

quote_subscription_item

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`billing_cycles`	Unknown
`item_price_id`	Unknown
`item_type`	Unknown
`object`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown

quote_subscription_item_tier

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`ending_unit`	Unknown
`ending_unit_in_decimal`	Unknown
`item_price_id`	Unknown
`object`	Unknown
`price`	Unknown
`price_in_decimal`	Unknown
`starting_unit`	Unknown
`starting_unit_in_decimal`	Unknown

quote_subscription_discount

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`apply_on`	Unknown
`created_at`	Unknown
`duration_type`	Unknown
`id`	Unknown
`invoice_name`	Unknown
`item_price_id`	Unknown
`object`	Unknown
`percentage`	Unknown
`type`	Unknown

quote_subscription_addon

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`amount`	Unknown
`amount_in_decimal`	Unknown
`id`	Unknown
`proration_type`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`remaining_billing_cycles`	Unknown
`trial_end`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown

quote_subscription_event_based_addon

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`charge_once`	Unknown
`id`	Unknown
`on_event`	Unknown
`quantity`	Unknown
`quantity_in_decimal`	Unknown
`unit_price`	Unknown
`unit_price_in_decimal`	Unknown

quote_subscription_coupon

Column	Type	Keys
`id`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`object`	Unknown

quote_subscription

Column	Type	Keys
`_fivetran_id`	String	PK
`auto_collection`	Unknown
`billing_period`	Unknown
`billing_period_unit`	Unknown
`change_option`	Unknown
`changes_scheduled_at`	Unknown
`contract_term_billing_cycle_on_renewal`	Unknown
`id`	Unknown
`object`	Unknown
`plan_id`	Unknown
`plan_quantity`	Unknown
`plan_quantity_in_decimal`	Unknown
`plan_unit_price`	Unknown
`plan_unit_price_in_decimal`	Unknown
`po_number`	Unknown
`quoted_contract_term_action_at_term_end`	Unknown
`quoted_contract_term_billing_cycle`	Unknown
`quoted_contract_term_cancellation_cutoff_period`	Unknown
`quoted_contract_term_contract_end`	Unknown
`quoted_contract_term_contract_start`	Unknown
`quoted_contract_term_object`	Unknown
`quoted_contract_term_total_contract_value`	Unknown
`remaining_billing_cycles`	Unknown
`setup_fee`	Unknown
`start_date`	Unknown
`trial_end`	Unknown