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	Pla: Redecoration - External	11/11/2014	3500	122851
AA SHOPFITTING & BUILDING SERVICES LTD	Health Improvement & Leisure	The Pavilion	Hired Services	11/11/2014	720	122851
AA SHOPFITTING & BUILDING SERVICES LTD	Health Improvement & Leisure	The Pavilion	Hired Services	11/11/2014	285	122572
A B WALLACE TROPHIES LIMITED	Health Improvement & Leisure	Local Sports Alliance	Materials - Purchase	26/11/2014	266.67	123487
ACTIVE ARTS GROUP	Health Improvement & Leisure	Leisure Dev. - Arts & Heritage	Project/Initiatives Fees	26/11/2014	1250	123609
AC TRAINING SERVICES	N'Hood & Env. Health Services	Vehicle Maintenance	Seminars & Short Training	12/11/2014	2741.55	122634
ADVANCED BUSINESS SOLUTIONS	Finance, Efficiency & Assets	Financial Services	Software Maintenance	25/11/2014	14315.2	123469
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	06/11/2014	1503.72	122570
ALL SAINTS CHURCH	N'Hood & Env. Health Services	Car Parks	Rent Payments	13/11/2014	1500	122878
ANCHORPRINT GROUP LIMITED	Health Improvement & Leisure	Corporate Health Improvement	Project/Initiatives Fees	26/11/2014	294.59	123543


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