Purchase invoice data of the City of Kuopio 2012-2021

Purchase invoice data of the City of Kuopio for the years 2012-2020. The information includes all the city’s offices, balance sheet units and commercial enterprises. The material has been extracted from the recycling and archiving system of the City of Kuopio’s purchase invoices and contains all the purchase invoices recorded in that system, subject to the limits set out below. Limitations: The data excludes a) enterprises that have been missing or had an incorrect Ly-ID in the invoice system b) private individuals and entities formed by private persons that do not have the Ly-ID c) invoices within different units of the City of Kuopio. Some of the invoice data are missing due to the technical solutions of the construction industry’s cost accounting system. The bills are shown as positive values in the dataset. Negative values indicate that this is a credit note. VAT is included in the accounting amounts and invoice amounts. As far as the material is concerned, it should be noted that the information on an individual invoice may be in several rows if the invoice has included services recorded in more than one cost point or in more than one accounting account. The column ‘Sum of invoice’ shows the total amount of the invoice and the column ‘accounting amount’ shows the breakdown of the total amount between the cost points and the accounting accounts. Explanations: Year, Certificate_paiva= Date of proof, Organisation number, Org_name= Organisation name, docId = Accounting account name, supplier number, Supplier name, Ly ID, invoice date, invoice total = Total amount of invoice, Reskontraviite, Account number= Accounting account number, Account name= Accounting account name, Kustp = Place of Cost, KP_name=Account total=Amount paid from Accounting account, Timestamp = Date of entry for last row