# Zuora schema ERD

Table and field reference for the Fivetran Zuora connector.

## Table & Field Reference

### journal_entry_detail_invoice_payment_application

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### rate_plan_charge_tier

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| rate_plan_charge_id | String | FK |
| amendment_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| discount_amount | Double |  |
| discount_percentage | Double |  |
| ending_unit | Double |  |
| included_units | Double |  |
| overage_price | Double |  |
| price | Double |  |
| price_format | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_id | String |  |
| starting_unit | Double |  |
| subscription_id | String |  |
| tier | Long |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_refund_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_invoice_payment_application_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| ach_account_type | String |  |
| ach_city | String |  |
| ach_country | String |  |
| ach_postal_code | String |  |
| ach_state | String |  |
| active | Boolean |  |
| bank_city | String |  |
| bank_code | String |  |
| bank_transfer_account_type | String |  |
| bank_transfer_type | String |  |
| business_identification_code | String |  |
| company_name | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_card_type | String |  |
| device_session_id | String |  |
| existing_mandate | String |  |
| iban | String |  |
| identity_number | String |  |
| is_company | Boolean |  |
| last_failed_sale_transaction_date | Instant |  |
| last_transaction_date_time | Instant |  |
| last_transaction_status | String |  |
| mandate_creation_date | LocalDate |  |
| mandate_reason | String |  |
| mandate_received | String |  |
| mandate_status | String |  |
| mandate_update_date | LocalDate |  |
| max_consecutive_payment_failures | Long |  |
| name | String |  |
| num_consecutive_failures | Long |  |
| payment_method_status | String |  |
| payment_retry_window | Long |  |
| paypal_type | String |  |
| total_number_of_error_payments | Long |  |
| total_number_of_processed_payments | Long |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |
| use_default_retry_rule | Boolean |  |

### revenue_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| revenue_schedule_id | String | FK |
| account_id | String |  |
| amendment_id | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| description | String |  |
| number | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| recognition_end | LocalDate |  |
| recognition_start | LocalDate |  |
| revenue_charge_summary_id | String |  |
| revenue_event_type_id | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### payment_method_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_method_id | String | FK |
| account_id | String |  |
| ach_aba_code | String |  |
| ach_account_name | String |  |
| ach_account_number_mask | String |  |
| company_name | String |  |
| country | String |  |
| created_date | Instant |  |
| credit_card_expiration_month | Long |  |
| credit_card_expiration_year | Long |  |
| credit_card_mask_number | String |  |
| credit_card_type | String |  |
| device_session_id | String |  |
| existing_mandate | String |  |
| is_company | Boolean |  |
| last_failed_sale_transaction_date | Instant |  |
| last_transaction_date_time | Instant |  |
| last_transaction_status | String |  |
| mandate_creation_date | LocalDate |  |
| mandate_id | String |  |
| mandate_reason | String |  |
| mandate_received | String |  |
| mandate_status | String |  |
| mandate_update_date | LocalDate |  |
| max_consecutive_payment_failures | Long |  |
| method_reference_id | String |  |
| method_specific_data | String |  |
| name | String |  |
| num_consecutive_failures | Long |  |
| payment_method_status | String |  |
| payment_retry_window | Long |  |
| paypal_type | String |  |
| state | String |  |
| sub_type | String |  |
| token_id | String |  |
| total_number_of_error_payments | Long |  |
| total_number_of_processed_payments | Long |  |
| type | String |  |
| updated_date | Instant |  |
| use_default_retry_rule | Boolean |  |
| user_reference_id | String |  |

