# Pennylane schema ERD

Table and field reference for the Fivetran Pennylane connector.

## Table & Field Reference

### transaction_matched_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| type | Unknown |  |
| url | Unknown |  |

### quote_invoice_line_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| rank | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### quote_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| discount_value | Unknown |  |
| label | Unknown |  |
| product_url | Unknown |  |
| quantity | Unknown |  |
| raw_currency_unit_price | Unknown |  |
| section_rank | Unknown |  |
| tax | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### category_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| label | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| appendice_url | Unknown |  |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| customer_url | Unknown |  |
| date | Unknown |  |
| deadline | Unknown |  |
| discount_type | Unknown |  |
| discount_value | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | Unknown |  |
| file_name | Unknown |  |
| invoice_line_section_url | Unknown |  |
| invoice_line_url | Unknown |  |
| label | Unknown |  |
| languages | Unknown |  |
| linked_invoice_url | Unknown |  |
| number | Unknown |  |
| pdf_description | Unknown |  |
| pdf_invoice_free_text | Unknown |  |
| pdf_invoice_subject | Unknown |  |
| public_file_url | Unknown |  |
| quote_template_id | Unknown |  |
| special_mention | Unknown |  |
| status | Unknown |  |
| tax | Unknown |  |
| updated_at | Unknown |  |

### fiscal_year

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| finish | Unknown |  |
| start | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### supplier_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_invoice_id | Unknown | PK, FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| description | Unknown |  |
| imputation_end_date | Unknown |  |
| imputation_start_date | Unknown |  |
| label | Unknown |  |
| tax | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### supplier_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_id | Unknown | PK, FK |
| email_id | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ledger_account_id | Unknown | FK |
| created_at | Unknown |  |
| establishment_no | Unknown |  |
| external_reference | Unknown |  |
| iban | Unknown |  |
| name | Unknown |  |
| postal_address | Unknown |  |
| postal_city | Unknown |  |
| postal_country_alpha_2 | Unknown |  |
| postal_postal_code | Unknown |  |
| reg_no | Unknown |  |
| supplier_due_date_delay | Unknown |  |
| supplier_due_date_rule | Unknown |  |
| supplier_payment_method | Unknown |  |
| updated_at | Unknown |  |
| vat_number | Unknown |  |

### ledger_entry_line_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| ledger_entry_line_id | Unknown | PK, FK |
| weight | Unknown |  |

### ledger_entry_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_id | Unknown | FK |
| ledger_account_id | Unknown | FK |
| ledger_entry_id | Unknown | FK |
| attachment_filename | Unknown |  |
| attachment_url | Unknown |  |
| created_at | Unknown |  |
| credit | Unknown |  |
| date | Unknown |  |
| debit | Unknown |  |
| journal_url | Unknown |  |
| label | Unknown |  |
| ledger_account_url | Unknown |  |
| ledger_attachment_filename | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_establishment_id | Unknown | FK |
| journal_id | Unknown | FK |
| ledger_account_id | Unknown | FK |
| balance | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| journal_url | Unknown |  |
| ledger_account_url | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### customer_invoice_matched_transaction_category

| Column | Type | Keys |
| --- | --- | --- |
| customer_invoice_id | Unknown | PK, FK |
| customer_invoice_matched_transaction_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| weight | Unknown |  |

### customer_invoice_matched_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| bank_account_id | Unknown | FK |
| customer_id | Unknown | FK |
| journal_id | Unknown | FK |
| amount | Unknown |  |
| archived_at | Unknown |  |
| attachment_required | Unknown |  |
| bank_account_url | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_fee | Unknown |  |
| customer_url | Unknown |  |
| date | Unknown |  |
| fee | Unknown |  |
| label | Unknown |  |
| outstanding_balance | Unknown |  |
| pro_account_expense_card_masked_number | Unknown |  |
| pro_account_expense_employee_first_name | Unknown |  |
| pro_account_expense_employee_id | Unknown |  |
| pro_account_expense_employee_last_name | Unknown |  |
| updated_at | Unknown |  |

