# Chargebee Product Catalog 2.0 schema ERD

Table and field reference for the Fivetran Chargebee Product Catalog 2.0 connector.

## 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 | PK, FK |
| 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_history_charged_item_price

| Column | Type | Keys |
| --- | --- | --- |
| item_price_id | Unknown | PK, FK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| deleted | Unknown |  |
| last_charged_at | Unknown |  |

### subscription_history_item_price

| Column | Type | Keys |
| --- | --- | --- |
| item_price_id | Unknown | PK, FK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| 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_history_coupon

| Column | Type | Keys |
| --- | --- | --- |
| coupon_id | Unknown | PK, FK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| coupon_code | Unknown | FK |
| applied_count | Unknown |  |
| apply_till | Unknown |  |
| deleted | Unknown |  |

### subscription_history_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| 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_history_item_tier_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| deleted | Unknown |  |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| item_price_id | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| subscription_index | Unknown |  |

### subscription_history_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| subscription_history_id | Unknown | PK, FK |
| subscription_history_updated_at | Unknown | PK, FK |
| value | Unknown |  |

### subscription_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| updated_at | 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 |  |
| meta_data_** |  |  |

### subscription_renewal_estimate_invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_estimate_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| item_id | Unknown | PK, FK |

### item_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| item_id | Unknown | PK, FK |
| 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 | PK, FK |
| ramp_id | Unknown | PK, FK |
| 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 | PK, FK |
| ramp_id | Unknown | PK, FK |
| 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 | PK, FK |
| apply_till | Unknown |  |

### ramp_discounts_to_add

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ramp_id | Unknown | PK, FK |
| 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 | PK, FK |
| ramp_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| scheduled_subscription_change_id | Unknown | PK, FK |
| billing_cycles | Unknown |  |
| billing_period | Unknown |  |
| billing_period_unit | Unknown |  |

### scheduled_subscription_change

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| billing_period | Unknown |  |
| billing_period_unit | Unknown |  |
| remaining_billing_cycles | Unknown |  |

### subscription_charged_item_price

| Column | Type | Keys |
| --- | --- | --- |
| item_price_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| deleted | Unknown |  |
| last_charged_at | Unknown |  |

### subscription_item_price

| Column | Type | Keys |
| --- | --- | --- |
| item_price_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| 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 | PK, FK |
| subscription_id | Unknown | PK, FK |
| coupon_code | Unknown | FK |
| applied_count | Unknown |  |
| apply_till | Unknown |  |
| deleted | Unknown |  |

### subscription_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| 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 |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| item_price_id | Unknown | FK |
| deleted | Unknown |  |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| subscription_index | Unknown |  |

### subscription_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| 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 | PK, FK |
| webhook_status | Unknown |  |

### event_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| coupon_item_constraint_type | Unknown | PK, FK |
| coupon_item_constraints | Unknown | PK, FK |
| item_price_id | Unknown | PK, FK |

### coupon_item_constraint

| Column | Type | Keys |
| --- | --- | --- |
| constraints | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| item_type | Unknown | PK, FK |

### coupon_applicable_item_family

| Column | Type | Keys |
| --- | --- | --- |
| coupon_id | Unknown | PK, FK |
| coupon_item_constraint_criteria_index | Unknown | PK, FK |
| item_family_id | Unknown | PK, FK |
| coupon_item_constraint_criteria_item_type | String |  |

### coupon_applicable_price_period

| Column | Type | Keys |
| --- | --- | --- |
| item_price_period | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| coupon_item_constraint_criteria_index | Unknown | PK, FK |

### coupon_item_constraint_criteria

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| item_type | String | FK |
| currencies | Json |  |

### coupon_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| transaction_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |

### transaction_linked_payment

| Column | Type | Keys |
| --- | --- | --- |
| linked_payment_id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| linked_payments_id | Unknown | FK |

### transaction_linked_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| credit_note_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |

### transaction_refund

| Column | Type | Keys |
| --- | --- | --- |
| refunded_transaction_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| 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 | PK, FK |
| invoice_id | String | PK, FK |
| allocated_amount | Unknown |  |
| 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 | PK, FK |
| transaction_id | Unknown | PK, FK |
| 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 | String | 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 | PK, FK |
| 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 | PK, FK |
| transaction_id | Unknown | PK, FK |

### 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 |  |
| name | Unknown |  |
| value | 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 | PK, FK |
| invoice_id | Unknown | PK, FK |

### invoice_adjustment_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| credit_note_id | Unknown | PK, FK |
| invoice_id | Unknown | PK, FK |

### invoice_dunning_attempt

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| invoice_id | Unknown | PK, FK |
| 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 | PK, FK |
| invoice_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| 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 | PK, FK |
| amount | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| reference_number | Unknown |  |

