# Invoiced schema ERD

Table and field reference for the Fivetran Invoiced connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| charge_customer_id | Unknown | FK |
| charge_payment_source_customer_id | Unknown | FK |
| customer_id | Unknown | FK |
| ach_sender_id | Unknown |  |
| amount | Unknown |  |
| applied_to | Json |  |
| balance | Unknown |  |
| charge_amount | Unknown |  |
| charge_amount_refunded | Unknown |  |
| charge_created_at | Unknown |  |
| charge_currency | Unknown |  |
| charge_disputed | Unknown |  |
| charge_failure_message | Unknown |  |
| charge_gateway | Unknown |  |
| charge_gateway_id | Unknown |  |
| charge_id | Unknown |  |
| charge_payment_source_account_holder_name | Unknown |  |
| charge_payment_source_account_holder_type | Unknown |  |
| charge_payment_source_bank_name | Unknown |  |
| charge_payment_source_chargeable | Unknown |  |
| charge_payment_source_country | Unknown |  |
| charge_payment_source_created_at | Unknown |  |
| charge_payment_source_currency | Unknown |  |
| charge_payment_source_failure_reason | Unknown |  |
| charge_payment_source_gateway | Unknown |  |
| charge_payment_source_gateway_customer | Unknown |  |
| charge_payment_source_gateway_id | Unknown |  |
| charge_payment_source_id | Unknown |  |
| charge_payment_source_last_4_card_digits | Unknown |  |
| charge_payment_source_merchant_account | Unknown |  |
| charge_payment_source_receipt_email | Unknown |  |
| charge_payment_source_routing_number | Unknown |  |
| charge_payment_source_type | Unknown |  |
| charge_payment_source_updated_at | Unknown |  |
| charge_payment_source_verified | Unknown |  |
| charge_receipt_email | Unknown |  |
| charge_refund | Json |  |
| charge_refunded | Unknown |  |
| charge_status | Unknown |  |
| charge_updated_at | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| matched | Unknown |  |
| method | Unknown |  |
| note | Unknown |  |
| pdf_url | Unknown |  |
| reference | Unknown |  |
| source | Unknown |  |
| updated_at | Unknown |  |
| voided | Unknown |  |
| custom_** |  |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| role | Unknown |  |
| send_new_invoice | Unknown |  |
| sms_enabled | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### credit_note_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | FK |
| created_at | Unknown |  |
| file_created_at | Unknown |  |
| file_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_type | Unknown |  |
| file_updated_at | Unknown |  |
| file_url | Unknown |  |
| updated_at | Unknown |  |

### plan_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| plan_id | Unknown | PK, FK |
| max_qty | Unknown |  |
| min_qty | Unknown |  |
| unit_cost | Unknown |  |

### plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| catalog_item | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| interval | Unknown |  |
| interval_count | Unknown |  |
| name | Unknown |  |
| pricing_mode | Unknown |  |
| quantity_type | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### credit_balance_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| note | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| timestamps | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |
| previous_** |  |  |
| user_** |  |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_id | Unknown | FK |
| created_at | Unknown |  |
| note | Unknown |  |
| updated_at | Instant |  |
| user_created_at | Unknown |  |
| user_email | Unknown |  |
| user_first_name | Unknown |  |
| user_id | Unknown |  |
| user_last_name | Unknown |  |
| user_registered | Unknown |  |
| user_two_factor_enabled | Unknown |  |
| user_updated_at | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_customer | Unknown | FK |
| payment_source_id | Unknown | FK |
| ach_gateway | Unknown |  |
| ach_gateway_id | Unknown |  |
| active | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| attention_to | Unknown |  |
| autopay | Unknown |  |
| autopay_delay_days | Unknown |  |
| avalara_entity_use_code | Unknown |  |
| avalara_exemption_number | Unknown |  |
| bill_to_parent | Unknown |  |
| cc_gateway | Unknown |  |
| cc_gateway_id | Unknown |  |
| chase | Unknown |  |
| chasing_cadence | Unknown |  |
| city | Unknown |  |
| consolidated | Unknown |  |
| convenience_fee | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| credit_hold | Unknown |  |
| credit_limit | Unknown |  |
| currency | Unknown |  |
| email | Unknown |  |
| languages | Unknown |  |
| late_fee_schedule | Unknown |  |
| late_fee_schedule_id | Unknown |  |
| name | Unknown |  |
| network_connection | Unknown |  |
| network_connection_id | Unknown |  |
| next_chase_step | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| owner | Unknown |  |
| payment_term | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| sign_up_page | Unknown |  |
| sign_up_url | Unknown |  |
| state | Unknown |  |
| statement_pdf_url | Unknown |  |
| statement_url | Unknown |  |
| tax | Json |  |
| tax_id | Unknown |  |
| taxable | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### current_balance_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| balance | Unknown |  |
| currency | Unknown |  |
| timestamps | Unknown |  |

