Baselight

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

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_october_to_december_2024
  • 29.8 KB
  • 517 rows
  • 13 columns
Loading...

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,
  "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 - Oct To Dec 2018

@ukgov.stockport_council_purchase_orders_over_5000.purchase_orders_over_5000_oct_to_dec_2018
  • 30.95 KB
  • 487 rows
  • 17 columns
Loading...

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,
  "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
);

Share link

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