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	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Aspire Leadership Ltd	99981892	630	Training	EC1N 7SU
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Aspire Leadership Ltd	99985751	630	Training	EC1N 7SU
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 1	Hays Specialist Recruitment Ltd	99990817	49.02	AUTH RECEIVED - OVERBILL	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 1	Hays Specialist Recruitment Ltd	99990817	9.8	CONSOLIDATED INVOICE - 01/03/23 TO W/E 31/03/23	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	Finance Operations 1	Hays Specialist Recruitment Ltd	99990817	3534.45	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	99990856	1173	bandwidth per port	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Avado Learning Ltd	99992013	2699.1	Training	W12 7RZ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	99992746	942	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	99992750	3090.76	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	99992772	3339.65	Recruitment Services	KT3 4QF


CREATE TABLE july_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
);