Fivetran documentation

Search the docs

/

BillingPlatform

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`id`	Unknown	PK
`billing_profile_id`	Unknown	FK
`creator_id`	Unknown	FK
`invoice_display_id`	Unknown	FK
`updater_id`	Unknown	FK
`allocation_strategy`	Unknown
`amount`	Unknown
`auto_allocate`	Unknown
`created`	Unknown
`credit_card_transaction_message`	Unknown
`credit_card_transaction_status`	Unknown
`ecom_transaction_id`	Unknown
`ecom_transaction_response_id`	Unknown
`gateway_profile_id`	Unknown
`gateway_transaction_id`	Unknown
`note`	Unknown
`payment_date`	Unknown
`pending_amount`	Unknown
`pre_surcharge_amount`	Unknown
`type`	Unknown
`unallocated_amount`	Unknown
`updated`	Unknown
`void_flag`	Unknown

activity_collector

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`time_zone_id`	Unknown	FK
`updater_id`	Unknown	FK
`activity_collector_name`	Unknown
`billable_activity_flag`	Unknown
`consolidation_mode`	Unknown
`create_after_process_directory_flag`	Unknown
`created`	Unknown
`delimiter`	Unknown
`field_included_char`	Unknown
`rate_activity_flag`	Unknown
`record_format`	Unknown
`reject_closed_flag`	Unknown
`skip_rows`	Unknown
`status`	Unknown
`type`	Unknown
`updated`	Unknown
`vendor_id`	Unknown

contract_currency

Column	Type	Keys
`id`	Unknown	PK
`contract_id`	Unknown	FK
`creator_id`	Unknown	FK
`created`	Unknown
`currency_code`	Unknown

contract

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`contract_number`	Unknown
`contract_status`	Unknown
`created`	Unknown
`end_date`	Unknown
`on_end_date`	Unknown
`start_date`	Unknown

dunning_interval

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`dunning_interval_name`	Unknown
`status`	Unknown

billing_profile

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`dunning_interval`	Unknown	FK
`invoice_template_id`	Unknown	FK
`time_zone_id`	Unknown	FK
`updater_id`	Unknown	FK
`account_balance`	Unknown
`account_balance_number`	Unknown
`ach_bank_acct_type`	Unknown
`address_1`	Unknown
`attention`	Unknown
`bill_to`	Unknown
`billing_cycle`	Unknown
`billing_entity`	Unknown
`billing_method`	Unknown
`city`	Unknown
`country`	Unknown
`created`	Unknown
`currency_code`	Unknown
`email`	Unknown
`fax`	Unknown
`hosted_payment_page_external_id`	Unknown
`invoice_approval_flag`	Unknown
`invoice_delivery_method`	Unknown
`invoice_file_format`	Unknown
`manual_close_flag`	Unknown
`monthly_billing_date`	Unknown
`payment_term_days`	Unknown
`period_cutoff_date`	Unknown
`phone`	Unknown
`quarterly_billing_month`	Unknown
`state`	Unknown
`statement_approval_flag`	Unknown
`statement_cycle`	Unknown
`statement_delivery_method`	Unknown
`statement_template_id`	Unknown
`status`	Unknown
`updated`	Unknown
`weekly_billing_date`	Unknown
`yearly_billing_month`	Unknown
`zip`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`billing_profile_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`activity_end_date`	Unknown
`activity_start_date`	Unknown
`aging_interval`	Unknown
`approval_status`	Unknown
`billable_flag`	Unknown
`billing_cycle_end_date`	Unknown
`billing_cycle_start_date`	Unknown
`closed_date`	Unknown
`created`	Unknown
`credit_amount`	Unknown
`due_amount`	Unknown
`due_date`	Unknown
`file_name`	Unknown
`grand_total_amount`	Unknown
`manual_close_approved_flag`	Unknown
`mass_update_error`	Unknown
`payment_amount`	Unknown
`payment_status`	Unknown
`pdf_created_date`	Unknown
`pdf_file`	Unknown
`status`	Unknown
`tax_total_amount_unrounded`	Unknown
`total_amount_unrounded`	Unknown
`updated`	Unknown
`xml_file`	Unknown

collector_field

Column	Type	Keys
`id`	Unknown	PK
`activity_collector_id`	Unknown	FK
`billing_identifier`	Unknown	FK
`activity_collector_history_id`	Unknown
`activity_date`	Unknown
`activity_date_ts`	Unknown
`charge_type`	Unknown
`consolidation_exempt`	Unknown
`created`	Unknown
`process_status`	Unknown
`quantity`	Unknown
`record_number`	Unknown
`usage_product`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`billable_account_id`	Unknown	FK
`billable_billing_profile_id`	Unknown	FK
`creator_id`	Unknown	FK
`parent_account_id`	Unknown	FK
`updater_id`	Unknown	FK
`account_type_id`	Unknown
`allow_pricing_in_different_currency`	Unknown
`created`	Unknown
`date_display_format`	Unknown
`invoice_at_this_level`	Unknown
`name`	Unknown
`rate_hierarchy`	Unknown
`status`	Unknown
`updated`	Unknown

billing_identifier

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`active_from`	Unknown
`billing_identifier`	Unknown
`created`	Unknown
`status`	Unknown
`updated`	Unknown
`vendor_id`	Unknown

revrec_contract

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`created`	Unknown
`current_active_contract`	Unknown
`name`	Unknown
`original_contract`	Unknown
`status`	Unknown
`total_expected_billings`	Unknown
`total_ssp`	Unknown
`updated`	Unknown

time_zone

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`created`	Unknown
`default_flag`	Unknown
`display_flag`	Unknown
`tz_name`	Unknown
`utc_offset`	Unknown

account_product

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`created`	Unknown
`end_date`	Unknown
`name`	Unknown
`product_id`	Unknown
`quantity`	Unknown
`rate`	Unknown
`rate_min_charge`	Unknown
`rate_override`	Unknown
`rating_method_id`	Unknown
`renewal_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`updated`	Unknown
`upgrade_downgrade_type`	Unknown

