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.
ABINGTON ACADEMY	Policy, Partner & Health Impr	Lpc - Commissioning	Oadby & Wigston Pay P Expend.	18/07/2013	390	98189
ADMIRAL CLEANING SUPPLIES LTD	Finance, Efficiency & Assets	Council Offices & Land	Hygiene Equip & Supps	25/07/2013	213.75	98027
ADVANCED BUSINESS SOLUTIONS	Other	General Fund Balance Sheet	In Year Capital Additions	02/07/2013	10290	97595
ADVANCED BUSINESS SOLUTIONS	Other	General Fund Balance Sheet	In Year Capital Additions	18/07/2013	5145	98633
AIM HIGHER COACHING	Policy, Partner & Health Impr	Lpc - Commissioning	Oadby & Wigston Pay P Expend.	11/07/2013	749.2	98298
ALF WRIGHT CONSTRUCTION LTD	Finance, Efficiency & Assets	Littlethorpe Depot	Rea: Building	02/07/2013	920	97872
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	04/07/2013	1330.56	98023
ANCHORPRINT GROUP LIMITED	Corp Serv, Perform. & Leisure	Communications	District Magazine Publication	18/07/2013	540	97923
ANCHORPRINT GROUP LIMITED	Corp Serv, Perform. & Leisure	Communications	Publicity & Promotion	29/07/2013	348	96133
ANCHORPRINT GROUP LIMITED	Policy, Partner & Health Impr	Corporate Health Improvement	Publicity & Promotion	02/07/2013	400	97922


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