# Maxio Chargify schema ERD

Table and field reference for the Fivetran Maxio Chargify connector.

## Table & Field Reference

### offer_signup_pages

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| offer_id | Unknown | PK, FK |
| enabled | Unknown |  |
| nickname | Unknown |  |
| return_params | Unknown |  |
| return_url | Unknown |  |

### offer_discounts

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| offer_id | Unknown | PK, FK |
| coupon_code | Unknown |  |
| coupon_id | Unknown |  |
| coupon_name | Unknown |  |

### offer_items

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| offer_id | Unknown | PK, FK |
| price_point_id | Unknown | FK |
| component_name | Unknown |  |
| component_unit_price | Unknown |  |
| currency_prices | Unknown |  |
| editable | Unknown |  |
| price_point_name | Unknown |  |
| starting_quantity | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_id | Unknown | FK |
| product_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| site_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| handle | Unknown |  |
| name | Unknown |  |
| product_family_name | Unknown |  |
| product_name | Unknown |  |
| product_price_in_cents | Unknown |  |
| product_price_point_name | Unknown |  |
| product_revisable_number | Unknown |  |
| updated_at | Unknown |  |

### customer_metadata

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| metafield_id | Unknown | FK |
| resource_id | Unknown | FK |
| deleted_at | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### credit_note_refund

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_uid | Unknown | PK, FK |
| applied_amount | Unknown |  |
| gateway_handle | Unknown |  |
| gateway_transaction_id | Unknown |  |
| gateway_used | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| payment_id | Unknown |  |
| transaction_id | Unknown |  |
| transaction_time | Unknown |  |

### credit_note_application

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_uid | Unknown | PK, FK |
| invoice_uid | Unknown | FK |
| applied_amount | Unknown |  |
| memo | Unknown |  |
| transaction_time | Unknown |  |

### credit_note_taxes_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_taxes_uid | Unknown | PK, FK |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |

### credit_note_taxes

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_uid | Unknown | PK, FK |
| percentage | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |
| title | Unknown |  |

### credit_note_discount_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_discount_uid | Unknown | PK, FK |
| discount_amount | Unknown |  |
| eligible_amount | Unknown |  |

### credit_note_discount

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_uid | Unknown | PK, FK |
| code | Unknown |  |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |
| eligible_amount | Unknown |  |
| percentage | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| title | Unknown |  |

### credit_note_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| credit_note_uid | Unknown | PK, FK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_id | Unknown | FK |
| description | Unknown |  |
| discount_amount | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| product_version | Unknown |  |
| quantity | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| tiered_unit_price | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| unit_price | Unknown |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| customer_id | Unknown | FK |
| site_id | Unknown | FK |
| subscription_id | Unknown | FK |
| applied_amount | Unknown |  |
| applied_date | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street | Unknown |  |
| billing_address_zip | Unknown |  |
| currency | Unknown |  |
| customer_chargify_id | Unknown |  |
| customer_email | Unknown |  |
| customer_first_name | Unknown |  |
| customer_last_name | Unknown |  |
| customer_organization | Unknown |  |
| customer_reference | Unknown |  |
| discount_amount | Unknown |  |
| issue_date | Unknown |  |
| memo | Unknown |  |
| number | Unknown |  |
| remaining_amount | Unknown |  |
| seller_address_city | Unknown |  |
| seller_address_country | Unknown |  |
| seller_address_line_2 | Unknown |  |
| seller_address_state | Unknown |  |
| seller_address_street | Unknown |  |
| seller_address_zip | Unknown |  |
| seller_name | Unknown |  |
| seller_phone | Unknown |  |
| sequence_number | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_street | Unknown |  |
| shipping_address_zip | Unknown |  |
| status | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| total_amount | Unknown |  |

### subscription_proforma_invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| subscription_proforma_invoice_uid | Unknown | PK, FK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| description | Unknown |  |
| discount_amount | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| product_version | Unknown |  |
| quantity | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| tiered_unit_price | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| unit_price | Unknown |  |

### subscription_proforma_invoice

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| customer_id | Unknown | FK |
| site_id | Unknown | FK |
| subscription_id | Unknown | FK |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street | Unknown |  |
| billing_address_zip | Unknown |  |
| collection_method | Unknown |  |
| consolidation_level | Unknown |  |
| created_at | Unknown |  |
| credit_amount | Unknown |  |
| credits | Json |  |
| currency | Unknown |  |
| custom_fields | Json |  |
| delivery_date | Unknown |  |
| discount_amount | Unknown |  |
| discounts | Unknown |  |
| due_amount | Unknown |  |
| number | Unknown |  |
| paid_amount | Unknown |  |
| payment_instructions | Unknown |  |
| payments | Json |  |
| product_family_name | Unknown |  |
| product_name | Unknown |  |
| refund_amount | Unknown |  |
| role | Unknown |  |
| seller_address_city | Unknown |  |
| seller_address_country | Unknown |  |
| seller_address_line_2 | Unknown |  |
| seller_address_state | Unknown |  |
| seller_address_street | Unknown |  |
| seller_address_zip | Unknown |  |
| seller_name | Unknown |  |
| seller_phone | Unknown |  |
| sequence_number | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_street | Unknown |  |
| shipping_address_zip | Unknown |  |
| status | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| taxes | Json |  |
| total_amount | Unknown |  |

