`etl`

This schema is tailored for incremental ingestion with ETL tools. It holds the same models as schema pennylane. The models in this schema contain a column deleted_at which indicates the time when a record was deleted and a column synchronised_at which shows the last time the record was synchronised with Pennylane's application.

Note on permissions

The etl schema is accessible to all users.

Available Models

analytical_ledger_etl
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_transactions_etl
NEW

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

companies_etl
NEW

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

company_users_etl
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_etl
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.