BCE Search
There is a way to add an input that will take a Belgian VAT number as input with a button and it will search on the BCE"s database after the information of the company that holds the VAT. The BCE service is managed by Insurgate (sls-data-be).
As an alternative, you can use the Pappers component to search for companies in Belgium, but Pappers allows to search for companies in other countries.
"bce_search": {
"component": "api_search",
"provider": "bce",
"label": "Search a company",
"placeholder": "Enter company number"
}
Customize the shown result
Multiple fields are returned by the API call, and we can organize them in the result shown.
We can change the order (ASC) if we want an option above others, and simply hide them by passing the show attribute to false.
List of attribute
- vat_formatted
- company_name
- juridical_form
- addresses
- activities
- vat_clean
- start_date
- phone_number
- fax_number
- website
- establishment_units
- financial_meta.capital
- financial_meta.exceptional_fiscal_year_begin
- financial_meta.exceptional_fiscal_year_end
- financial_meta.annual_meeting_month
- financial_meta.fiscal_year_end_day
- financial_meta.fiscal_year_end_month
Example
"bce_search": {
"component": "api_search",
"provider": "bce",
"label": "Search a company",
"placeholder": "Enter company number",
"bce": {
"options": {
"fields": [
{
"order": 1,
"show": true,
"key": "vat_formatted"
},
{
"order": 2,
"show": true,
"key": "company_name"
},
{
"order": 3,
"show": true,
"key": "juridical_form"
},
{
"order": 4,
"show": true,
"key": "addresses"
},
{
"order": 5,
"show": true,
"key": "activities"
},
{
"order": 6,
"show": true,
"key": "vat_clean"
},
{
"order": 6,
"show": true,
"key": "start_date",
"format": "date"
},
{
"order": 6,
"show": true,
"key": "phone_number"
},
{
"order": 6,
"show": true,
"key": "fax_number"
},
{
"order": 6,
"show": true,
"key": "email"
},
{
"order": 6,
"show": true,
"key": "website"
},
{
"order": 6,
"show": true,
"key": "establishment_units"
},
{
"order": 6,
"show": true,
"key": "financial_meta.capital"
},
{
"order": 6,
"show": true,
"key": "financial_meta.exceptional_fiscal_year_begin"
},
{
"order": 6,
"show": true,
"key": "financial_meta.exceptional_fiscal_year_end"
},
{
"order": 6,
"show": true,
"key": "financial_meta.annual_meeting_month"
},
{
"order": 6,
"show": true,
"key": "financial_meta.fiscal_year_end_day"
},
{
"order": 6,
"show": true,
"key": "financial_meta.fiscal_year_end_month"
}
]
}
}
}
Enrich with BVD
There is a possibility to add extra information coming from a referential of a customer. The BVD referential. The idea is to make the call and enrich the response of the BCE with related data coming from the customer referential. Note that it requires custom developement by customer and by referential.
To enrich the result, we can define the searchParams "enrich": "BVD" options. The search params will be added to the api call.
"bce_search": {
"component": "api_search",
"provider": "bce",
"label": "With all BVD keys",
"searchParams": {
"enrich": "BVD"
},
"placeholder": "Enter company number",
}
Customize the show result
As the enrich adds more data to display, we can customize what"s shown by defining the extraKeys attributes.
List of attributes
- bvd.bvd_postcode
- bvd.bvd_vat_nr
- bvd.create_month
- bvd.exp_month
- bvd.hoofd_nacebel
- bvd.naam_onderneming
- bvd.ratio_debt
- bvd.sectie_code
Example
"bce_search": {
"component": "api_search",
"provider": "bce",
"label": "With all BVD keys",
"searchParams": {
"enrich": "BVD"
},
"placeholder": "Enter company number",
"bce": {
"options": {
"extraKeys": [
{
"order": 10,
"show": true,
"key": "bvd.bvd_postcode"
},
{
"order": 10,
"show": true,
"key": "bvd.bvd_vat_nr"
},
{
"order": 10,
"show": true,
"key": "bvd.create_month"
},
{
"order": 10,
"show": true,
"key": "bvd.exp_month"
},
{
"order": 10,
"show": true,
"key": "bvd.hoofd_nacebel",
"label": "t:hoofd_nacebel"
},
{
"order": 10,
"show": true,
"key": "bvd.naam_onderneming",
"label": "t:naam_onderneming"
},
{
"order": 10,
"show": true,
"key": "bvd.ratio_debt",
"label": "t:ratio_debt"
},
{
"order": 10,
"show": true,
"key": "bvd.sectie_code",
"label": "t:sectie_code"
}
]
}
}
}