Pennylane
Explore the interactive ERD
Table & Field Reference
transaction_matched_invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transaction_id | Unknown | PKFK |
type | Unknown | |
url | Unknown |
quote_invoice_line_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quote_id | Unknown | PKFK |
created_at | Unknown | |
description | Unknown | |
rank | Unknown | |
title | Unknown | |
updated_at | Unknown |
quote_invoice_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quote_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
ledger_entry_line_id | Unknown | PKFK |
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 | PKFK |
customer_invoice_matched_transaction_id | Unknown | PKFK |
id | Unknown | PKFK |
weight | Unknown |
customer_invoice_matched_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_invoice_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
ledger_entry_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
supplier_invoice_id | Unknown | PKFK |
supplier_invoice_matched_transaction_id | Unknown | PKFK |
weight | Unknown |
supplier_invoice_matched_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_invoice_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
created_at | Unknown | |
file_name | Unknown | |
updated_at | Unknown | |
url | Unknown |
customer_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
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 | PKFK |
transaction_id | Unknown | PKFK |
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 |