Baselight
Sign In

UKSBS Monthly Spend

UK Shared Business Services

@ukgov.uk_sbs_monthly_spend

February 2022
@ukgov.uk_sbs_monthly_spend.february_2022

  • 17.38 KB
  • 321 rows
  • 10 columns
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 SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Consultancy ServicesInterfaces & API MgmtSoftware AG (UK) Ltd9909534219250.59Computer ConsumablesDE24 8BY
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Consultancy ServicesInterfaces & API MgmtSoftware AG (UK) Ltd9912194510911.23Computer ConsumablesDE24 8BY
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Computer HardwareProduction ServicesPremier Farnell UK Ltd T/A Farnell Onecall99182634165.06Audio VisualsSWAREHOUSEONLY
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Computer HardwareProduction ServicesPremier Farnell UK Ltd T/A Farnell Onecall9919107170.74Audio VisualsSWAREHOUSEONLY
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Computer Software LicencesProduction ServicesAcademia Ltd9922343188805.94Computing SoftwareEN3 7XH
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Contract StaffCorporate CommercialAlexander Mann Solutions Ltd992264658824.37Recruitment ServicesEC2N 3AQ
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Computer Software LicencesProcurement Policy & StrategySelcom Systems Ltd9922668242912Computing SoftwareYO26 6GA
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Staff TrainingHRSD RecoverablesProvek Ltd992374151620TrainingRG19 4LW
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Staff TrainingHRSD RecoverablesASK Europe PLC99239436936TrainingMK43 0BT
Department for Business, Innovation and SkillsUK Shared Business Services LtdTue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Staff TrainingHRSD RecoverablesASK Europe PLC99239437780TrainingMK43 0BT

CREATE TABLE february_2022 (
  "department" VARCHAR,
  "entity" VARCHAR,
  "date_of_payment" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);