companies

NEW

In short

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

This table is suited for incremental ingestion with an ETL tool. For standard data analysis, use schema pennylane.

A company represents a legal entity managed on Pennylane. Each company is uniquely identified by its Pennylane id, as well as its official registration_number (SIREN).

Most tables in the pennylane schema hold a company_id column that refers to companies.id, and allows to identify which records belong to which company.

Scopes

• accounting firm users have access to all companies falling in their portfolio;
• business owner users have access to their own company only.

Available Columns

id

bigint

Unique ID identifying the company on Pennylane.
Examples: 100094, 21847061

name

character varying

Company's display name on Pennylane. This name may differ from the legal registration name.

trade_name

character varying

NEW

Company's trade name on Pennylane. This name may differ from the legal registration name.

registration_number

character varying

Company's official registration number (SIREN).

vat_number

character varying

VAT number of the company, if applicable.

country_alpha2

character varying

Company's registration country code.
Examples: "FR", "DE", "GB"

city

character varying

Company's registration city.

postal_code

character varying

5 digits post code of the company.

saas_plan

character varying

Pennylane plan selected by the company - indicates the range of features that the company can access. Visit this page for more details.
Examples: "v1_basic", "v1_essential", "v1_pro"

cash_based_accounting

boolean

If true, indicates that the company uses cash-based accounting.
If false, the company uses the standard engagement accounting.

vat_frequency

character varying

Frequency at which VAT declarations are to be filed.
Examples: "monthly", "quarterly", "yearly", "not_applicable"

vat_day_of_month

integer

NEW

Day of the month at which VAT declarations are to be filed. This value is only relevant if `vat_frequency` is set to `monthly`.
Examples: 1, 15, 25

fiscal_category

character varying

NEW

Fiscal category of the company, as defined by the French tax administration. This value is used to determine the applicable VAT rates. It can take the following values:
`BIC-IS` : Bénéfices industriels et commerciaux - Impot sur les sociétés,
`BIC-IR` : Bénéfices industriels et commerciaux - Impot sur les revenus,
`BNC` : Benefices non commerciaux,
`BA` : Bénéfices agricoles,
`BIC-IS-GT` : Bénéfices industriels et commerciaux - Impot sur les sociétés, Groupe Tête,
`BIC-IS-GM` : Bénéfices industriels et commerciaux - Impot sur les sociétés, Groupe Membre,
`ETRANGER` : Revenus de source étrangère,
`SCM` : Société civile de moyens,
`RF` : Revenus Fonciers.
Examples: "SCM", "BNC", "BIC-IS"

fiscal_regime

character varying

NEW

Fiscal regime of the company, as defined by the French tax administration. It is used to determine the applicable VAT rates. This value can be empty when the fiscal regime has not been set.
Examples: "Simplified", "Normal"

registration_date

date

NEW

Date at which the company was registered officially.

activity_code

character varying

Activity sector code as defined by INSEE. This French nomenclature of economic activities, abbreviated NAF, is meant to simplify the organization of economic and social information.
Examples: "68.20B", "45.11Z", "81.10Z"

activity_sector

character varying

Human readable activity sector of the company; this value is derived from the `activity_code`.
Examples: "SCI/LMNP", "Restauration", "E-commerce"

legal_form_code

character varying

Legal form code, referring to the type of entity that an organisation may be, see `legal_form`. This is the official code provided by the INSEE.
Examples: "5710", "6585"

legal_form

character varying

Human readable equivalent of the `legal_form_code`.
Examples: "SAS, société par actions simplifiée", "Autre société civile professionnelle"

created_at

timestamp without time zone

NEW

Date and time at which the company was created on Pennylane.

updated_at

timestamp without time zone

NEW

Date and time at which the company was last updated on Pennylane.

synchronised_at

timestamp

Date and time at which the company's information was last synchronised with Pennylane's application.

deleted_at

timestamp without time zone

Date and time at which the company was deleted. If the company is not deleted, the value is NULL.