About this Dataset

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

Tables

Procurement Card Spend May 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_may_2020

13.82 KB
75 rows
13 columns


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

Procurement Card Spend May 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_may_2021

13.64 KB
102 rows
13 columns


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

Procurement Card Spend November 2018

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2018

18.02 KB
183 rows
13 columns


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

Procurement Card Spend November 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2019

20.12 KB
281 rows
13 columns


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

Procurement Card Spend November 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2020

12.29 KB
35 rows
13 columns


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

Procurement Card Spend November 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_november_2021

15.58 KB
152 rows
13 columns


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

Procurement Card Spend October 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2019

16.03 KB
151 rows
13 columns


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

Procurement Card Spend October 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2020

12.42 KB
46 rows
13 columns


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

Procurement Card Spend October 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_october_2021

13.82 KB
88 rows
13 columns


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

Procurement Card Spend September 2019

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2019

17.11 KB
165 rows
13 columns


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

Procurement Card Spend September 2020

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2020

12.7 KB
53 rows
13 columns


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

Procurement Card Spend September 2021

@ukgov.rushmoor_procurement_card_spend.procurement_card_spend_september_2021

17.31 KB
174 rows
13 columns


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

Rushmoor Procurement Card Spend

@ukgov.rushmoor_procurement_card_spend.rushmoor_procurement_card_spend

16.36 KB
122 rows
17 columns


CREATE TABLE rushmoor_procurement_card_spend (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "directorate_service" VARCHAR,
  "cost_centre" DOUBLE,
  "detail_code" DOUBLE,
  "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,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);