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 Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	100064080	1155.1	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	100064080	231.02	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Legal & Professional Services	Project Office	Pricewaterhouse Coopers LLP	100065992	143241.6	Professional Services	WC2N 6RH
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Proventeq Limited	100066696	69270	Computer Consumables	RG6 6BU
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	100066788	2887.75	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	100066788	577.55	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100067830	900	Computing Hardware	SMARTFORM
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100067830	6	Computing Hardware	SMARTFORM
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	3rd party IT Services	Production Services	Crown Hosting Data Centres Ltd	100068759	66	Computing Software	SN13 9GB
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Nov 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Health & Safety (inc. Medicals & Opticians)	Finance Operations 1	Unspecified	100069112	13	Medical Fees & Vaccinations (Actuals)	HOME


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