### invoice_linked_order

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |

### invoice_linked_payment

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| deleted | Unknown |  |
| scheme | Unknown |  |
| standard | Unknown |  |
| value | Unknown |  |

### customer_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_id | Unknown | PK, FK |
| 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 | PK, 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 |  |

### quote_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| 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 | PK, FK |
| note | Unknown |  |

### quote_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- gift_timeline(gift_id) → gift(id)
- gift(gift_receiver) → customer(id)
- gift(gift_receiver_subscription_id) → subscription(id)
- gift(gifter_customer_id) → customer(id)
- gift(gifter_invoice_id) → invoice(id)
- usage(subscription_id) → subscription(id)
- usage(invoice_id) → invoice(id)
- usage(item_price_id) → item_price(id)
- contract_term(subscription_id) → subscription(id)
- subscription_history_charged_item_price(item_price_id) → item_price(id)
- subscription_history_charged_item_price(subscription_history_id) → subscription_history(id)
- subscription_history_charged_item_price(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history_item_price(item_type) → item(id)
- subscription_history_item_price(item_price_id) → item_price(id)
- subscription_history_item_price(subscription_history_id) → subscription_history(id)
- subscription_history_item_price(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history_coupon(coupon_id) → coupon(id)
- subscription_history_coupon(coupon_code) → coupon_code(code)
- subscription_history_coupon(subscription_history_id) → subscription_history(id)
- subscription_history_coupon(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history_discount(subscription_history_id) → subscription_history(id)
- subscription_history_discount(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history_item_tier_price(subscription_history_id) → subscription_history(id)
- subscription_history_item_tier_price(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history_metadata(subscription_history_id) → subscription_history(id)
- subscription_history_metadata(subscription_history_updated_at) → subscription_history(updated_at)
- subscription_history(customer_id) → customer(id)
- subscription_history(payment_source_id) → payment_source(id)
- subscription_history(business_entity_id) → customer(id)
- subscription_history(contract_term_business_entity_id) → subscription(id)
- subscription_history(contract_term_subscription_id) → subscription(id)
- subscription_renewal_estimate_invoice_line_item(subscription_id) → subscription(id)
- subscription_renewal_estimate_invoice_line_item(customer_id) → customer(id)
- subscription_renewal_estimate_invoice_line_item(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_renewal_estimate(subscription_estimate_id) → subscription(id)
- subscription_renewal_estimate(invoice_estimate_customer_id) → customer(id)
- payment_source_mandate(subscription_id) → subscription(id)
- payment_source_mandate(payment_source_id) → payment_source(id)
- payment_source(customer_id) → customer(id)
- applicable_item(applicable_item_id) → item(id)
- applicable_item(item_id) → item(id)
- item_metadata(item_id) → item(id)
- item(item_family_id) → item_family(id)
- ramp_items_to_add(item_price_id) → item_price(id)
- ramp_items_to_add(ramp_id) → ramp(id)
- ramp_items_to_update(item_price_id) → item_price(id)
- ramp_items_to_update(ramp_id) → ramp(id)
- ramp_coupons_to_add(ramp_id) → ramp(id)
- ramp_discounts_to_add(ramp_id) → ramp(id)
- ramp_item_tier(item_price_id) → item_price(id)
- ramp_item_tier(ramp_id) → ramp(id)
- ramp_contract_term(ramp_id) → ramp(id)
- ramp_status_transition_reason(ramp_id) → ramp(id)
- ramp(subscription_id) → subscription(id)
- differential_price_tier(differential_price_id) → differential_price(id)
- differential_price_parent_period(differential_price_id) → differential_price(id)
- differential_price(parent_item_id) → item(id)
- differential_price(item_price_id) → item_price(id)
- resent_order(order_id) → orders(id)
- order_line_item(invoice_line_item_id) → invoice_line_item(line_item_id)
- order_line_item(invoice_id) → invoice(id)
- order_line_item(order_id) → orders(id)
- order_line_item_tax(line_item_id) → order_line_item(line_item_id)
- order_line_item_tax(order_id) → orders(id)
- order_line_item_discount(line_item_id) → order_line_item(line_item_id)
- order_line_item_discount(order_id) → orders(id)
- order_linked_credit_note(id) → credit_note(id)
- order_linked_credit_note(order_id) → orders(id)
- orders(gift_id) → gift(id)
- orders(original_order_id) → orders(id)
- orders(subscription_id) → subscription(id)
- orders(invoice_id) → invoice(id)
- orders(customer_id) → customer(id)
- scheduled_subscription_change_item_price(item_price_id) → item_price(id)
- scheduled_subscription_change_item_price(scheduled_subscription_change_id) → scheduled_subscription_change(id)
- scheduled_subscription_change(id) → subscription(id)
- subscription_charged_item_price(item_price_id) → item_price(id)
- subscription_charged_item_price(subscription_id) → subscription(id)
- subscription_item_price(item_type) → item(id)
- subscription_item_price(item_price_id) → item_price(id)
- subscription_item_price(subscription_id) → subscription(id)
- subscription_coupon(coupon_id) → coupon(id)
- subscription_coupon(coupon_code) → coupon_code(code)
- subscription_coupon(subscription_id) → subscription(id)
- subscription_discount(subscription_id) → subscription(id)
- subscription_item_tier_price(item_price_id) → item_price(id)
- subscription_item_tier_price(subscription_id) → subscription(id)
- subscription_metadata(subscription_id) → subscription(id)
- subscription(customer_id) → customer(id)
- subscription(payment_source_id) → payment_source(id)
- subscription(business_entity_id) → customer(id)
- subscription(contract_term_business_entity_id) → subscription(id)
- subscription(contract_term_subscription_id) → subscription(id)
- event_webhook(event_id) → event(id)
- event_metadata(event_id) → event(id)
- coupon_code(coupon_id) → coupon(id)
- coupon_code(coupon_set_id) → coupon_set(id)
- coupon_applicable_item_price(item_price_id) → item_price(id)
- coupon_applicable_item_price(coupon_id) → coupon(id)
- coupon_applicable_item_price(coupon_item_constraints) → coupon_item_constraint(constraints)
- coupon_applicable_item_price(coupon_item_constraint_type) → coupon_item_constraint(item_type)
- coupon_item_constraint(item_type) → item(type)
- coupon_item_constraint(coupon_id) → coupon(id)
- coupon_applicable_item_family(item_family_id) → item_family(id)
- coupon_applicable_item_family(coupon_id) → coupon(id)
- coupon_applicable_item_family(coupon_item_constraint_criteria_index) → coupon_item_constraint_criteria(index)
- coupon_applicable_price_period(coupon_id) → coupon(id)
- coupon_applicable_price_period(coupon_item_constraint_criteria_index) → coupon_item_constraint_criteria(index)
- coupon_item_constraint_criteria(item_type) → item(type)
- coupon_item_constraint_criteria(coupon_id) → coupon(id)
- coupon_metadata(coupon_id) → coupon(id)
- item_price_tier(item_price_id) → item_price(id)
- item_price_metadata(item_price_id) → item_price(id)
- item_price(item_id) → item(id)
- item_price(item_family_id) → item_family(id)
- transaction_invoice(invoice_id) → invoice(id)
- transaction_invoice(transaction_id) → transaction(id)
- transaction_linked_payment(transaction_id) → transaction(id)
- transaction_linked_payment(linked_payments_id) → transaction(id)
- transaction_linked_credit_note(credit_note_id) → credit_note(id)
- transaction_linked_credit_note(transaction_id) → transaction(id)
- transaction_refund(refunded_transaction_id) → transaction(id)
- transaction_refund(transaction_id) → transaction(id)
- transaction(reference_transaction_id) → transaction(id)
- transaction(subscription_id) → subscription(id)
- transaction(reference_authorization_id) → transaction(id)
- transaction(refunded_transaction_id) → transaction(id)
- transaction(reversal_transaction_id) → transaction(id)
- transaction(customer_id) → customer(id)
- transaction(payment_source_id) → payment_source(id)
- credit_note_invoice_allocation(invoice_id) → invoice(id)
- credit_note_invoice_allocation(credit_note_id) → credit_note(id)
- credit_note_line_item(subscription_id) → subscription(id)
- credit_note_line_item(customer_id) → customer(id)
- credit_note_line_item(reference_line_item_id) → invoice_line_item(line_item_id)
- credit_note_line_item(credit_note_id) → credit_note(id)
- credit_note_line_item_tax(line_item_id) → credit_note_line_item(line_item_id)
- credit_note_line_item_tax(credit_note_id) → credit_note(id)
- credit_note_line_item_discount(line_item_id) → credit_note_line_item(line_item_id)
- credit_note_line_item_discount(credit_note_id) → credit_note(id)
- credit_note_line_item_tier(line_item_id) → credit_note_line_item(line_item_id)
- credit_note_line_item_tier(credit_note_id) → credit_note(id)
- credit_note_tax(credit_note_id) → credit_note(id)
- credit_note_linked_refund(transaction_id) → transaction(id)
- credit_note_linked_refund(credit_note_id) → credit_note(id)
- credit_note_linked_tax_withheld_refund(credit_note_id) → credit_note(id)
- credit_note_discount(coupon_set_code) → coupon(id)
- credit_note_discount(line_item_id) → credit_note_line_item(line_item_id)
- credit_note_discount(credit_note_id) → credit_note(id)
- credit_note(reference_invoice_id) → invoice(id)
- credit_note(subscription_id) → subscription(id)
- credit_note(customer_id) → customer(id)
- coupon_set(coupon_id) → coupon(id)
- entitlement(entity_id) → item(id)
- payment_schedule_entry(payment_schedule_id) → payment_schedule(id)
- payment_schedule(entity_id) → invoice(id)
- attached_item(parent_item_id) → item(id)
- attached_item(item_id) → item(id)
- hosted_page_transaction(transaction_id) → transaction(id)
- hosted_page_transaction(hosted_page_id) → hosted_page(id)
- hosted_page(customer_id) → customer(id)
- subscription_entitlement(subscription_id) → subscription(id)
- subscription_entitlement(feature_id) → entitlement(feature_id)
- invoice_issued_credit_note(credit_note_id) → credit_note(id)
- invoice_issued_credit_note(invoice_id) → invoice(id)
- invoice_adjustment_credit_note(credit_note_id) → credit_note(id)
- invoice_adjustment_credit_note(invoice_id) → invoice(id)
- invoice_dunning_attempt(transaction_id) → transaction(id)
- invoice_dunning_attempt(invoice_id) → invoice(id)
- invoice_applied_credit(credit_note_id) → credit_note(id)
- invoice_applied_credit(invoice_id) → invoice(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_line_item(customer_id) → customer(id)
- invoice_line_item(subscription_id) → subscription(id)
- invoice_line_item_tax(line_item_id) → invoice_line_item(line_item_id)
- invoice_line_item_tax(invoice_id) → invoice(id)
- invoice_line_item_discount(line_item_id) → invoice_line_item(line_item_id)
- invoice_line_item_discount(invoice_id) → invoice(id)
- invoice_line_item_tier(line_item_id) → invoice_line_item(line_item_id)
- invoice_line_item_tier(invoice_id) → invoice(id)
- invoice_tax(invoice_id) → invoice(id)
- invoice_discount(line_item_id) → invoice_line_item(line_item_id)
- invoice_discount(invoice_id) → invoice(id)
- invoice_note(invoice_id) → invoice(id)
- invoice_linked_tax_withheld_refund(invoice_id) → invoice(id)
- invoice_linked_order(order_id) → orders(id)
- invoice_linked_order(invoice_id) → invoice(id)
- invoice_linked_payment(transaction_id) → transaction(id)
- invoice_linked_payment(invoice_id) → invoice(id)
- invoice(subscription_id) → subscription(id)
- invoice(customer_id) → customer(id)
- customer_referral_url(external_customer_id) → customer(id)
- customer_referral_url(customer_id) → customer(id)
- customer_contact(customer_id) → customer(id)
- customer_balance(customer_id) → customer(id)
- customer_entity_identifier(customer_id) → customer(id)
- customer_metadata(customer_id) → customer(id)
- customer(backup_payment_source_id) → payment_source(id)
- customer(primary_payment_source_id) → payment_source(id)
- customer(relationship_invoice_owner_id) → customer(id)
- customer(relationship_parent_id) → customer(id)
- customer(relationship_payment_owner_id) → invoice(id)
- quote_line_item(subscription_id) → subscription(id)
- quote_line_item(customer_id) → customer(id)
- quote_line_item(reference_line_item_id) → quote_line_item(id)
- quote_line_item(quote_id) → quote(id)
- quote_discount(line_item_id) → quote_line_item(id)
- quote_discount(quote_id) → quote(id)
- quote_note(quote_id) → quote(id)
- quote_line_item_tax(line_item_id) → quote_line_item(id)
- quote_line_item_tax(quote_id) → quote(id)
- quote_line_item_discount(line_item_id) → quote_line_item(id)
- quote_line_item_discount(coupon_id) → coupon(id)
- quote_line_item_discount(quote_id) → quote(id)
- quote_line_item_tier(line_item_id) → quote_line_item(id)
- quote_line_item_tier(quote_id) → quote(id)
- quote_tax(quote_id) → quote(id)
- quote(subscription_id) → subscription(id)
- quote(invoice_id) → invoice(id)
- quote(customer_id) → customer(id)
- quote_subscription_item(fivetran_id) → quote_subscription(_fivetran_id)
- quote_subscription_item_tier(fivetran_id) → quote_subscription(_fivetran_id)
- quote_subscription_discount(fivetran_id) → quote_subscription(_fivetran_id)
- quote_subscription_addon(fivetran_id) → quote_subscription(_fivetran_id)
- quote_subscription_event_based_addon(fivetran_id) → quote_subscription(_fivetran_id)
- quote_subscription_coupon(fivetran_id) → quote_subscription(_fivetran_id)