[go: up one dir, main page]
Wikidata

Property talk:P3608

Latest comment: 3 months ago by Samoasambia in topic "Replacement property" in format constraint

Documentation

EU VAT number
VAT number assigned in the EU
DescriptionEU VAT number
Data typeExternal identifier
Domain
According to this template: organizations
According to statements in the property:
organization (Q43229) or juridical person (Q155076)
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:
[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).+|
When possible, data should only be stored as statements
ExampleSanoma Corporation (Q1540297) → FI15243611
Ontotext (Q7095072) → BG200356710
Red Cross of Burgenland, Austria (Q105580734) → ATU16274500
Sourcehttp://ec.europa.eu/taxation_customs/vies
Formatter URLhttps://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: usageCategory:Pages using Wikidata property P3608 (Q50415106)
Related to country  European Union (Q458) (See 46 others)
Lists
Proposal discussionProposal discussion
Current uses
Total13,672
Main statement13,24996.9% of uses
Qualifier6<0.1% of uses
Reference4173.1% of uses
Search for values
[create Create a translatable help page (preferably in English) for this property to be included here]
 
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Unique value, SPARQL (every item), SPARQL (by value)
 
Item “instance of (P31)”: Items with this property should also have “instance of (P31)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P31, search, SPARQL
 
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Single value, SPARQL
 
 
Item “country (P17)”: Items with this property should also have “country (P17)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P17, search, SPARQL
 
Type “organization (Q43229), juridical person (Q155076)”: item must contain property “instance of (P31)” with classes “organization (Q43229), juridical person (Q155076)” or their subclasses (defined using subclass of (P279)). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Type Q43229, Q155076, SPARQL
 
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Entity types
 
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Scope, SPARQL
 
Item “headquarters location (P159)”: Items with this property should also have “headquarters location (P159)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Item P159, search, SPARQL
 
Format “[A-Z]{2}[A-Z\d*]+|”: value must be formatted using this pattern (PCRE syntax). (Help)
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, hourly updated report, SPARQL
 
Format “ATU\d{8}|^(?!AT).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “BE0\d{9}|^(?!BE).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “BG\d{9,10}|^(?!BG).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “CY\d{8}[A-Z]|^(?!CY).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “CZ\d{8,10}|^(?!CZ).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “DE\d{9}|^(?!DE).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “DK\d{8}|^(?!DK).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “EE\d{9}|^(?!EE).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “(EL|GR)\d{9}|^(?!EL|GR).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “ES[\dA-Z]\d{7}[\dA-Z]|^(?!ES).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “FI\d{8}|^(?!FI).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “FR[\dA-Z]{2}\d{9}|^(?!FR).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “GB\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!GB).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “HR\d{11}|^(?!HR).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “HU\d{8}|^(?!HU).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “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)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “IS[\dA-Z]{6}|^(?!IS).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “IT\d{11}|^(?!IT).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “LI\d{5}|^(?!LI).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “LT(\d{9}|\d{12})|^(?!LT).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “LU\d{8}|^(?!LU).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “LV\d{11}|^(?!LV).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “MT\d{8}|^(?!MT).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “NL\d{9}B\d{2}|^(?!NL).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “NO\d{9}(MVA)?|^(?!NO).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “PL\d{10}|^(?!PL).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “PT\d{9}|^(?!PT).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “RO\d{2,10}|^(?!RO).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “SE\d{12}|^(?!SE).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “SI\d{8}|^(?!SI).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “SK\d{10}|^(?!SK).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “XN\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!XN).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
 
Format “^(?!CH).+|”: value must be formatted using this pattern (PCRE syntax). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3608#Format, SPARQL
Law
Geography
Environment
Chemistry
Medicine
Research
Economy
Transport
Vocabulary
Person
other

Formatter URL doesn't work

edit
Latest comment: 6 years ago3 comments3 people in discussion

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)Reply

+1 AlessioMela --Deansfa (talk) 18:09, 24 November 2017 (UTC)Reply
@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)Reply

Format-constraints no longer mandatory

edit
Latest comment: 2 years ago3 comments1 person in discussion

Hi Ivan A. Krestinin, you've removed constraint status (P2316)mandatory constraint (Q21502408) from all per-country regular expressions. Could you please elaborate, why they shouldn't be mandatory, i.e. there are exceptions to the constraints? If I'm not mistaken, each regular expression describes exactly the language of valid VAT numbers for a country. --Nw520 (talk) 22:41, 4 April 2022 (UTC)Reply

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)Reply
Ivan A. Krestinin? --Nw520 (talk) 21:16, 29 August 2022 (UTC)Reply

formatter URL broken

edit
Latest comment: 5 months ago9 comments7 people in discussion

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)Reply

@Nw520: thanks for raising this! I found it today. Examples:

  Notified participants of WikiProject Companies

Mcnabber091 (talk) 00:29, 18 June 2014 (UTC) Tobias1984 (talk) 10:23, 8 November 2015 (UTC) Note 1 PAC2 (talk) 09:29, 26 September 2016 (UTC) Rjlabs (talk) 20:30, 14 March 2017 (UTC) Datawiki30 (talk) 11:55, 2 September 2018 (UTC) Sidpark (talk) 09:31, 2 December 2018 (UTC) Mathieu Kappler (talk) 11:44, 6 September 2021 (UTC)Reply

  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)Reply

JSON response is not an ideal outcome (for human), but still much better than nothing. Jklamo (talk) 23:08, 14 September 2022 (UTC)Reply
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)Reply
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)Reply

"Replacement property" in format constraint

edit
Latest comment: 3 months ago1 comment1 person in discussion

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)Reply

Add topic
Retrieved from "https://www.wikidata.org/w/index.php?title=Property_talk:P3608&oldid=2237456615"
Return to "P3608" page.