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 Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Telecoms - Land Line Rental	Production Services	British Telecom Plc (BT)	99772291	12551.36	SR11199494 REGULAR CHARGES 1 JUL 22-31 JUL 22	S98 1BT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99774618	-109.9	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Sundry Expenditure	D&I Management	Unspecified	99774618	109.9	GPC_Miscellaneous GPC Expenditure	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Risk, Information & Security Compliance	Risk Evolves Ltd	99776314	1224	Consultancy Services	CV31 1XT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Risk, Information & Security Compliance	Risk Evolves Ltd	99776314	816	Consultancy Services	CV31 1XT
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Contract Staff	Production Services	Alexander Mann Solutions Ltd	99776499	3465.3	Recruitment Services	EC2N 3AQ
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Parking Tolls Congestion Charges	D&I Digital	Unspecified	99776585	14	Parking, Tolls, Congestion Charge	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Accommodation	Contact Centres	Unspecified	99776586	105	Accommodation - Hotels Elsewhere Actuals	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Subsistence	Contact Centres	Unspecified	99776586	34.49	Evening Meal (Actuals)	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Mon Aug 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	T&S - Subsistence	Contact Centres	Unspecified	99776586	7.8	Lunch (Actuals)	HOME


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