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	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	SHARP	Oracle Corporation UK Ltd	99895029	53655.66	Computer Consumables	BH7 7DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	3779.35	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	1121.35	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	1868.91	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	747.56	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	2242.69	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Production Services	PLURALSIGHT LLC	99901375	747.56	Computer Consumables	60055-9719-USD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Executive Function	Enterprise Rent-A-Car UK Ltd	99904822	172.06		GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Vehicle Hire	Executive Function	Enterprise Rent-A-Car UK Ltd	99904822	34.41	SR11541844 - CarHire	GL2 5DA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Mar 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Procurement Policy & Strategy	Hays Specialist Recruitment Ltd	99904911	1201.75	Recruitment Services	KT3 4QF


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