### journal_entry_detail_credit_memo_application_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### revenue_charge_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| rate_plan_charge_id | String | FK |
| account_id | String |  |
| amendment_id | String |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| description | String |  |
| number | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_id | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_credit_balance_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### refund_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| refund_id | String | FK |
| account_id | String |  |
| account_receivable_accounting_code_id | String |  |
| accounting_period_id | String |  |
| bill_to_contact_id | String |  |
| cash_accounting_code_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| invoice_id | String |  |
| invoice_payment_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| parent_account_id | String |  |
| payment_id | String |  |
| payment_method_id | String |  |
| payment_method_snapshot_id | String |  |
| refund_amount | Double |  |
| ship_to_contact_id | String |  |
| sold_to_contact_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_invoice_item_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### taxation_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| invoice_item_id | String | FK |
| account_id | String |  |
| account_receivable_accounting_code_id | String |  |
| accounting_code | String |  |
| amendment_id | String |  |
| balance | Double |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_amount | Double |  |
| customer_code | String |  |
| default_payment_method_id | String |  |
| exempt_amount | Double |  |
| exempt_certificate | String |  |
| invoice_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| jurisdiction | String |  |
| location_code | String |  |
| name | String |  |
| parent_account_id | String |  |
| payment_amount | Double |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| sales_tax_payable_accounting_code_id | String |  |
| seller_registration | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| tax_amount | Double |  |
| tax_code | String |  |
| tax_code_description | String |  |
| tax_date | LocalDate |  |
| tax_mode | String |  |
| tax_rate | Double |  |
| tax_rate_description | String |  |
| tax_rate_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### refund

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_method_id | String | FK |
| account_id | String |  |
| accounting_code | String |  |
| amount | String |  |
| bill_to_contact_id | String |  |
| cancelled_on | Instant |  |
| comment | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| gateway | String |  |
| gateway_reconciliation_reason | String |  |
| gateway_reconciliation_status | String |  |
| gateway_response | String |  |
| gateway_response_code | String |  |
| gateway_state | String |  |
| marked_for_submission_on | Instant |  |
| method_type | String |  |
| parent_account_id | String |  |
| payment_method_snapshot_id | String |  |
| payout_id | String |  |
| reason_code | String |  |
| reference_id | String |  |
| refund_date | LocalDate |  |
| refund_number | String |  |
| refund_transaction_time | String |  |
| second_refund_reference_id | String |  |
| settled_on | Instant |  |
| soft_descriptor | String |  |
| soft_descriptor_phone | String |  |
| sold_to_contact_id | String |  |
| source_type | String |  |
| status | String |  |
| submitted_on | Instant |  |
| transferred_to_accounting | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### product_rate_plan_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_rate_plan_id | String | FK |
| accounting_code | String |  |
| apply_discount_to | String |  |
| bill_cycle_day | Long |  |
| bill_cycle_type | String |  |
| billing_period | String |  |
| billing_period_alignment | String |  |
| charge_model | String |  |
| charge_type | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_quantity | Double |  |
| deferred_revenue_account | String |  |
| description | String |  |
| discount_level | String |  |
| end_date_condition | String |  |
| included_units | Double |  |
| legacy_revenue_reporting | Boolean |  |
| list_price_base | String |  |
| max_quantity | Double |  |
| min_quantity | Double |  |
| name | String |  |
| number_of_period | Long |  |
| overage_calculation_option | String |  |
| overage_unused_units_credit_option | String |  |
| price_change_option | String |  |
| price_increase_percentage | Double |  |
| recognized_revenue_account | String |  |
| rev_rec_code | String |  |
| rev_rec_trigger_condition | String |  |
| revenue_recognition_rule_name | String |  |
| smoothing_model | String |  |
| specific_billing_period | Long |  |
| tax_code | String |  |
| tax_mode | String |  |
| taxable | Boolean |  |
| trigger_event | String |  |
| uom | String |  |
| up_to_periods | Long |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### revenue_schedule_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| accounting_period_id | String | FK |
| revenue_schedule_id | String | FK |
| account_id | String |  |
| amendment_id | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| deferred_revenue_accounting_code_id | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| recognized_revenue_accounting_code_id | String |  |
| revenue_charge_summary_id | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| payment_method_id | String | FK |
| accounting_code | String |  |
| amount | Double |  |
| applied_amount | Double |  |
| applied_credit_balance_amount | Double |  |
| auth_transaction_id | String |  |
| bill_to_contact_id | String |  |
| cancelled_on | Instant |  |
| comment | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| effective_date | LocalDate |  |
| gateway | String |  |
| gateway_order_id | String |  |
| gateway_reconciliation_reason | String |  |
| gateway_reconciliation_status | String |  |
| gateway_response | String |  |
| gateway_response_code | String |  |
| gateway_state | String |  |
| marked_for_submission_on | Instant |  |
| payment_method_snapshot_id | String |  |
| payment_number | String |  |
| payout_id | String |  |
| reference_id | String |  |
| referenced_payment_id | String |  |
| refund_amount | Double |  |
| second_payment_reference_id | String |  |
| settled_on | Instant |  |
| soft_descriptor | String |  |
| source | String |  |
| source_name | String |  |
| status | String |  |
| submitted_on | Instant |  |
| transferred_to_accounting | String |  |
| type | String |  |
| unapplied_amount | Double |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### order_action

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| order_id | String | FK |
| account_id | String |  |
| auto_generated | Boolean |  |
| auto_renew | Boolean |  |
| bill_to_contact_id | String |  |
| cancellation_effective_date | LocalDate |  |
| cancellation_policy | String |  |
| change_reason | String |  |
| clearing_existing_bill_to_contact | Boolean |  |
| clearing_existing_payment_term | Boolean |  |
| contract_effective_date | LocalDate |  |
| created_by_id | String |  |
| created_date | Instant |  |
| current_term | Long |  |
| current_term_period_type | String |  |
| customer_acceptance_date | LocalDate |  |
| default_payment_method_id | String |  |
| effective_policy | String |  |
| order_action_bill_to_id | String |  |
| parent_account_id | String |  |
| payment_term | String |  |
| renew_setting | String |  |
| renewal_term | Long |  |
| renewal_term_period_type | String |  |
| resume_date | LocalDate |  |
| sequence | Long |  |
| service_activation_date | LocalDate |  |
| sold_to_contact_id | String |  |
| sub_type | String |  |
| subscription_bill_to_id | String |  |
| subscription_id | String |  |
| subscription_owner_account_bill_to_id | String |  |
| subscription_owner_account_id | String |  |
| subscription_owner_account_sold_to_id | String |  |
| subscription_version_amendment_id | String |  |
| suspend_date | Instant |  |
| term_start_date | LocalDate |  |
| term_type | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### revenue_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| revenue_charge_summary_id | String | FK |
| account_id | String |  |
| amendment_id | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| billing_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| description | String |  |
| finance_transaction_type | String |  |
| number | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| recognition_period_end | LocalDate |  |
| recognition_period_start | LocalDate |  |
| reference_id | String |  |
| revenue_schedule_date | LocalDate |  |
| rule | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| transaction_date | LocalDate |  |
| transaction_number | String |  |
| undistributed_amount | Double |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### product_rate_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_id | String | FK |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| effective_end_date | LocalDate |  |
| effective_start_date | LocalDate |  |
| external_id_source_system | String |  |
| name | String |  |
| product_rate_plan_number | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### subscription_metrics_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| subscription_id | String | FK |
| account_id | String |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| end_date | LocalDate |  |
| ending_mrr_discount_amount | Double |  |
| ending_mrr_gross_amount | Double |  |
| ending_mrr_net_amount | Double |  |
| invoice_owner_account_id | String |  |
| invoice_owner_account_number | String |  |
| invoice_owner_id | String |  |
| org_tag_id | String |  |
| original_subscription_id | String |  |
| parent_account_id | String |  |
| ship_to_contact_id | String |  |
| sold_to_contact_id | String |  |
| start_date | LocalDate |  |
| subscription_name | String |  |
| subscription_owner_account_id | String |  |
| subscription_owner_account_number | String |  |
| tcb_discount_amount | Double |  |
| tcb_gross_amount | Double |  |
| tcb_net_amount | Double |  |
| tcv_discount_amount | Double |  |
| tcv_gross_amount | Double |  |
| tcv_net_amount | Double |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### ramp

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| order_id | String | FK |
| charge_numbers | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| discount_tcb | Double |  |
| discount_tcv | Double |  |
| gross_tcb | Double |  |
| gross_tcv | Double |  |
| metrics_processing_status | String |  |
| name | String |  |
| net_tcb | Double |  |
| net_tcv | Double |  |
| number | String |  |
| subscription_numbers | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### rate_plan_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_rate_plan_charge_id | String | FK |
| rate_plan_id | String | FK |
| account_id | String |  |
| accounting_code | String |  |
| apply_discount_to | String |  |
| bill_cycle_day | Long |  |
| bill_cycle_type | String |  |
| billing_period | String |  |
| billing_period_alignment | String |  |
| billing_timing | String |  |
| charge_model | String |  |
| charge_number | String |  |
| charge_type | String |  |
| charged_through_date | LocalDate |  |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| discount_level | String |  |
| dmrc | Double |  |
| dtcv | Double |  |
| effective_end_date | LocalDate |  |
| effective_start_date | LocalDate |  |
| end_date_condition | String |  |
| is_last_segment | Boolean |  |
| list_price_base | String |  |
| mrr | Double |  |
| name | String |  |
| number_of_periods | Long |  |
| original_id | String |  |
| overage_calculation_option | String |  |
| overage_unused_units_credit_option | String |  |
| processed_through_date | LocalDate |  |
| product_id | String |  |
| quantity | Double |  |
| rev_rec_code | String |  |
| rev_rec_trigger_condition | String |  |
| segment | Long |  |
| specific_billing_period | Long |  |
| uom | String |  |
| updated_date | Instant |  |
| version | Long |  |

