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	Finance, Efficiency & Assets	The Pavillion - Land And Build	Cash Back Scheme	30/09/2014	430	120913
AA SHOPFITTING & BUILDING SERVICES LTD	Finance, Efficiency & Assets	The Pavillion - Land And Build	Hire Of Rooms	30/09/2014	600	120913
AA SHOPFITTING & BUILDING SERVICES LTD	Health Improvement & Leisure	The Pavilion	Equipment R & M	30/09/2014	2635	120913
A B & C LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Accidental Damage Repair Costs	16/09/2014	260	120223
ABRITAS	Community Services	Choice Based Lettings	Professional Services	10/09/2014	4125.31	119834
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	04/09/2014	1489.56	119523
ANCHORPRINT GROUP LIMITED	Health Improvement & Leisure	Corporate Health Improvement	Publicity & Promotion	10/09/2014	286	119840
ANCHORPRINT GROUP LIMITED	Health Improvement & Leisure	Local Sports Alliance	Publicity & Promotion	04/09/2014	512.5	119496
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Non-Kerbside Recycling Prom.	Other Equipment	25/09/2014	256.86	120689
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Non-Kerbside Recycling Prom.	Other Equipment	25/09/2014	656.36	120691


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