Government Procurement Card (GPC) Spend - Transactions Over £500
Water Services Regulation Authority (Ofwat)
@ukgov.government_procurement_card_gpc_spend_transactions_over_500
Water Services Regulation Authority (Ofwat)
@ukgov.government_procurement_card_gpc_spend_transactions_over_500
CREATE TABLE government_procurement_card_transactions_greater_than__9f4fc640 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"vat_registration_number" VARCHAR
);
CREATE TABLE government_procurement_card_transactions_greater_than__d9c2b2d4 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
CREATE TABLE table_3 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"vat_registration_number" VARCHAR
);
Anyone who has the link will be able to view this.