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	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	FlyForm Ltd	99589861	4999.2	Computing Software	CF10 3AG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Other Staff Benefits	People	Amazon EU SARL	99589910	175	ZZ-Employee Benefits	EC2A 2FA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99591754	2919.31	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Corporate HR	Alexander Mann Solutions Ltd	99592714	3024.29	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99592718	6886.15	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	Jisc Services Ltd	99594718	540	Managed AWS Consumption	OX11 0SG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	Training Services	Unspecified	99594749	89.99	Home-working Equipment	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	D&I Operations	Unspecified	99594751	34.49	Miscellaneous (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed May 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	SIAM	JAM Software GmbH	99506789	328.3	Computing Software	54296 - EUR
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed May 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Onefix Recruitment Ltd	99565715	360	Recruitment Services	PO3 5EJ


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