Ordway

Explore the interactive ERD

Table & Field Reference

statement

Column	Type	Keys
`statement_id`	Unknown	PK
`customer_id`	Unknown	FK
`company_id`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`end_date`	Unknown
`integer`	Unknown
`start_date`	Unknown
`statement_date`	Unknown
`template_id`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown
`url`	Unknown

credit_line_item

Column	Type	Keys
`line_no`	Unknown	PK
`credit_id`	Unknown	PKFK
`product_id`	Unknown	FK
`credit_account`	Unknown
`description`	Unknown
`effective_price`	Unknown
`line_tax`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`tax_override`	Unknown
`taxable`	Unknown
`unit_price`	Unknown

credit_subtotal

Column	Type	Keys
`_fivetran_id`	String	PK
`credit_id`	Unknown	FK
`subtotal_name`	Unknown
`value`	Unknown

credit_invoice

Column	Type	Keys
`credit_id`	Unknown	PKFK
`id`	Unknown	PKFK
`amount_applied`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

credit_custom_field

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

credit

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`applied_amount`	Unknown
`auto_apply`	Unknown
`billing_contact_address_1`	Unknown
`billing_contact_address_2`	Unknown
`billing_contact_city`	Unknown
`billing_contact_country`	Unknown
`billing_contact_county`	Unknown
`billing_contact_department`	Unknown
`billing_contact_display_name`	Unknown
`billing_contact_email`	Unknown
`billing_contact_first_name`	Unknown
`billing_contact_job_title`	Unknown
`billing_contact_last_name`	Unknown
`billing_contact_mobile`	Unknown
`billing_contact_notes`	Unknown
`billing_contact_phone`	Unknown
`billing_contact_state`	Unknown
`billing_contact_zip`	Unknown
`conversion_rate`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`credit_amount`	Unknown
`credit_date`	Unknown
`credit_tax`	Unknown
`credit_type`	Unknown
`currency`	Unknown
`gl_account`	Unknown
`l_grouping_for_calculations`	Unknown
`notes`	Unknown
`reference_number`	Unknown
`refunds`	Json
`reversed_on`	Unknown
`shipping_contact_address_1`	Unknown
`shipping_contact_address_2`	Unknown
`shipping_contact_city`	Unknown
`shipping_contact_country`	Unknown
`shipping_contact_county`	Unknown
`shipping_contact_department`	Unknown
`shipping_contact_display_name`	Unknown
`shipping_contact_email`	Unknown
`shipping_contact_first_name`	Unknown
`shipping_contact_job_title`	Unknown
`shipping_contact_last_name`	Unknown
`shipping_contact_mobile`	Unknown
`shipping_contact_notes`	Unknown
`shipping_contact_phone`	Unknown
`shipping_contact_state`	Unknown
`shipping_contact_zip`	Unknown
`status`	Unknown
`subtotal`	Unknown
`unapplied_amount`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

revenue_rule_custom_field

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

revenue_rule

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown
`created_date`	Unknown
`name`	Unknown
`posting_day`	Unknown
`posting_method`	Unknown
`recognition_method`	Unknown
`recognition_schedule_period`	Unknown
`recognition_term`	Unknown
`status`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

plan_charge_transaction_posting_entries

Column	Type	Keys
`_fivetran_id`	String	PK
`plan_charge_id`	Unknown	PKFK
`plan_id`	Unknown	PKFK
`credit_account`	Unknown
`debit_account`	Unknown
`transaction_type`	Unknown

plan_charge_tier

Column	Type	Keys
`_fivetran_id`	String	PK
`plan_charge_id`	Unknown	PKFK
`plan_id`	Unknown	PKFK
`ending_unit`	Unknown
`price`	Unknown
`starting_unit`	Unknown
`tier`	Unknown
`type`	Unknown

plan_charge_custom_field

Column	Type	Keys
`name`	Unknown	PK
`plan_charge_id`	Unknown	PKFK
`plan_id`	Unknown	PKFK
`value`	Unknown

plan_charge

