Vale Of York CCG Spend Over £25k.

a3131 A3131	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	unnamed_3 Unnamed: 3	unnamed_4 Unnamed: 4	unnamed_5 Unnamed: 5	unnamed_6 Unnamed: 6	unnamed_7 Unnamed: 7	unnamed_8 Unnamed: 8	unnamed_9 Unnamed: 9	expenditure_over_threshold Expenditure Over Threshold	unnamed_11 Unnamed: 11	unnamed_12 Unnamed: 12




RUN AT 4/1/2016 11:31:16 AM
Department family	Entity	Date	Expense Type	Expense area	Supplier	Transaction number	AP Amount (ś)	VAT registration number	Purchase invoice number	Supplier Post Code	Supplier Type	Expenditure Type
Department of Health	NHS Vale Of York CCG	31/03/2016	Basic Sal-Rechgs to-from Other Non NHS	COMMISSIONING	ATTAIN COMMISSIONING SERVICES LTD	11303597	31,686.55	107232747	1684	WC1V 7HZ	SME	Admin
Department of Health	NHS Vale Of York CCG	31/03/2016	Basic Sal-Rechgs to-from Other Non NHS	COMMISSIONING	ATTAIN COMMISSIONING SERVICES LTD	11554558	30,548.95	107232747	1742	WC1V 7HZ	SME	Admin
Department of Health	NHS Vale Of York CCG	31/03/2016	Basic Sal-Rechgs to-from Other Non NHS	COMMISSIONING	ATTAIN COMMISSIONING SERVICES LTD	11554685	34,003.20	107232747	1816	WC1V 7HZ	SME	Admin
Department of Health	NHS Vale Of York CCG	31/03/2016	C&M-GMS Cost of Drugs -Dispensing	LOCAL ENHANCED SERVICES	BEECH TREE SURGERY	11393698	31,074.74		YN000016959	YO8 9AJ	SME	Programme


CREATE TABLE march_2016 (
  "a3131" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "expenditure_over_threshold" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);