### rate_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_rate_plan_id | String | FK |
| subscription_id | String | FK |
| account_id | String |  |
| amendment_id | String |  |
| amendment_type | String |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| externally_managed_plan_id | String |  |
| invoice_owner_id | String |  |
| is_from_external_catalog | Boolean |  |
| name | String |  |
| original_rate_plan_id | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_number | String |  |
| reverted | Boolean |  |
| sold_to_contact_id | String |  |
| subscription_owner_id | String |  |
| subscription_rate_plan_number | String |  |
| subscription_version_amendment_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| address_1 | String |  |
| address_2 | String |  |
| city | String |  |
| country | String |  |
| county | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| fax | String |  |
| first_name | String |  |
| home_phone | String |  |
| last_name | String |  |
| mobile_phone | String |  |
| nick_name | String |  |
| other_phone | String |  |
| other_phone_type | String |  |
| personal_email | String |  |
| postal_code | String |  |
| state | String |  |
| tax_region | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |
| work_email | String |  |
| work_phone | String |  |

### journal_entry_detail_taxation_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| accounting_period_id | String | FK |
| journal_run_id | String | FK |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| journal_entry_date | LocalDate |  |
| notes | String |  |
| number | String |  |
| status | String |  |
| transaction_count | Long |  |
| transaction_type | String |  |
| transfer_date | Instant |  |
| transferred_by | String |  |
| transferred_to_accounting | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### usage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| rate_plan_charge_id | String | FK |
| subscription_id | String | FK |
| account_number | String |  |
| amendment_id | String |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| description | String |  |
| end_date_time | Instant |  |
| file_name | String |  |
| import_id | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| quantity | Double |  |
| rate_plan_id | String |  |
| rbe_status | String |  |
| sold_to_contact_id | String |  |
| source_type | String |  |
| start_date_time | Instant |  |
| submission_date_time | Instant |  |
| uom | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### email_notification_history

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bcc | String |  |
| cc | String |  |
| error_message | String |  |
| event_category | Int |  |
| from_email | String |  |
| notification | String |  |
| reply_to | String |  |
| result | String |  |
| send_time | String |  |
| subject | String |  |
| to_email | String |  |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| order_id | String | FK |
| amendment_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| end_date | LocalDate |  |
| order_action_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| quantity | Double |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| start_date | LocalDate |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_revenue_event_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| journal_entry_id | String | FK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | String |  |

