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 Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	100173441	-1186.38	Unspecified	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	HR Training & Specialists	Unspecified	100173441	1186.38	Home-working Equipment	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	100173442	-1386	Unspecified	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	Facilities	Unspecified	100173442	1386	Home-working Equipment	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	100173443	-309.98	Unspecified	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	HR Training & Specialists	Unspecified	100173443	309.98	Home-working Equipment	HOME
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Apr 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	People	Pablo Raybould	100123312	4.15	4080026192 OVERBILL	B80 7PT
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Apr 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	People	Pablo Raybould	100123312	460.3	Training	B80 7PT
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Apr 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	100124991	-5754	Professional Services General Consultancy - Year 1	BS1 6NB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Tue Apr 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	100129432	26270.83	Computing Software	BS1 6NB


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