City of Mikkeli’s purchase invoices 2021-2022

The data contains information on purchase invoices related to purchases of services, substances, supplies, goods and other commodities of the City of Mikkeli from all sectors of the city. In addition, the data also includes, for example, some records related to the city’s financial expenditure. The data has been extracted from the city’s financial system, and the material has been supplemented with e.g. the business IDs of suppliers and name information describing the organisational hierarchy, so that the information is as informative to its users as possible. The euro amounts shown in the report are exempt from VAT. As this is a purchase ledger data, the accounts included in the data do not include any subsequent corrections made with memo receipts.

As a result of the provisions of the Data Protection Act, the purchase invoice information does not include payments made to individuals and business names to the extent that the supplier information is a person’s name or a business name containing the name of a natural person (Tmi). For example, the purchase invoice data does not indicate which purchase decision each purchase invoice relates to, because such information is not collected in the system that is the source of the purchase invoice data. Procurement decisions are made in the City’s case management system, which is not connected to the accounting programme.

The data contains the following column information: buyer (City of Mikkel), date of registration, voucher number, supplier number, supplier’s name, supplier’s business ID, account group number and name, account number and name, sum, institution number and name, number and name of the output area, number and name of the publishing venue. The data makes it possible to review purchase invoice data, for example, by supplier, account, group of accounts or the level of interest in the organisation hierarchy.

The material is updated once a year after the finalisation of the financial statements.

For further questions concerning purchase invoice data, please submit a request for information via the website of the City of Mikkeli.

本数据集包含米凯利市（City of Mikkeli）各部门采购服务、物料、耗材、商品及其他各类物资的采购发票信息。此外，本数据集还涵盖部分与该市财政支出相关的记录。本数据集提取自该市财政系统，并补充了供应商企业识别码、描述组织层级的名称信息等内容，以最大程度提升信息的可用性。报告中列明的欧元金额均不含增值税（VAT）。由于本数据集属于采购分类账数据，因此其中包含的账目未涵盖后续通过备忘收据进行的任何更正操作。

根据《数据保护法》的相关规定，当供应商信息为自然人姓名或包含自然人姓名的企业名称（Tmi）时，采购发票信息将不包含向该类个人及企业支付款项的相关内容。例如，本采购发票数据集无法体现每张发票对应的采购决策，因为采购发票数据源系统并未采集此类信息。采购决策由该市的案件管理系统制定，该系统未与会计系统对接。

本数据集包含以下字段信息：采购方（米凯利市）、登记日期、凭证编号、供应商编号、供应商名称、供应商企业识别码、会计科目组编号及名称、会计科目编号及名称、金额、机构编号及名称、输出区域编号及名称、发布场所编号及名称。用户可通过供应商、会计科目、会计科目组或组织层级等维度对采购发票数据进行查询分析。

本数据集每年在财务决算完成后更新一次。

若需咨询采购发票数据集的相关问题，请通过米凯利市官方网站提交信息查询申请。