suppliers

NEW

In short

Suppliers of companies managed on Pennylane.

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

A supplier represents a supplier of a company managed on Pennylane. Suppliers are all legal entities.

💡 In case the same legal entity is a supplier of multiple companies managed on Pennylane, they will be represented by multiple records that share similar metadata.

Scopes

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

Available Columns

id

bigint

UNIQUE

Unique ID identifying the supplier on Pennylane.

name

character varying

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

company_id

bigint

Unique ID of the company on Pennylane, referring to companies.id.

company_name

character varying

Name of the company on Pennylane, referring to companies.name.

vat_rate

character varying

VAT rate applied by the supplier. This value acts as an automation rule and is used by the Pennylane OCR.
Examples: "FR_200", "FR_100", "extracom", "exempt"

plan_item_number

character varying

401 accounting plan item number associated with the supplier.
Examples: "40100001", "401EDF"

pnl_plan_item_number

character varying

Profit & Loss accounting plan item number, i.e. a class 6 account.
Examples: "6022", "6752"

postal_code

character varying

Postal code of the supplier. This value is sourced from an internal legal entity listing, when available.

country_alpha2

character varying

The country code associated with the supplier addresss. This value is sourced from an internal legal entity listing, when available.
Examples: "FR", "IE", "GB"

city

character varying

City of the supplier. This value is sourced from an internal legal entity listing, when available.

registration_number

character varying

Supplier's official registration number, for example SIREN in France.

vat_number

character varying

VAT number of the supplier, when applicable.

activity_code

character varying

Activity sector code as defined by INSEE, when available. 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"

legal_name

character varying

Legal name of the supplier. This name may differ from the supplier's display name.

registration_country_alpha2

character varying

Some legal entities may have a postal address in France (country_alpha2 = 'FR'), and a registration address in Ireland (reg_country_alpha2 = 'IE').
This column contains the registration country code, that together with the registration number, uniquely identifies suppliers.
Examples: "FR", "IE", "GB"

synchronized_at

timestamp without time zone

Date and time when the supplier's information was last synchronised with Pennylane's application.

deleted_at

timestamp without time zone

Date and time when the supplier was deleted from Pennylane's application.