Fivetran documentation

Search the docs

/

RevOps

Explore the interactive ERD

Table & Field Reference

invoice

Column	Type	Keys
`id`	String	PK
`account_id`	String	PKFK
`plan_id`	String	FK
`amount_due`	String
`amount_paid`	String
`amount_remaining`	String
`amount_total`	String
`application_fee_amount`	String
`auto_advance`	Boolean
`billed_period`	String
`billed_usage_filename`	String
`charge_automatically`	Boolean
`contract_id`	String
`contract_url`	String
`currency`	String
`days_until_due`	Int
`detailed_usage_url`	String
`end_date`	String
`event_logs_url`	String
`invoice_due_date`	Instant
`invoice_due_date_timestamp`	Int
`invoice_number`	String
`invoice_paid_date`	Instant
`invoice_paid_date_timestamp`	Int
`invoice_pdf_url`	String
`invoice_sent_date`	Instant
`invoice_sent_date_timestamp`	Int
`paid_out_of_band`	Boolean
`payment_term`	String
`plan_type`	String
`provider`	String
`provider_id`	String
`recognition_amount`	String
`recognition_end_date`	String
`recognition_start_date`	String
`start_date`	String
`status`	String
`uri`	String

plan_tag

Column	Type	Keys
`id`	String	PK
`plan_id`	String	PKFK
`date_created`	Instant
`date_updated`	Instant
`description`	String
`icon`	String
`name`	String
`organization_id`	String
`status`	String
`type`	String

term

Column	Type	Keys
`internal_id`	String	PK
`plan_id`	String	PKFK
`id`	String	FK
`creator_id`	String
`crm_object`	String
`crm_object_field`	String
`date_created`	Instant
`date_updated`	Instant
`default_value`	String
`description`	String
`hide_label`	Boolean
`icon`	String
`internal`	Boolean
`is_required`	Boolean
`is_standard`	Boolean
`label`	String
`label_content`	String
`name`	String
`options_text`	String
`options_value`	String
`orders`	Int
`organization_id`	String
`placeholder`	String
`renewal_behavior`	String
`show_in_proposal_body`	Boolean
`show_in_proposal_header`	Boolean
`term_category`	String
`type`	String
`value`	String

rate_metric

Column	Type	Keys
`id`	String	PK
`rate_id`	String	PKFK
`divisor`	Double
`end_date_offset`	Int
`end_date_offset_period`	String
`friendly_name`	String
`metric_name`	String
`operator`	String
`organization_id`	String
`product`	String
`rounding_behavior`	String
`usage_period`	String

rate_rate_table

Column	Type	Keys
`id`	String	PK
`rate_id`	String	FK
`amount`	String
`monthly_rate`	String
`percentage`	Double
`quantity`	String
`quantity_max`	String
`quantity_min`	String
`rate`	String

rate

Column	Type	Keys
`id`	String	PK
`sku_id`	String	PKFK
`end_date_offset`	Int
`end_date_offset_period`	String
`is_default`	Boolean
`name`	String
`usage_period`	String

custom_property

Column	Type	Keys
`id`	String	PK
`sku_id`	String	PKFK
`enabled`	Boolean
`friendly_name`	String
`mode`	String
`value`	String

sku

Column	Type	Keys
`id`	String	PK
`plan_id`	String	PKFK
`adjusted_annual_price`	String
`adjusted_monthly_price`	String
`adjusted_net_price`	String
`adjusted_price`	String
`annual_price`	String
`billing_end_date`	String
`billing_provider_month_plan_id`	String
`billing_provider_plan_id`	String
`billing_provider_product_id`	String
`billing_provider_year_plan_id`	String
`billing_start_date`	String
`color`	String
`contract_length`	Int
`creator_id`	String
`crm_id`	String
`crm_pricebook_2_id`	String
`crm_product_2_id`	String
`currency`	String
`default_quantity`	Int
`fraction_digits`	Int
`icon`	String
`is_discount`	Boolean
`ledger_code`	String
`line_item_description`	String
`line_item_title`	String
`list_price`	String
`monthly_price`	String
`name`	String
`net_price`	String
`orders`	Int
`organization_id`	String
`product_code`	String
`quantity`	Int
`show_public_discount`	Boolean
`sku_group`	String
`status`	String
`tax`	String
`tiering_model`	String
`tiering_model_type`	String
`tiering_type`	String
`type`	String
`unit_name`	String
`unit_pricing_schedule`	String
`updated_line_item_description`	String

plan_group

Column	Type	Keys
`id`	String	PK
`date_created`	Instant
`date_updated`	Instant
`description`	String
`icon`	String
`name`	String
`organization_id`	String
`status`	String
`type`	String

plan

Column	Type	Keys
`id`	String	PK
`plan_group_id`	String	FK
`billing_provider_subscription_id`	String
`cpq`	Boolean
`date_created`	Instant
`date_updated`	Instant
`friendly_name`	String
`interval`	String
`interval_count`	Int
`is_default`	Boolean
`public`	String
`status`	String
`uri`	String

account

Column	Type	Keys
`id`	String	PK
`parent_account_id`	String	FK
`plan_id`	String	FK
`account_id`	String
`auto_billing`	String
`base_contract_id`	String
`billing_contact_address`	String
`billing_contact_address_2`	String
`billing_contact_bank_account_holder_name`	String
`billing_contact_bank_account_holder_type`	String
`billing_contact_bank_account_number`	String
`billing_contact_bank_country`	String
`billing_contact_bank_name`	String
`billing_contact_bank_routing_number`	String
`billing_contact_city`	String
`billing_contact_country`	String
`billing_contact_email`	String
`billing_contact_first_name`	String
`billing_contact_hubspot_contact_id`	String
`billing_contact_id`	String
`billing_contact_last_name`	String
`billing_contact_middle_name`	String
`billing_contact_payment_method`	String
`billing_contact_phone`	String
`billing_contact_postal_code`	String
`billing_contact_province`	String
`billing_contact_salesforce_contact_id`	String
`billing_contact_state`	String
`billing_contact_stripe_customer_id`	String
`billing_contact_title`	String
`blocked`	Boolean
`date_created`	Instant
`date_updated`	Instant
`email`	String
`in_contract`	Boolean
`name`	String
`payable`	Boolean
`primary_instrument_id`	String
`status`	String
`stripe_customer_id`	String
`uri`	String
`verified`	Boolean

cost_rate_table

Column	Type	Keys
`id`	String	PK
`cost_invoice_id`	String	FK
`amount`	String
`monthly_rate`	String
`percentage`	Double
`quantity`	String
`quantity_max`	String
`quantity_min`	String
`rate`	String

usage_object

Column	Type	Keys
`_fivetran_id`	String	PK
`cost_invoice_id`	String	FK
`amount`	String
`cumulative_sum`	String
`quantity`	String
`resource`	String
`time_stamp`	String
`unit_rate`	String

cost

Column	Type	Keys
`account_id`	String	PKFK
`invoice_id`	String	PKFK
`aggregate_amount`	String
`aggregate_quantity`	String
`currency`	String
`date_created`	Instant
`date_updated`	Instant
`description`	String
`end_date`	Instant
`is_lifetime`	Boolean
`pricing_schedule`	String
`provider_id`	String
`sku_type`	String
`start_date`	Instant
`status`	String