Masterdata | Customer Portal

Masterdata files are uploaded to Routty as CSV files. There are two type of master datafiles required:

A masterdata file defining the companies of the tenant
A masterdata file defining the business partners of the tenant.

You will find to example CSV files below:

Each company and business partner is identified via one or more identifiers, such as an IBAN or VAT number. When processing inbound and outbound documents, Routty will compare the company and business partner in the document with the master database. In case no match is found, the document will end up in an error state.

You can define both test and production companies and business partners within one environment.

The first line in a master data file specifies the fieldnames. All subsequent lines are the actual data that will be imported. Companies and Business Partners are imported as separate files. The company group id’s that are specified in the business partners file must already exist in the system prior to the import. Hence, it is recommended to first import the companies and then the business partners.

Each row/line in the master data file populates either the Company or Business Partner list for the Tenant.
Multiple files can be imported, each subsequent import adding on top of the existing data. Duplicates are skipped (and generate an error in the log).

The MasterData file contains the following fields:

Field	DataType	Restrictions	Required	Info
EntityType	String	ENUM Values: COMPANY, PARTNER	☑️
Type	String	ENUM Values: CUSTOMER, SUPPLIER	Only when Entitytype = PARTNER
CrmNumber	String	Unique within the scope of the tenant	☑️	Used as unique identifier within the scope of the tenant
Name	String		☑️
CompanyGroupId	Integer	Unique within the scope of the tenant.	☑️	CompanyGroupIds are created through the import of this file. A companyGroupId lets multiple companies be linked together, so they can be referenced together. For example, when defining a businessPartner, add it once for a companyGroupId, not for every individual company.
Status	String	ENUM Values: ACTIVE, DISABLED	☑️	Documents that enter the system for disabled companies or business partners will not be processed in Routty and receive the error status.
Street	String
Number	String
PoBox	String
PostalCode	String
City	String
CountryCode	String		☑️
Phone	String
Email	String
IdentifierNType	String	See below	☑️	** Identifier values for companies are unique across all active tenants and companies, per documentstream (Test vs Prod). N stands for a number, the first entry will be Identifier1Type, Identifier1Value, … and so on.
IdentifierNValue	String	**	☑️
isTest	Boolean	TRUE or FALSE	☑️	Determines whether this Company or businessPartner will be imported as data for the Test or Prod documentstream.

Additional requirements:

One CSV file must either contain companies or business partners, not both.
When processing a file with business partners, Routty verifies the company group ids against the values in its database.
It is possible that the CSV contains an company or business partner which has previously been defined. If this is the case, the entry in the database will be overwritten. This includes overwriting the identifiers to only those identifiers specified in the CSV file.
When there are entries that contain issues, all other entries will be created except for the ones that give issues.

Identifier types

Supported masterdata identifier types and their Peppol mappings are listed below. Use the Type value in the IdentifierNType CSV column. A masterdata identifier can exist without an active Peppol mapping.

Updated from the supplied database export on 2026-10-19: 63 identifier types, 83 distinct active Peppol codes, 2 inactive mappings and 15 identifier types without a Peppol mapping. Coverage was checked against Peppol participant identifier schemes v9.7.

The Peppol ICD column shows PeppolFieldType.IcdValue. For VAT, the code depends on the country; the generic FieldType.ICD value 9912 is deprecated and must not be used as a replacement for these country-specific codes. Leading zeros are significant.

Active means enabled in the supplied database export. Inactive and No mapping describe Peppol configuration, not whether the identifier type can be stored in masterdata. International means the mapping has no CountryId; Not specified means the export supplies no country for an unmapped type.

CBE uses 0208 and Swedish ORGNR uses 0007. COD 0205 remains inactive because it cannot be registered in SMP/SML. The OVT alias remains inactive; OVT2 provides the active 0216 mapping. ORG-FI 0212 and NSI 0215 are removed Peppol schemes.

Reference: Peppol participant identifier schemes v9.7.

