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.
ACTIVE ARTS GROUP	Corp Serv, Perform. & Leisure	Leisure Dev. - Arts & Heritage	Project/Initiatives Fees	05/06/2014	1250	115276
ADMIRAL CLEANING SUPPLIES LTD	Finance, Efficiency & Assets	Council Offices & Land	Hygiene Equip & Supps	19/06/2014	466.95	115252
ADVANCED BUSINESS SOLUTIONS	Other	General Fund Balance Sheet	In Year Capital Additions	16/06/2014	1286.25	116004
AIRCON MECHANICAL SERVICES LTD	Planning, Econ. Dev. & Housing	Planning Delivery	Fees And Charges	12/06/2014	385	115620
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	05/06/2014	1605.63	115279
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	26/06/2014	954.92	116363
ANCHORPRINT GROUP LIMITED	Policy, Partner & Health Impr	Community Development	Other Partnership Support	05/06/2014	2697.03	114657
ANCHORPRINT GROUP LIMITED	Policy, Partner & Health Impr	Corporate Health Improvement	Publicity & Promotion	05/06/2014	665.96	114861
A & S PROPERTIES	Community Services	Homelessness	Recoveries	12/06/2014	520	115485
BRAUNSTONE TOWN COUNCIL	Corp Serv, Perform. & Leisure	Customer Services	Rent Payments	05/06/2014	11068	115233


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