Rushmoor Procurement Card Spend
Rushmoor Borough Council
@ukgov.rushmoor_procurement_card_spend
Rushmoor Borough Council
@ukgov.rushmoor_procurement_card_spend
CREATE TABLE procurement_card_spend_april_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_april_2020 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_april_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" BIGINT,
"cost_centre" BIGINT,
"detail_code" VARCHAR,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_august_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_august_2020 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_august_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_december_2018 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_december_2019 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);
CREATE TABLE procurement_card_spend_december_2020 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_february_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_february_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);
CREATE TABLE procurement_card_spend_february_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_january_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_january_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);
CREATE TABLE procurement_card_spend_january_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_july_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_july_2020 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_july_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_june_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_june_2020 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_june_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_march_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_march_2020 (
"organisation" VARCHAR,
"service_area" VARCHAR,
"cost_centre" BIGINT,
"expense_type" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_no" BIGINT,
"amount" DOUBLE,
"capital_revenue" VARCHAR,
"supplier_name" VARCHAR,
"supplier_id" VARCHAR
);
CREATE TABLE procurement_card_spend_march_2021 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
CREATE TABLE procurement_card_spend_may_2019 (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"directorate_service" VARCHAR,
"cost_centre" BIGINT,
"detail_code" BIGINT,
"service_category_label" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" TIMESTAMP,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"purpose_of_spend" VARCHAR,
"procurement_classification" VARCHAR,
"card_transaction" VARCHAR
);
Anyone who has the link will be able to view this.