Baselight

All Payments To Suppliers

City of York Council

@ukgov.all_payments_to_suppliers

All Payments To Suppliers - 2016/2017
@ukgov.all_payments_to_suppliers.all_payments_to_suppliers_2016_2017

All payments for financial year 2016/2017

  • 1.18 MB
  • 141106 rows
  • 10 columns
organisationname

OrganisationName

directorate

Directorate

department

Department

expensecategory

ExpenseCategory

supplier_beneficiary

Supplier Beneficiary

supplierid

SupplierID

paymentdate

PaymentDate

transactionreference

TransactionReference

netamount_excvat

NetAmount ExcVAT

cardtransaction

CardTransaction

City of York CouncilAdult Social ServicesAdult Commissioning ProvisionExternal Temporary StaffPrestige Nursing Ltd585428Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR000031105489.05
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR000031106292.31
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR0000311062337.42
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110622276.07
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110621500.92
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110621232.46
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR000031106239.05
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110621649.78
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110623162.01
City of York CouncilAdult Social ServicesAdult Commissioning ProvisionGasBritish Gas Business518149Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)CR00003110622000.92

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
);

Share link

Anyone who has the link will be able to view this.