etl

This schema is tailored for incremental ingestion with ETL tools.

It holds the same models as the pennylane schema, with the addition of:

• a deleted_at column indicating when a record was deleted, if applicable,
• a synchronised_at column showing the last time the record was synchronised with the Pennylane application.

IMPORTANT: every now and then, typically on a weekly basis, tables in the etl schema are fully recreated from a snapshot of production data. This is done to ensure that table schemas remain in sync with Pennylane data, for examples in case new columns are added.
This means that any data marked as deleted will eventually be purged from tables. If you need to keep track of deleted data, we recommend storing this information in your systems.

Note on permissions

The etl schema is accessible to all users.

Available Models

analytical_ledger

NEW

General ledger with analytical tags. This table includes all the bookkeeping entries of the company, with the analytical tags associated with each entry.

bank_accounts

NEW

Bank accounts connected to Pennylane. This table includes basic account information, balances and data synchronization status.

bank_transactions

NEW

Bank transactions accessible on pennylane. This table includes basic transaction information, such as the amount, execution date, transaction state.

companies

NEW

Portfolio of companies accessible on Pennylane. This table includes basic company information such as their registration details and Pennylane settings.

company_users

NEW

This table contains information about the users associated to a company. It allows to easily retrieve their ids, role and permissions in the data sharing.

customer_invoices

NEW

Invoices edited by the company managed on Pennylane for its customers. They can be edited and sent from Pennylane, or simply imported from other tools through diverse integrations.

customers

NEW

Customers of companies managed on Pennylane.

fiscal_years

NEW

Fiscal years of companies managed on Pennylane.

general_ledger

NEW

General ledger. This table includes all the bookkeeping entries of the company.

supplier_invoices

NEW

Invoices received by the company managed on Pennylane from its suppliers.

suppliers

NEW

Suppliers of companies managed on Pennylane.

tax_declarations

NEW

Tax Declarations. This table includes all the bookkeeping entries of the company.