### customer_metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enum | Json |  |
| input_type | Unknown |  |
| name | Unknown |  |

### subscription_metadata

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| metafield_id | Unknown | FK |
| resource_id | Unknown | FK |
| deleted_at | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### subscription_metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enum | Json |  |
| input_type | Unknown |  |
| name | Unknown |  |

### insight_site_stat

| Column | Type | Keys |
| --- | --- | --- |
| site_id | Unknown | PK, FK |
| seller_name | Unknown |  |
| site_currency | Unknown |  |
| site_name | Unknown |  |
| stats_revenue_this_month | Unknown |  |
| stats_revenue_this_year | Unknown |  |
| stats_revenue_today | Unknown |  |
| stats_subscriptions_today | Unknown |  |
| stats_total_revenue | Unknown |  |
| stats_total_subscriptions | Unknown |  |

### invoice_event_data_payment

| Column | Type | Keys |
| --- | --- | --- |
| transaction_id | Unknown | PK |
| invoice_event_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| payment_method_card_brand | Unknown |  |
| payment_method_card_expiration | Unknown |  |
| payment_method_last_four | Unknown |  |
| payment_method_masked_card_number | Unknown |  |
| payment_method_type | Unknown |  |
| prepayment | Unknown |  |
| transaction_time | Unknown |  |

### invoice_event_data_taxes_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_event_data_taxes_uid | Unknown | PK, FK |
| tax_amount | Unknown |  |
| tax_exempt_amount | Unknown |  |
| taxable_amount | Unknown |  |

### invoice_event_data_taxes

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_event_id | Unknown | PK, FK |
| description | Unknown |  |
| eu_vat | Unknown |  |
| percentage | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| tax_amount | Unknown |  |
| tax_component_breakouts | Unknown |  |
| tax_exempt_amount | Unknown |  |
| taxable_amount | Unknown |  |
| title | Unknown |  |
| transaction_id | Unknown |  |

### invoice_event_data_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_event_id | Unknown | PK, FK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| component_cost_data | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| hide | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| product_version | Unknown |  |
| quantity | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| tax_code | Unknown |  |
| tax_exempt_amount | Unknown |  |
| tax_included | Unknown |  |
| tiered_unit_price | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| transaction_id | Unknown |  |
| unit_price | Unknown |  |

### invoice_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_uid | Unknown | FK |
| parent_invoice_id | Unknown | FK |
| payer_chargify_id | Unknown | FK |
| site_id | Unknown | FK |
| event_data_backported_at | Unknown |  |
| event_data_billing_address_city | Unknown |  |
| event_data_billing_address_country | Unknown |  |
| event_data_billing_address_line_2 | Unknown |  |
| event_data_billing_address_state | Unknown |  |
| event_data_billing_address_street | Unknown |  |
| event_data_billing_address_zip | Unknown |  |
| event_data_collection_method | Unknown |  |
| event_data_consolidation_level | Unknown |  |
| event_data_created_at | Unknown |  |
| event_data_credit_amount | Unknown |  |
| event_data_credits | Unknown |  |
| event_data_currency | Unknown |  |
| event_data_custom_fields | Unknown |  |
| event_data_customer_id | Unknown |  |
| event_data_discount_amount | Unknown |  |
| event_data_discounts | Unknown |  |
| event_data_display_settings_display_eu_vat_breakdown | Unknown |  |
| event_data_display_settings_display_introductory_offer | Unknown |  |
| event_data_display_settings_eu_vat_breakdown_exchange_rate | Unknown |  |
| event_data_display_settings_eu_vat_breakdown_exchange_rate_cached_at | Unknown |  |
| event_data_display_settings_eu_vat_breakdown_message_template | Unknown |  |
| event_data_display_settings_eu_vat_breakdown_total_in_eur | Unknown |  |
| event_data_display_settings_eu_vat_breakdown_vat_in_eur | Unknown |  |
| event_data_display_settings_hide_zero_subtotal_lines | Unknown |  |
| event_data_display_settings_include_discounts_on_lines | Unknown |  |
| event_data_display_settings_introductory_offer | Unknown |  |
| event_data_due_amount | Unknown |  |
| event_data_due_date | Unknown |  |
| event_data_id | Unknown |  |
| event_data_issue_date | Unknown |  |
| event_data_legacy_invoice_number | Unknown |  |
| event_data_memo | Unknown |  |
| event_data_net_terms | Unknown |  |
| event_data_number | Unknown |  |
| event_data_paid_amount | Unknown |  |
| event_data_paid_date | Unknown |  |
| event_data_parent_invoice_id | Unknown |  |
| event_data_parent_invoice_number | Unknown |  |
| event_data_payment_instructions | Unknown |  |
| event_data_prepaid_usage_details | Unknown |  |
| event_data_product_family_name | Unknown |  |
| event_data_product_name | Unknown |  |
| event_data_recipient_emails | Unknown |  |
| event_data_refund_amount | Unknown |  |
| event_data_refunds | Unknown |  |
| event_data_role | Unknown |  |
| event_data_seller_address_city | Unknown |  |
| event_data_seller_address_country | Unknown |  |
| event_data_seller_address_line_2 | Unknown |  |
| event_data_seller_address_state | Unknown |  |
| event_data_seller_address_street | Unknown |  |
| event_data_seller_address_zip | Unknown |  |
| event_data_seller_logo_url | Unknown |  |
| event_data_seller_name | Unknown |  |
| event_data_seller_phone | Unknown |  |
| event_data_sequence_number | Unknown |  |
| event_data_shipping_address_city | Unknown |  |
| event_data_shipping_address_country | Unknown |  |
| event_data_shipping_address_line_2 | Unknown |  |
| event_data_shipping_address_state | Unknown |  |
| event_data_shipping_address_street | Unknown |  |
| event_data_shipping_address_zip | Unknown |  |
| event_data_site_id | Unknown |  |
| event_data_statement_id | Unknown |  |
| event_data_status | Unknown |  |
| event_data_status_changed_at | Unknown |  |
| event_data_subscription_group_id | Unknown |  |
| event_data_subscription_id | Unknown |  |
| event_data_subtotal_amount | Unknown |  |
| event_data_tax_amount | Unknown |  |
| event_data_tax_exempt_amount | Unknown |  |
| event_data_total_amount | Unknown |  |
| event_data_transaction_time | Unknown |  |
| event_data_uid | Unknown |  |
| event_data_updated_at | Unknown |  |
| event_type | Unknown |  |
| invoice_id | Unknown |  |
| timestamps | Instant |  |

