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 May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Network Improvements	Alexander Mann Solutions Ltd	99950090	3780.36	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99950091	1755.4	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	SHARP	Alexander Mann Solutions Ltd	99950092	3387.66	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Project Office	Alexander Mann Solutions Ltd	99950093	1601.42	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	99950094	3464.64	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	99950094	692.93	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	BOE Upgrade	Alexander Mann Solutions Ltd	99950095	2438.05	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	VAT Input Tax Control (for UK VAT)	Balance Sheet	Alexander Mann Solutions Ltd	99950095	487.61	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Grants CRs	Alexander Mann Solutions Ltd	99950097	3465.3	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Grants CRs	Alexander Mann Solutions Ltd	99950099	3465.3	Recruitment Services	EC2N 3AQ


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