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 Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	ERP Support	Oracle Corporation UK Ltd	99776778	30000.13	PaaS and IaaS Universal Credits - Aug 22 - Oct 22	RG6 1RA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	Firebrand Training Ltd	99812631	6240	Training	WC1N 3AX
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	People	Onefix Recruitment Ltd	99828341	360	Recruitment Services	PO3 5EJ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	FlyForm Ltd	99829614	4999.2	Computing Software	CF10 3AG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99829660	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99829662	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99829664	504	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	99829665	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Health & Safety (inc. Medicals & Opticians)	Resourcing	Unspecified	99829771	11	Medical Fees & Vaccinations (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Subsistence	D&I Infrastructure & Network Services	Unspecified	99829772	44.08	Evening Meal (Actuals)	HOME


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