### component_price_point_price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| ending_quantity | Unknown |  |
| formatted_unit_price | Unknown |  |
| segment_id | Unknown |  |
| starting_quantity | Unknown |  |
| unit_price | Unknown |  |

### component_price_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| defaults | Unknown |  |
| handle | Unknown |  |
| name | Unknown |  |
| pricing_scheme | Unknown |  |
| tax_included | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### reason_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |

### group_subscription_id

| Column | Type | Keys |
| --- | --- | --- |
| group_subscription_id | Unknown | PK, FK |
| subscription_group_id | Unknown | PK, FK |

### subscription_group

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| customer_id | Unknown | FK |
| primary_subscription_id | Unknown | FK |
| cancel_at_end_of_period | Unknown |  |
| next_assessment_at | Unknown |  |
| payment_profile_id | Unknown |  |
| pending_discounts_balance_in_cents | Unknown |  |
| prepayments_balance_in_cents | Unknown |  |
| scheme | Unknown |  |
| service_credits_balance_in_cents | Unknown |  |
| state | Unknown |  |

### product_family

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_code | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| handle | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### coupon_restrictions

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| handle | Unknown |  |
| item_id | Unknown |  |
| item_type | Unknown |  |
| name | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_id | Unknown | FK |
| allow_negative_balance | Unknown |  |
| amount | Unknown |  |
| amount_in_cents | Unknown |  |
| apply_on_cancel_at_end_of_period | Unknown |  |
| archived_at | Unknown |  |
| code | Unknown |  |
| compounding_strategy | Unknown |  |
| conversion_limit | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| duration_interval | Unknown |  |
| duration_interval_span | Unknown |  |
| duration_interval_unit | Unknown |  |
| duration_period_count | Unknown |  |
| end_date | Unknown |  |
| exclude_mid_period_allocations | Unknown |  |
| name | Unknown |  |
| percentage | Unknown |  |
| product_family_name | Unknown |  |
| recurring | Unknown |  |
| recurring_scheme | Unknown |  |
| stackable | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |
| use_site_exchange_rate | Unknown |  |

### payment_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| bank_account_holder_type | Unknown |  |
| bank_account_type | Unknown |  |
| bank_name | Unknown |  |
| billing_address | Unknown |  |
| billing_address_2 | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_state | Unknown |  |
| billing_zip | Unknown |  |
| current_vault | Unknown |  |
| customer_vault_token | Unknown |  |
| first_name | Unknown |  |
| gateway_handle | Unknown |  |
| last_name | Unknown |  |
| masked_bank_account_number | Unknown |  |
| masked_bank_routing_number | Unknown |  |
| payment_type | Unknown |  |
| site_gateway_setting_id | Unknown |  |
| vault_token | Unknown |  |
| verified | Unknown |  |

### component_price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | PK, FK |
| price_point_id | Unknown | FK |
| ending_quantity | Unknown |  |
| formatted_unit_price | Unknown |  |
| segment_id | Unknown |  |
| starting_quantity | Unknown |  |
| unit_price | Unknown |  |

