FCO Prompt Payment Data
Foreign and Commonwealth Office
@ukgov.fco_prompt_payment_data
Foreign and Commonwealth Office
@ukgov.fco_prompt_payment_data
CREATE TABLE fco_prompt_payment_and_interest_liable_q1_2019_20 (
"financial_year_2018_19" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
CREATE TABLE fco_prompt_payment_data (
"financial_year_2017_18" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" BIGINT
);
CREATE TABLE fco_prompt_payments_and_interest_liable_full_fy_2018_19 (
"financial_year_2018_19" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
CREATE TABLE fco_prompt_payments_and_interest_liable_full_fy_2019_2020 (
"financial_year_2019_2020" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
CREATE TABLE fco_prompt_payments_and_interest_liable_q1_2020_21 (
"financial_year_2020_2021" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
CREATE TABLE fco_prompt_payments_and_interest_liable_q2_2019_2020 (
"financial_year_2019_2020" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
CREATE TABLE fco_prompt_payments_and_interest_liable_q3_2019_2020 (
"financial_year_2019_2020" VARCHAR,
"percentage_of_invoices_paid_within_5_days" VARCHAR,
"percentage_of_invoices_paid_within_30_days" VARCHAR,
"total_interest_liable" DOUBLE
);
Anyone who has the link will be able to view this.