Column	Type	Keys
`id`	Unknown	PK
`plan_id`	Unknown	PKFK
`product_id`	Unknown	FK
`revenue_rule_id`	Unknown	FK
`auto_refill_prepayment_units`	Unknown
`backcharge_current_period`	Unknown
`billing_day`	Unknown
`billing_period`	Unknown
`billing_period_start_alignment`	Unknown
`charge_billing_date`	Unknown
`charge_inherited_product`	Unknown
`dealhub_name`	Unknown
`defaults_from_product`	Unknown
`description`	Unknown
`effective_date`	Unknown
`included_units`	Unknown
`line_no`	Unknown
`list_price`	Unknown
`name`	Unknown
`original_type`	Unknown
`prepaid_units_enable`	Unknown
`prepaid_units_expiry`	Unknown
`prepayment_amount`	Unknown
`prepayment_periods`	Unknown
`pricing_model`	Unknown
`recognition_start_date`	Unknown
`refill_prepaid_units_for`	Unknown
`refill_qty`	Unknown
`refund_units_on_cancel`	Unknown
`salesforce_charge_id`	Unknown
`salesforce_id`	Unknown
`timing`	Unknown
`transaction_price`	Unknown
`type`	Unknown
`unit_of_measure`	Unknown
`unused_prepayment_units`	Unknown

plan_custom_field

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

plan

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown
`created_date`	Unknown
`description`	Unknown
`discount_tiers`	Unknown
`historical_zuora_id`	Unknown
`name`	Unknown
`public_url`	Unknown
`salesforce_id`	Unknown
`status`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

product_transaction_posting_entry

Column	Type	Keys
`_fivetran_id`	String	PK
`product_id`	Unknown	FK
`credit_account`	Unknown
`debit_account`	Unknown
`transaction_type`	Unknown

product_custom_field

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

product

Column	Type	Keys
`id`	Unknown	PK
`revenue_rule_id`	Unknown	FK
`country`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`description`	Unknown
`location_id`	Unknown
`name`	Unknown
`price`	Unknown
`primary_tag`	Unknown
`product_code`	Unknown
`recognition_start_date`	Unknown
`region`	Unknown
`salesforce_id`	Unknown
`show_revenue_schedules`	Unknown
`sku`	Unknown
`status`	Unknown
`taxable`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

orders_line_item_custom_field

Column	Type	Keys
`name`	Unknown	PK
`orders_line_item_line_no`	Unknown	PKFK
`orders_line_item_orders_id`	Unknown	PKFK
`value`	Unknown

orders_line_item

Column	Type	Keys
`line_no`	Unknown	PK
`orders_id`	Unknown	PKFK
`product_id`	Unknown	FK
`description`	Unknown
`discount`	Unknown
`effective_price`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`unit_price`	Unknown

orders_custom_field

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

orders

Column	Type	Keys
`id`	Unknown	PK
`coupon_code`	Unknown	FK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`bill_contact_id`	Unknown
`company_name`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`notes`	Unknown
`order_amount`	Unknown
`order_date`	Unknown
`payment_terms`	Unknown
`separate_invoice`	Unknown
`shipping_contact_id`	Unknown
`status`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

refund

Column	Type	Keys
`id`	Unknown	PK
`credit_id`	Unknown	FK
`customer_id`	Unknown	FK
`invoice_id`	Unknown	FK
`payment_id`	Unknown	FK
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`notes`	Unknown
`reference_number`	Unknown
`refund_amount`	Unknown
`refund_date`	Unknown
`refund_status`	Unknown
`refund_type`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

chart_of_account_custom_field

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

chart_of_account

Column	Type	Keys
`code`	Unknown	PK
`account_type`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`description`	Unknown
`name`	Unknown
`parent_account`	Unknown
`status`	Unknown
`sub_type`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

payments_run

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown
`currency`	Unknown
`failure_count`	Unknown
`filter_options`	Json
`payments_failed_value`	Unknown
`payments_success_value`	Unknown
`payments_total_value`	Unknown
`refunds_failed_value`	Unknown
`refunds_success_value`	Unknown
`refunds_total_value`	Unknown
`status`	Unknown
`success_count`	Unknown
`target_date`	Unknown
`updated_by`	Unknown

