Foreign, Commonwealth And Development Office: Government Procurement Card Spending Over £500

CREATE TABLE fcdo_dfid_government_e_payment_framework_transaction_march_2022 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__363c5afd (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__3a336604 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__404fa633 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__4f594ae2 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__7cae873d (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__896be732 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__9be21313 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__9ed9fc01 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__b365ef76 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__b5291382 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__b9ecc111 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__c56d49bf (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__ca26ba46 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__ed0b0e37 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions__f62a9d74 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions_july_2021 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" VARCHAR
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions_june_2021 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

CREATE TABLE fcdo_dfid_government_e_payment_framework_transactions_may_2021 (
  "posted_date" VARCHAR,
  "merchant_name" VARCHAR,
  "invoice_net_line_amount" DOUBLE
);

CREATE TABLE fcdo_fco_gpc_transactions_april_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

CREATE TABLE fcdo_fco_gpc_transactions_august_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

CREATE TABLE fcdo_fco_gpc_transactions_december_2020 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

CREATE TABLE fcdo_fco_gpc_transactions_december_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

CREATE TABLE fcdo_fco_gpc_transactions_february_2021 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);

CREATE TABLE fcdo_fco_gpc_transactions_february_2022 (
  "unique_reference_number" VARCHAR,
  "transaction_date" TIMESTAMP,
  "merchant_category_code_description2" VARCHAR,
  "location" VARCHAR,
  "merchant_category_group_description3" VARCHAR,
  "amount" DOUBLE,
  "supplier" VARCHAR
);