### customer_invoice_custom_header_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| created_at | Unknown |  |
| rank | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### billing_subscription_invoice_line_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_subscription_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| rank | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### billing_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| customer_invoice_template_id | Unknown | FK |
| activated_at | Unknown |  |
| billing_email_template_id | Unknown |  |
| billing_email_template_label | Unknown |  |
| created_at | Unknown |  |
| customer_invoice_amount | Unknown |  |
| customer_invoice_currency | Unknown |  |
| customer_invoice_currency_amount | Unknown |  |
| customer_invoice_currency_amount_before_tax | Unknown |  |
| customer_invoice_currency_tax | Unknown |  |
| customer_invoice_discount_type | Unknown |  |
| customer_invoice_discount_value | Unknown |  |
| customer_invoice_exchange_rate | Unknown |  |
| customer_invoice_invoice_line_url | Unknown |  |
| customer_invoice_label | Unknown |  |
| customer_invoice_language | Unknown |  |
| customer_invoice_line_section_url | Unknown |  |
| customer_invoice_pdf_description | Unknown |  |
| customer_invoice_pdf_invoice_free_text | Unknown |  |
| customer_invoice_pdf_invoice_subject | Unknown |  |
| customer_invoice_special_mention | Unknown |  |
| customer_url | Unknown |  |
| finish | Unknown |  |
| label | Unknown |  |
| mode | Unknown |  |
| next_occurrence | Unknown |  |
| payment_condition | Unknown |  |
| payment_method | Unknown |  |
| prev_occurrence | Unknown |  |
| recipient | Json |  |
| recurring_rule_count | Unknown |  |
| recurring_rule_day | Json |  |
| recurring_rule_day_of_month | Json |  |
| recurring_rule_interval | Unknown |  |
| recurring_rule_month_of_year | Json |  |
| recurring_rule_rule_type | Unknown |  |
| recurring_rule_until | Unknown |  |
| recurring_rule_week_start | Unknown |  |
| start | Unknown |  |
| status | Unknown |  |
| stopped_at | Unknown |  |
| updated_at | Unknown |  |

### pro_account_mandate_migration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| customer_url | Unknown |  |
| direct_debit_method | Unknown |  |
| error_message | Unknown |  |
| mandate_id | Unknown |  |
| mandate_type | Unknown |  |
| migrated_at | Unknown |  |
| migration_started_at | Unknown |  |
| signed_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### customer_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_subscription_id | Unknown | FK |
| credited_invoice_id | Unknown | FK |
| customer_id | Unknown | FK |
| ledger_entry_id | Unknown | FK |
| quote_id | Unknown | FK |
| template_id | Unknown | FK |
| amount | Unknown |  |
| appendices_url | Unknown |  |
| archived_at | Unknown |  |
| billing_subscription_url | Unknown |  |
| categories_url | Unknown |  |
| created_at | Unknown |  |
| credited_invoice_url | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| custom_header_fields_url | Unknown |  |
| customer_url | Unknown |  |
| date | Unknown |  |
| deadline | Unknown |  |
| discount_type | Unknown |  |
| discount_value | Unknown |  |
| draft | Unknown |  |
| e_invoicing | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | Unknown |  |
| factur_x | Unknown |  |
| filename | Unknown |  |
| invoice_line_url | Unknown |  |
| invoice_number | Unknown |  |
| label | Unknown |  |
| languages | Unknown |  |
| line_section_url | Unknown |  |
| matched_transactions_url | Unknown |  |
| paid | Unknown |  |
| payments_url | Unknown |  |
| pdf_description | Unknown |  |
| pdf_invoice_free_text | Unknown |  |
| pdf_invoice_subject | Unknown |  |
| public_file_url | Unknown |  |
| quote_url | Unknown |  |
| remaining_amount_with_tax | Unknown |  |
| remaining_amount_without_tax | Unknown |  |
| schematron_validation_status | Unknown |  |
| special_mention | Unknown |  |
| status | Unknown |  |
| tax | Unknown |  |
| transaction_reference_banking_provider | Unknown |  |
| transaction_reference_field_name | Unknown |  |
| transaction_reference_field_value | Unknown |  |
| updated_at | Unknown |  |

### ledger_entry_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| ledger_entry_id | Unknown | PK, FK |
| weight | Unknown |  |