### journal_entry_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| journal_entry_id | String | FK |
| accounting_code_id | String |  |
| accounting_period_id | String |  |
| amount | Double |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| journal_run_id | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_debit_taxation_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### order

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| bill_to_contact_id | String |  |
| category | String |  |
| created_by_id | String |  |
| created_by_migration | Boolean |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| description | String |  |
| error_code | String |  |
| error_message | String |  |
| is_scheduled | Boolean |  |
| order_date | LocalDate |  |
| order_number | String |  |
| parent_account_id | String |  |
| response | String |  |
| reversion_order | Boolean |  |
| reverted_by_order_id | String |  |
| reverted_date | LocalDate |  |
| reverted_order_id | String |  |
| reverted_order_number | String |  |
| scheduled_date | LocalDate |  |
| scheduled_date_policy | String |  |
| sold_to_contact_id | String |  |
| state | String |  |
| status | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| auto_renew | Boolean |  |
| bill_to_contact_id | String |  |
| cancelled_date | LocalDate |  |
| contract_acceptance_date | LocalDate |  |
| contract_effective_date | LocalDate |  |
| created_by_id | String |  |
| created_date | String |  |
| creator_account_id | String |  |
| creator_invoice_owner_id | String |  |
| current_term | Long |  |
| current_term_period_type | String |  |
| default_payment_method_id | String |  |
| externally_managed_by | String |  |
| initial_term | Long |  |
| initial_term_period_type | String |  |
| invoice_owner_id | String |  |
| is_invoice_separate | Boolean |  |
| name | String |  |
| notes | String |  |
| opportunity_name_qt | String |  |
| original_created_date | Instant |  |
| original_id | String |  |
| payment_term | String |  |
| previous_subscription_id | String |  |
| quote_business_type_qt | String |  |
| quote_number_qt | String |  |
| renewal_setting | String |  |
| renewal_term | Long |  |
| renewal_term_period_type | String |  |
| revision | String |  |
| service_activation_date | LocalDate |  |
| status | String |  |
| subscription_end_date | LocalDate |  |
| subscription_start_date | LocalDate |  |
| term_end_date | LocalDate |  |
| term_start_date | LocalDate |  |
| term_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |
| version | Long |  |

