Prompt Payment Data
Food Standards Agency
@ukgov.fsa_prompt_payment_data
Food Standards Agency
@ukgov.fsa_prompt_payment_data
Requirement to publish percentage of our invoices paid within i) 5 Days and ii) 30 Days on a quarterly basis.
Publisher name: Food Standards Agency
Last updated: 2025-03-19T04:00:14Z
CREATE TABLE prompt_payment_data_2017_to_2018 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);CREATE TABLE prompt_payment_data_2018_to_2019 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);CREATE TABLE prompt_payment_data_2019_to_2020 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" DOUBLE
);CREATE TABLE prompt_payment_data_2020_to_2021 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" BIGINT
);CREATE TABLE prompt_payment_data_2021_to_2022 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" DOUBLE
);CREATE TABLE prompt_payment_data_2022_to_2023 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR
);CREATE TABLE prompt_payment_data_2023_to_2024 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE prompt_payment_data_2024_to_2025 (
"quarterno" BIGINT,
"datefrom" TIMESTAMP,
"dateto" TIMESTAMP,
"percentageofinvoicespaidwithin5days" DOUBLE,
"percentageofinvoicespaidwithin30days" DOUBLE,
"totalamountofliabilitytopay" VARCHAR
);Anyone who has the link will be able to view this.