billing_run

Column	Type	Keys
`id`	Unknown	PK
`charge_type`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`customer_filter_options`	Unknown
`filter_options`	Json
`invoice_date`	Unknown
`invoices_count`	Unknown
`invoices_total`	Unknown
`status`	Unknown
`subscription_filter_options`	Json
`target_date`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

subscription_plan_transaction_posting_entries

Column	Type	Keys
`_fivetran_id`	String	PK
`subscription_id`	Unknown	FK
`subscription_plan_id`	Unknown	FK
`subscription_plan_index`	Unknown	FK
`subscription_version`	Unknown	FK
`credit_account`	Unknown
`debit_account`	Unknown
`transaction_type`	Unknown

subscription_plan_custom_field

Column	Type	Keys
`name`	Unknown	PK
`subscription_id`	Unknown	PKFK
`subscription_plan_index`	Unknown	PKFK
`subscription_version`	Unknown	PKFK
`subscription_plan_id`	Unknown	FK
`value`	Unknown

subscription_plan

Column	Type	Keys
`index`	Unknown	PK
`id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`subscription_version`	Unknown	PKFK
`charge_id`	Unknown	FK
`product_id`	Unknown	FK
`revenue_rule_id`	Unknown	FK
`revenue_schedule_id`	Unknown	FK
`backcharge_current_period`	Unknown
`billing_day`	Unknown
`billing_period`	Unknown
`billing_period_start_alignment`	Unknown
`billing_schedule_id`	Unknown
`charge_billing_date`	Unknown
`charge_end_date`	Unknown
`charge_start_date`	Unknown
`charge_timing`	Unknown
`charge_type`	Unknown
`completion_date`	Unknown
`current_period_end_date`	Unknown
`current_period_start_date`	Unknown
`defaults_from_plan`	Unknown
`discount`	Unknown
`discount_tiers`	Unknown
`effective_date`	Unknown
`effective_price`	Unknown
`included_units`	Unknown
`l_grouping_for_calculations`	Unknown
`list_price`	Unknown
`list_price_base`	Unknown
`original_type`	Unknown
`override_renewal_increment_percent`	Unknown
`prepayment_enabled`	Unknown
`price_base`	Unknown
`pricing_model`	Unknown
`product_code`	Unknown
`prorate_partial_periods`	Unknown
`quantity`	Unknown
`recognition_start_date`	Unknown
`refund_units_on_cancel`	Unknown
`region`	Unknown
`remove_units_on_cancel`	Unknown
`renewal_increment_percent`	Unknown
`rewards_discount_eligible`	Unknown
`salesforce_id`	Unknown
`subscription_line_id`	Unknown
`transaction_price`	Unknown
`true_up_eligible`	Unknown
`unit_of_measure`	Unknown
`updated_transaction_price`	Unknown

subscription_custom_field

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

subscription

Column	Type	Keys
`id`	Unknown	PK
`version`	Unknown	PK
`customer_id`	Unknown	FK
`auto_renew`	Unknown
`bill_contact_id`	Unknown
`bill_contact_sf_id`	Unknown
`billing_start_date`	Unknown
`cancellation_date`	Unknown
`cancellation_type`	Unknown
`cmrr`	Unknown
`contract_effective_date`	Unknown
`contract_term`	Unknown
`coupon_code`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`current_term_end_date`	Unknown
`current_term_start_date`	Unknown
`customer_salesforce_id`	Unknown
`defer_start_date`	Unknown
`discounted_cmrr`	Unknown
`historical_zuora_id`	Unknown
`min_commited_value`	Unknown
`min_commited_value_docv`	Unknown
`min_commited_value_idv`	Unknown
`min_commited_value_kyb`	Unknown
`min_commited_value_mobile_id`	Unknown
`min_commited_value_utility_id`	Unknown
`min_commited_value_watchlist`	Unknown
`min_commitment_end_date`	Unknown
`min_commitment_end_date_docv`	Unknown
`min_commitment_end_date_idv`	Unknown
`min_commitment_end_date_kyb`	Unknown
`min_commitment_end_date_mobile_id`	Unknown
`min_commitment_end_date_utility_id`	Unknown
`min_commitment_end_date_watchlist`	Unknown
`mrr`	Unknown
`notes`	Unknown
`order_placed_at`	Unknown
`payment_terms`	Unknown
`renewal_increment_percent`	Unknown
`renewal_term`	Unknown
`salesforce_id`	Unknown
`separate_invoice`	Unknown
`service_start_date`	Unknown
`shipping_contact_id`	Unknown
`shipping_contact_sf_id`	Unknown
`status`	Unknown
`tcv`	Unknown
`updated_by`	Unknown
`updated_date`	Instant
`version_type`	Unknown

billing_schedule_line_custom_field

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

billing_schedule_line

Column	Type	Keys
`id`	Unknown	PK
`billing_schedule_id`	Unknown	PKFK
`amount`	Unknown
`charge_ready_date`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`description`	Unknown
`discount`	Unknown
`end_date`	Unknown
`expired_units`	Unknown
`invoiced`	Unknown
`l_grouping_for_calculations`	Unknown
`line_type`	Unknown
`list_price`	Unknown
`list_price_base`	Unknown
`quantity`	Unknown
`start_date`	Unknown
`unit_price`	Unknown
`unused_prepayment_units`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown
`usages`	Json

billing_schedule_custom_field

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

billing_schedule

Column	Type	Keys
`id`	Unknown	PK
`charge_id`	Unknown	FK
`customer_id`	Unknown	FK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`end_date`	Unknown
`key_metrics_amount_invoiced`	Unknown
`key_metrics_annual_contract_revenue`	Unknown
`key_metrics_monthly_recurring_revenue`	Unknown
`key_metrics_total_contract_revenue`	Unknown
`start_date`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

coupon

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`criteria_value`	Unknown
`discount_criteria`	Unknown
`discount_type`	Unknown
`discount_value`	Unknown
`display_text`	Unknown
`duration_period`	Unknown
`expiration_date`	Unknown
`status`	Unknown
`trial_type`	Unknown
`trial_value`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown
`usage_count`	Unknown
`usage_limit`	Unknown

revenue_schedule_line

Column	Type	Keys
`_fivetran_id`	String	PK
`revenue_schedule_id`	Unknown	FK
`amount`	Unknown
`currency`	Unknown
`custom_fields`	Json
`exchange_rate`	Unknown
`financial_period`	Unknown
`period_revenue`	Unknown
`posted`	Unknown
`posting_date`	Unknown

revenue_schedule

Column	Type	Keys
`id`	Unknown	PK
`charge_id`	Unknown	FK
`customer_id`	Unknown	FK
`plan_id`	Unknown	FK
`product_id`	Unknown	FK
`charge_timing`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`end_date`	Unknown
`recognized_revenue`	Unknown
`source_transaction`	Unknown
`start_date`	Unknown
`total_revenue`	Unknown
`unrecognized_revenue`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

customer_contact_custom_field

Column	Type	Keys
`name`	Unknown	PK
`customer_contact_customer_id`	Unknown	PKFK
`customer_contact_id`	Unknown	PKFK
`value`	Unknown

customer_contact

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	PKFK
`address_1`	Unknown
`address_2`	Unknown
`city`	Unknown
`country`	Unknown
`county`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`department`	Unknown
`display_name`	Unknown
`email`	Unknown
`first_name`	Unknown
`is_unrelated_contact`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`notes`	Unknown
`phone`	Unknown
`salesforce_id`	Unknown
`state`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown
`zip`	Unknown

customer_custom_field

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

customer

Column	Type	Keys
`id`	Unknown	PK
`ach_enabled`	Unknown
`auto_pay`	Unknown
`balance`	Unknown
`banking_info`	Unknown
`billing_batch`	Unknown
`billing_contact_email`	Unknown
`billing_contact_id`	Unknown
`billing_cycle_day`	Unknown
`child_customers`	Unknown
`cmrr`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`credit_enabled`	Unknown
`cumulative_rewards`	Unknown
`currency`	Unknown
`customer_type`	Unknown
`description`	Unknown
`discount_amt`	Unknown
`discount_month`	Unknown
`discount_tiers`	Unknown
`discount_tiers_docv`	Unknown
`discount_tiers_idv`	Unknown
`discount_tiers_kyb`	Unknown
`discount_tiers_mobile_id`	Unknown
`discount_tiers_utility_id`	Unknown
`discount_tiers_watchlist`	Unknown
`discounted_cmrr`	Unknown
`edit_auto_pay`	Unknown
`email`	Unknown
`email_preference`	Unknown
`flat_discount_percent`	Unknown
`flat_discount_percent_docv`	Unknown
`flat_discount_percent_idv`	Unknown
`flat_discount_percent_kyb`	Unknown
`flat_discount_percent_mobile_id`	Unknown
`flat_discount_percent_utility_id`	Unknown
`flat_discount_percent_watchlist`	Unknown
`historical_zuora_id`	Unknown
`last_day_previous_month`	Unknown
`name`	Unknown
`open_invoices_url`	Unknown
`participating_in_rewards_discount`	Unknown
`participating_in_true_up`	Unknown
`pay_now_url`	Unknown
`payment_gateway_id`	Unknown
`payment_terms`	Unknown
`print`	Unknown
`print_preference`	Unknown
`salesforce_id`	Unknown
`shipping_contact_email`	Unknown
`shipping_contact_id`	Unknown
`status`	Unknown
`suspended`	Unknown
`tax_exempt`	Unknown
`true_up_start_date`	Unknown
`update_payment_method_url`	Unknown
`updated_by`	Unknown
`updated_date`	Instant
`vip`	Unknown
`website`	Unknown
`zero_balance_needed`	Unknown

payments_invoice

Column	Type	Keys
`id`	Unknown	PKFK
`payments_id`	Unknown	PKFK
`amount_applied`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

payments_refund

Column	Type	Keys
`id`	Unknown	PKFK
`payments_id`	Unknown	PKFK
`amount_applied`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

payments_custom_field

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

payments

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`payment_run_id`	Unknown	FK
`applied_amount`	Unknown
`auto_apply`	Unknown
`conversion_rate`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`email_status`	Unknown
`failed_attempt`	Unknown
`failure_reason`	Unknown
`fee_amount`	Unknown
`gl_account`	Unknown
`notes`	Unknown
`opt`	Json
`payment_amount`	Unknown
`payment_date`	Unknown
`payment_method`	Unknown
`payment_type`	Unknown
`reference_number`	Unknown
`refunded_amount`	Unknown
`retried_attempts`	Unknown
`status`	Unknown
`unapplied_amount`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

journal_entry_custom_field

Column	Type	Keys
`name`	Unknown	PK
`journal_entry_journal_id`	Unknown	PKFK
`journal_entry_line_no`	Unknown	PKFK
`value`	Unknown

journal_entry

Column	Type	Keys
`line_no`	Unknown	PK
`journal_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`account`	Unknown
`credit`	Unknown
`customer_name`	Unknown
`debit`	Unknown
`description`	Unknown