### current_balance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | Unknown | FK |
| available_credit | Unknown |  |
| currency | Unknown |  |
| due_now | Unknown |  |
| open_credit_note | Unknown |  |
| past_due | Unknown |  |
| total_outstanding | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| action | Unknown |  |
| chase_step_id | Unknown |  |
| complete | Unknown |  |
| completed_by_user_id | Unknown |  |
| completed_date | Unknown |  |
| created_at | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |
| user_id | Unknown |  |

### payment_plan_installment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_plan_id | Unknown | PK, FK |
| amount | Unknown |  |
| balance | Unknown |  |
| date | Unknown |  |

### payment_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | FK |
| approval_id | Unknown |  |
| approval_ip | Unknown |  |
| approval_timestamps | Unknown |  |
| approval_user_agent | Unknown |  |
| created_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### estimate_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | FK |
| created_at | Unknown |  |
| file_created_at | Unknown |  |
| file_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_type | Unknown |  |
| file_updated_at | Unknown |  |
| file_url | Unknown |  |
| updated_at | Unknown |  |

### subscription_addon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| plan | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| plan_id | Unknown | FK |
| bill_in | Unknown |  |
| bill_in_advance_day | Unknown |  |
| cancel_at_period_end | Unknown |  |
| canceled_at | Unknown |  |
| contract_period_end | Unknown |  |
| contract_period_start | Unknown |  |
| contract_renewal_cycle | Unknown |  |
| contract_renewal_mode | Unknown |  |
| created_at | Unknown |  |
| cycle | Unknown |  |
| discount | Json |  |
| mrr | Unknown |  |
| paused | Unknown |  |
| period_end | Unknown |  |
| period_start | Unknown |  |
| quantity | Unknown |  |
| recurring_total | Unknown |  |
| ship_to | Json |  |
| start_date | Unknown |  |
| status | Unknown |  |
| taxes | Json |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

### pending_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| catalog_item | Unknown |  |
| description | Unknown |  |
| discount | Json |  |
| discountable | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| quantity | Unknown |  |
| taxable | Unknown |  |
| taxes | Json |  |
| type | Unknown |  |
| unit_cost | Unknown |  |
| updated_at | Unknown |  |

### invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| amount | Unknown |  |
| catalog_item | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discount | Json |  |
| discountable | Unknown |  |
| plan_id | Unknown |  |
| quantity | Unknown |  |
| taxable | Unknown |  |
| taxes | Json |  |
| type | Unknown |  |
| unit_cost | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### invoice_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| amount | Unknown |  |
| tax_rate | Json |  |
| updated_at | Unknown |  |

### invoice_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| amount | Unknown |  |
| coupon | Json |  |
| expire | Unknown |  |
| from_payment_term | Unknown |  |
| updated_at | Unknown |  |

### invoice_shipping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| attention_to | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| payment_plan_id | Unknown | FK |
| subscription_id | Unknown | FK |
| attempt_count | Unknown |  |
| autopay | Unknown |  |
| balance | Unknown |  |
| chase | Unknown |  |
| closed | Unknown |  |
| created_at | Unknown |  |
| csv_url | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| draft | Unknown |  |
| due_date | Unknown |  |
| late_fees | Unknown |  |
| name | Unknown |  |
| needs_attention | Unknown |  |
| network_document | Unknown |  |
| network_document_id | Unknown |  |
| next_chase_on | Unknown |  |
| next_payment_attempt | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| paid | Unknown |  |
| payment_source | Unknown |  |
| payment_term | Unknown |  |
| payment_url | Unknown |  |
| pdf_url | Unknown |  |
| purchase_order | Unknown |  |
| ship_to_address_1 | Unknown |  |
| ship_to_address_2 | Unknown |  |
| ship_to_attention_to | Unknown |  |
| ship_to_city | Unknown |  |
| ship_to_country | Unknown |  |
| ship_to_created_at | Unknown |  |
| ship_to_name | Unknown |  |
| ship_to_postal_code | Unknown |  |
| ship_to_state | Unknown |  |
| ship_to_updated_at | Unknown |  |
| status | Unknown |  |
| subscription | Unknown |  |
| subtotal | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

