Baselight
Sign In

Purchase Orders Over £5000

Stockport Metropolitan Borough Council

@ukgov.stockport_council_purchase_orders_over_5000

Loading...
Loading...

About this Dataset

Purchase Orders Over £5000

Purchase orders over £5000 by Stockport Council. Whilst all transactions are published, certain pieces of personal information within those transactions will redacted, i.e. replaced with general terms, to provide protection under the Data Protection Act.
Publisher name: Stockport Metropolitan Borough Council
Last updated: 2025-04-03T04:00:20Z

Tables

Purchase Orders Over £5000 - April To June 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2019
  • 38.34 kB
  • 780 rows
  • 14 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

Purchase Orders Over £5000 - April To June 2020

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_april_to_june_2020
  • 33.89 kB
  • 687 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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.93 kB
  • 872 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 42.09 kB
  • 907 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "n__net_order_value_over_5000_00_line_item_value_shown_here" VARCHAR  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 41.24 kB
  • 883 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 37.44 kB
  • 725 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 29.33 kB
  • 505 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 33.11 kB
  • 543 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 31.03 kB
  • 569 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 32.18 kB
  • 609 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 34.59 kB
  • 573 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "n__net_order_value_over_5000_00_line_item_value_shown_here" VARCHAR  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 33.73 kB
  • 557 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 33.45 kB
  • 596 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 33.01 kB
  • 454 rows
  • 17 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

Purchase Orders Over £5000 - July To September 2019

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_july_to_september_2019
  • 29.93 kB
  • 780 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 31 kB
  • 621 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 28.16 kB
  • 436 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 33.7 kB
  • 735 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "n__net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 31.68 kB
  • 550 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 31.18 kB
  • 518 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 29.08 kB
  • 488 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 28.22 kB
  • 482 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 30.63 kB
  • 574 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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.84 kB
  • 514 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "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
  • 29.56 kB
  • 459 rows
  • 13 columns
Loading... 
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  -- Description Of Goods (Purpose Of Expenditure Look Up),
  "service_department_sap_hierarchy_position" VARCHAR  -- Service/Department (SAP Hierarchy Position),
  "expense_area_cost_centre_desc" VARCHAR  -- Expense Area (cost Centre Desc),
  "net_order_value_over_5000_00_line_item_value_shown_here" DOUBLE  -- Net Order Value Over Ł5000.00 (line Item Value Shown Here),
  "gl_code" BIGINT,
  "cost_centre_wbs" VARCHAR
);

Share link

Anyone who has the link will be able to view this.