### ledger_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_id | Unknown | FK |
| attachment_filename | Unknown |  |
| attachment_url | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| invoice_number | Unknown |  |
| journal_url | Unknown |  |
| label | Unknown |  |
| piece_number | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### billing_subscription_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_subscription_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| discount_value | Unknown |  |
| imputation_end_date | Unknown |  |
| imputation_start_date | Unknown |  |
| label | Unknown |  |
| product_url | Unknown |  |
| quantity | Unknown |  |
| raw_currency_unit_price | Unknown |  |
| section_rank | Unknown |  |
| tax | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### gocardless_mandate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| customer_url | Unknown |  |
| external_customer_account | Unknown |  |
| external_customer_label | Unknown |  |
| external_reference | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### customer_invoice_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### customer_invoice_line_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| rank | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_accounting_logic | Unknown |  |
| company_id | Unknown |  |
| company_name | Unknown |  |
| company_reg_no | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |

### customer_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| discount_value | Unknown |  |
| imputation_end_date | Unknown |  |
| imputation_start_date | Unknown |  |
| label | Unknown |  |
| product_url | Unknown |  |
| quantity | Unknown |  |
| raw_currency_unit_price | Unknown |  |
| section_rank | Unknown |  |
| substance | Unknown |  |
| tax | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### supplier_invoice_matched_transaction_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| supplier_invoice_id | Unknown | PK, FK |
| supplier_invoice_matched_transaction_id | Unknown | PK, FK |
| weight | Unknown |  |

### supplier_invoice_matched_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_invoice_id | Unknown | PK, FK |
| bank_account_id | Unknown | FK |
| journal_id | Unknown | FK |
| supplier_id | Unknown | FK |
| amount | Unknown |  |
| archived_at | Unknown |  |
| attachment_required | Unknown |  |
| bank_account_url | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_fee | Unknown |  |
| date | Unknown |  |
| fee | Unknown |  |
| label | Unknown |  |
| outstanding_balance | Unknown |  |
| pro_account_expense_card_masked_number | Unknown |  |
| pro_account_expense_employee_first_name | Unknown |  |
| pro_account_expense_employee_id | Unknown |  |
| pro_account_expense_employee_last_name | Unknown |  |
| supplier_url | Unknown |  |
| updated_at | Unknown |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| label | Unknown |  |
| type | Unknown |  |

### ledger_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_alpha_2 | Unknown |  |
| created_at | Unknown |  |
| enabled | Unknown |  |
| label | Unknown |  |
| letterable | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### customer_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| label | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### supplier_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_invoice_id | Unknown | PK, FK |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| label | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### trial_balance

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| credit | Unknown |  |
| debit | Unknown |  |
| formatted_number | Unknown |  |
| label | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ledger_account_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| external_reference | Unknown |  |
| label | Unknown |  |
| price | Unknown |  |
| price_before_tax | Unknown |  |
| reference | Unknown |  |
| substance | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |
| vat_rate | Unknown |  |

### customer_invoice_appendice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_invoice_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_name | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### purchase_request_linked_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_request_id | Unknown | PK, FK |
| url | Unknown |  |

### purchase_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| delivery_address | Unknown |  |
| delivery_city | Unknown |  |
| delivery_country_alpha_2 | Unknown |  |
| delivery_postal_code | Unknown |  |
| estimated_delivery_date | Unknown |  |
| exchange_rate | Unknown |  |
| purchase_order_file_name | Unknown |  |
| purchase_order_number | Unknown |  |
| purchase_order_url | Unknown |  |
| reason | Unknown |  |
| status | Unknown |  |
| supplier_url | Unknown |  |
| tax | Unknown |  |
| updated_at | Unknown |  |

### pa_registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| exchange_direction | Unknown |  |
| siren | Unknown |  |
| siret | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### quote_appendice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| created_at | Unknown |  |
| file_name | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| mobile_number | Unknown |  |
| role | Unknown |  |
| telephone_number | Unknown |  |
| updated_at | Unknown |  |