### invoice_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | FK |
| created_at | Unknown |  |
| file_created_at | Unknown |  |
| file_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| file_type | Unknown |  |
| file_updated_at | Unknown |  |
| file_url | Unknown |  |
| updated_at | Unknown |  |

### payment_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| bank_name | Unknown |  |
| brand | Unknown |  |
| currency | Unknown |  |
| expiry_month | Unknown |  |
| expiry_year | Unknown |  |
| funding | Unknown |  |
| last_4_card_digits | Unknown |  |
| object | Unknown |  |
| routing_number | Unknown |  |
| updated_at | Unknown |  |
| verified | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avalara_location_code | Unknown |  |
| avalara_tax_code | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| discountable | Unknown |  |
| gl_account | Unknown |  |
| name | Unknown |  |
| taxable | Unknown |  |
| type | Unknown |  |
| unit_cost | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| currency | Unknown |  |
| duration | Unknown |  |
| exclusive | Unknown |  |
| expiration_date | Unknown |  |
| is_percent | Unknown |  |
| max_redemption | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| custom_** |  |  |

### tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| currency | Unknown |  |
| inclusive | Unknown |  |
| is_percent | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| custom_** |  |  |

### credit_note_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| amount | Unknown |  |
| catalog_item | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discount | Json |  |
| discountable | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| taxable | Unknown |  |
| taxes | Json |  |
| type | Unknown |  |
| unit_cost | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### credit_note_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| amount | Unknown |  |
| tax_rate | Json |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_id | Unknown | FK |
| balance | Unknown |  |
| closed | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| discount | Json |  |
| draft | Unknown |  |
| name | Unknown |  |
| network_document | Unknown |  |
| network_document_id | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| paid | Unknown |  |
| pdf_url | Unknown |  |
| purchase_order | Unknown |  |
| shipping | Json |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

### estimate_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | PK, FK |
| amount | Unknown |  |
| catalog_item | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discount | Json |  |
| discountable | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| taxable | Unknown |  |
| type | Unknown |  |
| unit_cost | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### estimate_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | PK, FK |
| amount | Unknown |  |
| tax_rate | Json |  |

### estimate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_id | Unknown | FK |
| approval | Unknown |  |
| approved | Unknown |  |
| closed | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| deposit | Unknown |  |
| deposit_paid | Unknown |  |
| discount | Json |  |
| draft | Unknown |  |
| expiration_date | Unknown |  |
| name | Unknown |  |
| network_document | Unknown |  |
| network_document_id | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| payment_terms | Unknown |  |
| pdf_url | Unknown |  |
| purchase_order | Unknown |  |
| ship_to | Json |  |
| shipping | Json |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

## Relationships

- payment(customer_id) → customer(id)
- payment(charge_customer_id) → customer(id)
- payment(charge_payment_source_customer_id) → customer(id)
- contact(customer_id) → customer(id)
- credit_note_attachment(credit_note_id) → credit_note(id)
- plan_tier(plan_id) → plan(id)
- credit_balance_adjustment(customer_id) → customer(id)
- note(customer_id) → customer(id)
- note(invoice_id) → invoice(id)
- customer(parent_customer) → customer(id)
- customer(payment_source_id) → payment_source(id)
- current_balance_history(_fivetran_id) → current_balance(_fivetran_id)
- current_balance(customer_id) → customer(id)
- task(customer_id) → customer(id)
- payment_plan_installment(payment_plan_id) → payment_plan(id)
- payment_plan(invoice_id) → invoice(id)
- estimate_attachment(estimate_id) → estimate(id)
- subscription_addon(subscription_id) → subscription(id)
- subscription(plan_id) → plan(id)
- subscription(customer_id) → customer(id)
- pending_line_item(customer_id) → customer(id)
- invoice_item(invoice_id) → invoice(id)
- invoice_tax(invoice_id) → invoice(id)
- invoice_discount(invoice_id) → invoice(id)
- invoice_shipping(invoice_id) → invoice(id)
- invoice(subscription_id) → subscription(id)
- invoice(payment_plan_id) → payment_plan(id)
- invoice(customer_id) → customer(id)
- invoice_attachment(invoice_id) → invoice(id)
- payment_source(customer_id) → customer(id)
- credit_note_item(credit_note_id) → credit_note(id)
- credit_note_tax(credit_note_id) → credit_note(id)
- credit_note(invoice_id) → invoice(id)
- credit_note(customer_id) → customer(id)
- estimate_item(estimate_id) → estimate(id)
- estimate_tax(estimate_id) → estimate(id)
- estimate(invoice_id) → invoice(id)
- estimate(customer_id) → customer(id)