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

All Payments To Suppliers - 2016/2017

@ukgov.all_payments_to_suppliers.all_payments_to_suppliers_2016_2017

1.24 MB
141,106 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 - 2011/2012

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2011_2012

410.95 kB
37,906 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 - 2012/2013

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2012_2013

760.79 kB
88,727 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 - 2013/2014

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2013_2014

1.33 MB
164,366 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 - 2014/2015

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2014_2015

1.2 MB
146,703 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 - 2015/2016

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2015_2016

1.13 MB
146,008 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
);

Payments To Suppliers - 2017/2018

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2017_2018

690.12 kB
58,736 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 - 2018/2019

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2018_2019

999.3 kB
66,475 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
);

Payments To Suppliers - 2019/2020

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2019_2020

940.78 kB
61,389 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 - 2020/2021

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2020_2021

890.97 kB
56,076 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 - 2021/2022

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2021_2022

953.31 kB
61,591 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 - 2022/2023

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2022_2023

912.62 kB
58,188 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 - 2023/2024

@ukgov.all_payments_to_suppliers.payments_to_suppliers_2023_2024

932.95 kB
61,708 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

876.83 kB
63,108 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
);