### accounting_period

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by_id | String |  |
| created_date | Instant |  |
| end_date | String |  |
| fiscal_quarter | Long |  |
| fiscal_year | Long |  |
| name | String |  |
| notes | String |  |
| start_date | LocalDate |  |
| status | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### credit_balance_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| payment_id | String | FK |
| account_receivable_accounting_code_id | String |  |
| accounting_code | String |  |
| accounting_period_id | String |  |
| adjustment_date | LocalDate |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| cancelled_on | Instant |  |
| cash_accounting_code_id | String |  |
| comment | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| customer_cash_on_account_accounting_code_id | String |  |
| default_payment_method_id | String |  |
| invoice_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| number | String |  |
| parent_account_id | String |  |
| payment_method_id | String |  |
| payment_method_snapshot_id | String |  |
| reason_code | String |  |
| reference_id | String |  |
| refund_id | String |  |
| sold_to_contact_id | String |  |
| source_transaction_id | String |  |
| source_transaction_number | String |  |
| source_transaction_type | String |  |
| status | String |  |
| transferred_to_accounting | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_credit_memo_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### invoice_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| invoice_id | String | FK |
| account_id | String |  |
| account_receivable_accounting_code_id | String |  |
| accounting_code | String |  |
| accounting_period_id | String |  |
| adjustment_date | LocalDate |  |
| adjustment_number | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| cancelled_by_id | String |  |
| cancelled_on | Instant |  |
| comments | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| deferred_revenue_accounting_code_id | String |  |
| impact_amount | Double |  |
| invoice_number | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| parent_account_id | String |  |
| reason_code | String |  |
| reference_id | String |  |
| ship_to_contact_id | String |  |
| sold_to_contact_id | String |  |
| status | String |  |
| transferred_to_accounting | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| bill_to_contact_id | String | FK |
| sold_to_contact_id | String | FK |
| account_number | String |  |
| allow_invoice_edit | Boolean |  |
| auto_pay | Boolean |  |
| balance | Double |  |
| batch | String |  |
| bcd_setting_option | String |  |
| bill_cycle_day | Long |  |
| communication_profile_id | String |  |
| created_by_id | String |  |
| created_date | String |  |
| credit_balance | Double |  |
| crm_id | String |  |
| currency | String |  |
| customer_service_rep_name | String |  |
| default_payment_method_id | String |  |
| invoice_delivery_prefs_email | Boolean |  |
| invoice_delivery_prefs_print | Boolean |  |
| invoice_template_id | String |  |
| last_invoice_date | LocalDate |  |
| mrr | Double |  |
| parent_id | String |  |
| payment_gateway | String |  |
| payment_term | String |  |
| purchase_order_number | String |  |
| sales_rep_name | String |  |
| sequence_set_id | String |  |
| status | String |  |
| tax_exempt_certificate_type | String |  |
| tax_exempt_description | String |  |
| tax_exempt_effective_date | LocalDate |  |
| tax_exempt_expiration_date | LocalDate |  |
| tax_exempt_issuing_jurisdiction | String |  |
| tax_exempt_status | String |  |
| total_debit_memo_balance | Double |  |
| total_invoice_balance | Double |  |
| unapplied_balance | Double |  |
| unapplied_credit_memo_amount | Double |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### product_rate_plan_charge_tier

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_rate_plan_charge_id | String | FK |
| active | Boolean |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| discount_amount | Double |  |
| discount_percentage | Double |  |
| ending_unit | Double |  |
| included_units | Double |  |
| overage_price | Double |  |
| price | Double |  |
| price_format | String |  |
| product_id | String |  |
| product_rate_plan_id | String |  |
| starting_unit | Double |  |
| tier | Long |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### revenue_charge_summary_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| revenue_charge_summary_id | String | FK |
| account_id | String |  |
| accounting_period_id | String |  |
| amendment_id | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_debit_memo_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | String |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### ramp_interval

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ramp_id | String | FK |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| discount_tcb | Double |  |
| discount_tcv | Double |  |
| end_date | LocalDate |  |
| gross_tcb | Double |  |
| gross_tcv | Double |  |
| name | String |  |
| net_tcb | Double |  |
| net_tcv | Double |  |
| start_date | LocalDate |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_run

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by_id | String |  |
| created_date | Instant |  |
| number | String |  |
| process_end_date_time | Instant |  |
| process_start_date_time | Instant |  |
| status | String |  |
| target_date_type | String |  |
| target_end_date | LocalDate |  |
| target_start_date | LocalDate |  |
| total_journal_entry_count | Long |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_invoice_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | String |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_refund_application_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | String |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_credit_memo_taxation_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| invoice_id | String | FK |
| rate_plan_charge_id | String | FK |
| account_id | String |  |
| account_receivable_accounting_code_id | String |  |
| accounting_code | String |  |
| amendment_id | String |  |
| applied_to_invoice_item_id | String |  |
| balance | Double |  |
| bill_to_contact_id | String |  |
| bill_to_contact_snapshot_id | String |  |
| booking_reference | String |  |
| charge_amount | Double |  |
| charge_date | String |  |
| charge_name | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| default_payment_method_id | String |  |
| deferred_revenue_accounting_code_id | String |  |
| exclude_item_billing_from_revenue_accounting | Boolean |  |
| journal_entry_id | String |  |
| processing_type | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| quantity | Double |  |
| rate_plan_id | String |  |
| recognized_revenue_accounting_code_id | String |  |
| rev_rec_start_date | LocalDate |  |
| service_end_date | LocalDate |  |
| service_start_date | LocalDate |  |
| sku | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| tax_amount | Double |  |
| tax_code | String |  |
| tax_exempt_amount | Double |  |
| tax_mode | String |  |
| unit_price | Double |  |
| uom | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| adjustment_amount | Double |  |
| amount | Double |  |
| amount_without_tax | Double |  |
| auto_pay | Boolean |  |
| balance | Double |  |
| bill_to_contact_id | String |  |
| bill_to_contact_snapshot_id | String |  |
| comments | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_balance_adjustment_amount | Double |  |
| default_payment_method_id | String |  |
| due_date | LocalDate |  |
| includes_one_time | Boolean |  |
| includes_recurring | Boolean |  |
| includes_usage | Boolean |  |
| invoice_date | LocalDate |  |
| invoice_number | String |  |
| last_email_sent_date | Instant |  |
| parent_account_id | String |  |
| payment_amount | Double |  |
| payment_term | String |  |
| posted_by | String |  |
| posted_date | Instant |  |
| refund_amount | Double |  |
| reversed | Boolean |  |
| sold_to_contact_id | String |  |
| sold_to_contact_snapshot_id | String |  |
| source | String |  |
| source_id | String |  |
| source_type | String |  |
| status | String |  |
| target_date | LocalDate |  |
| tax_amount | Double |  |
| tax_exempt_amount | Double |  |
| tax_message | String |  |
| tax_status | String |  |
| transferred_to_accounting | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### amendment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| subscription_id | String | FK |
| auto_renew | Boolean |  |
| booking_date | LocalDate |  |
| code | String |  |
| contract_effective_date | LocalDate |  |
| created_by_id | String |  |
| created_date | Instant |  |
| current_term | Long |  |
| current_term_period_type | String |  |
| customer_acceptance_date | LocalDate |  |
| description | String |  |
| effective_date | LocalDate |  |
| effective_policy | String |  |
| name | String |  |
| new_rate_plan_id | String |  |
| removed_rate_plan_id | String |  |
| renewal_setting | String |  |
| renewal_term | Long |  |
| renewal_term_period_type | String |  |
| resume_date | LocalDate |  |
| service_activation_date | LocalDate |  |
| specific_update_date | LocalDate |  |
| status | String |  |
| sub_type | String |  |
| suspend_date | LocalDate |  |
| term_start_date | LocalDate |  |
| term_type | String |  |
| type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### revenue_event_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| revenue_event_id | String | FK |
| account_id | String |  |
| accounting_period_id | String |  |
| amendment_id | String |  |
| amount | Double |  |
| bill_to_contact_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency | String |  |
| default_payment_method_id | String |  |
| deferred_revenue_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| parent_account_id | String |  |
| product_id | String |  |
| product_rate_plan_charge_id | String |  |
| product_rate_plan_id | String |  |
| rate_plan_charge_id | String |  |
| rate_plan_id | String |  |
| recognized_revenue_accounting_code_id | String |  |
| revenue_charge_summary_id | String |  |
| revenue_event_type_id | String |  |
| revenue_schedule_id | String |  |
| sold_to_contact_id | String |  |
| subscription_id | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| allow_feature_changes | Boolean |  |
| category | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| description | String |  |
| effective_end_date | LocalDate |  |
| effective_start_date | LocalDate |  |
| name | String |  |
| product_number | String |  |
| sku | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

