Department For Transport Prompt Payment Performance
Department for Transport
@ukgov.department_for_transport_prompt_payment
Department for Transport
@ukgov.department_for_transport_prompt_payment
CREATE TABLE department_for_transport_prompt_payment_performance (
"year_2017_2018" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
CREATE TABLE dft_5_and_30_day_prompt_payment_data_2016_to_2017 (
"financial_year_2016_2017" VARCHAR,
"organisation" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR
);
CREATE TABLE dft_5_and_30_day_prompt_payment_data_2017_to_2018 (
"year_2017_2018" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_5_and_30_day_prompt_payment_data_2018_to_2019 (
"year_2017_2018" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_prompt_payment_data_2024_to_2025 (
"year_2024_2025" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_prompt_payment_performance_annual_summary_2018_to_2019 (
"year_2018_2019" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
CREATE TABLE dft_prompt_payment_performance_annual_summary_2019_to_2020 (
"year_2019_2020" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_2019_to_2020 (
"year_2019_2020" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_2020_to_2021 (
"year_2020_2021" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_2021_to_2022 (
"year_2021_2022" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_2022_to_2023 (
"year_2022_2023" VARCHAR,
"financial_quarter" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_5_days" VARCHAR,
"group_quarter_period_average_percentage_paid_within_5_days" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_quarter_period_average_paid_within_30_days" VARCHAR,
"total_amount_of_liability_to_pay_interest" VARCHAR,
"group_quarter_period_average_of_total_amount_of_liabil_f60dd7cd" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_annual_summary_2020_to_2021 (
"year_2020_2021" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_annual_summary_2021_to_2022 (
"year_2021_2022" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
CREATE TABLE dft_s_prompt_payment_data_annual_summary_2022_to_2023 (
"year_2022_2023" VARCHAR,
"organisation" VARCHAR,
"percentage_paid_within_30_days" VARCHAR,
"group_year_average_paid_within_30_days" VARCHAR,
"total_interest_paid" VARCHAR,
"group_year_average_interest_paid" VARCHAR
);
Anyone who has the link will be able to view this.