Type	Country / scope	Explanation	Peppol ICD	Peppol mapping
ABN	AU	Australian Business Number (ABN) Scheme	0151	Active
BE	Not specified	Belgian identifier alias; no Peppol mapping	—	No mapping
CBE	BE	Belgian enterprise number (BCE/KBO/CBE)	0208	Active
CC	EE	Company Code	0191	Active
CFI	IT	Italian CODICE FISCALE	0210	Active
CNPJ	Not specified	Cadastro Nacional da Pessoa Jurídica – the official business registry identification number in Brazil.	—	No mapping
COD	IT	The COD identifier	0205	Inactive
CPR	Not specified	Danish Ministry of the Interior and Health	—	No mapping
CRMNB	Not specified	CRM Number	—	No mapping
CTC	FR	French electronic invoicing routing address	0225	Active
CUUO	IT	Codice Univoco Unità Organizzativa iPA	0201	Active
CVR	Not specified	The Danish Commerce and Companies Agency	—	No mapping
DIC	SK	Slovak tax identification number (DIC)	0245	Active
DIGST	DK	DIGSTORG	0184	Active
DUNS	International	Data Universal Numbering System (D-U-N-S Number)	0060	Active
EIF	MY	Malaysian e-invoicing framework identifier	0230	Active
EIN	US	US Employer Identification Number	9959	Active
EN	Not specified	Belgian enterprise number alias; no Peppol mapping	—	No mapping
ERST	DK	ERSTORG Code	0198	Active
FTI	IT	FTI - Ediforum Italia	0097	Active
GEBA	DE	German Electronic Business Address	0246	Active
GLN	International	Global Location Number	0088	Active
GOV	AT	Österreichisches Verwaltungs bzw. Organisationskennzeichen	9915	Active
GSN	International	GS1 identification keys	0209	Active
IBAN	International	SOCIETY FOR WORLDWIDE INTERBANK FINANCIAL, TELECOMMUNICATION S.W.I.F.T	9918	Active
ICO	SK	Slovak identification number of economic subject (ICO)	0158	Active
IIN	Not specified	Japanese invoice issuer number alias; no Peppol mapping	—	No mapping
IVA	IT	Italian VAT number	0211	Active
KTNR	IS	Icelandic Registration identifier	0196	Active
KUR	AT	Kennziffer des Unternehmensregisters	9919	Active
KVK	NL	Kamer van Koophandel nummer	0106	Active
LEC	LT	Lithuanian legal entity code	0200	Active
LEI	International	Legal Entity Identifier (LEI)	0199	Active
LWID	DE	Peppol-Leitweg-ID	0204	Active
MAT	LU	Luxembourg register of legal persons	0240	Active
NAL	International	Directorates of the European Commission	0130	Active
NAME	Not specified	Name	—	No mapping
NG-TID	NG	Nigerian Tax Identification (Tax ID)	0244	Active
NIP	Not specified	The Polish KSeF Identifier	—	No mapping
NSI	Not specified	Finnish Net service ID	—	No mapping
OIB	Not specified	Croatian Personal Identification Number	—	No mapping
OINO	NL	Organisatie-identificatienummer (OIN)	0190	Active
ORG	NO	Norwegian Organisasjonsnummer	0192	Active
ORG-FI	Not specified	Finnish Organization Identifier (removed Peppol scheme)	—	No mapping
ORGNR	SE	Swedish organisation number	0007	Active
OVT	FI	Legacy OVT alias; Peppol mapping inactive; use OVT2	0216	Inactive
OVT2	FI	Finnish OVT code	0216	Active
P	DK	Danish Business Authority P-number	0096	Active
REID	International	Business Registers Network	9913	Active
RNC	Not specified	Registro Nacional de Contribuyentes – the tax registration number used in the Dominican Republic.	—	No mapping
SE	Not specified	Danish Ministry of Taxation, Central Customs and Tax Administration	—	No mapping
SECETI	IT	SECETI Object Identifiers	0142	Active
SIA	IT	SIA Object Identifier -Società Interbancaria per l'Automazione S.p.A.	0135	Active
SIREN	FR	9-digit identifier assigned to a French legal entity	0002	Active
SIRET	FR	French SIRET code	0009	Active
SST	JP	Japanese Corporate Number of The Social Security and Tax Number System	0188	Active
TIN	AE	United Arab Emirates tax identifier	0235	Active
UEN	SG	Singapore Nationwide E-Invoice Framework	0195	Active
UIDB	CH	Swiss Unique Business Identification Number (UIDB)	0183	Active
URN	LV	Latvian unified registration number	0218	Active
VANS	Not specified	Danish VANS providers	—	No mapping
VAT	AD	VAT / tax registration number	9922	Active
VAT	AL	VAT / tax registration number	9923	Active
VAT	AT	VAT / tax registration number	9914	Active
VAT	BA	VAT / tax registration number	9924	Active
VAT	BE	VAT / tax registration number	9925	Active
VAT	BG	VAT / tax registration number	9926	Active
VAT	CH	VAT / tax registration number	9927	Active
VAT	CY	VAT / tax registration number	9928	Active
VAT	CZ	VAT / tax registration number	9929	Active
VAT	DE	VAT / tax registration number	9930	Active
VAT	EE	VAT / tax registration number	9931	Active
VAT	ES	VAT / tax registration number	9920	Active
VAT	FR	VAT / tax registration number	9957	Active
VAT	GB	VAT / tax registration number	9932	Active
VAT	GR	VAT / tax registration number	9933	Active
VAT	HR	VAT / tax registration number	9934	Active
VAT	HU	VAT / tax registration number	9910	Active
VAT	IE	VAT / tax registration number	9935	Active
VAT	JP	VAT / tax registration number	0221	Active
VAT	LI	VAT / tax registration number	9936	Active
VAT	LT	VAT / tax registration number	9937	Active
VAT	LU	VAT / tax registration number	9938	Active
VAT	LV	VAT / tax registration number	9939	Active
VAT	MC	VAT / tax registration number	9940	Active
VAT	ME	VAT / tax registration number	9941	Active
VAT	MK	VAT / tax registration number	9942	Active
VAT	MT	VAT / tax registration number	9943	Active
VAT	NL	VAT / tax registration number	9944	Active
VAT	OM	VAT / tax registration number	0248	Active
VAT	PL	VAT / tax registration number	9945	Active
VAT	PT	VAT / tax registration number	9946	Active
VAT	RO	VAT / tax registration number	9947	Active
VAT	RS	VAT / tax registration number	9948	Active
VAT	SI	VAT / tax registration number	9949	Active
VAT	SK	VAT / tax registration number	9950	Active
VAT	SM	VAT / tax registration number	9951	Active
VAT	TR	VAT / tax registration number	9952	Active
VAT	VA	VAT / tax registration number	9953	Active