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 Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT / Computing Support Services	UKRI Taleo	Oracle Corporation UK Ltd	99323675	3253.58	Technical Support (Professional Services) for Oracle Taleo System. This Professional Services is required to build a new Candidate Selection Workflow.	RG6 1RA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT / Computing Support Services	UKRI Taleo	Oracle Corporation UK Ltd	99325024	138.46	Technical Support (Professional Services) for Oracle Taleo System. This Professional Services is required to build a new Candidate Selection Workflow.	BH7 7DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT / Computing Support Services	UKRI Taleo	Oracle Corporation UK Ltd	99349848	553.81	Technical Support (Professional Services) for Oracle Taleo System. This Professional Services is required to build a new Candidate Selection Workflow.	RG6 1RA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT / Computing Support Services	UKRI Taleo	Oracle Corporation UK Ltd	99358976	1799.88	Technical Support (Professional Services) for Oracle Taleo System. This Professional Services is required to build a new Candidate Selection Workflow.	BH7 7DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	D&I Operations	Premier Farnell UK Ltd T/A Farnell Onecall	99372008	200.94	Audio Visuals	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	FlyForm Ltd	99382714	4999.2	Computing Software	CF10 3AG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	D&I Operations	Premier Farnell UK Ltd T/A Farnell Onecall	99382899	32.76	Audio Visuals	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	D&I Operations	Premier Farnell UK Ltd T/A Farnell Onecall	99382900	13.1	Audio Visuals	SWAREHOUSEONLY
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Printing & Stationery	Production Services	Konica Minolta Business Solutions (UK) Ltd	99382925	956.28	Computing Hardware	SS14 3AR
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Printing & Stationery	Production Services	Konica Minolta Business Solutions (UK) Ltd	99382925	22110.84	Audio Visuals	SS14 3AR


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