### component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_price_point_id | Unknown | FK |
| product_family_id | Unknown | FK |
| accounting_code | Unknown |  |
| allow_fractional_quantities | Unknown |  |
| archived | Unknown |  |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| downgrade_credit | Unknown |  |
| handle | Unknown |  |
| hide_date_range_on_invoice | Unknown |  |
| item_category | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| price_per_unit_in_cents | Unknown |  |
| price_points_url | Unknown |  |
| pricing_scheme | Unknown |  |
| recurring | Unknown |  |
| tax_code | Unknown |  |
| taxable | Unknown |  |
| unit_name | Unknown |  |
| unit_price | Unknown |  |
| updated_at | Instant |  |
| upgrade_charge | Unknown |  |
| use_site_exchange_rate | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency | Unknown |  |
| customer_hierarchy_enabled | Unknown |  |
| default_payment_collection_method | Unknown |  |
| name | Unknown |  |
| net_terms_automatic_net_terms | Unknown |  |
| net_terms_custom_net_terms_enabled | Unknown |  |
| net_terms_default_net_terms | Unknown |  |
| net_terms_net_terms_on_remittance_signups_enabled | Unknown |  |
| net_terms_remittance_net_terms | Unknown |  |
| non_primary_currencies | Json |  |
| organization_address_city | Unknown |  |
| organization_address_country | Unknown |  |
| organization_address_line_2 | Unknown |  |
| organization_address_name | Unknown |  |
| organization_address_phone | Unknown |  |
| organization_address_state | Unknown |  |
| organization_address_street | Unknown |  |
| organization_address_zip | Unknown |  |
| relationship_invoicing_enabled | Unknown |  |
| seller_id | Unknown |  |
| subdomain | Unknown |  |
| tax_configuration_destination_address | Unknown |  |
| tax_configuration_fully_configured | Unknown |  |
| tax_configuration_kind | Unknown |  |
| test | Unknown |  |
| whopays_default_payer | Unknown |  |
| whopays_enabled | Unknown |  |

### coupon_usage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coupon_id | Unknown | FK |
| product_family_id | Unknown | FK |
| name | Unknown |  |
| revenue | Unknown |  |
| revenue_in_cents | Unknown |  |
| savings | Unknown |  |
| savings_in_cents | Unknown |  |
| signups | Unknown |  |

### invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| transaction_id | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| applied_amount | Unknown |  |
| gateway_transaction_id | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| payment_method_card_brand | Unknown |  |
| payment_method_card_expiration | Unknown |  |
| payment_method_details | Unknown |  |
| payment_method_kind | Unknown |  |
| payment_method_last_four | Unknown |  |
| payment_method_masked_card_number | Unknown |  |
| payment_method_memo | Unknown |  |
| payment_method_type | Unknown |  |
| prepayment | Unknown |  |
| transaction_time | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_id | Unknown | FK |
| component_cost_data | Json |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| product_version | Unknown |  |
| quantity | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| tiered_unit_price | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| unit_price | Unknown |  |

### invoice_discount_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_discount_uid | Unknown | PK, FK |
| discount_amount | Unknown |  |
| eligible_amount | Unknown |  |

### invoice_discount

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| code | Unknown | FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |
| eligible_amount | Unknown |  |
| integer | Unknown |  |
| percentage | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| title | Unknown |  |

### invoice_taxes_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_taxes_uid | Unknown | PK, FK |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |

### invoice_taxes

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| code | Unknown |  |
| percentage | Unknown |  |
| source_id | Unknown |  |
| source_type | Unknown |  |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |
| title | Unknown |  |

### invoice_credit

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| credit_note_uid | Unknown | FK |
| applied_amount | Unknown |  |
| credit_note_number | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| transaction_time | Unknown |  |

### invoice_refund

| Column | Type | Keys |
| --- | --- | --- |
| transaction_id | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| applied_amount | Unknown |  |
| gateway_transaction_id | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| payment_id | Unknown |  |

### invoice_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| name | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |
| value | Unknown |  |

### previous_balance_data_invoice

| Column | Type | Keys |
| --- | --- | --- |
| previous_balance_data_invoice_uid | Unknown | PK |
| invoice_uid | Unknown | PK, FK |
| number | Unknown |  |
| outstanding_amount | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| customer_id | Unknown | FK |
| group_primary_subscription_id | Unknown | FK |
| parent_invoice_uid | Unknown | FK |
| site_id | Unknown | FK |
| subscription_id | Unknown | FK |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street | Unknown |  |
| billing_address_zip | Unknown |  |
| collection_method | Unknown |  |
| consolidation_level | Unknown |  |
| created_at | Unknown |  |
| credit_amount | Unknown |  |
| currency | Unknown |  |
| discount_amount | Unknown |  |
| due_amount | Unknown |  |
| due_date | Unknown |  |
| issue_date | Unknown |  |
| memo | Unknown |  |
| number | Unknown |  |
| paid_amount | Unknown |  |
| paid_date | Unknown |  |
| parent_invoice_number | Unknown |  |
| payment_instructions | Unknown |  |
| previous_balance_data_capture_date | Unknown |  |
| product_family_name | Unknown |  |
| product_name | Unknown |  |
| public_url | Unknown |  |
| refund_amount | Unknown |  |
| seller_address_city | Unknown |  |
| seller_address_country | Unknown |  |
| seller_address_line_2 | Unknown |  |
| seller_address_state | Unknown |  |
| seller_address_street | Unknown |  |
| seller_address_zip | Unknown |  |
| seller_name | Unknown |  |
| seller_phone | Unknown |  |
| sequence_number | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_street | Unknown |  |
| shipping_address_zip | Unknown |  |
| status | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| total_amount | Unknown |  |
| updated_at | Instant |  |

### transaction_taxation_tax_rules

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| transaction_taxation_index | Unknown | PK, FK |
| country_code | Unknown |  |
| description | Unknown |  |
| subdivision_code | Unknown |  |
| tax_rule_id | Unknown |  |

