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	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	Production Services	Groupe Sharegate Inc.	100188203	4846.6	Computing Software	H3K 1G6 -USD
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Agenda Resource Management Ltd	100188321	148.91	Professional Services	HU12 8YJ
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Freight Charges	Corporate Finance	Edenred Childcare Vouchers Limited	100188739	1201.75	Invoice to offset credit see v/n 1482908	SW1V 2RS
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	Corporate HR	Dawson Books Ltd	100188742	2.75	GB VAT - GB VAT	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	Corporate HR	Dawson Books Ltd	100188742	550	Unspecified	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Books Professional Journals & Guides	Major Projects	Dawson Books Ltd	100188743	23.13	Unspecified	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Books Professional Journals & Guides	Major Projects	Dawson Books Ltd	100188744	29.37	Unspecified	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Books Professional Journals & Guides	Major Projects	Dawson Books Ltd	100188748	23.13	Unspecified	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	Corporate HR	Dawson Books Ltd	100188750	80.1	Unspecified	NN10 6DB
Department for Science, Innovation and Technology	UK Shared Business Services Ltd	Wed May 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Accommodation	Corporate Finance	Green Park Interim & Executive Ltd	100190756	4968	Invoice for credit note see v/n 1016414	TW13 7QD


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