Purchase Orders Over £5000
Stockport Metropolitan Borough Council
@ukgov.stockport_council_purchase_orders_over_5000
Stockport Metropolitan Borough Council
@ukgov.stockport_council_purchase_orders_over_5000
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
);
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
);
Anyone who has the link will be able to view this.