### transaction_taxation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| rate | Unknown |  |
| tax_amount_in_cents | Unknown |  |
| tax_charge_id | Unknown |  |
| tax_id | Unknown |  |
| tax_name | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | FK |
| component_price_point_id | Unknown | FK |
| customer_id | Unknown | FK |
| product_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount_in_cents | Unknown |  |
| card_expiration | Unknown |  |
| card_number | Unknown |  |
| card_type | Unknown |  |
| component_handle | Unknown |  |
| component_price_point_handle | Unknown |  |
| created_at | Instant |  |
| currency | Unknown |  |
| discount_amount_in_cents | Unknown |  |
| ending_balance_in_cents | Unknown |  |
| exchange_rate | Unknown |  |
| gateway_handle | Unknown |  |
| gateway_order_id | Unknown |  |
| gateway_response_code | Unknown |  |
| gateway_transaction_id | Unknown |  |
| gateway_used | Unknown |  |
| item_name | Unknown |  |
| kind | Unknown |  |
| memo | Unknown |  |
| original_amount_in_cents | Unknown |  |
| parent_id | Unknown |  |
| payment_id | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| price_point_handle | Unknown |  |
| price_point_id | Unknown |  |
| quantity | Unknown |  |
| refunded_amount_in_cents | Unknown |  |
| role | Unknown |  |
| site_gateway_setting_id | Unknown |  |
| starting_balance_in_cents | Unknown |  |
| statement_id | Unknown |  |
| success | Unknown |  |
| tax_id | Unknown |  |
| taxable_amount_in_cents | Unknown |  |
| type | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_subscription_group_uid | Unknown | FK |
| parent_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| cc_emails | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| organization | Unknown |  |
| phone | Unknown |  |
| portal_customer_created_at | Unknown |  |
| portal_invite_last_accepted_at | Unknown |  |
| portal_invite_last_sent_at | Unknown |  |
| reference | Unknown |  |
| state | Unknown |  |
| state_name | Unknown |  |
| tax_exempt | Unknown |  |
| updated_at | Instant |  |
| vat_number | Unknown |  |
| verified | Unknown |  |
| zip | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_customer_id | Unknown | FK |
| coupon_code | Unknown | FK |
| credit_card_customer_id | Unknown | FK |
| customer_id | Unknown | FK |
| next_product_id | Unknown | FK |
| next_product_price_point_id | Unknown | FK |
| offer_id | Unknown | FK |
| payer_id | Unknown | FK |
| product_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| reason_code | Unknown | FK |
| activated_at | Unknown |  |
| automatically_resume_at | Unknown |  |
| balance_in_cents | Unknown |  |
| bank_account_bank_name | Unknown |  |
| bank_account_billing_address | Unknown |  |
| bank_account_billing_address_2 | Unknown |  |
| bank_account_billing_city | Unknown |  |
| bank_account_billing_country | Unknown |  |
| bank_account_billing_state | Unknown |  |
| bank_account_billing_zip | Unknown |  |
| bank_account_chargify_token | Unknown |  |
| bank_account_current_vault | Unknown |  |
| bank_account_customer_vault_token | Unknown |  |
| bank_account_first_name | Unknown |  |
| bank_account_gateway_handle | Unknown |  |
| bank_account_holder_type | Unknown |  |
| bank_account_id | Unknown |  |
| bank_account_last_name | Unknown |  |
| bank_account_masked_bank_account_number | Unknown |  |
| bank_account_masked_bank_routing_number | Unknown |  |
| bank_account_site_gateway_setting_id | Unknown |  |
| bank_account_type | Unknown |  |
| bank_account_vault_token | Unknown |  |
| cancel_at_end_of_period | Unknown |  |
| canceled_at | Unknown |  |
| cancellation_message | Unknown |  |
| cancellation_method | Unknown |  |
| coupon_use_count | Unknown |  |
| coupon_uses_allowed | Unknown |  |
| created_at | Unknown |  |
| credit_card_billing_address | Unknown |  |
| credit_card_billing_address_2 | Unknown |  |
| credit_card_billing_city | Unknown |  |
| credit_card_billing_country | Unknown |  |
| credit_card_billing_state | Unknown |  |
| credit_card_billing_zip | Unknown |  |
| credit_card_card_type | Unknown |  |
| credit_card_current_vault | Unknown |  |
| credit_card_customer_vault_token | Unknown |  |
| credit_card_expiration_month | Unknown |  |
| credit_card_expiration_year | Unknown |  |
| credit_card_first_name | Unknown |  |
| credit_card_gateway_handle | Unknown |  |
| credit_card_id | Unknown |  |
| credit_card_last_name | Unknown |  |
| credit_card_masked_card_number | Unknown |  |
| credit_card_payment_type | Unknown |  |
| credit_card_site_gateway_setting_id | Unknown |  |
| credit_card_vault_token | Unknown |  |
| current_billing_amount_in_cents | Unknown |  |
| current_period_ends_at | Unknown |  |
| current_period_started_at | Unknown |  |
| delayed_cancel_at | Unknown |  |
| dunning_communication_delay_enabled | Unknown |  |
| dunning_communication_delay_time_zone | Unknown |  |
| expires_at | Unknown |  |
| group_primarys | Unknown |  |
| group_uid | Unknown |  |
| net_terms | Unknown |  |
| next_assessment_at | Unknown |  |
| on_hold_at | Unknown |  |
| payment_collection_method | Unknown |  |
| payment_type | Unknown |  |
| prepaid_dunning | Unknown |  |
| previous_state | Unknown |  |
| reference | Unknown |  |
| referral_code | Unknown |  |
| signup_payment_id | Unknown |  |
| signup_revenue | Unknown |  |
| snap_day | Unknown |  |
| state | Unknown |  |
| stored_credential_transaction_id | Unknown |  |
| total_revenue_in_cents | Unknown |  |
| trial_ended_at | Unknown |  |
| trial_started_at | Unknown |  |
| updated_at | Instant |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| event_specific_data_component_id | Unknown | FK |
| subscription_id | Unknown | FK |
| created_at | Instant |  |
| event_specific_data_event_type | Unknown |  |
| event_specific_data_memo | Unknown |  |
| event_specific_data_metafield_id | Unknown |  |
| event_specific_data_metafield_name | Unknown |  |
| event_specific_data_new_subscription_state | Unknown |  |
| event_specific_data_new_unit_balance | Unknown |  |
| event_specific_data_new_value | Unknown |  |
| event_specific_data_old_value | Unknown |  |
| event_specific_data_previous_subscription_state | Unknown |  |
| event_specific_data_previous_unit_balance | Unknown |  |
| event_specific_data_resource_id | Unknown |  |
| event_specific_data_resource_type | Unknown |  |
| event_specific_data_usage_quantity | Unknown |  |
| key | Unknown |  |
| message | Unknown |  |

