All Payments To Suppliers by UK Government | Finance and Economics

About this Dataset

All Payments To Suppliers

Payments to suppliers made by City of York Council from April 2011 onwards. Resources are split according to financial years. Date: The date shown is the date the transaction was input to the system, not the payment date. Transaction number: Our internal reference number to enable us to identify an individual transaction. Transaction numbers beginning with CR relate to entries from the creditor system, usually straightforward payments or credit notes. Transaction numbers beginning with J relate to journal entries, which are usually an accounting entry to correct a miscoding error. Amount: All payments shown exclude VAT. Negative amounts relate to credit notes or corrections. Corrections: Miscoding errors may occur, for example the allocation of a payment to an incorrect expense area or expense type. These are usually corrected in the next month. One of the principles of the spending guidance is to make the data available quickly and to reflect how each individual item was originally recorded in the financial system. Therefore since this report includes only one months data it is likely to include some miscoding errors which have not been corrected yet. These corrections will not be back dated so will appear in the next months report. In the month that the correction occurs a credit (negative) amount will show against the incorrect expense area/ expense type and the corresponding payment will show against the correct expense area/expense type. Supplier Name: The name of the supplier or recipient of the payment. Payments to individuals which may contain sensitive information have been redacted. Supplier ID: Our internal reference number to enable us to identify the supplier. Expense Area: The department where the expenditure is incurred. Expense Type: The description of the nature of the spend. For further information, please visit City of York Council's website
Publisher name: City of York Council
Last updated: 2024-09-16T04:00:03Z

Tables

Payments To Suppliers - 2015/2016

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2015_2016

1.07 MB
146008 rows
10 columns


CREATE TABLE payments_to_suppliers_2015_2016 (
  "organisationname" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "expensecategory" VARCHAR,
  "supplier_beneficiary" VARCHAR,
  "supplierid" DOUBLE,
  "paymentdate" TIMESTAMP,
  "transactionreference" VARCHAR,
  "netamount_excvat" DOUBLE,
  "cardtransaction" VARCHAR
);

All Payments To Suppliers - 2016/2017

@ukgov.all_payments_to_suppliers.all_payments_to_suppliers_2016_2017

1.18 MB
141106 rows
10 columns


CREATE TABLE all_payments_to_suppliers_2016_2017 (
  "organisationname" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "expensecategory" VARCHAR,
  "supplier_beneficiary" VARCHAR,
  "supplierid" DOUBLE,
  "paymentdate" TIMESTAMP,
  "transactionreference" VARCHAR,
  "netamount_excvat" DOUBLE,
  "cardtransaction" VARCHAR
);

Payments To Suppliers - 2022/2023

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2022_2023

891.23 KB
58188 rows
13 columns


CREATE TABLE payments_to_suppliers_2022_2023 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "transaction_no" VARCHAR,
  "card_transaction" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2020/2021

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2020_2021

870.09 KB
56076 rows
13 columns


CREATE TABLE payments_to_suppliers_2020_2021 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "card_transaction" VARCHAR,
  "transaction_no" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2011/2012

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2011_2012

401.32 KB
37906 rows
8 columns


CREATE TABLE payments_to_suppliers_2011_2012 (
  "bodyname" VARCHAR,
  "organisationunit" VARCHAR,
  "expensecategory" VARCHAR,
  "expenditurecode" BIGINT,
  "date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "amount" DOUBLE,
  "suppliername" VARCHAR
);

Payments To Suppliers - 2019/2020

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2019_2020

918.73 KB
61389 rows
13 columns


CREATE TABLE payments_to_suppliers_2019_2020 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "card_transaction" VARCHAR,
  "transaction_no" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2021/2022

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2021_2022

930.96 KB
61591 rows
13 columns


CREATE TABLE payments_to_suppliers_2021_2022 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "card_transaction" VARCHAR,
  "transaction_no" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2023/2024

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2023_2024

911.09 KB
61708 rows
13 columns


CREATE TABLE payments_to_suppliers_2023_2024 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "transaction_no" VARCHAR,
  "card_transaction" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2024/2025

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2024_2025

856.28 KB
63108 rows
13 columns


CREATE TABLE payments_to_suppliers_2024_2025 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "payment_date" VARCHAR,
  "transaction_no" VARCHAR,
  "card_transaction" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);

Payments To Suppliers - 2017/2018

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2017_2018

673.95 KB
58736 rows
10 columns


CREATE TABLE payments_to_suppliers_2017_2018 (
  "organisationname" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "expensecategory" VARCHAR,
  "supplier_beneficiary" VARCHAR,
  "supplierid" VARCHAR,
  "paymentdate" TIMESTAMP,
  "transactionreference" VARCHAR,
  "netamount_excvat" DOUBLE,
  "cardtransaction" VARCHAR
);

Payments To Suppliers - 2014/2015

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2014_2015

1.15 MB
146703 rows
8 columns


CREATE TABLE payments_to_suppliers_2014_2015 (
  "bodyname" VARCHAR,
  "organisationunit" VARCHAR,
  "expensecategory" VARCHAR,
  "expenditurecode" DOUBLE,
  "date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "amount" DOUBLE,
  "suppliername" VARCHAR
);

Payments To Suppliers - 2013/2014

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2013_2014

1.27 MB
164366 rows
8 columns


CREATE TABLE payments_to_suppliers_2013_2014 (
  "bodyname" VARCHAR,
  "organisationunit" VARCHAR,
  "expensecategory" VARCHAR,
  "expenditurecode" DOUBLE,
  "date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "amount" DOUBLE,
  "suppliername" VARCHAR
);

Payments To Suppliers - 2012/2013

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2012_2013

742.96 KB
88727 rows
8 columns


CREATE TABLE payments_to_suppliers_2012_2013 (
  "bodyname" VARCHAR,
  "organisationunit" VARCHAR,
  "expensecategory" VARCHAR,
  "expenditurecode" DOUBLE,
  "date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "amount" DOUBLE,
  "suppliername" VARCHAR
);

Payments To Suppliers - 2018/2019

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2018_2019

975.88 KB
66475 rows
14 columns


CREATE TABLE payments_to_suppliers_2018_2019 (
  "organisation_name" VARCHAR,
  "directorate" VARCHAR,
  "department" VARCHAR,
  "service_plan" VARCHAR,
  "creditor_name" VARCHAR,
  "gl_date" TIMESTAMP,
  "payment_date" TIMESTAMP,
  "card_transaction" VARCHAR,
  "transaction_no" VARCHAR,
  "net_amount" DOUBLE,
  "irrecoverable_vat" VARCHAR,
  "subjective_group" VARCHAR,
  "subjective_subgroup" VARCHAR,
  "subjective_detail" VARCHAR
);