UKSBS Monthly Spend

department Department	entity Entity	date_of_payment Date Of Payment	expense_type Expense Type	expense_area Expense Area	supplier Supplier	transaction_number Transaction Number	amount Amount	description Description	supplier_postcode Supplier Postcode
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Chartered Institute of Personnel and Development (CIPD)	99784995	897.6	Training	SW19 1JQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Procurement Policy & Strategy	Dun & Bradstreet Ltd	99789537	6146.4	Professional Memberships	W2 1AF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	FlyForm Ltd	99789796	4999.2	Computing Software	CF10 3AG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Finance Services	Enterprise Rent-A-Car UK Ltd	99790732	119.49	21/8/22-24/8/22	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Finance Services	Enterprise Rent-A-Car UK Ltd	99790732	23.9	SR11256254 / SR11256260 MONTHLY CAR RENTAL	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Operational Excellence	Enterprise Rent-A-Car UK Ltd	99790732	141.94	16/8/22-19/8/22	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Operational Excellence	Enterprise Rent-A-Car UK Ltd	99790732	28.39	SR11256254 / SR11256260 MONTHLY CAR RENTAL	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99790768	540	NREN Fee June 2022 - Year 1	OX11 0SG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Health & Safety (inc. Medicals & Opticians)	Facilities	AM Health & Safety Ltd	99790881	63	Professional Services	SN5 6BD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Parking Tolls Congestion Charges	D&I Digital, Data & Analytics	Unspecified	99791858	14	Parking, Tolls, Congestion Charge	HOME


CREATE TABLE september_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" DOUBLE,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);