Payments To Suppliers

supplier_name SUPPLIER NAME	portfolio PORTFOLIO	cost_centre COST CENTRE	expenditure_class EXPENDITURE CLASS	post_date POST. DATE	amount AMOUNT	ref REF.
4WARD STROKES	Corp Serv, Perform. & Leisure	Active Together (Oper Funding)	Other Partnership Support	10/07/2014	240	117094
AA SHOPFITTING & BUILDING SERVICES LTD	Corp Serv, Perform. & Leisure	The Pavilion	Hired Services	03/07/2014	500	116704
AA SHOPFITTING & BUILDING SERVICES LTD	Corp Serv, Perform. & Leisure	The Pavilion	Publicity & Promotion	30/07/2014	1177	118098
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	10/07/2014	1418.21	116917
ALZHEIMER'S SOCIETY	Policy, Partner & Health Impr	Corporate Health Improvement	Project/Initiatives Fees	31/07/2014	2374	117623
ANCHORPRINT GROUP LIMITED	Corp Serv, Perform. & Leisure	Communications	District Magazine Publication	03/07/2014	540	116687
ANCHORPRINT GROUP LIMITED	Corp Serv, Perform. & Leisure	Local Sports Alliance	Publicity & Promotion	31/07/2014	334	117619
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	16/07/2014	275	117009
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	17/07/2014	300	117011
ANCHORPRINT GROUP LIMITED	Policy, Partner & Health Impr	Corporate Health Improvement	Publicity & Promotion	24/07/2014	280	117622


CREATE TABLE july_2014 (
  "supplier_name" VARCHAR,
  "portfolio" VARCHAR,
  "cost_centre" VARCHAR,
  "expenditure_class" VARCHAR,
  "post_date" VARCHAR,
  "amount" DOUBLE,
  "ref" DOUBLE
);