account_package

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`created`	Unknown
`end_date`	Unknown
`package_id`	Unknown
`start_date`	Unknown
`updated`	Unknown
`upgrade_downgrade_type`	Unknown

contract_rate

Column	Type	Keys
`id`	Unknown	PK
`contract_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`contract_rate_label`	Unknown
`created`	Unknown
`name`	Unknown
`product_id`	Unknown
`rate`	Unknown
`rating_method_id`	Unknown
`updated`	Unknown

invoice_template

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`updater_id`	Unknown	FK
`created`	Unknown
`date_format`	Unknown
`default_flag`	Unknown
`email_template_id`	Unknown
`invoice_file_format`	Unknown
`invoice_xsl_id`	Unknown
`language_code`	Unknown
`name`	Unknown
`show_aging`	Unknown
`show_credit_adj_detail`	Unknown
`show_past_due_statements`	Unknown
`show_tax_fee_detail`	Unknown
`status`	Unknown
`support_message`	Unknown
`support_message_1`	Unknown
`support_number`	Unknown
`type`	Unknown
`updated`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`creator_id`	Unknown	FK
`time_zone_id`	Unknown	FK
`updater_id`	Unknown	FK
`addr_1`	Unknown
`collections_flag`	Unknown
`convert_time_zone`	Unknown
`created`	Unknown
`email`	Unknown
`first_name`	Unknown
`forbid_internal_auth`	Unknown
`language_code`	Unknown
`last_name`	Unknown
`reset_password_flag`	Unknown
`role_id`	Unknown
`role_name`	Unknown
`role_status`	Unknown
`root_account_id`	Unknown
`status`	Unknown
`theme_id`	Unknown
`title`	Unknown
`type`	Unknown
`updated`	Unknown
`user_name`	Unknown

activity

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`account_product_id`	Unknown	FK
`creator_id`	Unknown	FK
`invoice_id`	Unknown	FK
`updater_id`	Unknown	FK
`activity_date`	Unknown
`cost_unrounded`	Unknown
`created`	Unknown
`currency_code`	Unknown
`estimated`	Unknown
`feature`	Unknown
`min_charge_flag`	Unknown
`pricing_currency_code`	Unknown
`pricing_currency_cost`	Unknown
`pricing_id`	Unknown
`pro_rate_factor`	Unknown
`process_status`	Unknown
`product_id`	Unknown
`quantity`	Unknown
`rate`	Unknown
`rate_source`	Unknown
`rated_amount`	Unknown
`rating_date`	Unknown
`rating_method_id`	Unknown
`standard_cost_unrounded`	Unknown
`standard_rate`	Unknown
`subscription_from_date`	Unknown
`subscription_to_date`	Unknown
`tax_cost_unrounded`	Unknown
`tiered_group`	Unknown
`total_cost`	Unknown
`updated`	Unknown
`upper_band`	Unknown