### bank_establishment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### supplier_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ledger_entry_id | Unknown | FK |
| supplier_id | Unknown | FK |
| accounting_status | Unknown |  |
| amount | Unknown |  |
| archived_at | Unknown |  |
| category_url | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_amount_before_tax | Unknown |  |
| currency_tax | Unknown |  |
| date | Unknown |  |
| deadline | Unknown |  |
| e_invoicing_flow_id | Unknown |  |
| e_invoicing_reason | Unknown |  |
| e_invoicing_source_file_url | Unknown |  |
| e_invoicing_status | Unknown |  |
| exchange_rate | Unknown |  |
| external_reference | Unknown |  |
| file_name | Unknown |  |
| import_source | Unknown |  |
| import_source_path | Unknown |  |
| invoice_line_url | Unknown |  |
| label | Unknown |  |
| matched_transaction_url | Unknown |  |
| number | Unknown |  |
| paid | Unknown |  |
| payment_status | Unknown |  |
| payment_url | Unknown |  |
| public_file_url | Unknown |  |
| reconciled | Unknown |  |
| remaining_amount_with_tax | Unknown |  |
| remaining_amount_without_tax | Unknown |  |
| supplier_url | Unknown |  |
| tax | Unknown |  |
| transaction_reference_banking_provider | Unknown |  |
| transaction_reference_field_name | Unknown |  |
| transaction_reference_field_value | Unknown |  |
| updated_at | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_group_id | Unknown | FK |
| analytical_code | Unknown |  |
| created_at | Unknown |  |
| direction | Unknown |  |
| label | Unknown |  |
| updated_at | Unknown |  |

### sepa_mandate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| bank | Unknown |  |
| bic | Unknown |  |
| created_at | Unknown |  |
| customer_url | Unknown |  |
| iban | Unknown |  |
| identifier | Unknown |  |
| sequence_type | Unknown |  |
| signed_at | Unknown |  |
| updated_at | Unknown |  |

### transaction_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| weight | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_id | Unknown | FK |
| customer_id | Unknown | FK |
| journal_id | Unknown | FK |
| supplier_id | Unknown | FK |
| amount | Unknown |  |
| archived_at | Unknown |  |
| attachment_required | Unknown |  |
| bank_account_url | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_amount | Unknown |  |
| currency_fee | Unknown |  |
| customer_url | Unknown |  |
| date | Unknown |  |
| fee | Unknown |  |
| interbank_code | Unknown |  |
| journal_url | Unknown |  |
| label | Unknown |  |
| outstanding_balance | Unknown |  |
| pro_account_expense_card_masked_number | Unknown |  |
| pro_account_expense_employee_first_name | Unknown |  |
| pro_account_expense_employee_id | Unknown |  |
| pro_account_expense_employee_last_name | Unknown |  |
| supplier_url | Unknown |  |
| updated_at | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ledger_account_id | Unknown | FK |
| billing_address | Unknown |  |
| billing_city | Unknown |  |
| billing_country_alpha_2 | Unknown |  |
| billing_iban | Unknown |  |
| billing_language | Unknown |  |
| billing_postal_code | Unknown |  |
| contact_url | Unknown |  |
| created_at | Unknown |  |
| customer_type | Unknown |  |
| delivery_address | Unknown |  |
| delivery_city | Unknown |  |
| delivery_country_alpha_2 | Unknown |  |
| delivery_postal_code | Unknown |  |
| external_reference | Unknown |  |
| mandate_url | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| payment_condition | Unknown |  |
| phone | Unknown |  |
| pro_account_mandate_url | Unknown |  |
| recipient | Unknown |  |
| reference | Unknown |  |
| reg_no | Unknown |  |
| updated_at | Unknown |  |
| vat_number | Unknown |  |

## Relationships

