About this Dataset

Spend Over £25,000 In The Sustainable Development Commission

A monthly-updated list of all financial transactions spending over £25,000 made by the Sustainable Development Commission, as part of the Government's commitment to transparency in expenditure.
Publisher name: Sustainable Development Commission
Last updated: 2022-07-01T04:07:39Z

Tables

Spend Over £25,000 In The Sustainable Development Commission

@ukgov.financial_transactions_data_sdc.spend_over_25_000_in_the_sustainable_development_commission

40.36 kB
1 row
53 columns

CREATE TABLE spend_over_25_000_in_the_sustainable_development_commission (
  "supplier_name" VARCHAR,
  "vendor_number" BIGINT,
  "vendor_site" VARCHAR,
  "vendor_classification" VARCHAR,
  "invoice_number" BIGINT,
  "invoice_description" VARCHAR,
  "n__invoice_amount" DOUBLE  -- Invoice Amount,
  "source" VARCHAR,
  "invoice_type" VARCHAR,
  "payment_method" VARCHAR,
  "invoice_date" VARCHAR,
  "invoice_received_date" VARCHAR,
  "goods_received_date" VARCHAR,
  "hold_release_date" VARCHAR,
  "terms_date_calculation_basis" VARCHAR,
  "supplier_credit_terms_calendar_days" VARCHAR  -- Supplier Credit Terms (Calendar Days),
  "due_date_based_on_supplier_terms" VARCHAR  -- Due Date (Based On Supplier Terms),
  "invoice_paid_date" VARCHAR,
  "payment_reference_number" BIGINT,
  "paid_late_based_on_supplier_terms" VARCHAR  -- Paid Late? (Based On Supplier Terms),
  "no_of_days_paid_late_based_on_supplier_terms" BIGINT  -- No. Of Days Paid Late (Based On Supplier Terms),
  "due_date_based_on_5_working_day_payment_directive" VARCHAR  -- Due Date (Based On 5 Working Day Payment Directive),
  "no_of_working_days_to_make_payment" BIGINT  -- No. Of Working Days To Make Payment,
  "paid_late_based_on_5_working_day_payment_directive" VARCHAR  -- Paid Late? (Based On 5 Working Day Payment Directive),
  "no_of_days_paid_late_based_on_5_working_day_payment_directive" BIGINT  -- No. Of Days Paid Late (Based On 5 Working Day Payment Directive),
  "company" BIGINT,
  "cost_centre" BIGINT,
  "objective" BIGINT,
  "account" BIGINT,
  "sub_account" BIGINT,
  "project" VARCHAR,
  "invoice_contains_multiple_cost_centre_distribution" VARCHAR  -- Invoice Contains Multiple Cost Centre Distribution?,
  "matched" VARCHAR  -- Matched?,
  "po_number" BIGINT,
  "po_creation_date" VARCHAR,
  "requisition_number" BIGINT,
  "requisition_creation_date" VARCHAR,
  "requisitioner_name" VARCHAR,
  "requisitioner_employee_no" BIGINT  -- Requisitioner Employee No.,
  "requisitioner_email" VARCHAR,
  "requisitioner_location" VARCHAR,
  "requisitioner_cost_centre" VARCHAR,
  "requestor_name" VARCHAR,
  "requestor_employee_no" BIGINT  -- Requestor Employee No.,
  "requestor_email" VARCHAR,
  "requestor_location" VARCHAR,
  "requestor_cost_centre_1" VARCHAR,
  "requestor_cost_centre_2" VARCHAR,
  "requestor_cost_centre_3" VARCHAR,
  "requestor_cost_centre_4" VARCHAR,
  "requestor_cost_centre_5" VARCHAR,
  "requestor_cost_centre_6" VARCHAR,
  "requestor_cost_centre_7" VARCHAR
);