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 Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	ERP Support	Oracle Corporation UK Ltd	99323278	111661.67	BPO License Core Service Bundle, Image Capture Bundle and Grants Bundle - (June 2021-Nov 2021)	BH7 7DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tax Advice	Corporate Finance	KPMG LLP	99323876	1200	Professional Services	WD17 1DE
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tax Advice	Corporate Finance	KPMG LLP	99323881	2208	Professional Services	WD17 1DE
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	Production Services	Unspecified	99323961	103.5	Mileage - Car (excl Home to Office)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Conferences & Seminars	Accounting	Unspecified	99323962	3000	Conference/Course Fees (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Accounting	Unspecified	99323964	116	Professional Subscriptions (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Parking Tolls Congestion Charges	Service Improvement and Assurance	Unspecified	99323965	10	Parking, Tolls, Congestion Charge	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	Production Services	IB Boost Ltd	99102281	7238.95	Computing Software	EC2A 4NE
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Telecoms - Maintenance & Repairs	Production Services	SCB Global Ltd	99271600	1228.56	Telephony	E14 5AA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Data Storage & Recovery	Accounting	Restore plc	99274491	910.8	Computing Services	RH1 5DY


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