Purchase Orders Over £5000 - April To June 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2019

37.44 KB
780 rows
14 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2019 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR,
  "unnamed_13" VARCHAR
);

Purchase Orders Over £5000 - April To June 2020

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2020

33.1 KB
687 rows
13 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2020 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - April To June 2021

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2021

38.02 KB
872 rows
13 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2021 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - April To June 2022

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2022

41.1 KB
907 rows
13 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2022 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "n__net_order_value_over_5000_00_line_item_value_shown_here" VARCHAR,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - April To June 2023

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2023

40.27 KB
883 rows
13 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2023 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - April To June 2024

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2024

36.56 KB
725 rows
13 columns


CREATE TABLE purchase_orders_over_5000_april_to_june_2024 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2019

28.64 KB
505 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2019 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" DOUBLE,
  "supplier_id" DOUBLE,
  "supplier_name" VARCHAR,
  "pro_class" DOUBLE,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" DOUBLE,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2020

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2020

32.33 KB
543 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2020 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2021

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2021

30.31 KB
569 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2021 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2022

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2022

31.43 KB
609 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2022 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2023

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2023

33.78 KB
573 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2023 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" DOUBLE,
  "supplier_id" DOUBLE,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "n__net_order_value_over_5000_00_line_item_value_shown_here" VARCHAR,
  "gl_code" DOUBLE,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2024

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2024

32.94 KB
557 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2024 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - January To March 2025

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_january_to_march_2025

32.67 KB
596 rows
13 columns


CREATE TABLE purchase_orders_over_5000_january_to_march_2025 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To Sept 2018

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_sept_2018

32.24 KB
454 rows
17 columns


CREATE TABLE purchase_orders_over_5000_july_to_sept_2018 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

Purchase Orders Over £5000 - July To September 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2019

29.23 KB
780 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2019 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" DOUBLE,
  "supplier_id" DOUBLE,
  "supplier_name" VARCHAR,
  "pro_class" DOUBLE,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" DOUBLE,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To September 2020

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2020

30.28 KB
621 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2020 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To September 2021

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2021

27.5 KB
436 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2021 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To September 2022

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2022

32.91 KB
735 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2022 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" DOUBLE,
  "supplier_id" DOUBLE,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "n__net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" DOUBLE,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To September 2023

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2023

30.94 KB
550 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2023 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - July To September 2024

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2024

30.45 KB
518 rows
13 columns


CREATE TABLE purchase_orders_over_5000_july_to_september_2024 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - October To December 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2019

28.4 KB
488 rows
13 columns


CREATE TABLE purchase_orders_over_5000_october_to_december_2019 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - October To December 2020

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2020

27.56 KB
482 rows
13 columns


CREATE TABLE purchase_orders_over_5000_october_to_december_2020 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - October To December 2021

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2021

29.91 KB
574 rows
13 columns


CREATE TABLE purchase_orders_over_5000_october_to_december_2021 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" VARCHAR,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - October To December 2022

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2022

30.12 KB
514 rows
13 columns


CREATE TABLE purchase_orders_over_5000_october_to_december_2022 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000 - October To December 2023

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2023

28.87 KB
459 rows
13 columns


CREATE TABLE purchase_orders_over_5000_october_to_december_2023 (
  "document_date" TIMESTAMP,
  "purchase_order_no" VARCHAR,
  "line_item_no" BIGINT,
  "supplier_id" BIGINT,
  "supplier_name" VARCHAR,
  "pro_class" BIGINT,
  "pro_class_description" VARCHAR,
  "description_of_goods_purpose_of_expenditure_look_up" VARCHAR,
  "service_department_sap_hierarchy_position" VARCHAR,
  "expense_area_cost_centre_desc" VARCHAR,
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE,
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Purchase Orders Over £5000

About this Dataset