About this Dataset

Purchase Order Transactions

A Purchase Order is a document sent by the Council to a supplier indicating types, quantities, and agreed prices for products or services. Acceptance of a purchase order forms a contract between the parties. Data has been excluded or redacted from the publication in line with guidance issued by the Local Government Association. There are occasions when data items have been removed (redacted) for the following reasons: - REDACTED PERSONAL DATA where the data would identify an individual in the context of their private life. - REDACTED COMMERCIAL CONFIDENTIALITY where the release of information could prejudice the conduct of business or was provided in confidence. - REDACTED OTHER where revealing information would compromise security, health & safety or crime prevention. The Council manage 4 distinct processes – 1. Tendering, 2. Awarding a Contract 3. Ordering Goods and Services via a Purchase Order as required 4. Paying an Invoice or awarding a Grant. This means that the same or similar information may be duplicated over datasets published by the Council. An example of this process would be a contract being advertised via an Invitation to Tender, awarded to a stationery supplier, a purchase order will then be raised to order 200 pens, the goods will be delivered and then an invoice submitted to the Council for payment. This information will be contained in the Invitation to Tender declaration, the Contract Register, Purchase Order Information and the Spend Data. It is likely that the values contained in the Invitation to Tender, Contract Register, Purchase Order data and Spend Data will not reconcile. This is because the timeframe whereby each item of data is captured will be different and actual spend varies over time. For example, the Invitation to Tender will be the estimated maximum value for the full contract term at the point the contract is advertised, the Contract Register will be the estimated maximum contract value over the full term, Purchase Orders may reflect requirements over a much shorter time or a single “call off” and the spend declaration reflects when we pay for the goods and services. If you have queries with any of the payments listed in the data, please email foi@rochdale.gov.uk specifying the name of the file you are referring to, the transaction reference or invoice or contract number, the amount and what additional information you require.
Publisher name: Rochdale Borough Council
Last updated: 2024-06-14T04:03:01Z

Tables

Table 1

@ukgov.purchase_order_transactions.table_1

19.77 KB
505 rows
7 columns


CREATE TABLE table_1 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 10

@ukgov.purchase_order_transactions.table_10

20.16 KB
470 rows
7 columns


CREATE TABLE table_10 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 11

@ukgov.purchase_order_transactions.table_11

20.58 KB
494 rows
7 columns


CREATE TABLE table_11 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 12

@ukgov.purchase_order_transactions.table_12

19.45 KB
479 rows
7 columns


CREATE TABLE table_12 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 13

@ukgov.purchase_order_transactions.table_13

18.57 KB
433 rows
7 columns


CREATE TABLE table_13 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 14

@ukgov.purchase_order_transactions.table_14

18.43 KB
413 rows
7 columns


CREATE TABLE table_14 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 15

@ukgov.purchase_order_transactions.table_15

19.45 KB
479 rows
7 columns


CREATE TABLE table_15 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 16

@ukgov.purchase_order_transactions.table_16

17.03 KB
344 rows
7 columns


CREATE TABLE table_16 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 17

@ukgov.purchase_order_transactions.table_17

18.43 KB
426 rows
7 columns


CREATE TABLE table_17 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 18

@ukgov.purchase_order_transactions.table_18

24.71 KB
697 rows
7 columns


CREATE TABLE table_18 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 19

@ukgov.purchase_order_transactions.table_19

19.5 KB
481 rows
7 columns


CREATE TABLE table_19 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 2

@ukgov.purchase_order_transactions.table_2

18.41 KB
434 rows
7 columns


CREATE TABLE table_2 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 20

@ukgov.purchase_order_transactions.table_20

19.42 KB
449 rows
7 columns


CREATE TABLE table_20 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 21

@ukgov.purchase_order_transactions.table_21

20.13 KB
478 rows
7 columns


CREATE TABLE table_21 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 22

@ukgov.purchase_order_transactions.table_22

22.18 KB
626 rows
7 columns


CREATE TABLE table_22 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 3

@ukgov.purchase_order_transactions.table_3

18.63 KB
447 rows
7 columns


CREATE TABLE table_3 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 4

@ukgov.purchase_order_transactions.table_4

22.65 KB
614 rows
7 columns


CREATE TABLE table_4 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 5

@ukgov.purchase_order_transactions.table_5

17.57 KB
393 rows
7 columns


CREATE TABLE table_5 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 6

@ukgov.purchase_order_transactions.table_6

17.06 KB
365 rows
7 columns


CREATE TABLE table_6 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 7

@ukgov.purchase_order_transactions.table_7

16.96 KB
351 rows
7 columns


CREATE TABLE table_7 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);

Table 8

@ukgov.purchase_order_transactions.table_8

18.85 KB
385 rows
9 columns


CREATE TABLE table_8 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);

Table 9

@ukgov.purchase_order_transactions.table_9

22.61 KB
619 rows
7 columns


CREATE TABLE table_9 (
  "organisation_name" VARCHAR,
  "purchase_order_number" VARCHAR,
  "order_date" TIMESTAMP,
  "total_value" VARCHAR,
  "supplier_name" VARCHAR,
  "account_name" VARCHAR,
  "service" VARCHAR
);