# BillingPlatform schema ERD

Table and field reference for the Fivetran BillingPlatform connector.

## 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 |  |

## Relationships

- payment(billing_profile_id) → billing_profile(id)
- payment(updater_id) → users(id)
- payment(invoice_display_id) → invoice(id)
- payment(creator_id) → users(id)
- activity_collector(updater_id) → users(id)
- activity_collector(time_zone_id) → time_zone(id)
- activity_collector(creator_id) → users(id)
- activity_collector(account_id) → account(id)
- contract_currency(creator_id) → users(id)
- contract_currency(contract_id) → contract(id)
- contract(creator_id) → users(id)
- contract(account_id) → account(id)
- billing_profile(invoice_template_id) → invoice_template(id)
- billing_profile(updater_id) → users(id)
- billing_profile(dunning_interval) → dunning_interval(id)
- billing_profile(time_zone_id) → time_zone(id)
- billing_profile(account_id) → account(id)
- invoice(billing_profile_id) → billing_profile(id)
- invoice(updater_id) → users(id)
- invoice(creator_id) → users(id)
- collector_field(activity_collector_id) → activity_collector(id)
- collector_field(billing_identifier) → billing_identifier(billing_identifier)
- account(billable_billing_profile_id) → billing_profile(id)
- account(billable_account_id) → account(id)
- account(updater_id) → users(id)
- account(creator_id) → users(id)
- account(parent_account_id) → account(id)
- billing_identifier(updater_id) → users(id)
- billing_identifier(creator_id) → users(id)
- revrec_contract(updater_id) → users(id)
- revrec_contract(creator_id) → users(id)
- revrec_contract(account_id) → account(id)
- time_zone(creator_id) → users(id)
- account_product(updater_id) → users(id)
- account_product(creator_id) → users(id)
- account_product(account_id) → account(id)
- account_package(updater_id) → users(id)
- account_package(creator_id) → users(id)
- account_package(account_id) → account(id)
- contract_rate(contract_id) → contract(id)
- contract_rate(updater_id) → users(id)
- contract_rate(creator_id) → users(id)
- invoice_template(updater_id) → users(id)
- invoice_template(creator_id) → users(id)
- invoice_template(account_id) → account(id)
- users(updater_id) → users(id)
- users(time_zone_id) → time_zone(id)
- users(creator_id) → users(id)
- users(account_id) → account(id)
- activity(account_product_id) → account_product(id)
- activity(updater_id) → users(id)
- activity(invoice_id) → invoice(id)
- activity(creator_id) → users(id)
- activity(account_id) → account(id)