Spend Over £25,000 In Milton Keynes Hospital NHS Foundation Trust
Milton Keynes Hospital NHS Foundation Trust
@ukgov.financial_transactions_milton_keynes_hospital_nhs_foun_57f73e56
Milton Keynes Hospital NHS Foundation Trust
@ukgov.financial_transactions_milton_keynes_hospital_nhs_foun_57f73e56
CREATE TABLE n_2016_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2016_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2016_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2016_november_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2016_october_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2016_september_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_august_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_january_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" DOUBLE,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_may_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_november_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_october_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2017_september_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_april_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_december_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_february_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_january_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_july_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_june_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
CREATE TABLE n_2018_march_return (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"ap_amount" DOUBLE,
"vat_registration_number" VARCHAR,
"purchase_invoice_number" VARCHAR
);
Anyone who has the link will be able to view this.