### product_public_signup_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| currency | Unknown |  |
| enabled | Unknown |  |
| nickname | Unknown |  |
| return_params | Unknown |  |
| return_url | Unknown |  |
| url | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_product_price_point_id | Unknown | FK |
| product_family_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| accounting_code | Unknown |  |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| expiration_interval | Unknown |  |
| expiration_interval_unit | Unknown |  |
| handle | Unknown |  |
| initial_charge_after_trial | Unknown |  |
| initial_charge_in_cents | Unknown |  |
| interval | Unknown |  |
| interval_unit | Unknown |  |
| item_category | Unknown |  |
| name | Unknown |  |
| price_in_cents | Unknown |  |
| request_billing_address | Unknown |  |
| request_credit_card | Unknown |  |
| require_billing_address | Unknown |  |
| require_credit_card | Unknown |  |
| require_shipping_address | Unknown |  |
| return_params | Unknown |  |
| tax_code | Unknown |  |
| taxable | Unknown |  |
| trial_interval | Unknown |  |
| trial_interval_unit | Unknown |  |
| trial_price_in_cents | Unknown |  |
| update_return_params | Unknown |  |
| update_return_url | Unknown |  |
| updated_at | Instant |  |
| use_site_exchange_rate | Unknown |  |
| version_number | Unknown |  |

### subscription_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_family_id | Unknown | FK |
| subscription_id | Unknown | FK |
| currency | Unknown |  |
| display_on_hosted_page | Unknown |  |
| unit_balance | Unknown |  |
| updated_at | Instant |  |

### products_price_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| subscription_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| expiration_interval | Unknown |  |
| expiration_interval_unit | Unknown |  |
| handle | Unknown |  |
| initial_charge_after_trial | Unknown |  |
| initial_charge_in_cents | Unknown |  |
| interval | Unknown |  |
| interval_unit | Unknown |  |
| introductory_offer | Unknown |  |
| name | Unknown |  |
| price_in_cents | Unknown |  |
| tax_included | Unknown |  |
| trial_interval | Unknown |  |
| trial_interval_unit | Unknown |  |
| trial_price_in_cents | Unknown |  |
| trial_type | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### allocation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| component_id | Unknown |  |
| memo | Unknown |  |
| previous_quantity | Unknown |  |
| proration_downgrade_scheme | Unknown |  |
| proration_upgrade_scheme | Unknown |  |
| quantity | Unknown |  |
| subscription_id | Unknown |  |
| timestamps | Unknown |  |

### usage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| subscription_id | Unknown | FK |
| created_at | Instant |  |
| memo | Unknown |  |
| quantity | Unknown |  |

### prepayment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| amount_in_cents | Unknown |  |
| created_at | Instant |  |
| details | Unknown |  |
| external | Unknown |  |
| memo | Unknown |  |
| payment_type | Unknown |  |
| remaining_amount_in_cents | Unknown |  |

### subscription_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| sticky | Unknown |  |
| updated_at | Unknown |  |

### preview_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| preview_performa_invoice_subscription_id | Unknown | PK, FK |
| metadatum_id | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |
| value | Unknown |  |

### preview_payment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| preview_performa_invoice_subscription_id | Unknown | FK |
| applied_amount | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |
| prepayment | Unknown |  |

### preview_credit

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| preview_performa_invoice_subscription_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| memo | Unknown |  |
| original_amount | Unknown |  |

### preview_taxes_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| preview_performa_invoice_subscription_id | Unknown | FK |
| preview_taxes_uid | Unknown | FK |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |

### preview_taxes

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| preview_performa_invoice_subscription_id | Unknown | PK, FK |
| percentage | Unknown |  |
| source_type | Unknown |  |
| tax_amount | Unknown |  |
| taxable_amount | Unknown |  |
| title | Unknown |  |

