All GPC Transparency Reports

CREATE TABLE all_gpc_transparency_reports (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" VARCHAR
);

CREATE TABLE all_gpc_transparency_reports_april_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_april_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_april_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_april_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_april_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_august_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_august_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_august_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_august_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_august_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_august_2024 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_december_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_december_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_december_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_december_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_december_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

CREATE TABLE all_gpc_transparency_reports_december_2024 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_february_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_february_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_february_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_february_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_january_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_january_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

CREATE TABLE all_gpc_transparency_reports_january_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);