Masterdata
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 | ☑️ |
|
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 | ☑️ | 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 |
|
|
|
String |
|
|
| |
IdentifierNType | String | See below | ☑️ | ** Identifier values for companies are unique across all active tenants and companies, per documentstream (Test vs Prod). |
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
In the list below, you can find all allowed Identifier Types in the masterdata
Type | Country | Explanation |
|---|---|---|
P | DK | DANISH CHAMBER OF COMMERCE Scheme |
ABN | AU | Australian Business Number (ABN) Scheme |
NSI | FI | Finnish Net service ID |
CFI | IT | Italian CODICE FISCALE |
IVA | IT | Italiann IVA code |
LEC | LT | Lituanian legal entity code |
UIDB | CH | Swiss Unique Business Identification Number (UIDB) |
SIRET | FR | Frech SIRET Code |
SST | JP | Japanese Corporate Number of The Social Security and Tax Number System |
OVT | FI | Finnish OVT Code |
UEN | SG | Singapore Nationwide E-Invoice Framework |
SECETI | IT | SECETI Object Identifiers |
GLN | International | Global Location Number |
NAL | International | Directorates of the European Commission |
ORG | NO | Norwegian Organisasjonsnummer |
KTNR | IS | Icelandic Registration identifier |
CVR | DK | The Danish Commerce and Companies Agency |
VAT | International | Tax registration number |
SE | DK | Danish Ministry of Taxation, Central Customs and Tax Administration |
ORGNR | SE | Swedish organisation number |
IBAN | International | SOCIETY FOR WORLDWIDE INTERBANK FINANCIAL, TELECOMMUNICATION S.W.I.F.T |
REID | International | Business Registers Network |
CPR | DK | Danish Ministry of the Interior and Health |
LWID | DE | Peppol-Leitweg-ID |
ORGNR | FI | Finnish Organization Identifier |
SIRENE | FR | System Information et Repertoire des Entreprise et des Etablissements: SIRENE |
ERST | DK | ERSTORG Code |
CUUO | IT | Codice Univoco Unità Organizzativa iPA |
VANS | DK | Danish VANS providers |
FTI | IT | FTI - Ediforum Italia |
GOV | AT | Österreichisches Verwaltungs bzw. Organisationskennzeichen |
LEI | International | Legal Entity Identifier (LEI) |
CBE | BE | Crosspoint Bank |
DIGST | DK | DIGSTORG |
SIA | IT | SIA Object Identifier -Società Interbancaria per l'Automazione S.p.A. |
CC | EE | Company Code |
OINO | NL | Organisatie-identificatienummer (OIN) |
KVK | NL | Kamer van Koophandel nummer |
KUR | AT | Kennziffer des Unternehmensregisters |
DUNS | International | Data Universal Numbering System (D-U-N-S Number) |
CRMNB | International | CRM Number |
NAME | International | Name |
CNPJ | BR | Cadastro Nacional da Pessoa Jurídica – the official business registry identification number in Brazil. |
RNC | DO | Registro Nacional de Contribuyentes – the tax registration number used in the Dominican Republic. |