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 Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	IT Cloud Services	Production Services	FlyForm Ltd	99871358	4999.2	Computing Software	CF10 3AG
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Hardware/Software Maintenance	Production Services	Softcat plc	99872247	17266.7	Computing Software	SL7 1LW
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	SIAM	Softcat plc	99872248	2091.74	Computing Software	SL7 1LW
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Agency Staff	ROE Application Upgrade	Alexander Mann Solutions Ltd	99871465	4090.44	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	99872327	3387.66	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	People	Alexander Mann Solutions Ltd	99872333	7696.44	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Conferences & Seminars	Contact Centres	Calder Conference Ltd	99872438	1968	Conference & Venues	LS16 6RF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	Accounting	Unspecified	99872503	106.2	Mileage - Car (excl Home to Office)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Mileage	D&I Infrastructure & Network Services	Unspecified	99872504	73.5	Mileage - Car (excl Home to Office)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Subsistence	D&I Infrastructure & Network Services	Unspecified	99872504	8.05	Lunch (Actuals)	HOME


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