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	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Rates	Facilities	UKRI - Engineering & Physical Sciences Research Council	100003540	522222.34	ZZ-Rent & Rates	INTERCO
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Hays Specialist Recruitment Ltd	100009927	14371.81	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Hays Specialist Recruitment Ltd	100023092	11634.32	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Hays Specialist Recruitment Ltd	100047749	15056.18	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Production Services	Skillsbay Ltd	100049107	9900	Recruitment Services	SW6 3JD
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	Accounting	Unspecified	100049643	106.2	Mileage - Car (excl Home to Office)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Public Transport	Risk, Information & Security Compliance	Unspecified	100049644	6.4	Public Transport - Bus (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Staff Training	HRSD Recoverables	ASK Europe PLC	100049973	840	Training	MK43 0BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100050005	6	Computing Hardware	SMARTFORM
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Oct 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Hardware	Production Services	Probrand Ltd	100050005	9969.6	Computing Hardware	SMARTFORM


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