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	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	Production Services	Deloitte LLP	100125426	830.4	Computer Consumables	EC4A 3HQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Reconome Technologies Ltd	100127124	1500.6	Computing Hardware	E11 4RA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	Executive Function	Pricewaterhouse Coopers LLP	100128088	6636	Professional Services	WC2N 6RH
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	100128169	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Telecoms - Maintenance & Repairs	Production Services	SCB Global Ltd	100128266	202.48	Computer Consumables	E14 5AA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Health & Safety (inc. Medicals & Opticians)	Accounting	Unspecified	100129270	80	Medical Fees & Vaccinations (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	D&I Operations	Unspecified	100129271	76.5	Mileage - Car (excl Home to Office)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	UK - Professional Memberships & Subscriptions	Risk, Information & Security Compliance	Unspecified	100129273	40	Professional Subscriptions (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Feb 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Other Charges	Payroll	Unspecified	100124225	80	Miscellaneous (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Feb 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Precision Resource Group Ltd T/A iO	100128749	3000	Recruitment Services	BS1 2NH


CREATE TABLE february_2024 (
  "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
);