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 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Production Services	Unspecified	99107232	12.18	GPC_Professional Services	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99107232	-12.18	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99107233	-19	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Sundry Expenditure	Production Services	Unspecified	99107233	19	GPC_Miscellaneous GPC Expenditure	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Consultancy Services	Production Services	Unspecified	99107234	24.33	GPC_Professional Services	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99107234	-24.33	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99109293	-144.48	Unspecified	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Health & Safety (inc. Medicals & Opticians)	Executive Function	Unspecified	99109293	144.48	GPC_Health & Safety	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Computer Software	Production Services	Unspecified	99109548	310.32	GPC_Computer Software	HOME
Department for Business, Innovation and Skills	UK Shared Business Services Ltd	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GPC Clearing - SSC	Balance Sheet	Unspecified	99109548	-310.32	Unspecified	HOME


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