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 Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99845980	2740.74	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Subsistence	Executive Function	Unspecified	99847971	280	Lunch (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Other Staff Benefits	People	Amazon EU SARL	99848281	525	ZZ-Employee Benefits	EC2A 2FA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Fri Dec 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Production Services	Hays Specialist Recruitment Ltd	99848084	6819.88	Recruitment Services	KT3 4QF
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software Licences	Production Services	Bottomline Technologies Ltd	99817218	48050.63	Computer Consumables	RG7 4SA
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computing Consumables	D&I Management	Unspecified	99847715	151.25	GPC_Computer Consumables	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99847715	-151.25	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computing Consumables	D&I Management	Unspecified	99847716	160.74	GPC_Computer Consumables	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99847716	-160.74	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Recruitment Costs	Corporate HR	Everwell Occupational Health Ltd	99848142	378	Professional Services	CW11 3AE


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