DFID Government E-payments Framework Transactions
Department for International Development
@ukgov.dfid_gpc_transactions_over_500_quarterly
Department for International Development
@ukgov.dfid_gpc_transactions_over_500_quarterly
CREATE TABLE april_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE april_2020_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE august_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE august_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
CREATE TABLE december_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE dfid_government_e_payments_framework_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE february_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE february_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE january_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE january_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE july_2019_gpc_transactions (
"n" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE july_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
CREATE TABLE june_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR
);
CREATE TABLE june_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
CREATE TABLE march_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE may_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE may_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
CREATE TABLE november_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE october_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE october_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
CREATE TABLE september_2019_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" DOUBLE
);
CREATE TABLE september_2020_gpc_transactions (
"posted_date" VARCHAR,
"merchant_name" VARCHAR,
"invoice_net_line_amount" VARCHAR
);
Anyone who has the link will be able to view this.