SIREN/SIRET validation
Use this function to compare your records for French business partners with the French government database, Sirene®. Information that is different or missing displays in a log file. If there are discrepancies between your records and the database, you need to make changes or updates manually.
Prerequisites
You need to complete these requirements before you can use this functionality.
Organizations
To connect with the Sirene® database, you need to create your organization. And, importantly, you need to register your organization in the final step. Check with your administrator if you are not sure.
Activity code
Make sure this activity code is active to use all the features described here.
EINSI - SIREN/SIRET validation
Filter records
- In the General block, define records you want to include in the validation process.
- You can enter 1 or a range of business partners.
- If you don't select All roles, you can select 1 or a combination of roles to limit to your search.
- In the Options block, you can include natural persons and/or public sector companies by selecting their respective checkboxes. Business partners in these categories are not included in the general search by default.
- Use the Formula field to create a custom filter. You can select fields from the following tables: BPARTNER, BPSUPPLIER, and BPCUSTOMER.
- Select OK to validate records and generate a log file.
- If there are errors or inconsistencies between your records and those in the Sirene® database, a message displays with the number of errors. Results are listed in the log file.
Results
Results display in a log file. For each company, there is a line for each value compared against the database. Each line details if the value matches and if not, a reason is provided. If all fields match correctly, a message states that the BP is valid.
If 1 or more values for a business partner do not match the database, the last line for the business partner displays a message that the BP is not valid. You need to make corrections to your records manually. There is no automatic update of information between your records and the Sirene® database.
This list does not include all possible messages.
- BP is closed in SIRENE database
- Invalid BP FR003
- Site tax ID no. (SIREN) is valid
- SIRET is incomplete. Please update the field 'Site tax ID no.' with SIRET
- Company name: Value does not exist in the SIRENE database
- Address (Postal code): invalid value "44400"
- Expected: 44350
- FR005 is valid
Screen management
Entry screen
General block
Use these fields to filter BPs whose records you want to validate.
From BP/To BP (BPRDEB/BPRFIN) |
Enter a range of French business partners. |
Country (CRY) |
The country defaults to France. |
All roles (ALLROLES) |
Select this checkbox to include all business partner roles. |
Customer (BPCFLG) |
If the All roles checkbox is not selected, you can select this checkbox to only include customer roles. |
Supplier (BPSFLG) |
If the All roles checkbox is not selected, you can select this checkbox to only include supplier roles. |
Other (OTHERFLG) |
If the All roles checkbox is not selected, you can select this checkbox to only include other roles. |
Options block
Natural person (LEGETT) |
Select this checkbox to include business partners that are artisans or sole proprietors. These types of business partners are not included if the checkbox is not selected. |
Public sector (BPPFLG) |
Select this checkbox to include business partners that are in the public sector such as government or state agencies. These types of business partners are not included if the checkbox is not selected. |
Formula (CRITERE) |
Enter a custom formula to create a custom filter. You can build a formula that uses all fields for business partners (BP), customers (BPC), and suppliers (BPS). From the Actions icon in the field, you have direct access to the standard tools: Formula wizard, Message display, and Analyze formula. |