- transaction_matched_invoice(transaction_id) → transaction(id)
- quote_invoice_line_section(quote_id) → quote(id)
- quote_invoice_line(product_id) → product(id)
- quote_invoice_line(quote_id) → quote(id)
- quote(customer_id) → customer(id)
- supplier_invoice_line(supplier_invoice_id) → supplier_invoice(id)
- supplier_email(supplier_id) → supplier(id)
- supplier(ledger_account_id) → ledger_account(id)
- ledger_entry_line_category(id) → category(id)
- ledger_entry_line_category(ledger_entry_line_id) → ledger_entry_line(id)
- ledger_entry_line(journal_id) → journal(id)
- ledger_entry_line(ledger_entry_id) → ledger_entry(id)
- ledger_entry_line(ledger_account_id) → ledger_account(id)
- bank_account(journal_id) → journal(id)
- bank_account(ledger_account_id) → ledger_account(id)
- bank_account(bank_establishment_id) → bank_establishment(id)
- customer_invoice_matched_transaction_category(id) → category(id)
- customer_invoice_matched_transaction_category(customer_invoice_matched_transaction_id) → customer_invoice_matched_transaction(id)
- customer_invoice_matched_transaction_category(customer_invoice_id) → customer_invoice_matched_transaction(customer_invoice_id)
- customer_invoice_matched_transaction(journal_id) → journal(id)
- customer_invoice_matched_transaction(customer_id) → customer(id)
- customer_invoice_matched_transaction(bank_account_id) → bank_account(id)
- customer_invoice_matched_transaction(customer_invoice_id) → customer_invoice(id)
- customer_invoice_custom_header_field(customer_invoice_id) → customer_invoice(id)
- billing_subscription_invoice_line_section(billing_subscription_id) → billing_subscription(id)
- billing_subscription(customer_id) → customer(id)
- billing_subscription(customer_invoice_template_id) → customer_invoice_template(id)
- pro_account_mandate_migration(customer_id) → customer(id)
- customer_invoice(template_id) → customer_invoice_template(id)
- customer_invoice(quote_id) → quote(id)
- customer_invoice(ledger_entry_id) → ledger_entry(id)
- customer_invoice(customer_id) → customer(id)
- customer_invoice(credited_invoice_id) → customer_invoice(id)
- customer_invoice(billing_subscription_id) → billing_subscription(id)
- ledger_entry_category(id) → category(id)
- ledger_entry_category(ledger_entry_id) → ledger_entry(id)
- ledger_entry(journal_id) → journal(id)
- billing_subscription_invoice_line(product_id) → product(id)
- billing_subscription_invoice_line(billing_subscription_id) → billing_subscription(id)
- gocardless_mandate(customer_id) → customer(id)
- customer_invoice_line_section(customer_invoice_id) → customer_invoice(id)
- customer_invoice_line(product_id) → product(id)
- customer_invoice_line(customer_invoice_id) → customer_invoice(id)
- supplier_invoice_matched_transaction_category(id) → category(id)
- supplier_invoice_matched_transaction_category(supplier_invoice_matched_transaction_id) → supplier_invoice_matched_transaction(id)
- supplier_invoice_matched_transaction_category(supplier_invoice_id) → supplier_invoice_matched_transaction(supplier_invoice_id)
- supplier_invoice_matched_transaction(journal_id) → journal(id)
- supplier_invoice_matched_transaction(supplier_id) → supplier(id)
- supplier_invoice_matched_transaction(bank_account_id) → bank_account(id)
- supplier_invoice_matched_transaction(supplier_invoice_id) → supplier_invoice(id)
- customer_invoice_payment(customer_invoice_id) → customer_invoice(id)
- supplier_invoice_payment(supplier_invoice_id) → supplier_invoice(id)
- product(ledger_account_id) → ledger_account(id)
- customer_invoice_appendice(customer_invoice_id) → customer_invoice(id)
- purchase_request_linked_invoice(purchase_request_id) → purchase_request(id)
- purchase_request(supplier_id) → supplier(id)
- quote_appendice(quote_id) → quote(id)
- customer_contact(customer_id) → customer(id)
- supplier_invoice(ledger_entry_id) → ledger_entry(id)
- supplier_invoice(supplier_id) → supplier(id)
- category(category_group_id) → category_group(id)
- sepa_mandate(customer_id) → customer(id)
- transaction_category(id) → category(id)
- transaction_category(transaction_id) → transaction(id)
- transaction(journal_id) → journal(id)
- transaction(supplier_id) → supplier(id)
- transaction(customer_id) → customer(id)
- transaction(bank_account_id) → bank_account(id)
- customer(ledger_account_id) → ledger_account(id)