Property talk:P3608
Documentation
VAT number assigned in the EU
Description | EU VAT number | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data type | External identifier | ||||||||||||
Domain | According to this template:
organizations
When possible, data should only be stored as statements | ||||||||||||
Allowed values | According to this template:
First two letters are the country code where the organization is registered, followed by the VAT number of the organization within that country.
According to statements in the property:
When possible, data should only be stored as statements[A-Z]{2}[A-Z\d*]+|ATU\d{8}|^(?!AT).+|BE0\d{9}|^(?!BE).+|BG\d{9,10}|^(?!BG).+|CY\d{8}[A-Z]|^(?!CY).+|CZ\d{8,10}|^(?!CZ).+|DE\d{9}|^(?!DE).+|DK\d{8}|^(?!DK).+|EE\d{9}|^(?!EE).+|(EL|GR)\d{9}|^(?!EL|GR).+|ES[\dA-Z]\d{7}[\dA-Z]|^(?!ES).+|FI\d{8}|^(?!FI).+|FR[\dA-Z]{2}\d{9}|^(?!FR).+|GB\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!GB).+|HR\d{11}|^(?!HR).+|HU\d{8}|^(?!HU).+|IE(\d[A-Z*+]\d{5}[A-Z]|\d{7}([A-Z]W?|[A-Z]{2}))|^(?!IE).+|IS[\dA-Z]{6}|^(?!IS).+|IT\d{11}|^(?!IT).+|LI\d{5}|^(?!LI).+|LT(\d{9}|\d{12})|^(?!LT).+|LU\d{8}|^(?!LU).+|LV\d{11}|^(?!LV).+|MT\d{8}|^(?!MT).+|NL\d{9}B\d{2}|^(?!NL).+|NO\d{9}(MVA)?|^(?!NO).+|PL\d{10}|^(?!PL).+|PT\d{9}|^(?!PT).+|RO\d{2,10}|^(?!RO).+|SE\d{12}|^(?!SE).+|SI\d{8}|^(?!SI).+|SK\d{10}|^(?!SK).+|XN\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!XN).+|^(?!CH).+| | ||||||||||||
Example | Sanoma Corporation (Q1540297) → FI15243611 Ontotext (Q7095072) → BG200356710 Red Cross of Burgenland, Austria (Q105580734) → ATU16274500 | ||||||||||||
Source | http://ec.europa.eu/taxation_customs/vies | ||||||||||||
Formatter URL | https://wikidata-externalid-url.toolforge.org/index.php?url=https%3A%2F%2Fec.europa.eu%2Ftaxation_customs%2Fvies%2Frest-api%2Fms%2F%251%2Fvat%2F%252&exp=(%5BA-Z%5D%5BA-Z%5D)(.*)&id=$1 | ||||||||||||
Tracking: usage | Category:Pages using Wikidata property P3608 (Q50415106) | ||||||||||||
Related to country | European Union (Q458) (See 49 others) | ||||||||||||
Lists |
| ||||||||||||
Proposal discussion | Proposal discussion | ||||||||||||
Current uses |
| ||||||||||||
Search for values |
List of violations of this constraint: Database reports/Constraint violations/P3608#Unique value, SPARQL (every item), SPARQL (by value)
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P31, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Single value, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P17, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Type Q43229, Q155076, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Entity types
List of violations of this constraint: Database reports/Constraint violations/P3608#Scope, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P159, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
(EL|GR)\d{9}|^(?!EL|GR).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
ES[\dA-Z]\d{7}[\dA-Z]|^(?!ES).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
FR[\dA-Z]{2}\d{9}|^(?!FR).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
GB\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!GB).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
IE(\d[A-Z*+]\d{5}[A-Z]|\d{7}([A-Z]W?|[A-Z]{2}))|^(?!IE).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
LT(\d{9}|\d{12})|^(?!LT).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
XN\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!XN).+|
”: value must be formatted using this pattern (PCRE syntax). (Help)List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
|
Formatter URL doesn't work
[edit]The formatter URL needs two parameters: the code of the state and the rest of the VAT numbers. For now instead is just one parameter so the link doesn't work properly. --AlessioMela (talk) 08:33, 20 May 2017 (UTC)
- +1 AlessioMela --Deansfa (talk) 18:09, 24 November 2017 (UTC)
- @AlessioMela, Deansfa: Thanks to ArthurPSmith and it's Wikidata External ID redirector, the property now links to the EU website properly. Tubezlob (🙋) 16:16, 10 April 2018 (UTC)
Format-constraints no longer mandatory
[edit]Hi Ivan A. Krestinin, you've removed
- There seem to be some false-positives (namely for HU and NO) but that was due to errornous regular expressions. --Nw520 (talk) 22:48, 4 April 2022 (UTC)
formatter URL broken
[edit]https://ec.europa.eu/taxation_customs/vies/vatResponse.html
is no longer available and the new service at https://ec.europa.eu/taxation_customs/vies/
doesn't seem to accept query parameters. Requests are made to https://ec.europa.eu/taxation_customs/vies/rest-api/ms/{COUNTRY_CODE}/vat/{VAT_ID}
which seems to be stable but doesn't provide a nice UI. --Nw520 (talk) 21:16, 29 August 2022 (UTC)
@Nw520: thanks for raising this! I found it today. Examples:
- https://ec.europa.eu/taxation_customs/vies/vatResponse.html?memberStateCode=AT&number=U16274500 is now broken
- https://ec.europa.eu/taxation_customs/vies/rest-api/ms/AT/vat/U16274500 is JSON payload. On their website, it's displayed as a simple table.
Notified participants of WikiProject Companies
Notified participants of WikiProject Economics
Does anyone know how to fix this, short of deploying a web server with a simple app? Could copy some JS logic from their site.
--Vladimir Alexiev (talk) 11:31, 14 September 2022 (UTC)
- @Vladimir Alexiev: if we were ok with the JSON response I could update the external-id redirect service to point there. But it sounds like you're hoping for something different? ArthurPSmith (talk) 17:38, 14 September 2022 (UTC)
- Please do! Vladimir Alexiev (talk) 10:52, 19 September 2022 (UTC)
- JSON response is not an ideal outcome (for human), but still much better than nothing. Jklamo (talk) 23:08, 14 September 2022 (UTC)
- Agree, https://ec.europa.eu/taxation_customs/vies/rest-api/ms/AT/vat/U64807427 is not bad. Firefox at least displays JSON in a somewhat 'pretty' way (not sure about others) ; at the very least I imagine browsers would not force a file-download.
- IDs do not have to web-resolve ; but if they do, in my view it is for 2 purposes: 1/ giving more information to the reader ; 2/ confirm that the value is actually correct. With a broken formatter URL I thought I must have made a mistake entering `ATU64807427`, or perhaps the ID was withdrawn, or perhaps Austria opted-out of the EU registry etc. That the URL works at all is already great I think. Jean-Fred (talk) 08:22, 23 February 2023 (UTC)
- I've changed P3608 to now instead use wikidata-externalid-url.toolforge.org with custom regex functionality to generate the link to the JSON at least. I've also made a cleaner PR #34 to accomplish the same thing. Let me know if it doesn't work for you, or if you find a more user friendly way to display data than raw JSON (that can be done via HTTP GET request). You can test at e.g. Q652564, as it might take some time for other links to become clickable (adding
?action=purge
to page you're interested in and waiting a bit might help speed it up) --Mnalis (talk) 13:14, 29 May 2024 (UTC)
- I've changed P3608 to now instead use wikidata-externalid-url.toolforge.org with custom regex functionality to generate the link to the JSON at least. I've also made a cleaner PR #34 to accomplish the same thing. Let me know if it doesn't work for you, or if you find a more user friendly way to display data than raw JSON (that can be done via HTTP GET request). You can test at e.g. Q652564, as it might take some time for other links to become clickable (adding
"Replacement property" in format constraint
[edit]Hi, I removed replacement property (P6824) parameter from the format constraint since the constraint does not accept such parameter, and it results in an error of the violations report. Samoasambia ✎ 10:26, 27 August 2024 (UTC)
- European Union-related properties
- All Properties
- Properties with external-id-datatype
- Properties used on 10000+ items
- Properties with unique value constraints
- Properties with constraints on items using them
- Properties with single value constraints
- Properties with conflicts with constraints
- Properties with constraints on type
- Properties with entity type constraints
- Properties with scope constraints
- Properties with format constraints