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.
AA SHOPFITTING & BUILDING SERVICES LTD	Other	General Fund Balance Sheet	In Year Capital Additions	03/10/2013	520	102878
A B & C LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Accidental Damage Repair Costs	23/10/2013	400	104196
ACTIVE ARTS	Corp Serv, Perform. & Leisure	Leisure Dev. - Arts & Heritage	Project/Initiatives Fees	01/11/2013	1250	104473
ACTUATE INTERNATIONAL SARL	Corp Serv, Perform. & Leisure	Ict Services	Applications - Business	24/10/2013	7065	104170
ADVANCED BUSINESS SOLUTIONS	Other	General Fund Balance Sheet	In Year Capital Additions	10/10/2013	3858.75	103318
AHS LIMITED	N'Hood & Env. Health Services	Grounds Maintenance Service	Equipment R & M	10/10/2013	369	102934
AIR CONDITIONING WRIGHT FAVELL LIMITED	Finance, Efficiency & Assets	Littlethorpe Depot	Rea: Electrical	01/11/2013	307	102541
ALF WRIGHT CONSTRUCTION LTD	Finance, Efficiency & Assets	Council Offices & Land	Pla: Building Works	03/10/2013	2048	102144
ALF WRIGHT CONSTRUCTION LTD	Finance, Efficiency & Assets	Council Offices & Land	Pla: Building Works	10/10/2013	4294	102143
ALF WRIGHT CONSTRUCTION LTD	Finance, Efficiency & Assets	Council Offices & Land	Rea: Building	10/10/2013	434.33	103228


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