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	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	SHARP	Oracle Corporation UK Ltd	100021667	2432.26	Computer Consumables	BH7 7DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100024795	1173	bandwidth per port	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	100025176	-40.87	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Sundry Expenditure	D&I Management	Unspecified	100025176	40.87	GPC_Miscellaneous GPC Expenditure	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Risk, Information & Security Compliance	Unspecified	100025437	180	Professional Subscriptions (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Corporate HR	Everwell Occupational Health Ltd	100026322	810	Professional Services	CW11 3AE
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Sep 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	HR Ops	Hays Specialist Recruitment Ltd	100021481	2105.68	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Sep 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Risk, Information & Security Compliance	Unspecified	100022232	20	Vehicle Hire/Rental/Fuel (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Sep 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Public Transport	Risk, Information & Security Compliance	Unspecified	100022233	59.2	Public Transport - Train (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Sep 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Risk, Information & Security Compliance	Unspecified	100022233	15	Vehicle Hire/Rental/Fuel (Actuals)	HOME


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