Rushmoor Procurement Card Spend
Rushmoor Borough Council
@ukgov.rushmoor_procurement_card_spend
Rushmoor Borough Council
@ukgov.rushmoor_procurement_card_spend
This dataset is a list of the spend by Rushmoor Borough Council on procurement cards. Issued following the transparency code 2014, it follows the recommended schema issued by the LGA. PLEASE NOTE: This is currently a draft release and is incomplete, there will be regular updates, so please check back frequently. Please contact us if you have any specific queries
Publisher name: Rushmoor Borough Council
Last updated: 2024-06-14T04:03:03Z
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 -- Transaction No.,
"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 -- Transaction No.,
"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 -- Transaction No.,
"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 -- Transaction No.,
"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.