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	unnamed_10 Unnamed: 10	unnamed_11 Unnamed: 11	unnamed_12 Unnamed: 12




RUN AT 7/13/2015 10:51:28 AM
Department family	Entity	Date	Expense Type	Expense area	Supplier	Transaction number	AP Amount (Ł)	Description	Purchase invoice number	Supplier Post Code	Supplier Type	Expenditure Type
Department of Health	NHS Vale Of York CCG	30/06/2015	Clinical&Medical-Independent Sector	PROGRAMME PROJECTS	UNITY HEALTH	8119070	64,684.85	PROGRAMME PROJECTS	1531	YO10 4DU	SME	Programme
Department of Health	NHS Vale Of York CCG	30/06/2015	Clinical&Medical-Independent Sector	COMMISSIONING SCHEMES	PRIORY MEDICAL GROUP	8133741	44,141.66	COMMISSIONING SCHEMES	29	YO24 3WX	SME	Programme
Department of Health	NHS Vale Of York CCG	30/06/2015	Hcare Srv Rec NHS Trust	ACUTE COMMISSIONING	HULL AND EAST YORKSHIRE HOSPITALS NHS TRUST	8148982	184,999.00	ACUTE COMMISSIONING	1210016656	HU16 5JQ	PUBLIC SECTOR	Programme
Department of Health	NHS Vale Of York CCG	30/06/2015	Hcare Srv Rec NHS Trust	AMBULANCE SERVICES	YORKSHIRE AMBULANCE SERVICE NHS TRUST	8149032	44,292.00	AMBULANCE SERVICES	2810009451	WF2 OXQ	PUBLIC SECTOR	Programme


CREATE TABLE june_2015 (
  "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,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR
);