### journal_entry_detail_refund_application

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String |  |
| amount | Double |  |
| container_transaction_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| credit_accounting_code_id | String |  |
| currency | String |  |
| debit_accounting_code_id | String |  |
| journal_entry_id | String |  |
| journal_run_id | String |  |
| transaction_date | LocalDate |  |
| transaction_id | String |  |
| transaction_subtype | String |  |
| transaction_type | String |  |
| updated_by_id | String |  |
| updated_date | Instant |  |

## Relationships

- rate_plan_charge_tier(rate_plan_charge_id) → rate_plan_charge(id)
- payment_method(account_id) → account(id)
- revenue_event(revenue_schedule_id) → revenue_schedule(id)
- payment_method_snapshot(payment_method_id) → payment_method(id)
- revenue_charge_summary(rate_plan_charge_id) → rate_plan_charge(id)
- refund_invoice_payment(refund_id) → refund(id)
- taxation_item(invoice_item_id) → invoice_item(id)
- refund(payment_method_id) → payment_method(id)
- product_rate_plan_charge(product_rate_plan_id) → product_rate_plan(id)
- revenue_schedule_item(revenue_schedule_id) → revenue_schedule(id)
- revenue_schedule_item(accounting_period_id) → accounting_period(id)
- payment(account_id) → account(id)
- payment(payment_method_id) → payment_method(id)
- order_action(order_id) → order(id)
- revenue_schedule(revenue_charge_summary_id) → revenue_charge_summary(id)
- product_rate_plan(product_id) → product(id)
- subscription_metrics_summary(subscription_id) → subscription(id)
- ramp(order_id) → order(id)
- rate_plan_charge(rate_plan_id) → rate_plan(id)
- rate_plan_charge(product_rate_plan_charge_id) → product_rate_plan_charge(id)
- rate_plan(product_rate_plan_id) → product_rate_plan(id)
- rate_plan(subscription_id) → subscription(id)
- contact(account_id) → account(id)
- journal_entry(journal_run_id) → journal_run(id)
- journal_entry(accounting_period_id) → accounting_period(id)
- usage(account_id) → account(id)
- usage(subscription_id) → subscription(id)
- usage(rate_plan_charge_id) → rate_plan_charge(id)
- order_item(order_id) → order(id)
- journal_entry_detail_revenue_event_item(journal_entry_id) → journal_entry(id)
- journal_entry_item(journal_entry_id) → journal_entry(id)
- order(account_id) → account(id)
- subscription(account_id) → account(id)
- credit_balance_adjustment(account_id) → account(id)
- credit_balance_adjustment(payment_id) → payment(id)
- invoice_adjustment(invoice_id) → invoice(id)
- account(bill_to_contact_id) → contact(id)
- account(sold_to_contact_id) → contact(id)
- product_rate_plan_charge_tier(product_rate_plan_charge_id) → product_rate_plan_charge(id)
- revenue_charge_summary_item(revenue_charge_summary_id) → revenue_charge_summary(id)
- ramp_interval(ramp_id) → ramp(id)
- invoice_item(invoice_id) → invoice(id)
- invoice_item(rate_plan_charge_id) → rate_plan_charge(id)
- invoice(account_id) → account(id)
- amendment(subscription_id) → subscription(id)
- revenue_event_item(revenue_event_id) → revenue_event(id)