LT.VAT (data source)

From CDQ Wiki
DataSource:LT.VAT
Jump to navigation Jump to search
Property Value
Identifiers LT.VAT (The ALEI prefix element is the ISO 3166-2 code for country and subdivision if applicable followed by the stop character <code>.</code>. This is followed by an acronym representing the register maintained by the administrative agency for the governing body of a nation, state, or community that assigned the identifier element. The prefix is assigned by ECCMA ALEI prefix), LT_VAT (A technical identifier, unique in a certain context. Technical key)
Language-specific short name. Monolingual short name Lithuania VAT Register (en)
Language-specific name. Monolingual name Lithuania Taxpayer Register (en)
An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description Taxpayer register and VAT registration status published by the Lithuanian State Tax Inspectorate (VMI).
The country a linked concept is active or generally relevant for. Country scope LT (Lithuania)
Data access State Tax Inspectorate under the Ministry of Finance (Valstybinė mokesčių inspekcija prie Finansų ministerijos) (Provider or authority of a data source. Provider), website (URL that provides more information for a given concept. URL), API (URL that provides direct access to the data of a data source. Deep URL), IDENTIFIER (Search type (data sources)<br/>Describes how data can be searched in a data source.<br/>IDENTIFIER: Data can be searched by business identifiers.<br/>INDEX: Data can be searched by business identifiers.<br/>FUZZY: Data can be searched by address and name attributes. Search type)
The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates, nonetheless, we continue to offer the most recent available data. Release status IDEA, COPY (Documents how a data source is integrated into the CDL with respect to data gathering:<br/><code>REMOTE ACCESS</code>: Data is not stored on CDL side but queried ad-hoc from the data source (e.g. webservices)<br/><code>COPY</code>: Data is replicated on CDL side (usually already transformed into the target CDL data model)<br/><code>UNDEFINED</code>: not yet known Integration type)
Content BUSINESS_PARTNER (Data source category<br/>Specifies the category of a data source in terms of the content.<br/>ADDRESS: The data source provides address reference data.<br/>BANK_ACCOUNT: The data source provides bank and bank account reference data.<br/>BENEFICIAL_OWNER: The data source provides information about beneficial owners of companies.<br/>BUSINESS_PARTNER: The data source provides master data about companies.<br/>CERTIFICATE: The data source provides information about business partner certifications.<br/>HEALTHCARE_ORGANIZATION: The data source provides information about HCOs.<br/>HEALTHCARE_PROFESSIONAL: The data source provides information about HCPs.<br/>INSOLVENCY: The data source provides information about insolvencies.<br/>SANCTION_AND_WATCHLIST: A data source that provides sanctioned or watched companies or persons. Data source category) , 46 concepts, 8 terms
Legal classification 2020-01-01 (Date when a legal classification was approved (the last time). Legal approval), GOVERNMENTAL (Data ownership<br/>Categorizes legal right-holding by the type of the data owner, e.g. a private organization or a governmental authority.<br/>GOVERNMENTAL: The data source is owned by a governmental body, e.g., a federal, state, or municipal authority.<br/>PRIVATE: The data source is owned by a private body, e.g., a company or an association. Data ownership), OPEN (Data provision<br/>Categorizes restriction of data access, i.e., whether a data source provides "open" data or requires registration.<br/>FREE: Data is provided for free, but the data source requires registration, i.e., authentication when data is downloaded or queried.<br/>OPEN: Data is provided for free and unlimited access without registration or subscription.<br/>COMMERCIAL: Data is not provided for free, but users of the data source have to pay for downloading, querying, or using the data according to a commercial contract. Data provision), EU_PUBLIC (Terms type<br/>A client or CDQ accepts the terms of use of a particular data source and the compliant use of its data.<br/>NO_TERMS: No specific terms of use are provided for a data source.<br/>STANDARD: A standard licence is used, further details are provided by license type information of the data source.<br/>EU_PUBLIC: The data source is provided by a governmental organization under EU law, i.e., from "within" a EU member country.<br/>EU_PRIVATE: The data source is provided by a private organization under EU law, i.e., from "within" a EU member country.<br/>CDQ_CONTRACTED: CDQ accepts the terms of a particular data source and the compliant use of its data.<br/>CLIENT_CONTRACTED: A client (i.e., the data end user) accepts the terms of a particular data source and the compliant use of its data. Terms type), https://creativecommons.org/licenses/by/4.0/ (URL that provides more information on a license, e.g., of a data source. License URL)
Quota 250,000 (The default maximum quota for a data source. Maximum Quota (default)), MONTH (Quota reset<br/>The default reset period of a defined quota for a data source.<br/>DAY: The quota of the data source is reset daily.<br/>WEEK: The quota of the data source is reset weekly.<br/>MONTH: The quota of the data source is reset monthly.<br/>YEAR: The quota of the data source is reset yearly. Quota reset (default)), CDQ (Quota control<br/>The control of changing the maximum quota and reset period for a data source.<br/>CDQ: The quota of the data source can be higher than set by CDQ.<br/>CLIENT: The quota of the data source can be set higher than the default.<br/>CREDENTIAL_DEPENDENT: If a customer uses CDQ credentials to assess the data source then the quota can't be higher than the default, but if customers use their own credentials, then the quota can be increased. Quota control), NO (Quota enablement<br/>whether the quota management is turned on for a specific data source.<br/>YES: A quota is enabled for the data source.<br/>NO: The data source does not have an enabled quota. Quota enabled)
Linkage strategy Linkage strategy for data source LT.VAT and country LT
Update monitoring NO (Update monitor enablement<br/>whether the update monitoring is turned on for a specific data source.<br/>YES: An update monitor is enabled for the data source.<br/>NO: For the data source, no update monitor is enabled. Update monitoring enabled), Daily (Date and time when a data source is checked to find updates. Update frequency)

Managed business identifiers

IdentifierTechnical nameParentDescriptionCDQ mapping
ja_kodas (LT.VAT)ja_kodasrecord (LT.VAT)Legal entity code (juridinio asmens kodas), 9 digits
key of the record
Identifier Value (CDQ)

Data model concepts

ConceptTechnical nameParentDescriptionCDQ mapping
anul_tipas (LT.VAT)tipai_first_anul_tipasfirst (LT.VAT)Date on which the entry was annulled, yyyy-MM-dd
ekonomine_veikla_id (LT.VAT)veiklos_first_ekonomine_veikla_idfirst (LT.VAT)Reference (UUID) to the economic activity in another data.gov.lt dataset
the activity code is not part of this dataset (source column ekonomine_veikla._id)
first (LT.VAT)padaliniai_firstpadaliniai (LT.VAT)First branch of the list. Other entries have the same attributes
first (LT.VAT)tipai_firsttipai (LT.VAT)The first type of the list. The importer sorts the types: current types (no end date, not annulled) by code ascending, so that a group of legal forms (101-126) comes before the tax roles 129, 242, 243
then ended types by end date descending
annulled types last. Other entries have the same attributes
first (LT.VAT)grupes_firstgrupes (LT.VAT)First group of the list. Other entries have the same attributes
first (LT.VAT)veiklos_firstveiklos (LT.VAT)First activity of the list. Other entries have the same attributes
grup_aprasymas (LT.VAT)grupes_first_grup_aprasymasfirst (LT.VAT)Description of the group
grupe_anul (LT.VAT)grupes_first_grupe_anulfirst (LT.VAT)Date on which the membership was annulled, yyyy-MM-dd
grupe_iki (LT.VAT)grupes_first_grupe_ikifirst (LT.VAT)Member until, yyyy-MM-dd
grupe_nuo (LT.VAT)grupes_first_grupe_nuofirst (LT.VAT)Member from, yyyy-MM-dd
grupes (LT.VAT)grupesrecord (LT.VAT)Groups of taxpayers the taxpayer belongs to
ireg_data (LT.VAT)ireg_datarecord (LT.VAT)Date of registration in the Register of Taxpayers, yyyy-MM-dd
isformuota (LT.VAT)padaliniai_first_isformuotafirst (LT.VAT)Date the branch was closed, yyyy-MM-dd
isreg_data (LT.VAT)isreg_datarecord (LT.VAT)Date of deregistration from the Register of Taxpayers, yyyy-MM-dd
ja_kodas (LT.VAT)ja_kodasrecord (LT.VAT)Legal entity code (juridinio asmens kodas), 9 digits
key of the record
Identifier Value (CDQ)
klnt_tipas (LT.VAT)klnt_tipasrecord (LT.VAT)Kind of taxpayer
always LJA (Lithuanian legal entity) in this dataset
Business Partner Category (CDQ)
latest (LT.VAT)pvm_latestpvm (LT.VAT)The latest registration: the importer sorts the current registration (no deregistration date) first, then by registration date descending. Other entries have the same attributes
mm_grupe (LT.VAT)grupes_first_mm_grupefirst (LT.VAT)Code of the group
only 17 occurs
padaliniai (LT.VAT)padaliniairecord (LT.VAT)Branches / places of business (padaliniai) registered with the tax authority
no address is published
padalinio_kodas (LT.VAT)padaliniai_first_padalinio_kodasfirst (LT.VAT)Country of the branch, ISO 3166 numeric (440 = Lithuania)
padalinio_nr (LT.VAT)padaliniai_first_padalinio_nrfirst (LT.VAT)Number of the branch within the taxpayer
padalinio_pvd (LT.VAT)padaliniai_first_padalinio_pvdfirst (LT.VAT)Name / kind of the branch (free text)
padalinio_savivaldybe (LT.VAT)padaliniai_first_padalinio_savivaldybefirst (LT.VAT)Code of the municipality of the branch
pagrindine (LT.VAT)veiklos_first_pagrindinefirst (LT.VAT)Main activity flag: 1 = main, 0 = other
pavadinimas (LT.VAT)pavadinimasrecord (LT.VAT)Name of the legal entityName Value (CDQ)
pvm (LT.VAT)pvmrecord (LT.VAT)Registrations as VAT payer (PVM mokėtojas)
one VAT number per taxpayer, rarely several registration periods
pvm_iregistruota (LT.VAT)pvm_latest_pvm_iregistruotalatest (LT.VAT)Date of registration as VAT payer, yyyy-MM-dd
pvm_isregistruota (LT.VAT)pvm_latest_pvm_isregistruotalatest (LT.VAT)Date of deregistration as VAT payer, yyyy-MM-dd
pvm_kodas (LT.VAT)pvm_latest_pvm_kodaslatest (LT.VAT)VAT number without prefix (PVM mokėtojo kodas), 9 or 12 digits
pvm_kodas_pref (LT.VAT)pvm_latest_pvm_kodas_preflatest (LT.VAT)Country prefix of the VAT number, always LT
missing on VAT codes deregistered before 2004 (national VAT codes from before EU accession)
record (LT.VAT)recordOne taxpayer (legal entity) of the Register of Taxpayers of the State Tax Inspectorate of Lithuania (VMI), identified by the legal entity code. The importer groups the rows of the open data table MokesciuMoketojas (data.gov.lt, one row per combination of taxpayer type, VAT registration, branch and economic activity) by ja_kodas into one record
repeated values are merged into lists, empty values are left out.
suformuota (LT.VAT)padaliniai_first_suformuotafirst (LT.VAT)Date the branch was set up, yyyy-MM-dd
tipai (LT.VAT)tipairecord (LT.VAT)Taxpayer types (mokesčių mokėtojo tipai) with their validity
a taxpayer can have several at the same time (e.g. a group of legal forms and land tax payer)
tipas_iki (LT.VAT)tipai_first_tipas_ikifirst (LT.VAT)Valid until, yyyy-MM-dd
tipas_nuo (LT.VAT)tipai_first_tipas_nuofirst (LT.VAT)Valid from, yyyy-MM-dd
tipo_aprasymas (LT.VAT)tipai_first_tipo_aprasymasfirst (LT.VAT)Description of the taxpayer type (plural name of the group)
tipo_kodas (LT.VAT)tipai_first_tipo_kodasfirst (LT.VAT)Code of the taxpayer type: 101-126 groups of legal forms (e.g. 124 private limited companies), 129 OSS participant, 242 real estate tax payer, 243 land tax payerLegal Form (CDQ)
valstybe (LT.VAT)valstyberecord (LT.VAT)Country (ISO 3166 alpha-3) recorded for the taxpayer, LTU for nearly all
for some Lithuanian companies a foreign country (origin of capital), not the country of an address
veikla_anuliuota (LT.VAT)veiklos_first_veikla_anuliuotafirst (LT.VAT)Date on which the activity entry was annulled, yyyy-MM-dd
veiklos (LT.VAT)veiklosrecord (LT.VAT)Economic activities carried out by the taxpayer with the municipality where they are carried out
veiklos_pabaiga (LT.VAT)veiklos_first_veiklos_pabaigafirst (LT.VAT)End of the activity, yyyy-MM-dd
veiklos_pradzia (LT.VAT)veiklos_first_veiklos_pradziafirst (LT.VAT)Start of the activity, yyyy-MM-dd
vv_adresas_anul (LT.VAT)veiklos_first_vv_adresas_anulfirst (LT.VAT)Date on which the place of activity was annulled, yyyy-MM-dd
vv_adresas_iki (LT.VAT)veiklos_first_vv_adresas_ikifirst (LT.VAT)Place of activity valid until, yyyy-MM-dd
vv_adresas_nuo (LT.VAT)veiklos_first_vv_adresas_nuofirst (LT.VAT)Place of activity valid from, yyyy-MM-dd
vv_savivaldybe (LT.VAT)veiklos_first_vv_savivaldybefirst (LT.VAT)Code of the municipality where the activity is carried out

Controlled vocabulary terms

Term (external)Technical nameParentDescriptionCDQ mappingMapping target constant
101 (LT.VAT)101tipo_kodas (LT.VAT)Valstybės įmonėsLT_1821 (CDQ)
102 (LT.VAT)102tipo_kodas (LT.VAT)Savivaldybės įmonėsLT_4003 (CDQ)
112 (LT.VAT)112tipo_kodas (LT.VAT)Užsienio valstybių įmonių padaliniaiLT_0490 (CDQ)
123 (LT.VAT)123tipo_kodas (LT.VAT)Akcinės bendrovėsLT_5319 (CDQ)
124 (LT.VAT)124tipo_kodas (LT.VAT)Uždarosios akcinės bendrovėsLT_0320 (CDQ)
125 (LT.VAT)125tipo_kodas (LT.VAT)Europos bendrovės, įmonėsLT_0276 (CDQ)
126 (LT.VAT)126tipo_kodas (LT.VAT)Biudžetinės įstaigosLT_1285 (CDQ)
LJA (LT.VAT)LJAklnt_tipas (LT.VAT)Lithuanian legal entity (Lietuvos juridinis asmuo)COMPANY (CDQ)