journal

Column	Type	Keys
`id`	Unknown	PK
`conversion_rate`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`date`	Unknown
`description`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`transaction_amount`	Unknown
`transaction_currency`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

invoice_line_item_tax_line

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_line_item_line_no`	Unknown	FK
`name`	Unknown
`value`	Unknown

invoice_line_item_custom_field

Column	Type	Keys
`name`	Unknown	PK
`invoice_line_item_invoice_id`	Unknown	PKFK
`invoice_line_item_line_no`	Unknown	PKFK
`value`	Unknown

invoice_line_item

Column	Type	Keys
`line_no`	Unknown	PK
`invoice_id`	Unknown	PKFK
`charge_id`	Unknown	FK
`customer_id`	Unknown	FK
`plan_id`	Unknown	FK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`subscription_line_id`	Unknown	FK
`applied_tiers`	Json
`charge_type`	Unknown
`description`	Unknown
`discount`	Unknown
`effective_price`	Unknown
`end_date`	Unknown
`included_quantity`	Unknown
`line_tax`	Unknown
`list_price`	Unknown
`list_price_base`	Unknown
`quantity`	Unknown
`start_date`	Unknown
`taxable`	Unknown
`unit_price`	Unknown

invoice_subtotal

Column	Type	Keys
`_fivetran_id`	String	PK
`invoice_id`	Unknown	FK
`subtotal_name`	Unknown
`value`	Unknown

invoice_custom_field

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

invoice

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`balance`	Unknown
`billing_contact_address_1`	Unknown
`billing_contact_address_2`	Unknown
`billing_contact_city`	Unknown
`billing_contact_country`	Unknown
`billing_contact_county`	Unknown
`billing_contact_department`	Unknown
`billing_contact_display_name`	Unknown
`billing_contact_email`	Unknown
`billing_contact_first_name`	Unknown
`billing_contact_job_title`	Unknown
`billing_contact_last_name`	Unknown
`billing_contact_mobile`	Unknown
`billing_contact_phone`	Unknown
`billing_contact_state`	Unknown
`billing_contact_zip`	Unknown
`billing_run_id`	Unknown
`created_by`	Unknown
`created_date`	Unknown
`credits`	Json
`currency`	Unknown
`discount_display_name`	Unknown
`due_date`	Unknown
`emailed`	Unknown
`end_date`	Unknown
`exchange_rate`	Unknown
`invoice_amount`	Unknown
`invoice_date`	Unknown
`invoice_tax`	Unknown
`notes`	Unknown
`paid_amount`	Unknown
`payment_term_id`	Unknown
`payment_terms`	Unknown
`payments`	Json
`refunds`	Json
`shipping_contact_address_1`	Unknown
`shipping_contact_address_2`	Unknown
`shipping_contact_city`	Unknown
`shipping_contact_country`	Unknown
`shipping_contact_county`	Unknown
`shipping_contact_department`	Unknown
`shipping_contact_display_name`	Unknown
`shipping_contact_email`	Unknown
`shipping_contact_first_name`	Unknown
`shipping_contact_job_title`	Unknown
`shipping_contact_last_name`	Unknown
`shipping_contact_mobile`	Unknown
`shipping_contact_phone`	Unknown
`shipping_contact_state`	Unknown
`shipping_contact_zip`	Unknown
`start_date`	Unknown
`status`	Unknown
`subtotal`	Unknown
`updated_by`	Unknown
`updated_date`	Instant

usage_custom_field

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

usage

Column	Type	Keys
`id`	Unknown	PK
`charge_id`	Unknown	FK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`subscription_line_id`	Unknown	FK
`created_by`	Unknown
`created_date`	Unknown
`currency`	Unknown
`date`	Unknown
`description`	Unknown
`error_message`	Unknown
`invoiced`	Unknown
`l_grouping_for_calculations`	Unknown
`quantity`	Unknown
`status`	Unknown
`unit_of_measure`	Unknown
`updated_by`	Unknown
`updated_date`	Unknown

payments_method

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`customer_payment_gateway_id`	Unknown	FK
`account_holder_name`	Unknown
`account_number`	Unknown
`country`	Unknown
`cvc`	Unknown
`defaults`	Unknown
`expiry`	Unknown
`payment_method_id`	Unknown
`payment_type`	Unknown
`status`	Unknown
`type`	Unknown
`url`	Unknown

customer_note

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`company_id`	Unknown
`created_at`	Unknown
`description`	Unknown
`file_upload_content_type`	Unknown
`file_upload_file_name`	Unknown
`file_upload_file_size`	Unknown
`file_upload_updated_at`	Unknown
`has_versions`	Unknown
`title`	Unknown
`updated_at`	Unknown
`user_id`	Unknown