UKSBS Monthly Spend
UK Shared Business Services
@ukgov.uk_sbs_monthly_spend
UK Shared Business Services
@ukgov.uk_sbs_monthly_spend
CREATE TABLE may_2024 (
"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
);
CREATE TABLE november_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
);
CREATE TABLE november_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
);
CREATE TABLE october_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
);
CREATE TABLE october_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
);
CREATE TABLE september_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
);
CREATE TABLE september_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
);
Anyone who has the link will be able to view this.