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 - October To December 2024

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2024

30.51 kB
517 rows
13 columns

CREATE TABLE purchase_orders_over_5000_october_to_december_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 - Oct To Dec 2018

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_oct_to_dec_2018

31.7 kB
487 rows
17 columns

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