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 Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 2	Hays Specialist Recruitment Ltd	99928492	2179.01	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Dell Corporation Limited	99964518	30000	Computing Hardware	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 2	Hays Specialist Recruitment Ltd	99964865	2907.1	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 2	Hays Specialist Recruitment Ltd	99964867	3132.32	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 2	Hays Specialist Recruitment Ltd	99964869	2179.01	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Contact Centres	Enterprise Rent-A-Car UK Ltd	99966577	177.53	Car Hire	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Contact Centres	Enterprise Rent-A-Car UK Ltd	99966577	35.51	SR 11697000 CAR HIRE	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Finance Services	Enterprise Rent-A-Car UK Ltd	99966577	28.22	SR 11697000 CAR HIRE	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Finance Services	Enterprise Rent-A-Car UK Ltd	99966577	141.08	Car Hire	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	99966652	3387.66	Recruitment Services	EC2N 3AQ


CREATE TABLE june_2023 (
  "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
);