### preview_discount_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| preview_discount_index | Unknown | FK |
| preview_performa_invoice_subscription_id | Unknown | FK |
| discount_amount | Unknown |  |
| eligible_amount | Unknown |  |

### preview_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| preview_performa_invoice_subscription_id | Unknown | PK, FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |
| eligible_amount | Unknown |  |
| source_type | Unknown |  |
| title | Unknown |  |

### preview_line_item

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| preview_performa_invoice_subscription_id | Unknown | PK, FK |
| component_id | Unknown | FK |
| price_point_id | Unknown | FK |
| product_id | Unknown | FK |
| product_price_point_id | Unknown | FK |
| description | Unknown |  |
| discount_amount | Unknown |  |
| period_range_end | Unknown |  |
| period_range_start | Unknown |  |
| quantity | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| tiered_unit_price | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| unit_price | Unknown |  |

### preview_performa_invoice

| Column | Type | Keys |
| --- | --- | --- |
| subscription_id | Unknown | PK, FK |
| customer_chargify_id | Unknown | FK |
| customer_id | Unknown | FK |
| site_id | Unknown | FK |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street | Unknown |  |
| billing_address_zip | Unknown |  |
| collection_method | Unknown |  |
| consolidation_level | Unknown |  |
| created_at | Unknown |  |
| credit_amount | Unknown |  |
| currency | Unknown |  |
| delivery_date | Unknown |  |
| discount_amount | Unknown |  |
| due_amount | Unknown |  |
| memo | Unknown |  |
| number | Unknown |  |
| paid_amount | Unknown |  |
| payment_instructions | Unknown |  |
| product_family_name | Unknown |  |
| refund_amount | Unknown |  |
| role | Unknown |  |
| seller_address_city | Unknown |  |
| seller_address_country | Unknown |  |
| seller_address_line_2 | Unknown |  |
| seller_address_state | Unknown |  |
| seller_address_street | Unknown |  |
| seller_address_zip | Unknown |  |
| seller_name | Unknown |  |
| seller_phone | Unknown |  |
| sequence_number | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_street | Unknown |  |
| shipping_address_zip | Unknown |  |
| status | Unknown |  |
| subtotal_amount | Unknown |  |
| tax_amount | Unknown |  |
| total_amount | Unknown |  |
| uid | Unknown |  |

## Relationships

- offer_signup_pages(offer_id) → offer(id)
- offer_discounts(offer_id) → offer(id)
- offer_items(component_id) → component(id)
- offer_items(price_point_id) → component_price_point(id)
- offer_items(offer_id) → offer(id)
- offer(product_id) → product(id)
- offer(product_price_point_id) → products_price_point(id)
- offer(product_family_id) → product_family(id)
- offer(site_id) → site(id)
- customer_metadata(resource_id) → customer(id)
- customer_metadata(metafield_id) → customer_metafield(id)
- credit_note_refund(credit_note_uid) → credit_note(uid)
- credit_note_application(invoice_uid) → invoice(uid)
- credit_note_application(credit_note_uid) → credit_note(uid)
- credit_note_taxes_line_item(credit_note_taxes_uid) → credit_note_taxes(uid)
- credit_note_taxes(credit_note_uid) → credit_note(uid)
- credit_note_discount_line_item(credit_note_discount_uid) → credit_note_discount(uid)
- credit_note_discount(credit_note_uid) → credit_note(uid)
- credit_note_line_item(product_id) → product(id)
- credit_note_line_item(component_id) → component(id)
- credit_note_line_item(price_point_id) → component_price_point(id)
- credit_note_line_item(credit_note_uid) → credit_note(uid)
- credit_note(subscription_id) → subscription(id)
- credit_note(customer_id) → customer(id)
- credit_note(site_id) → site(id)
- subscription_proforma_invoice_line_item(product_id) → product(id)
- subscription_proforma_invoice_line_item(product_price_point_id) → products_price_point(id)
- subscription_proforma_invoice_line_item(component_id) → component(id)
- subscription_proforma_invoice_line_item(price_point_id) → component_price_point(id)
- subscription_proforma_invoice_line_item(subscription_proforma_invoice_uid) → subscription_proforma_invoice(uid)
- subscription_proforma_invoice(subscription_id) → subscription(id)
- subscription_proforma_invoice(customer_id) → customer(id)
- subscription_proforma_invoice(site_id) → site(id)
- subscription_metadata(resource_id) → subscription(id)
- subscription_metadata(metafield_id) → subscription_metafield(id)
- insight_site_stat(site_id) → site(id)
- invoice_event_data_payment(invoice_event_id) → invoice_event(id)
- invoice_event_data_taxes_line_item(invoice_event_data_taxes_uid) → invoice_event_data_taxes(uid)
- invoice_event_data_taxes(invoice_event_id) → invoice_event(id)
- invoice_event_data_line_item(product_id) → product(id)
- invoice_event_data_line_item(product_price_point_id) → products_price_point(id)
- invoice_event_data_line_item(component_id) → component(id)
- invoice_event_data_line_item(price_point_id) → component_price_point(id)
- invoice_event_data_line_item(invoice_event_id) → invoice_event(id)
- invoice_event(invoice_uid) → invoice(uid)
- invoice_event(payer_chargify_id) → customer(id)
- invoice_event(parent_invoice_id) → subscription(id)
- invoice_event(customer_id) → customer(id)
- invoice_event(site_id) → site(id)
- component_price_point_price(price_point_id) → component_price_point(id)
- component_price_point_price(component_id) → component(id)
- component_price_point(component_id) → component(id)
- reason_code(site_id) → site(id)
- group_subscription_id(group_subscription_id) → subscription(id)
- group_subscription_id(subscription_group_id) → subscription_group(uid)
- subscription_group(primary_subscription_id) → subscription(id)
- subscription_group(customer_id) → customer(id)
- coupon_restrictions(coupon_id) → coupon(id)
- coupon(product_family_id) → product_family(id)
- payment_profile(customer_id) → customer(id)
- component_price(price_point_id) → component_price_point(id)
- component_price(component_id) → component(id)
- component(product_family_id) → product_family(id)
- component(default_price_point_id) → component_price_point(id)
- coupon_usage(product_family_id) → product_family(id)
- coupon_usage(coupon_id) → coupon(id)
- invoice_payment(invoice_uid) → invoice(uid)
- invoice_line_item(product_id) → product(id)
- invoice_line_item(component_id) → component(id)
- invoice_line_item(price_point_id) → component_price_point(id)
- invoice_line_item(invoice_uid) → invoice(uid)
- invoice_discount_line_item(invoice_discount_uid) → invoice_discount(uid)
- invoice_discount(code) → coupon(code)
- invoice_discount(invoice_uid) → invoice(uid)
- invoice_taxes_line_item(invoice_taxes_uid) → invoice_taxes(uid)
- invoice_taxes(invoice_uid) → invoice(uid)
- invoice_credit(credit_note_uid) → credit_note(uid)
- invoice_credit(invoice_uid) → invoice(uid)
- invoice_refund(invoice_uid) → invoice(uid)
- invoice_custom_field(invoice_uid) → invoice(uid)
- previous_balance_data_invoice(invoice_uid) → invoice(uid)
- invoice(subscription_id) → subscription(id)
- invoice(parent_invoice_uid) → invoice(uid)
- invoice(customer_id) → customer(id)
- invoice(group_primary_subscription_id) → subscription(id)
- invoice(site_id) → site(id)
- transaction_taxation_tax_rules(transaction_id) → transaction(id)
- transaction_taxation_tax_rules(transaction_taxation_index) → transaction_taxation(index)
- transaction_taxation(transaction_id) → transaction(id)
- transaction(product_id) → product(id)
- transaction(subscription_id) → subscription(id)
- transaction(component_price_point_id) → component_price_point(id)
- transaction(component_id) → component(id)
- transaction(customer_id) → customer(id)
- customer(default_subscription_group_uid) → subscription_group(uid)
- customer(parent_id) → customer(id)
- subscription(product_id) → product(id)
- subscription(customer_id) → customer(id)
- subscription(product_price_point_id) → products_price_point(id)
- subscription(next_product_price_point_id) → products_price_point(id)
- subscription(payer_id) → customer(id)
- subscription(coupon_code) → coupon(code)
- subscription(reason_code) → reason_code(code)
- subscription(offer_id) → offer(id)
- subscription(next_product_id) → product(id)
- subscription(bank_account_customer_id) → customer(id)
- subscription(credit_card_customer_id) → customer(id)
- event(subscription_id) → subscription(id)
- event(customer_id) → customer(id)
- event(event_specific_data_component_id) → component(id)
- product_public_signup_page(product_id) → product(id)
- product(product_price_point_id) → products_price_point(id)
- product(product_family_id) → product_family(id)
- product(default_product_price_point_id) → products_price_point(id)
- subscription_component(subscription_id) → subscription(id)
- subscription_component(component_id) → component(id)
- subscription_component(product_family_id) → product_family(id)
- subscription_component(price_point_id) → component_price_point(id)
- products_price_point(product_id) → product(id)
- products_price_point(subscription_id) → subscription(id)
- allocation(id) → subscription(id)
- usage(component_id) → component(id)
- usage(price_point_id) → component_price_point(id)
- usage(subscription_id) → subscription(id)
- prepayment(subscription_id) → subscription(id)
- subscription_note(subscription_id) → subscription(id)
- preview_custom_field(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_payment(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_credit(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_taxes_line_item(preview_taxes_uid) → preview_taxes(uid)
- preview_taxes_line_item(preview_performa_invoice_subscription_id) → preview_taxes(preview_performa_invoice_subscription_id)
- preview_taxes(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_discount_line_item(preview_discount_index) → preview_discount(index)
- preview_discount_line_item(preview_performa_invoice_subscription_id) → preview_discount(preview_performa_invoice_subscription_id)
- preview_discount(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_line_item(product_id) → product(id)
- preview_line_item(product_price_point_id) → products_price_point(id)
- preview_line_item(component_id) → component(id)
- preview_line_item(price_point_id) → component_price_point(id)
- preview_line_item(preview_performa_invoice_subscription_id) → preview_performa_invoice(subscription_id)
- preview_performa_invoice(subscription_id) → subscription(id)
- preview_performa_invoice(customer_chargify_id) → customer(id)
- preview_performa_invoice(customer_id) → customer(id)
- preview_performa_invoice(site_id) → site(id)